My Sql refuses to start - Free BSD 4.10 Stable

[skysurfer]

Hello There,

I am having trouble with the installation of the latest toaster with FreeBSD 4.10.  I do the port upgrade, configure, etc and the installation, everything goes fine.  Till I try to create to virtual domain.  Then I get the following message.

Please enter password for postmaster:
enter password again:
vmysql: sql error[c]: MySQL server has gone away
vmysql: sql error: MySQL server has gone away
vmysql: sql error[3]: MySQL server has gone away
vmysql: sql error[c]: MySQL server has gone away
vmysql: sql error[c]: MySQL server has gone away
vmysql: sql error: MySQL server has gone away
vmysql: sql error[3]: MySQL server has gone away
vmysql: sql error[2]: MySQL server has gone away
Failed while attempting to add user to auth backend
Error: (vadduser) no auth connection

After I do a nmap localhost I get:
PORT    STATE SERVICE
22/tcp  open  ssh
25/tcp  open  smtp
110/tcp open  pop3
143/tcp open  imap
199/tcp open  smux
587/tcp open  submission
993/tcp open  imaps
995/tcp open  pop3s

Obviously MYSQL is not running.

When I try to run it I get a message that I cannot run it as root.

So I tried a reboot, etc.  Still cannot get it to run.

Reinstalled!  Thought it was a glitch the first time, second time, same message.  First time I changed the super secret password, second time I did not.  I am so close, yet so far!  I seen another post with a message to change the password, but that cannot be it because I did change it the first time....  I am SO CONFUSED!  Please anyhelp would be good.

[virtus]

Hello there.. I have the same problem!

MySQL is runnin just fine, but when I try to use vadddomain I get:

vmysql: error creating table 'dir_control': MySQL server has gone away
vmysql: sql error: MySQL server has gone away
vmysql: error creating table 'blah_com': MySQL server has gone away
Error. Failed while attempting to add domain to auth backend
vmysql: error creating table 'dir_control': MySQL server has gone away
vmysql: error creating table 'dir_control': MySQL server has gone away
vmysql: sql error: MySQL server has gone away
vmysql: error creating table 'dir_control': MySQL server has gone away
vmysql: sql error[e]: MySQL server has gone away
Failed while attempting to delete domain from dir_control
Error: no auth connection

While MySQL is still running just fine:

server1# ps aux | grep sql
root     26158  0.0 16.0 53876 20004  p0  S     7:29PM   0:02.40 /usr/local/libexec/mysqld -u root

From what I can see, there is something wrong with the vpopmail database/tables, that should have been created... (I have no vpopmail tables or even a vpopmail database).

Any suggestions would be _REALLY_ welcome, I'm a bit stuck here and I would love to have my Toaster fully running

Thanks in advance, and thanks for the great project Matt

[matt]

The mysql port now requires that you have mysql_enable="YES" in your /etc/rc.conf in order to start.

[skysurfer]

matt

The mysql port now requires that you have mysql_enable="YES" in your /etc/rc.conf in order to start.

I did this, now the server starts but I get the same message about not connecting to the database.  I am thinking it it time to reinstall with FreeBSD 5.3 release and see what happens with that.  I did have 5.21 running, but it kept running out of memory when Perl decided to own the system, fill the hard drive, swap and temp directory!  So I thought it would be easier to downgrade to stable 4.10, guess not

[JIM]

virtus

Hello there.. I have the same problem! MySQL is runnin just fine, but when I try to use vadddomain I get: vmysql: error creating table 'dir_control': MySQL server has gone away vmysql: sql error: MySQL server has gone away vmysql: error creating table 'blah_com': MySQL server has gone away Error. Failed while attempting to add domain to auth backend vmysql: error creating table 'dir_control': MySQL server has gone away vmysql: error creating table 'dir_control': MySQL server has gone away vmysql: sql error: MySQL server has gone away vmysql: error creating table 'dir_control': MySQL server has gone away vmysql: sql error[e]: MySQL server has gone away Failed while attempting to delete domain from dir_control Error: no auth connection While MySQL is still running just fine: server1# ps aux | grep sql root     26158  0.0 16.0 53876 20004  p0  S     7:29PM   0:02.40 /usr/local/libexec/mysqld -u root From what I can see, there is something wrong with the vpopmail database/tables, that should have been created... (I have no vpopmail tables or even a vpopmail database). Any suggestions would be _REALLY_ welcome, I'm a bit stuck here and I would love to have my Toaster fully running Thanks in advance, and thanks for the great project Matt

