[opencms-dev] Installation Problem: Server configuration denies access to data source

[Rafael Diaz Valdes]

 Hi, Petr
 Thanks for your replay Petr, I'll be so glad if you can help me.
I haven't configured access for root user. I have only assigned a password to root accounts using:

shell> mysqladmin -u root password "newpwd"
shell> mysqladmin -u root -h host_name password "newpwd"

Also I check the root grants doing:

[root at pcepaip30 local]# mysql -u root -h localhost -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 20 to server version: 4.1.1-alpha-standard-log

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

mysql> SHOW GRANTS FOR root at localhost;
+---------------------------------------------------------------------------------------------------------------+
| Grants for root at localhost                                                                                     |
+---------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '3dcfe44136403ab8' WITH GRANT OPTION |
+---------------------------------------------------------------------------------------------------------------+
1 row in set (0.10 sec)



Should I put a my.cnf into the /etc directory or not?

Thanks in advance

 Rafael


-----Original Message-----
From:	opencms-dev-admin at opencms.org on behalf of Petr Hollay
Sent:	Mon 3/1/2004 5:43 PM
To:	opencms-dev at opencms.org
Cc:	
Subject:	AW: [opencms-dev] Installation Problem: Server configuration denies access to data source

Hi,

1) do you have configured access for root user in MySQL for localhost?
2) what is the complete stack trace?

Best regards
Petr



-----Ursprüngliche Nachricht-----
Von: opencms-dev-admin at opencms.org [mailto:opencms-dev-admin at opencms.org] Im
Auftrag von Rafael Diaz Valdes
Gesendet: Montag, 1. März 2004 16:40
An: opencms-dev at opencms.org
Betreff: [opencms-dev] Installation Problem: Server configuration denies
access to data source

Hi,
I am trying to configure Open CMS
5.0.0 with mysql. But while Database and and table creation I am getting
following error.
 
Could no connect to database via: jdbc:mysql://localhost:3306/
java.sql.SQLException: Server configuration denies access to data source
-------------------------------------------
java.lang.NullPointerException

I tested mysql with the root password I assigned using mysqladmin -u
root -p, so it looks like mysql is setup correctly.However when trying
to create the database in opencms I get that message.
 Best  Regards,
Rafael



                          \|||/   
                          (o o)
-----------------------oo0-(_)-0oo------------------------------- 
MSc.Rafael Díaz Valdes                                           
Dpto. Física
Centro de Aplicaciones Tecnológicas y Desarrollo Nuclear (CEADEN)
P.O. Box 6122, Cuba.
Tel: 2093920
E-Mail: rdiaz at ceaden.edu.cu
Fax:(537)2021518
-----------------------------------------------------------------

_______________________________________________
This mail is send to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://mail.opencms.org/mailman/listinfo/opencms-dev

_______________________________________________
This mail is send to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://mail.opencms.org/mailman/listinfo/opencms-dev



-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 4326 bytes
Desc: not available
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20040301/e54a4dd2/attachment.bin>