Mysql-server adventures in 4.3
I've tried to successfully install mysql-server on a 4.3 installation, and while at this point, it seems to be working, it wasn't without some head-scratching. The point of this post is to see if anyone else has experienced what I've gone through. Namely-
1) Packages curiosity-
For me, running a "pkg_info -Q mysql" didn't show the mysql-server application itself, despite it being listed in the packages page for i386 on the openbsd.org site. Even when adding the package path as the two paths referenced on the site, I still can't see it with pkg_info.
I was able obviously to copy the .gz file from each site referenced on the website, and do a slightly 'successful' installation of mysql-server, but it's weird that I couldn't see it on a pkg_info -Q command.
And that leads me to my next conundrum...
2) msql-bin.index issue
once 'installed', one is directed to run the " /usr/local/bin/mysql_install_db" included on the package installation, which installs the base mysql table and gives further instructions to setup the server. When running it, I came across
/usr/local/libexec/mysqld: File './mysql-bin.index' not found (Errcode: 13)
I tried placing this mysql-bin.index in various directories I thought that mysqld was referencing (including the usual "/var/mysql" directory, where it's supposed to be) with no luck. I followed a googled suggestion from the mysql forum that directed me to confirm ownership and permissions, and still got the same error.
Out of frustration, I even uninstalled the package, downloaded the application from mysql itself and compiled it (and, as expected, it took forever.) Sadly, even on the compiled version, I got the same error.
The only thing that got me past this was something a little murky and quirky. I did a 'make uninstall' on the compiled version (but left many files hanging around because I didn't "make clean") and then did a pkg_add of the pre-compiled version all over again... and finally I could run the mysql_install_db script successfully.
I thought my problems were odd, but over... nope.
3) misplacement of proper support files
Perhaps one of the more important scripts, mysqladmin, was not where it's supposed to be (/usr/local/bin)... so I was lucky that I didn't do a 'make clean' on the compiled version I uninstalled... mysqladmin is still located in that downloaded, untarred installation tree. I can run it from there, but of course, it's not the optimal setup.
Again, I'm just chronicling all of this in case anyone else has experienced anything similar... so, anyone?
|Thread||Thread Starter||Forum||Replies||Last Post|
|Mysql server instaliaton from ports||edvinus||OpenBSD Packages and Ports||2||23rd June 2009 12:46 PM|
|Sun Java System Web Server - Active Server Pages (yes ASP)||hopla||FreeBSD General||0||26th September 2008 09:22 AM|
|MYSQL HOW TO START||disappearedng||FreeBSD General||7||18th September 2008 10:48 AM|
|mysql using >100% cpu||bdj||FreeBSD General||5||16th May 2008 05:20 PM|