FreeBSD and frustration with MySQL

[CaptainPinko]

I recently wiped my SuSE 9.1 partition to finally try out FreeBSD 5.3. I had been excited about it for a while and am now kind of disappointed. With the experience. The sound card doesn't work, the mouse scroll wheel doesn't work, the handbook --while has some good information-- is spotty at times, and now this...

while doing pkg_add -r mysql40-server ; pkg_add -r mysql40-client, amongst the output, I got this message:

To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system


This doesn't tells me the full puth of the file I need, nor do I have any idea what exactly the right place for this file is. This is disappointing. The Apache2 package at least said cleary add this line to that file.

I search the Handbook for MySQL and Googled for "MySQL FreeBSD 5.3 mysql.server" with nothing helpful yet.

I must admit that I'm liking the ports and packages system

[drummerboy195]

If you haven't built the "locate" database yet, then I would, were I in your shoes

As root:
locate -u

This builds a database of all the files on your hard drive, which you can then use to find the file you are looking for

locate mysql.server

[j79zlr]

Use ports instead of binary packages, that is the real power of FreeBSD.

Either way, that is the startup script, I'm not sure where the binary package places it, but it should go into /usr/local/etc/rc.d/ and you would also have to add mysqld_enable="YES" to /etc/rc.conf

The mouse wheel setup is the same as it is in Linux.

[CaptainPinko]

Originally posted by j79zlr
Use ports instead of binary packages, that is the real power of FreeBSD.

Is there any real benefit of FreeBSD ports vs Gentoo's portage? What's wrong with the packages?



Either way, that is the startup script, I'm not sure where the binary package places it, but it should go into /usr/local/etc/rc.d/ and you would also have to add mysqld_enable="YES" to /etc/rc.conf
is that the way it's always done? just add the line $DAEMONNAME_enable="YES" to /etc/rc.conf?


The mouse wheel setup is the same as it is in Linux.
Hmm, I've always had the installer configure it for me and I didn't see the option in sysinstall...

[j79zlr]

Without trying to start an argument, FreeBSD's ports are better maintained, more stable, and just better developed, its been around a lot longer. The binary packages are only build about once a month IIRC, so if you want to stay up-to-date, use the ports tree along with cvsup to keep everything updated.

Alot, but not everything, must be enabled in /etc/rc.conf now, apache, mysql, samba, daemontools, etc. that I know of.

To get the mouse scroll wheel, just set

Option "Buttons" "5"
Option "ZAxisMapping" "4 5"

in the mouse section of your xfree/xorg config file, just like you would in linux.

[CaptainPinko]

Originally posted by j79zlr

To get the mouse scroll wheel, just set

Option "Buttons" "5"
Option "ZAxisMapping" "4 5"

in the mouse section of your xfree/xorg config file, just like you would in linux.

Heh, off to the Gentoo docs it is. I hate them distro but they got some good docs and advice. :p

----
EDIT: in case anyone is reading this the file was /etc/X11/xorg.conf