Hi,
The grant statement seems to be wrong. It should look like this:
GRANT ALL ON {db_name}.* TO [EMAIL PROTECTED] IDENTIFIED BY 'somepassword';
Yours looks like this:
grant all privileges on openca.* to root identified by "openca";
This means that you created the user root with password openca. In your
config.xml you use a different user name and password.
Mit freundlichen Gr��en / With Kind Regards
Max Schmid
-----Urspr�ngliche Nachricht-----
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Andr�a Cavallari
Gesendet: Donnerstag, 24. Februar 2005 13:54
An: [email protected]
Betreff: Re: [Openca-Users] CONNECT_FAILED
Hello Dalini!
So, let me talk about my environment...
I'm using in the same machine mysql and CA.
Here, we can see taht mysql is connected and using the 3306 port:
[EMAIL PROTECTED] openca]# netstat -anp
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address
State PID/Program name
tcp 0 0 0.0.0.0:3306 0.0.0.0:*
LISTEN 6850/mysqld
tcp 0 0 0.0.0.0:80 0.0.0.0:*
LISTEN 2713/httpd
tcp 0 0 0.0.0.0:22 0.0.0.0:*
LISTEN 2268/sshd
tcp 0 0 127.0.0.1:25 0.0.0.0:*
LISTEN 2300/sendmail: acce
tcp 0 0 0.0.0.0:443 0.0.0.0:*
LISTEN 2713/httpd
tcp 0 0 10.10.3.174:22 10.10.2.181:3399
ESTABLISHED 8608/0
tcp 52 0 10.10.3.174:22 10.10.2.181:3429
ESTABLISHED 8676/2
Active UNIX domain sockets (servers and established)
Proto RefCnt Flags Type State I-Node PID/Program name
Path
unix 2 [ ACC ] STREAM LISTENING 60704 8100/perl
/var/lib/openca/tmp/openca_xml_cache
unix 2 [ ACC ] STREAM LISTENING 64517 8101/perl
/var/lib/openca/tmp/openca_socket
unix 2 [ ACC ] STREAM LISTENING 58732 6850/mysqld
/var/lib/mysql/mysql.sock
unix 2 [ ACC ] STREAM LISTENING 7898 2658/xfs
/tmp/.font-unix/fs7100
unix 2 [ ACC ] STREAM LISTENING 2844 2319/gpm
/dev/gpmctl
unix 10 [ ] DGRAM 2399 2168/syslogd
/dev/log
unix 3 [ ] STREAM CONNECTED 65358 6850/mysqld
/var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 65357 8732/mysql
unix 3 [ ] STREAM CONNECTED 64515 8100/perl
/var/lib/openca/tmp/openca_xml_cache
unix 3 [ ] STREAM CONNECTED 64514 8101/perl
unix 2 [ ] DGRAM 60854 8101/perl
unix 2 [ ] DGRAM 7948 2658/xfs
unix 2 [ ] DGRAM 7924 2677/rhnsd
unix 2 [ ] DGRAM 7867 2632/crond
unix 2 [ ] DGRAM 2831 2309/clientmqueue
unix 2 [ ] DGRAM 2814 2300/sendmail: acce
unix 2 [ ] DGRAM 2488 2231/apmd
unix 2 [ ] DGRAM 2407 2172/klogd
In the /varlog/mysqld.log I have:
050223 15:52:37 mysqld started
Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do not
want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld]
section of init parameters in your my.cnf or my.ini. If you want to use InnoDB
tables, add to the [mysqld] section, for example, innodb_data_file_path =
ibdata1:10M:autoextend But to get good performance you should adjust for your
hardware the InnoDB startup options listed in section 2 at
http://www.innodb.com/ibman.html
/usr/libexec/mysqld: ready for connections
To create de DB I use:
mysql -uroot -p mysql
<password>
create database openca;
create database openra;
grant all privileges on openca.* to root identified by "openca"; grant all
privileges on openra.* to root identified by "openra";
I can connect....
mysql> connect openca
Connection id: 22
Current database: openca
And I can see the database created...
mysql> show databases;
+----------+
| Database |
+----------+
| mysql |
| openca |
| openra |
| test |
+----------+
4 rows in set (0.00 sec)
But when I will test it, I have this result:
[EMAIL PROTECTED] openca]# mysql -uopenca -p
Enter password: (I DIDN'T INPUT ANY PASSWORD! BUT I CAN ENTER!!) Welcome to the
MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 23 to
server version: 3.23.58
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use openca;
ERROR 1044: Access denied for user: '@localhost' to database 'openca'
mysql>
In my config.xml I have a password for openca DB:
<!-- ====================== -->
<!-- database configuration -->
<!-- ====================== -->
<option>
<name>dbmodule</name>
<!-- you can use DB or DBI -->
<value>DBI</value>
</option>
<option>
<name>db_type</name>
<value>mysql</value>
</option>
<option>
<name>db_name</name>
<value>openca</value>
</option>
<option>
<name>db_host</name>
<value>10.10.3.174</value>
</option>
<option>
<name>db_port</name>
<value>3306</value>
</option>
<option>
<name>db_user</name>
<value>openca</value>
</option>
<option>
<name>db_passwd</name>
<value>mudar123</value>
</option>
<option>
But if I type the same password that I have in config.xml I have this result
(the password is the same to login on linux too):
[EMAIL PROTECTED] openca]# mysql -uopenca -p
Enter password:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
So, Where I can define a correct password for this user openca??
Why mysql is referenced by localhost if I put the ip address in config.xml??
There are any mysql config file that I can verify this??
Thanks a lot!
Andr�a
----- Original Message -----
From: "Ives Steglich" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Thursday, February 24, 2005 9:01 AM
Subject: Re: [Openca-Users] CONNECT_FAILED
Andr�a Cavallari wrote:
> config.xml and started to see the error.
>
i just forgot
could you please send the mysql setting for this user?
means, what is the exact entry for the rights... in the user table? (pwd
doesn't matter...) together with the config.xml entry and like mentioned, where
is the db - same machine, different machine and if they are different, whats
the ca dns/ip... this must match the mysql entry... if its not % (for all host
to allow to connect, which it shouldn't of
course)
greetings
dalini
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_ide95&alloc_id396&op=ick
_______________________________________________
Openca-Users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openca-users
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
Openca-Users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openca-users
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_ide95&alloc_id396&op=click
_______________________________________________
Openca-Users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openca-users
