[xwiki-users] database name using the standalone jetty?
Hello XWiki experts, today, I tried to install a fresh xwiki. I downloaded the jetty thing in the current release (I do not like installers) and adjusted the hibernate.cfg.xml to uncomment the MySQL part and have <property name="connection.url">jdbc:mysql://localhost/notationCensus</property> and related user and password. At launch, http://localhost:8080/xwiki/bin/view/Main/, however, it tells me: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'xwiki'@'localhost' to database 'xwiki' So... - the change to MySQL is well received - the change of user is right (I also tried changing it) - but the database name seems to be stuck. Is there some multiwiki ghost somewhere that I need to educate? thanks in advance. Paul
Actually this is probably not related to hibernate configuration file but to the fact that the fist thing XWiki does is switching to the database corresponding to wiki in the XWikiContext (so "xwiki" by default for the main wiki when the database is MySQL). You can change it in xwiki.cfg (property xwiki.db).xwiki On Tue, Jul 7, 2015 at 5:17 PM, Paul Libbrecht <paul@hoplahup.net> wrote:
Hello XWiki experts,
today, I tried to install a fresh xwiki. I downloaded the jetty thing in the current release (I do not like installers) and adjusted the hibernate.cfg.xml to uncomment the MySQL part and have <property name="connection.url">jdbc:mysql://localhost/notationCensus</property> and related user and password.
At launch, http://localhost:8080/xwiki/bin/view/Main/, however, it tells me: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'xwiki'@'localhost' to database 'xwiki'
So... - the change to MySQL is well received - the change of user is right (I also tried changing it) - but the database name seems to be stuck.
Is there some multiwiki ghost somewhere that I need to educate?
thanks in advance.
Paul _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne
thanks Thomas, that was helpful. I uncommented xwiki.db= and set it accordingly. And it started to work. It would be good to add a comment about it into each of the DBs' section of the hibernate file. Paul
Thomas Mortagne <mailto:thomas.mortagne@xwiki.com> 7 juillet 2015 17:33via Postbox <https://www.postbox-inc.com/?utm_source=email&utm_medium=sumlink&utm_campaign=reach> Actually this is probably not related to hibernate configuration file but to the fact that the fist thing XWiki does is switching to the database corresponding to wiki in the XWikiContext (so "xwiki" by default for the main wiki when the database is MySQL). You can change it in xwiki.cfg (property xwiki.db).xwiki
Paul Libbrecht <mailto:paul@hoplahup.net> 7 juillet 2015 17:17via Postbox <https://www.postbox-inc.com/?utm_source=email&utm_medium=sumlink&utm_campaign=reach> Hello XWiki experts,
today, I tried to install a fresh xwiki. I downloaded the jetty thing in the current release (I do not like installers) and adjusted the hibernate.cfg.xml to uncomment the MySQL part and have <property name="connection.url">jdbc:mysql://localhost/notationCensus</property> and related user and password.
At launch, http://localhost:8080/xwiki/bin/view/Main/, however, it tells me: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'xwiki'@'localhost' to database 'xwiki'
So... - the change to MySQL is well received - the change of user is right (I also tried changing it) - but the database name seems to be stuck.
Is there some multiwiki ghost somewhere that I need to educate?
thanks in advance.
Paul _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
What would be even better is to use whatever is the database in the hibernate configuration as main wiki database but in the meantime adding some comment would be useful yes. On Tue, Jul 7, 2015 at 11:34 PM, Paul Libbrecht <paul@hoplahup.net> wrote:
thanks Thomas,
that was helpful. I uncommented xwiki.db= and set it accordingly. And it started to work. It would be good to add a comment about it into each of the DBs' section of the hibernate file.
Paul
Thomas Mortagne <mailto:thomas.mortagne@xwiki.com> 7 juillet 2015 17:33via Postbox <https://www.postbox-inc.com/?utm_source=email&utm_medium=sumlink&utm_campaign=reach> Actually this is probably not related to hibernate configuration file but to the fact that the fist thing XWiki does is switching to the database corresponding to wiki in the XWikiContext (so "xwiki" by default for the main wiki when the database is MySQL). You can change it in xwiki.cfg (property xwiki.db).xwiki
Paul Libbrecht <mailto:paul@hoplahup.net> 7 juillet 2015 17:17via Postbox <https://www.postbox-inc.com/?utm_source=email&utm_medium=sumlink&utm_campaign=reach> Hello XWiki experts,
today, I tried to install a fresh xwiki. I downloaded the jetty thing in the current release (I do not like installers) and adjusted the hibernate.cfg.xml to uncomment the MySQL part and have <property name="connection.url">jdbc:mysql://localhost/notationCensus</property> and related user and password.
At launch, http://localhost:8080/xwiki/bin/view/Main/, however, it tells me: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'xwiki'@'localhost' to database 'xwiki'
So... - the change to MySQL is well received - the change of user is right (I also tried changing it) - but the database name seems to be stuck.
Is there some multiwiki ghost somewhere that I need to educate?
thanks in advance.
Paul _______________________________________________ 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
-- Thomas Mortagne
participants (2)
-
Paul Libbrecht -
Thomas Mortagne