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
