Re: [xwiki-users] Mysql Configuration problem
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 ra...@hotmail.com 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-tp7580467p7580576.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Mysql Configuration problem
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 ra...@hotmail.com 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.jpg 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-td501954.html;cid=1343149060713-31 http://xwiki.475771.n2.nabble.com/Re-Could-not-initialize-main-XWiki-context-td501954.html;cid=1343149060713-31 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-tp7580467p7580559.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Mysql Configuration problem
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-tp7580467p7580576.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Mysql Configuration problem
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 ra...@hotmail.com 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-tp7580467p7580537.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Mysql Configuration problem
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.jpg 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-td501954.html;cid=1343149060713-31 http://xwiki.475771.n2.nabble.com/Re-Could-not-initialize-main-XWiki-context-td501954.html;cid=1343149060713-31 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-tp7580467p7580559.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Mysql Configuration problem
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 ra...@hotmail.com: 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.jpg 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 users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users Kind regards, Dmitry ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Mysql Configuration problem
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-tp7580467p7580537.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Mysql Configuration problem
Any ideas? Thanks in advance. -- View this message in context: http://xwiki.475771.n2.nabble.com/Mysql-Configuration-problem-tp7580467p7580504.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
[xwiki-users] Mysql Configuration problem
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.jpg 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 users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users