OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
RE: bugzilla not working now after MySQL re-installed

From: Yiannis Mavroukakis (yiannisjaguarfreight.com)
Date: Fri Jul 02 2004 - 09:56:36 CDT


Yes it does, as it is a 'special' file (it's a socket), notice the 's' in the file definition.
Link this to /tmp/mysql.sock and you should be ok
-----Original Message-----
From: Nguyen, Long P (Mission Systems) [mailto:Long.P.Nguyenngc.com]
Sent: 01 July 2004 21:14
To: Yiannis Mavroukakis; mysqllists.mysql.com
Subject: RE: bugzilla not working now after MySQL re-installed

The 'mysql.sock' file is at /var/lib/mysql/mysql.sock with a size of 0

Does this look right?

[rootseahawk mysql]# pwd
/var/lib/mysql
[rootseahawk mysql]# ls -l mysql.sock
srwxrwxrwx 1 mysql mysql 0 Jul 1 11:41 mysql.sock

-----Original Message-----
From: Yiannis Mavroukakis [mailto:yiannisjaguarfreight.com]
Sent: Thursday, July 01, 2004 12:23 PM
To: mysqllists.mysql.com
Subject: RE: bugzilla not working now after MySQL re-installed

The original error might be slightly more cryptic than it intends. It is saying that it cannot
connect to your db through /tmp/mysql.sock. Check if your mySQL installation has installed
the socket file in another place. If it has, a quick and dirty fix is to soft link the socket file wherever it is to /tmp/mysql.sock

i.e.

ln -s /usr/local/mysql/mysql.sock /tmp/mysql.sock

Change /usr/local/mysql/mysql.sock to your file. In some distributions it can be found in /var/lib/mysql/mysql.sock.

Yiannis.

-----Original Message-----
From: Nguyen, Long P (Mission Systems) [mailto:Long.P.Nguyenngc.com]
Sent: 01 July 2004 17:07
To: Hassan Schroeder; mysqllists.mysql.com
Subject: RE: bugzilla not working now after MySQL re-installed

yes.. below:

[rootseahawk root]# mysql -u bugs -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 4.0.20-standard

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

mysql>

-----Original Message-----
From: Hassan Schroeder [mailto:hassanwebtuitive.com]
Sent: Thursday, July 01, 2004 11:52 AM
To: mysqllists.mysql.com
Subject: Re: bugzilla not working now after MySQL re-installed

Nguyen, Long P (Mission Systems) wrote:

> I tried this and get a 0 affect below..
>
> mysql> GRANT SELECT,INSERT,UPDATE,DELETE,INDEX, ALTER,CREATE,DROP,REFERENCES ON bugs.* TO bugslocalhost IDENTIFIED BY 'marvin';
> Query OK, 0 rows affected (0.00 sec)

OK, I assume 'bugs' and 'marvin' are the values in bugzilla's config
file; can you log in from the MySQL client using them instead of the
root user/pwd?

--
Hassan Schroeder ----------------------------- hassanwebtuitive.com
Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com

                           dream. code.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=long.p.nguyenngc.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=yiannisjaguarfreight.com

________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs.

Note:__________________________________________________________________
This message is for the named person's use only. It may contain
confidential, proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mistransmission.
If you receive this message in error, please immediately delete it and
all copies of it from your system, destroy any hard copies of it and
notify the sender. You must not, directly or indirectly, use, disclose,
distribute, print, or copy any part of this message if you are not the
intended recipient. Jaguar Freight Services and any of its subsidiaries
each reserve the right to monitor all e-mail communications through its
networks.
Any views expressed in this message are those of the individual sender,
except where the message states otherwise and the sender is authorized
to state them to be the views of any such entity.
________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=long.p.nguyenngc.com

________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs.

Note:__________________________________________________________________
This message is for the named person's use only. It may contain
confidential, proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mistransmission.
If you receive this message in error, please immediately delete it and
all copies of it from your system, destroy any hard copies of it and
notify the sender. You must not, directly or indirectly, use, disclose,
distribute, print, or copy any part of this message if you are not the
intended recipient. Jaguar Freight Services and any of its subsidiaries
each reserve the right to monitor all e-mail communications through its
networks.
Any views expressed in this message are those of the individual sender,
except where the message states otherwise and the sender is authorized
to state them to be the views of any such entity.
________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql