[xwiki-users] Getting Unknown database error with xwiki version 5.1?
Hi All, I installed the xwiki latest version i.e 5.1 war file under tomcat. Here is my hibernate.cfg.xml to use MySQL as databse. I named the DB as IP. <property name="connection.url">jdbc:mysql://localhost/IP</property> <property name="connection.username">root</property> <property name="connection.password">sa1234</property> Now,when i startup my tomcat container, it gives below error INFO: SessionListener: contextInitialized() Sep 14, 2013 5:35:56 PM org.apache.catalina.core.StandardWrapperValve invoke SEVERE: Servlet.service() for servlet action threw exception *com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'IP'* Then i created the empty mysql database with name as 'IP' from command prompt, then it gives below error. i am not sure why its looking for database 'xwiki' instead of 'IP'. Do i need to change some other config file also apart from hibernate.cfg.xml ? INFO: SessionListener: contextInitialized() Sep 14, 2013 5:35:56 PM org.apache.catalina.core.StandardWrapperValve invoke SEVERE: Servlet.service() for servlet action threw exception *com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'xwiki'*
I could resolve this issue by uncomment and setting below property to IP in xwiki.cfg. I don't is it really required as i never set it for previously installed version i.e xwiki 3.5? As i have already mentioned in hibernate.cfg.xml (<property name="connection.url">jdbc:mysql://localhost/IP</property> ), it should be coming from there. Is n't it? xwiki.db=IP On Sat, Sep 14, 2013 at 5:56 PM, Mohit Gupta <[email protected]> wrote:
Hi All,
I installed the xwiki latest version i.e 5.1 war file under tomcat. Here is my hibernate.cfg.xml to use MySQL as databse. I named the DB as IP.
<property name="connection.url">jdbc:mysql://localhost/IP</property> <property name="connection.username">root</property> <property name="connection.password">sa1234</property>
Now,when i startup my tomcat container, it gives below error
INFO: SessionListener: contextInitialized() Sep 14, 2013 5:35:56 PM org.apache.catalina.core.StandardWrapperValve invoke SEVERE: Servlet.service() for servlet action threw exception *com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'IP'*
Then i created the empty mysql database with name as 'IP' from command prompt, then it gives below error. i am not sure why its looking for database 'xwiki' instead of 'IP'. Do i need to change some other config file also apart from hibernate.cfg.xml ?
INFO: SessionListener: contextInitialized() Sep 14, 2013 5:35:56 PM org.apache.catalina.core.StandardWrapperValve invoke SEVERE: Servlet.service() for servlet action threw exception *com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'xwiki'*
participants (1)
-
Mohit Gupta