Try this steps:
1. add line in /etc/rc.conf         mysql_enable="YES"
2. restart server
3. make "toaster_setup.pl -s vpopmail" again -  create vpopmail table

[skysurfer]

Decided to do the reinstall, of the 5.3 system, although perhaps I should not have  Install went fine, but now qmail is not stating something about a permisions thing.  I created another post for this topic, as I felt it was more appropriate.  I also decided to upgrade because some of the services in the 4.10 were getting old and with the new 6 current, I just thought it would be more hastle in the future if we needed to upgrade.

Thanks for the info again.

[virtus]

Hello everyone,
thanks for the suggestions guys.. However, I'm afraid it still doesn't work.. do you have any more ideas? I did enable mysqld to start in rc.conf, I re-ran toaster_setup -s vpopmail, still no luck.. this is really weird, I started with a fresh install and did not encounter any issues.. When I tried to access the index page in the localroot it didn't work.. I fixed up SSL and now that works.. I still can't use phpMyAdmin though.. (i get a 404 while it is in /usr/local/www/data/phpMyAdmin).

The weird thing on this network is that because of nameserver issues it's not possible to use the extern domain (e.g. blah.foo.com), you have to use the internal server IP adress (10.0.0.160 in this case).. Could this be causing these issues?

If so, how would I go about fixing it?

Thanks in advance

[virtus]

Hey, back again.. I just found out the perms on my /tmp/mysql.sock were weird.. I fixed it but still it doesn't work.. the awkward thing is that it does seem to add the domain, but still gives these errors, look:

Quote:

server1# ./vadddomain server1.coolweb.nl Please enter password for postmaster: enter password again: vmysql: sql error[c]: MySQL server has gone away vmysql: sql error: MySQL server has gone away vmysql: sql error[3]: MySQL server has gone away vmysql: sql error[c]: MySQL server has gone away vmysql: sql error[c]: MySQL server has gone away vmysql: sql error: MySQL server has gone away vmysql: sql error[3]: MySQL server has gone away vmysql: sql error[2]: MySQL server has gone away Failed while attempting to add user to auth backend Error: (vadduser) no auth connection server1# ./vadddomain server1.coolweb.nl Please enter password for postmaster: enter password again: Error: Domain already exists server1# ./vdeldomain server1.coolweb.nl Warning: Failed while attempting to delete domain from auth backend vmysql: sql error[c]: MySQL server has gone away vmysql: sql error[e]: MySQL server has gone away Warning: Failed to delete dir_control for server1.coolweb.nl vmysql: sql error[c]: MySQL server has gone away vmysql: sql error[c]: MySQL server has gone away vmysql: sql error: MySQL server has gone away

It says that the domain already exists.. so it is in the table.. what is causing these errors??  

[aznoktrnl]

Well for those if you all that get MYSQL going and still getting the following error.

vmysql: error creating table 'dir_control': MySQL server has gone away
vmysql: sql error: MySQL server has gone away
vmysql: sql error[3]: MySQL server has gone away
vmysql: error creating table 'dir_control': MySQL server has gone away
vmysql: error creating table 'dir_control': MySQL server has gone away
vmysql: sql error: MySQL server has gone away
vmysql: sql error[3]: MySQL server has gone away
vmysql: sql error[2]: MySQL server has gone away
Failed while attempting to add user to auth backend
Error: (vadduser) no auth connection

You might want to try the following:
http://www.qmailrocks.org/vpopmail_mysql.htm" target="_blank">http://www.qmailrocks.org/vpopmail_mysql.htm

I was having the same problem and it was an authentication error that was happening. Once I followed these steps.. Tada.. All good.

[fnemo]

nd