Re: [cobalt-developers] Re: RaQ 550 & mysql

[Raq Admin <raq@xxxxxxxxxxxxx>]

Hi Jan - thanks for the reply.

I followed your directions and findings are below.

Of note is that fact that start/stop commands returned file not found.

At 12:46 AM 6/5/2003 +0200, you wrote:
> Hi,
> sounds wired: How do you try to access mysql by web? What application do
> you use? Is it configured properly? Is mysql runnig? Have you installed
> mysql and its components properly? Did you use the package from pkgmaster?

I did nothing to the installation of mysql.  I had the understanding that 
it was configured by default

I did install pkgmaster and receive the same error


> Can you connect from console with:
> mysql -u root

Yes
[root /]# mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 85 to server version: 3.23.38

Type 'help;' or '\h' for help. Type '\c' to clear the buffer

mysql>



> If not, try:
> ps -ax | grep mysql
> This should display at least one or three mysql-processes.

[root /]# ps -ax | grep mysql
 1164 ?        S      0:00 /bin/sh /usr/bin/safe_mysqld 
--datadir=/var/lib/mysql
 1199 ?        S      0:00 /usr/sbin/mysqld --basedir=/ 
--datadir=/var/lib/mysql
 1225 ?        S      0:00 /usr/sbin/mysqld --basedir=/ 
--datadir=/var/lib/mysql
 1226 ?        S      0:00 /usr/sbin/mysqld --basedir=/ 
--datadir=/var/lib/mysql
22125 pts/1    S      0:00 grep mysql
[root /]#



> If not, try:
> /etc/rc.d/mysql stop

[root /]# /etc/rc.d/mysql stop
bash: /etc/rc.d/mysql: No such file or directory


> /etc/rc.d/mysql start

[root /]# /etc/rc.d/mysql start
bash: /etc/rc.d/mysql: No such file or directory



> If you still can't connect, does the socket /tmp/mysql.sock exist?
> Try ls -al /tmp/ and you should see it. If it exists, stop mysql with

[root /]# ls -al /tmp/
total 24
drwxrwxrwt    5 root     root         4096 Jun  4 08:17 .
drwxr-xr-x   19 root     root         4096 May  5 03:42 ..
drwxrwxrwx    2 root     root            6 Jun  4 08:17 .casp3000
-rw-r-----    1 root     root          414 May 28 19:10 noterror
drwxr-xr-x    2 httpd    httpd         133 May  9 08:41 paletteStatus
-rw-------    1 httpd    httpd         103 May  8 16:46 
sess_2d7ff2cc41373a7120dbb17805f280b9
-rw-------    1 httpd    httpd          15 May 23 15:24 
sess_7bb5b69b2ab07256c0282095af38ab29
-rw-------    1 httpd    httpd          16 May  1 13:18 
sess_b489514e53efbd78665c0803ea608f98
drwx------    5 root     root           74 Jun  1 04:26 .swupdate
[root /]#

Not there....

> /etc/rc.d/mysql stop
> and rename or delete /tmp/mysql.sock and afterwards restart
> /etc/rc.d/mysql start
> (this helped me out with a non-working socket, after deleting it and
> restarting mysql it created a new socket).
> Hope this helps a bit, good luck.
> Yours
> Jan*
> Raq Admin writes:
> > Brand new RAQ user.
> > When I attempt to access mysql through browser for virtual sites I get 
> > the following error.
> > Error
> > MySQL said:
> >
> > Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
> >
> > Any help is greatly appreciated.
> > Thanks
> > GNH
> > _______________________________________________
> > cobalt-developers mailing list
> > cobalt-developers@xxxxxxxxxxxxxxx
> > http://list.cobalt.com/mailman/listinfo/cobalt-developers
>
>
> --
> ---------------------
> Ingenieurbüro Münter
> Jörg Jan Münter
> Leipziger Straße 16
> 38165 Wendhausen
> info@xxxxxxxxxxx
> Tel: 05309 - 8052
> Fax: 05309 - 8053
> ---------------------
> _______________________________________________
> cobalt-developers mailing list
> cobalt-developers@xxxxxxxxxxxxxxx
> http://list.cobalt.com/mailman/listinfo/cobalt-developers