View Single Post
  #1   (View Single Post)  
Old 9th June 2008
ai-danno's Avatar
ai-danno ai-danno is offline
Spam Deminer
 
Join Date: May 2008
Location: Boca Raton, Florida
Posts: 284
Default 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?
__________________
Network Firefighter
Reply With Quote