Opened 9 years ago

Closed 9 years ago

#46328 closed defect (invalid)

unable to start Myth's database in MacOSX Yosemite

Reported by: jgandrade11@… Owned by: ctreleaven (Craig Treleaven)
Priority: Normal Milestone:
Component: ports Version: 2.3.3
Keywords: Cc:
Port:

Description (last modified by larryv (Lawrence Velázquez))

After successful installation of Mythtv via Macports, I'm unable to intialize Myth's database despite following the cookbook from http://www.mythtv.org/wiki/MacPorts#Terminal_and_PATH
The answer that I get is: command not found.
The folder dvr under opt was not created despite running the command echo export PATH=/opt/dvr/bin:/opt/dvr/sbin:/opt/dvr/lib/mariadb/bin:$PATH" >> ~/.bash_profile. However, after running the command echo $PATH I do get the following:

/opt/dvr/bin:/opt/dvr/sbin:/opt/dvr/lib/mariadb/bin:/opt/local/bin:/opt/local/sbin:/opt/dvr/bin:/opt/dvr/sbin:/opt/dvr/lib/mariadb/bin:/opt/dvr/bin:/opt/dvr/sbin:/opt/dvr/lib/mariadb/bin:/opt/dvr/bin:/opt/dvr/sbin:/opt/dvr/lib/mariadb/bin:/opt/local/bin:/opt/local/sbin:/usr/local/git/bin:/usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin

Please let me know where to find the log files you need to help me solve this issue. Thanks

Change History (6)

comment:1 Changed 9 years ago by larryv (Lawrence Velázquez)

Description: modified (diff)
Keywords: Mythtv Yosemite 10.10.1 removed
Owner: changed from macports-tickets@… to ctreleaven@…

comment:2 Changed 9 years ago by ctreleaven (Craig Treleaven)

If you built Myth (as opposed to downloading the pre-built, all-in-one, installer, then you're following the wrong instructions. The pre-built installer puts everything under '/opt/dvr'; by default building with MacPorts puts everything under '/opt/local'. If that is the case for you, see the instructions at:

http://www.mythtv.org/wiki/Building_Myth_for_Mac_with_MacPorts#Build_and_Install_Myth_0.27.4

You probably need to install mariadb-server.

Then adapt the configuration and set-up instructions--changing /opt/dvr to /opt/local ...

comment:3 Changed 9 years ago by jgandrade11@…

Thanks for your advise. I tried again a clean install of macports and mythtv via macports. I installed "mariadb-server" and "logrotate +startupitem". Everything goes well. However, I am not able to start Myth's database. When I follow the instructions from "http://www.mythtv.org/wiki/Myth_for_Mac_with_MacPorts" starting at the database section, I have no problem until I type "mysql -u root < /opt/local/share/mythtv/database/mythconverg_init.sql". I get the following error: "-bash: mysql: command not found". If you can please tell me step by step how to fix this issue I'll really appreciate it. Thanks for your help.

comment:4 in reply to:  3 Changed 9 years ago by larryv (Lawrence Velázquez)

Replying to jgandrade11@…:

I have no problem until I type "mysql -u root < /opt/local/share/mythtv/database/mythconverg_init.sql". I get the following error: "-bash: mysql: command not found".

You may have to refresh your shell’s command cache to tell it about the newly-installed MariaDB executable (hash -r if you’re using bash or zsh). Also check port contents mariadb-server to make sure you’re trying to run the right binary.

comment:5 in reply to:  3 Changed 9 years ago by pixilla (Bradley Giesbrecht)

Replying to jgandrade11@…:

I type "mysql -u root < /opt/local/share/mythtv/database/mythconverg_init.sql". I get the following error: "-bash: mysql: command not found".

The mariadb "mysql" binary is not in your path.

$ port contents mariadb | grep bin/mysql$
  /opt/local/lib/mariadb/bin/mysql

Using the full path to the mariadb "mysql" binary should resolve your error:

$ /opt/local/lib/mariadb/bin/mysql -u root < /opt/local/share/mythtv/database/mythconverg_init.sql
Last edited 9 years ago by pixilla (Bradley Giesbrecht) (previous) (diff)

comment:6 Changed 9 years ago by ctreleaven (Craig Treleaven)

Resolution: invalid
Status: newclosed

No indication of an actual bug; closing as invalid.

If you are continuing to have problems, let's take this to the OSX forum on https://forum.mythtv.org/index.php or the mythtv-users mailing list.

Note: See TracTickets for help on using tickets.