Re: bugzilla not working now after MySQL re-installed

2004-07-06 Thread Egor Egorov
Nguyen, Long P (Mission Systems) [EMAIL PROTECTED] wrote:

 Your thoughts on this would be appreciated.
 MySQL was re-installed and now Bugzilla is not working now I am getting this error 
 when I bring up - http://localhost/bugzilla/ http://localhost/bugzilla/ 
 

The scripts were looking for MySQL socket located in /tmp. Now as you installed
the RPM version, the socket is no longer available there. 

You can tweak my.cnf to tell client libraries where to find the socket. Add
socket = /var/lib/mysql/mysql.sock to /etc/my.cnf to [client] section. For
more info, see http://dev.mysql.com/doc/mysql/en/Option_files.html






-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



RE: bugzilla not working now after MySQL re-installed

2004-07-02 Thread Yiannis Mavroukakis

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:[EMAIL PROTECTED]
Sent: 01 July 2004 21:14
To: Yiannis Mavroukakis; [EMAIL PROTECTED]
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?

[EMAIL PROTECTED] mysql]# pwd
/var/lib/mysql
[EMAIL PROTECTED] mysql]# ls -l mysql.sock
srwxrwxrwx1 mysqlmysql   0 Jul  1 11:41 mysql.sock



-Original Message-
From: Yiannis Mavroukakis [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 01, 2004 12:23 PM
To: [EMAIL PROTECTED]
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:[EMAIL PROTECTED]
Sent: 01 July 2004 17:07
To: Hassan Schroeder; [EMAIL PROTECTED]
Subject: RE: bugzilla not working now after MySQL re-installed


yes..  below:

[EMAIL PROTECTED] 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:[EMAIL PROTECTED]
Sent: Thursday, July 01, 2004 11:52 AM
To: [EMAIL PROTECTED]
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 [EMAIL PROTECTED] 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 - [EMAIL PROTECTED]
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/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



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/[EMAIL PROTECTED]



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

Re: bugzilla not working now after MySQL re-installed

2004-07-01 Thread Hassan Schroeder
Nguyen, Long P (Mission Systems) wrote:
Your thoughts on this would be appreciated.
MySQL was re-installed  ,,,

preCan't connect to the mysql database. Is the database installed and
up and running?  Do you have the correct username and password selected in
localconfig?  
What else do you need besides the error message above? It appears
that MySQL isn't running.
Have you *tried* accessing it from the command-line client, using
the username/password set in your localconfig? That would be the
first logical step...
--
Hassan Schroeder - [EMAIL PROTECTED]
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/[EMAIL PROTECTED]


RE: bugzilla not working now after MySQL re-installed

2004-07-01 Thread Nguyen, Long P (Mission Systems)
MySQL is running..

[EMAIL PROTECTED] /]# ps -ef | grep mysql
root  1338 1  0 10:51 pts/200:00:00 /bin/sh /usr/bin/mysqld_safe --d
mysql 1362  1338  0 10:51 pts/200:00:00 /usr/sbin/mysqld --basedir=/ --d
root  1374  1124  0 10:51 pts/200:00:00 grep mysql


