I am having a similar problem. I looked at another Linux machine that
has MySQL 4.0.13 running on it and the file /var/lib/mysql/mysql.sock
is there but it is empty.
Well, that's the way sockets always look to my when I look at them with
a directory listing.
So I created the file, chmod
Kevin H. Phillips wrote:
Well, the find / -name mysql.sock didn't return anything at all so this
*is* an odd predicament. Would it work if someone with a similar
version e-mailed me a copy of their mysql.sock file?
Kevin
John Nichel wrote:
It doesn't look as if you have any conflicting
: mysql.sock doesn't exist
Kevin H. Phillips wrote:
Well, the find / -name mysql.sock didn't return anything at all so this
*is* an odd predicament. Would it work if someone with a similar
version e-mailed me a copy of their mysql.sock file?
Kevin
John Nichel wrote:
It doesn't look
stuck on this
quite a
while.
Good Luck
Brian
-Original Message-
From: John Nichel [mailto:[EMAIL PROTECTED]
Sent: Friday, June 27, 2003 8:25 AM
To: [EMAIL PROTECTED]
Subject: Re: mysql.sock doesn't exist
Kevin H. Phillips wrote:
Well, the find / -name mysql.sock didn't return anything
The permissions on my /var/lib/mysql directory are: File Owner: mysql
- MySQL Server; Group is mysql.
I did discover that I had not set a user in /etc/my.cnf. Once I did
that, the mysql.sock file was set up (doh! sorry about that).
Here's a portion of what I get when I do ls -l
Well, the find / -name mysql.sock didn't return anything at all so this
*is* an odd predicament. Would it work if someone with a similar
version e-mailed me a copy of their mysql.sock file?
Kevin
John Nichel wrote:
It doesn't look as if you have any conflicting MySQL versions. When the
I am having a similar problem. I looked at another Linux machine that
has MySQL 4.0.13 running on it and the file /var/lib/mysql/mysql.sock
is there but it is empty. So I created the file, chmod to 777 and then
tried to light up /usr/bin/mysqld_safe and it is giving the same error
message
Well, the find / -name mysql.sock didn't return anything at all so this
*is* an odd predicament.
Maybe it doesn't exist unless mysqld is running? Maybe the mysqld user
can't get at the directory the socket is supposed to be in?
Would it work if someone with a similar
version e-mailed me a
Yes, I installed by RPM. I have now found the error file as you
mentioned. The output for the last few days is:
030621 06:49:27 mysqld started
030621 6:49:28 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on
Kevin H. Phillips wrote:
Yes, I installed by RPM. I have now found the error file as you
mentioned. The output for the last few days is:
030621 06:49:27 mysqld started
030621 6:49:28 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting
The output of the greps follows. Could it be the mysqlclient that is
causing the trouble?
Kevin
[EMAIL PROTECTED] root]# rpm -qa | grep My
MySQL-python-debuginfo-0.9.1-7
Mysql-DBI-perl-bin-1.1825-1
MySQL-shared-3.23.53a-1
qt-MySQL-3.1.1-6
MySQL-python-0.9.1-7
MyODBC-2.50.39-11
Is the mysql server currently running? You can also use either -S or
--socket to specify the socket connection.
-Original Message-
From: Kevin H. Phillips [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 8:10 AM
To: [EMAIL PROTECTED]
Subject: mysql.sock doesn't exist
I apologize
Yes, the server is running. One odd thing about my setup is that when I
restart the service I get a Failed signal for the shutdown phase but
an OK for the start phase.
Thanks,
Kevin
Victor Pendleton wrote:
Is the mysql server currently running? You can also use either -S or
--socket to
From the mysql monitor `show variables` to see what socket the server is
connecting on.
-Original Message-
From: Kevin H. Phillips [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 8:33 AM
Cc: [EMAIL PROTECTED]
Subject: Re: mysql.sock doesn't exist
Yes, the server is running. One
Kevin H. Phillips wrote:
Yes, the server is running. One odd thing about my setup is that when I
restart the service I get a Failed signal for the shutdown phase but
an OK for the start phase.
Thanks,
Kevin
Victor Pendleton wrote:
Is the mysql server currently running? You can also use either
Nichel [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 9:26 AM
To: Kevin H. Phillips
Cc: [EMAIL PROTECTED]
Subject: Re: mysql.sock doesn't exist
Kevin H. Phillips wrote:
Yes, the server is running. One odd thing about my setup is that when I
restart the service I get a Failed signal
The output of the grep is:
[EMAIL PROTECTED] root]# ps -ax | grep mysqld
4578 ?S 0:00 /bin/sh /usr/bin/mysqld_safe
--defaults-file=/etc/my.cnf
4601 ?S 0:01 /usr/libexec/mysqld
--defaults-file=/etc/my.cnf --basedir=/usr --datadir=/var/lib/mysql
--user=mysql
Stop the process you currently have or start up the server on a port other
than 3306.
-Original Message-
From: Kevin H. Phillips [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 1:46 PM
Cc: [EMAIL PROTECTED]
Subject: Re: mysql.sock doesn't exist
The output of the grep is:
[EMAIL
Kevin H. Phillips wrote:
The output of the grep is:
[EMAIL PROTECTED] root]# ps -ax | grep mysqld
4578 ?S 0:00 /bin/sh /usr/bin/mysqld_safe
--defaults-file=/etc/my.cnf
4601 ?S 0:01 /usr/libexec/mysqld
--defaults-file=/etc/my.cnf --basedir=/usr
I changed the port in /etc/my.cnf and restarted the service but still
get a message that I can't connect to the server, etc.
I am still not seeing any fresh log messages. Why would there not be
any output on that? Is there someplace I should look for a log file
besides /var/log ?
Kevin
--
Kevin H. Phillips wrote:
I changed the port in /etc/my.cnf and restarted the service but still
get a message that I can't connect to the server, etc.
I am still not seeing any fresh log messages. Why would there not be
any output on that? Is there someplace I should look for a log file
21 matches
Mail list logo