MySQL and Roundcube Problem - db won't start!
X-No-Archive: true Hi, With the gracious help of a poster here, I managed to get roundcube up and running, and had to resort to MySQL, which I know very little of. After it was all up and running, and we'd added the users and tested their access to webmail, we decided to put some more memory into the machine. So a quick shutdown later, and we were powering back up. Disaster: MySQL didn't start and so roundcube mail just gives us 'service currently unavailable' !! I've scoured the MySQL website, FAQ, etc., but can I start the damned database? Can I hell. [EMAIL PROTECTED]/usr/local/bin(111): ./mysqladmin start ./mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! ... and other similar errors. Fortunately, this server won't be 'production' until teachers and pupils come back next week after the Sukkot holidays .. if this had happened when the server was being accessed by 95 people, bang would have gone our credibility. Anyone able to help me get the db up and running, whilst I try to learn about MySQL before this happens again ? Thanks. D. - Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Demandez à ceux qui savent sur Yahoo! Questions/Réponses. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: MySQL and Roundcube Problem - db won't start!
Hi, With the gracious help of a poster here, I managed to get roundcube up and running, and had to resort to MySQL, which I know very little of. After it was all up and running, and we'd added the users and tested their access to webmail, we decided to put some more memory into the machine. So a quick shutdown later, and we were powering back up. Disaster: MySQL didn't start and so roundcube mail just gives us 'service currently unavailable' !! I've scoured the MySQL website, FAQ, etc., but can I start the damned database? Can I hell. [EMAIL PROTECTED]/usr/local/bin(111): ./mysqladmin start ./mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! You say too little about your system to allow proper help. How did you install MySQL? Fro the source? From the ports? From package? If you installed MySQL through FreeBSD mechanism, it should be started with the comand: /usr/local/etc/rc.d/mysql.sh start provided you have put mysql_enable=YES in /etc/rc.conf Else youmust locate your MySQL log file and see why it is not starting, if it is failingbecause of some error. mysqladmin is a command to MySQL database server, so it suppose that MySQL is running beforeyou can issue any mysqladmin command. Bests, Olivier ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: MySQL and Roundcube Problem - db won't start!
Hi, could you please try and run this: # /usr/local/libexec/mysqld -u root you probably want to add an ampersand '' at the end of the line. and let me/us know if it works. I am sure this is not the appropriate way to do this, but maybe it will get you started. I am also curious for the response from experienced people for the above command which i think will work. All these provided that you have the mysql server installed.. Regards, Spiros On 13/10/06, Desmond Coughlan [EMAIL PROTECTED] wrote: X-No-Archive: true Hi, With the gracious help of a poster here, I managed to get roundcube up and running, and had to resort to MySQL, which I know very little of. After it was all up and running, and we'd added the users and tested their access to webmail, we decided to put some more memory into the machine. So a quick shutdown later, and we were powering back up. Disaster: MySQL didn't start and so roundcube mail just gives us 'service currently unavailable' !! I've scoured the MySQL website, FAQ, etc., but can I start the damned database? Can I hell. [EMAIL PROTECTED]/usr/local/bin(111): ./mysqladmin start ./mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! ... and other similar errors. Fortunately, this server won't be 'production' until teachers and pupils come back next week after the Sukkot holidays .. if this had happened when the server was being accessed by 95 people, bang would have gone our credibility. Anyone able to help me get the db up and running, whilst I try to learn about MySQL before this happens again ? Thanks. D. - Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Demandez à ceux qui savent sur Yahoo! Questions/Réponses. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] -- Spiros Papadopoulos ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: MySQL and Roundcube Problem - db won't start!
On Fri, 13 Oct 2006 10:18:43 +0100 Spiros Papadopoulos [EMAIL PROTECTED] wrote: # /usr/local/libexec/mysqld -u root you probably want to add an ampersand '' at the end of the line. and let me/us know if it works. I am sure this is not the appropriate way to do this, but maybe it will get you started. and if you (original mysql-newbie-poster) want to check the logfiles, they're usually in /var/db/mysql/ you'll want to look at the *.err file(s), it could just be a problem with the socket -- grtjs, albi ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: MySQL and Roundcube Problem - db won't start!
Olivier Nicole wrote: [...] If you installed MySQL through FreeBSD mechanism, it should be started with the comand: /usr/local/etc/rc.d/mysql.sh start Actually, mine is: /usr/local/etc/rc.d/mysql-server I think it depends on what version is installed. provided you have put mysql_enable=YES in /etc/rc.conf Same here. [...] -- Gerard sic transit gloria mundi ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
RE : Re: MySQL and Roundcube Problem - db won't start!
X-No-Archive: true Thanks guys.. it worked. I still don't know why MySQL didn't start at boot. That's worrying, 'cos if I get hit by a car on my way home tonight, and the bloke who does IT here knows MySQL even less than I do (no really.. that _is_ possible..) I've printed out the command that I used, and pinned it to the wall next to the machine. :) D. -- Des Coughlan [EMAIL PROTECTED] Un client de plus, c'est un relou de plus... - Yahoo! Mail réinvente le mail ! Découvrez le nouveau Yahoo! Mail et son interface révolutionnaire. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: RE : Re: MySQL and Roundcube Problem - db won't start!
Desmond Coughlan wrote: X-No-Archive: true Thanks guys.. it worked. I still don't know why MySQL didn't start at boot. That's worrying, 'cos if I get hit by a car on my way home tonight, and the bloke who does IT here knows MySQL even less than I do (no really.. that _is_ possible..) I've printed out the command that I used, and pinned it to the wall next to the machine. :) D. check the error logs tho, that will explain why its not restarting. most likely you have to just delete the old sock files Eric ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: RE : Re: MySQL and Roundcube Problem - db won't start!
Hi again, On 13/10/06, Desmond Coughlan [EMAIL PROTECTED] wrote: X-No-Archive: true Thanks guys.. it worked. I still don't know why MySQL didn't start at boot. I am using MySQL occasionally in my FreeBSD. For this reason when i first had the same with you problem and i found this way to start it, i never tried to fix it due to the fact that i don't need it..yet. I will try and fix it when i will really need MySQL to start on startup, which can be at any time. I am not 100% sure, this is why i asked for comments from other experienced users. On the other hand since it works it is a possible solution! Maybe not the best possible one, but it is. I sent you this, to start you working and have time to look for a more appropriate solution if you want / if exists (must exists). That's worrying, 'cos if I get hit by a car on my way home tonight, and the bloke who does IT here knows MySQL even less than I do (no really.. that _is_ possible..) I've printed out the command that I used, and pinned it to the wall next to the machine. :) b that's gruesome :) You can always put the command in your .cshrc file (WARNING: i haven't done this myself ! ..but i cannot see any reason why it should not work), again until you find the way to fix the /etc/rc.d/*mysql* script Regards Spiros ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]