mythtv-core.27: use MySQL 5.6?

[octavioj@…]

MythTV 2.7 seems to require MySQL 5 but that does not build well under Mavericks. Is it possible to make MythTV use MySQL 5.6?

[ryandesign (Ryan Carsten Schmidt)]

mythtv-core.27 depends on qt4-mac-mysql5-plugin, which depends on mysql5. To use mysql56, mythtv-core.27 would have to depend instead on qt4-mac-mysql56-plugin.

mythtv-core.27 also depends on py26-mysql. py26-mysql has variants for selecting the desired mysql version. It does not yet have a variant for mysql56; one should be added, along with mariadb and percona variants (see #39068). MacPorts does not have the capability to declare a dependency on a variant of a port (see #126) though we do now have the active_variants-1.1 portgroup which can help.

mythtv-core.27 also depends on p5.12-dbd-mysql which again has variants.

Ideally mythtv-core.27 would offer the user variants to select the desired versions of mysql, python, perl, ......

[ryandesign (Ryan Carsten Schmidt)]

And for the record, mysql5 installed fine for me on Mavericks.

[ctreleaven (Craig Treleaven)]

I know of at least a couple of users that have successfully installed Myth (and MySQL 5) under Mavericks.

Did you get an error message while trying to build and install MySQL?

Perhaps you neglected to install the port 'mysql5-server'? See ​http://www.mythtv.org/wiki/MacPorts#Before_first_run

Ryan, regarding variants, In an ideal world, I'd like to support variants for the various databases, perl versions and python versions. Practically, however, it is a support nightmare. From the link above, you can see that I have a couple of wiki pages with detailed cookbook-style instructions. Those would become even more challenging to try to follow if expanded for a bunch of variant combinations. To pick one specific issue, if a user wanted to migrate their system from one database to another, they would have to use a very precise set of steps to make a backup of the existing database and restore it to the new one. It is not particularly difficult but there are several opportunities to go wrong. My goal has been to make it so Myth can be installed by someone with minimal exposure to the command line.

Also, whenever a user experienced a problem, there would the question of whether it was caused by their configuration. I simply don't have the time or resources to develop, maintain and test a bunch of configurations. If I had some help...

[octavioj@…]

Yes I get an error message while trying to build and install MySQL. I will post the error and log when I have time to try to build it again.

[octavioj@…]

I still get the error. It seems related to the configuration and the C compiler. Everything compiles fine until I get to MySQL5. I also attached the main.log file. Here is what I get from the command line:

---> Computing dependencies for mythtv-core.27 ---> Dependencies to be installed: p5.12-dbd-mysql mysql5 p5.12-dbi p5.12-clone p5.12-sql-statement p5.12-params-util p5.12-test-simple p5.12-http-request-ascgi p5.12-class-accessor p5.12-libwww-perl p5.12-encode-locale p5.12-file-listing p5.12-http-date p5.12-html-form p5.12-html-parser p5.12-html-tagset p5.12-http-message p5.12-lwp-mediatypes p5.12-uri p5.12-mime-base64 p5.12-http-cookies p5.12-http-daemon p5.12-http-negotiate p5.12-lwp-protocol-https p5.12-io-socket-ssl p5.12-net-libidn libidn p5.12-net-ssleay p5.12-mozilla-ca p5.12-net-http p5.12-www-robotrules p5.12-io-socket-inet6 p5.12-io p5.12-socket6 p5.12-lwp-useragent-determined p5.12-net-upnp pkgconfig py26-lxml libxslt python26 db46 db_select libedit python_select sqlite3 py26-mysql py26-urlgrabber py26-curl curl curl-ca-bundle qt4-mac-mysql5-plugin qt4-mac dbus jpeg libmng lcms tiff taglib x264 yasm ---> Fetching archive for mysql5 Warning: Your DNS servers incorrectly claim to know the address of nonexistent hosts. This may cause checksum mismatches for some ports. ---> Attempting to fetch mysql5-5.1.72_0.darwin_13.x86_64.tbz2 from ​http://packages.macports.org/mysql5 ---> Attempting to fetch mysql5-5.1.72_0.darwin_13.x86_64.tbz2 from ​http://mse.uk.packages.macports.org/sites/packages.macports.org/mysql5 ---> Attempting to fetch mysql5-5.1.72_0.darwin_13.x86_64.tbz2 from ​http://lil.fr.packages.macports.org/mysql5 ---> Fetching distfiles for mysql5 ---> Verifying checksums for mysql5 ---> Extracting mysql5 ---> Applying patches to mysql5 ---> Configuring mysql5 Error: Failed to configure mysql5, consult /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_databases_mysql5/mysql5/work/mysql-5.1.72/config.log Error: org.macports.configure for port mysql5 returned: configure failure: command execution failed Error: Failed to install mysql5 Please see the log file for port mysql5 for details:

/opt/local/var/macports/logs/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_databases_mysql5/mysql5/main.log

Error: The following dependencies were not installed: p5.12-dbd-mysql mysql5 p5.12-dbi p5.12-clone p5.12-sql-statement p5.12-params-util p5.12-test-simple p5.12-http-request-ascgi p5.12-class-accessor p5.12-libwww-perl p5.12-encode-locale p5.12-file-listing p5.12-http-date p5.12-html-form p5.12-html-parser p5.12-html-tagset p5.12-http-message p5.12-lwp-mediatypes p5.12-uri p5.12-mime-base64 p5.12-http-cookies p5.12-http-daemon p5.12-http-negotiate p5.12-lwp-protocol-https p5.12-io-socket-ssl p5.12-net-libidn libidn p5.12-net-ssleay p5.12-mozilla-ca p5.12-net-http p5.12-www-robotrules p5.12-io-socket-inet6 p5.12-io p5.12-socket6 p5.12-lwp-useragent-determined p5.12-net-upnp pkgconfig py26-lxml libxslt python26 db46 db_select libedit python_select sqlite3 py26-mysql py26-urlgrabber py26-curl curl curl-ca-bundle qt4-mac-mysql5-plugin qt4-mac dbus jpeg libmng lcms tiff taglib x264 yasm To report a bug, follow the instructions in the guide:

​http://guide.macports.org/#project.tickets

Error: Processing of port mythtv-core.27 failed

Any help you could provide will be appreciated.

[larryv (Lawrence Velázquez)]

:info:configure checking for C compiler default output file name...
:info:configure configure: error: in `/opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_databases_mysql5/mysql5/work/mysql-5.1.72':
:info:configure configure: error: C compiler cannot create executables
:info:configure See `config.log' for more details.

Please attach this file. You should be able to find it with find $(port work mysql5) -name config.log.

[ctreleaven (Craig Treleaven)]

Quite possibly the XCode Command Line Tools are missing? FAQ#missingxcode

See ​https://trac.macports.org/ticket/41978 for a similar report.

[octavioj@…]

Replying to ctreleaven@…:

Quite possibly the XCode Command Line Tools are missing? FAQ#missingxcode

See ​https://trac.macports.org/ticket/41978 for a similar report.

That was the issue. When I no longer found the option to install the command line tools from within Xcode I assumed they were installed by default. Thank you for the help.

[ctreleaven (Craig Treleaven)]

Glad to hear you got past it.

Could someone with commit rights please close this ticket?