-Original Message-
From: Hassan Schroeder [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 01, 2004 10:38 AM
To: Nguyen, Long P (Mission Systems); [EMAIL PROTECTED]
Subject: Re: bugzilla not working now after MySQL re-installed


Nguyen, Long P (Mission Systems) wrote:

 Your thoughts on this would be appreciated.
 MySQL was re-installed  ,,,

 preCan't connect to the mysql database. Is the database installed and
 up and running?  Do you have the correct username and password selected in
 localconfig?  

What else do you need besides the error message above? It appears
that MySQL isn't running.

Have you *tried* accessing it from the command-line client, using
the username/password set in your localconfig? That would be the
first logical step...

-- 
Hassan Schroeder - [EMAIL PROTECTED]
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/[EMAIL PROTECTED]



Re: bugzilla not working now after MySQL re-installed

2004-07-01 Thread Hassan Schroeder
Nguyen, Long P (Mission Systems) wrote:
MySQL is running..
OK, that's /half/ the question :-)
Have you *tried* accessing it from the command-line client, using
the username/password set in your localconfig? 
Does the username and password in localconfig get you into the DB
using the MySQL client?
--
Hassan Schroeder - [EMAIL PROTECTED]
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/[EMAIL PROTECTED]


RE: bugzilla not working now after MySQL re-installed

2004-07-01 Thread Nguyen, Long P (Mission Systems)
I am able to log into mysql as this:


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

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

mysql


I tried this and get a 0 affect below..

mysql GRANT SELECT,INSERT,UPDATE,DELETE,INDEX, ALTER,CREATE,DROP,REFERENCES ON bugs.* 
TO [EMAIL PROTECTED] IDENTIFIED BY 'marvin';
Query OK, 0 rows affected (0.00 sec)

Thanks for your help...



-Original Message-
From: Hassan Schroeder [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 01, 2004 11:34 AM
To: [EMAIL PROTECTED]
Subject: Re: bugzilla not working now after MySQL re-installed


Nguyen, Long P (Mission Systems) wrote:

 MySQL is running..

OK, that's /half/ the question :-)

 Have you *tried* accessing it from the command-line client, using
 the username/password set in your localconfig? 

Does the username and password in localconfig get you into the DB
using the MySQL client?

-- 
Hassan Schroeder - [EMAIL PROTECTED]
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/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: bugzilla not working now after MySQL re-installed

2004-07-01 Thread Hassan Schroeder
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 [EMAIL PROTECTED] 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 - [EMAIL PROTECTED]
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/[EMAIL PROTECTED]


RE: bugzilla not working now after MySQL re-installed

2004-07-01 Thread Nguyen, Long P (Mission Systems)
yes..  below:

[EMAIL PROTECTED] 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:[EMAIL PROTECTED]
Sent: Thursday, July 01, 2004 11:52 AM
To: [EMAIL PROTECTED]
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 [EMAIL PROTECTED] 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 - [EMAIL PROTECTED]
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/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: bugzilla not working now after MySQL re-installed

2004-07-01 Thread Hassan Schroeder
Nguyen, Long P (Mission Systems) wrote:
yes..  below:
[EMAIL PROTECTED] 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
Uh, OK. You said MySQL was re-installed -- why? Was it the same
version, or an upgrade? If the latter, there's a difference in the 
authentication between 3.x and 4.x that requires a client upgrade
(or that you explicitly use the old auth).

If it was the same version re-installed, is it possible some file
system permissions were changed? And does anything show up in the
MySQL logs when bugzilla runs (or tries to)?
--
Hassan Schroeder - [EMAIL PROTECTED]
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/[EMAIL PROTECTED]


RE: bugzilla not working now after MySQL re-installed

2004-07-01 Thread Nguyen, Long P (Mission Systems)
I am able to logon with user 'bugs' and passwd 'marvin' as below:

[EMAIL PROTECTED] 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


I noticed before the MySQL installed - when I do a 'which mysql' I get output of 
'/usr/local/mysql/bin/mysql' - but now I get /usr/bin/mysql.

But why does bugzilla checksetup.pl failed to connect to the database in error below..

Checking user setup ...
Precompiling templates ...
DBI connect(';localhost;3306','bugs',...) failed: Can't connect to local MySQL server 
through socket '/tmp/mysql.sock' (2) at ./checksetup.pl line 1189
[Thu Jul  1 12:32:14 2004] checksetup.pl: DBI connect(';localhost;3306','bugs',...) 
failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at 
./checksetup.pl line 1189
h1Software error:/h1
preCan't connect to the mysql database. Is the database installed and
up and running?  Do you have the correct username and password selected in
localconfig?  AHA

/pre
p
For help, please send mail to this site's webmaster, giving this error message
and the time and date of the error.

/p
[Thu Jul  1 12:32:14 2004] checksetup.pl: Can't connect to the mysql database. Is the 
database installed and
[Thu Jul  1 12:32:14 2004] checksetup.pl: up and running?  Do you have the correct 
username and password selected in
[Thu Jul  1 12:32:14 2004] checksetup.pl: localconfig?  AHA
[Thu Jul  1 12:32:14 2004] checksetup.pl:
[EMAIL PROTECTED] bugzilla-2.16.5]#


-Original Message-
From: Hassan Schroeder [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 01, 2004 11:52 AM
To: [EMAIL PROTECTED]
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 [EMAIL PROTECTED] 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 - [EMAIL PROTECTED]
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/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



RE: bugzilla not working now after MySQL re-installed

2004-07-01 Thread Yiannis Mavroukakis
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:[EMAIL PROTECTED]
Sent: 01 July 2004 17:07
To: Hassan Schroeder; [EMAIL PROTECTED]
Subject: RE: bugzilla not working now after MySQL re-installed


yes..  below:

[EMAIL PROTECTED] 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:[EMAIL PROTECTED]
Sent: Thursday, July 01, 2004 11:52 AM
To: [EMAIL PROTECTED]
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 [EMAIL PROTECTED] 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 - [EMAIL PROTECTED]
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/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



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/[EMAIL PROTECTED]



RE: bugzilla not working now after MySQL re-installed

2004-07-01 Thread Nguyen, Long P (Mission Systems)
I re-installed it this time by rpm because when I tried to recompile it with 
'--with-mqsql' this DRES and some other errors for Keystone tools keeps telling me 
that MySQL needs to be recompiled with '--with-mqsql'.  This time with the 
re-installed - I used rpm.

Same version but by rpm.
I noticed that my databases are not there anymore when I do a 'show databases'.  I 
just need to get Bugzilla to run the checksetup.pl script and it will go and create 
what it needs.  but the unable to logon error is preventing it.

There should not be any differ between rpm and the compile install is there?


-Original Message-
From: Hassan Schroeder [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 01, 2004 12:20 PM
To: [EMAIL PROTECTED]
Subject: Re: bugzilla not working now after MySQL re-installed


Nguyen, Long P (Mission Systems) wrote:

 yes..  below:
 
 [EMAIL PROTECTED] 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

Uh, OK. You said MySQL was re-installed -- why? Was it the same
version, or an upgrade? If the latter, there's a difference in the 
authentication between 3.x and 4.x that requires a client upgrade
(or that you explicitly use the old auth).

If it was the same version re-installed, is it possible some file
system permissions were changed? And does anything show up in the
MySQL logs when bugzilla runs (or tries to)?

-- 
Hassan Schroeder - [EMAIL PROTECTED]
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/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



RE: bugzilla not working now after MySQL re-installed

2004-07-01 Thread Nguyen, Long P (Mission Systems)
The 'mysql.sock' file is at /var/lib/mysql/mysql.sock with a size of 0

Does this look right?

[EMAIL PROTECTED] mysql]# pwd
/var/lib/mysql
[EMAIL PROTECTED] mysql]# ls -l mysql.sock
srwxrwxrwx1 mysqlmysql   0 Jul  1 11:41 mysql.sock



-Original Message-
From: Yiannis Mavroukakis [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 01, 2004 12:23 PM
To: [EMAIL PROTECTED]
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:[EMAIL PROTECTED]
Sent: 01 July 2004 17:07
To: Hassan Schroeder; [EMAIL PROTECTED]
Subject: RE: bugzilla not working now after MySQL re-installed


yes..  below:

[EMAIL PROTECTED] 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:[EMAIL PROTECTED]
Sent: Thursday, July 01, 2004 11:52 AM
To: [EMAIL PROTECTED]
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 [EMAIL PROTECTED] 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 - [EMAIL PROTECTED]
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/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



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/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: bugzilla not working now after MySQL re-installed

2004-07-01 Thread Hassan Schroeder
Nguyen, Long P (Mission Systems) wrote:
I re-installed it this time by rpm 
/
Same version but by rpm.
/
I noticed that my databases are not there anymore when I do a 
 'show databases'.  I just need to get Bugzilla to run the
checksetup.pl script and it will go and create what it needs.  
but the unable to logon error is preventing it.
If it's been installed in a different place, and you're no longer
accessing the original database files, your user/password info will
need to be re-entered. But you probably got that already.
There should not be any differ between rpm and the compile install 
 is there?
I run RedHat but I'm not that much of an RPM fan; tried it a few
times and got tired of wierd installation defaults... :-)
It's certainly possible the RPM was compiled with different options
than the configure/make defaults, though.
--
Hassan Schroeder - [EMAIL PROTECTED]
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/[EMAIL PROTECTED]