Hi! Try to check username AND password you issued to xwiki user. According to hibernate.cfg password is also set to "xwiki". :-) Username looks fine. Is it the same with password? Kind Regards, Dmitry Mon, 23 Jul 2012 13:04:06 -0700 (PDT) от raav2012 <[email protected]>: Hello everyone I' ve been really busy tryin to figure out what's wrong with my mysql conf., I've searched about this but can't find anything related so any advice, tip, hint... would be greatly welcome. Here's my conf. so far 1) Extracted xiki.war on tomcat/webapps folder... ( using Winscp ) http://xwiki.475771.n2.nabble.com/file/n7580467/xwiki-on-tomcat.jpg 2) Copy mysql driver inside xwiki/WEB-INF/lib folder http://xwiki.475771.n2.nabble.com/file/n7580467/mysql-driver-installed.jpg 3) Create the database xwiki ( currently empty ) http://xwiki.475771.n2.nabble.com/file/n7580467/mysql-database-list.jpg 4) Create user xwiki, grant all privileges ( using phpmyadmin) http://xwiki.475771.n2.nabble.com/file/n7580467/user-xwiki-all-provoleges.jp... 5) Edit the hibernate.cfg.xml file http://xwiki.475771.n2.nabble.com/file/n7580467/hibernate-cfg.jpg 6) Tomcat Working ... http://xwiki.475771.n2.nabble.com/file/n7580467/tomcat-working.jpg 7) netstat list, mysql http://xwiki.475771.n2.nabble.com/file/n7580467/procesos-mysql.jpg 8) And finally, THE HORROR!. http://xwiki.475771.n2.nabble.com/file/n7580467/xwiki-problem.jpg Any clue about this?, im using CentOS (based on Red Hat), seems like a dumb mistake but I'm out of ideas. Thanks in advance, Robinson. -- View this message in context: http://xwiki.475771.n2.nabble.com/Mysql-Configuration-problem-tp7580467.html Sent from the XWiki- Users mailing list archive at Nabble.com. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users Kind regards, Dmitry

Hello, Why is there two mysql listening? Have you tried simply connect through the command line with the xwiki credentials? mysql -u xwiki -p --port 3306 xwiki

You should be able to access this database with no problem. Perhaps you're connected to the other running mysql instance when you make you tests..? If it's the case, you can set the mysql port in the hibernate file (mysql://localhost:3306/xwiki) Good luck! Guillaume Fenollar XWiki SAS 2012/7/26 raav2012 <[email protected]>

Hi Dmitry, thanks for the answer.

Yeah, the database, user and password are set to xwiki, still cant find what wrong tho, xwiki user has full permisions, tried with diferent users, addresses etc, nothing works.

Thanks anyway Dmitry, cheers.

-- View this message in context: http://xwiki.475771.n2.nabble.com/Mysql-Configuration-problem-tp7580467p7580... Sent from the XWiki- Users mailing list archive at Nabble.com. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users

Hello Robinson, I'm sorry, I have no more idea. Every time I had problems about hibernate configuration, I succeed to solve it using mysql binaries in command line. Perhaps it's possible to set some debug log for hibernate layer? (I'm sure it is, but if someone has a clue about it..?). Otherwise I will get back to you with some news about how to set this debug to be sure what xwiki is trying to do. Have a nice day, GuillaumeF 2012/7/26 raav2012 <[email protected]>

Hi Guillaume,

I've tried with the command you gave me and and I get this

http://xwiki.475771.n2.nabble.com/file/n7580559/02_-_Connect_with_password.j...

As you can see so far I can login to the DB and I have full grants

Change the port in hibernate.cfg.xml as you suggested.

http://xwiki.475771.n2.nabble.com/file/n7580559/03_-_hibernate_conf_file.jpg

Reload tomcat... and tada!.... Still the same issue :-( http://xwiki.475771.n2.nabble.com/file/n7580559/04_-_Same_problem.jpg

Ive tried any sort of connections in the hibernate.cfg.xml file and I get always the same.

Also I ve tried this

"What do you have in /etc/hosts ? I suspect some weird reverse DNS You should make sure nslookup 127.0.0.1 returns 'localhost' and not 'localhost.localdomain' which might be unknown to your mysql instance.

You should have 127.0.0.1 localhost in your /etc/hosts (probably being first)

Ludovic " From this post

http://xwiki.475771.n2.nabble.com/Re-Could-not-initialize-main-XWiki-context...

http://xwiki.475771.n2.nabble.com/Re-Could-not-initialize-main-XWiki-context...

I just don't get it, I'll keep searching anyway.

Thanks a lot Guillaume. Cheers. Robinson.

-- View this message in context: http://xwiki.475771.n2.nabble.com/Mysql-Configuration-problem-tp7580467p7580... Sent from the XWiki- Users mailing list archive at Nabble.com. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users

Hi, I hope you succeed to resolve your problem in the meantime. If it's not the case, could you add this logging configuration into you logback.xml file? (path : xwiki/WEB-INF/classes/logback.xml) just past this line in there:

<logger name="com.xpn.xwiki.store.hibernate" level="debug"/>

Then restart your wiki and look at the logs during the load. I'm not sure this is enough to gather as much information as we need, but this is a beggining. You could try to put the logger 'org.xwiki.hibernate' as debug as well, but you'll gather A LOT of information. So if first solution didn't help, paste the below line in place of the one above. If will output a lot of lines, so maybe you can use a " | grep -c 5 "'xwiki'@'localhost'" " to see the interesting stuff. <logger name="org.hibernate" level="debug"/>

Good luck! Guillaume Fenollar 2012/7/27 raav2012 <[email protected]>

Thanks a lot Guillaume, any idea would be greatly welcome.

Cheers.

-- View this message in context: http://xwiki.475771.n2.nabble.com/Mysql-Configuration-problem-tp7580467p7580... Sent from the XWiki- Users mailing list archive at Nabble.com. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users