Go Back   DaemonForums > OpenBSD > OpenBSD Packages and Ports

OpenBSD Packages and Ports Installation and upgrading of packages and ports on OpenBSD.

Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mysql server instaliaton from ports edvinus OpenBSD Packages and Ports 2 23rd June 2009 11:46 AM
Sun Java System Web Server - Active Server Pages (yes ASP) hopla FreeBSD General 0 26th September 2008 08:22 AM
MYSQL HOW TO START disappearedng FreeBSD General 7 18th September 2008 09:48 AM
mysql using >100% cpu bdj FreeBSD General 5 16th May 2008 04:20 PM

All times are GMT. The time now is 01:25 PM.

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Content copyright © 2007-2010, the authors
Daemon image copyright ©1988, Marshall Kirk McKusick