Re: [xwiki-users] - trouble restarting xwiki

2 Sep 2008


      On Tue, 2008-09-02 at 10:31, Skinner, John (GE Healthcare) wrote:
...
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf
Of Jean-Vincent Drean
Sent: Tuesday, September 02, 2008 10:30 AM
To: XWiki Users
Subject: Re: [xwiki-users] - trouble restarting xwiki
On Tue, Sep 2, 2008 at 5:45 PM, John V. Skinner
<[email protected]> wrote:
...
My first posting:
I am unable to start my xwiki, (beta 4).
You mean XWiki 1.0 beta 4 ?!
Yes
...
I saw some discussions regarting this problem, but didn't quite see 
the solution.
any help, plus help on exporting data without xwiki service running in
...
case it does come back to life would be appreciated.
http://ctaa.ct.med.ge.com:8080/xwiki/bin/view/Main/WebHome
DBCPConnectionProvider:configure:191 - Could not create a DBCP pool
org.apache.commons.dbcp.SQLNestedException: Cannot create 
PoolableConnectionFactory (User not found: SA)
This error means that xwiki is not able to connect to your database.
What kind of db are you trying to use ? Considering the user SA it looks
like your wiki is configured to use the embedded hsqldb database, have
you deleted the database/ directory ?
from webapps/xwiki/WEB-INF/hobernate.cfg.xml it reads like i am using
myql, although i thought i was using hsqldb.  Am I looking int the
right file?

<hibernate-configuration>
  <session-factory>
                                                                                          
    <property name="show_sql">false</property>
    <property name="use_outer_join">true</property>
                                                                                          
    <property name="dbcp.defaultAutoCommit">false</property>
    <property name="dbcp.maxActive">50</property>
    <property name="dbcp.maxIdle">5</property>
    <property name="dbcp.maxWait">30000</property>
    <property name="dbcp.whenExhaustedAction">1</property>
    <property name="dbcp.ps.whenExhaustedAction">1</property>
    <property name="dbcp.ps.maxActive">20</property>
    <property name="dbcp.ps.maxWait">120000</property>
    <property name="dbcp.ps.maxIdle">20</property>
                                                                                          
    <!-- Uncomment if you want to use HSQLDB.
         Note that the database will be created automatically if it
doesn't already exist.    <property
name="connection.url">jdbc:hsqldb:file:/some/path/xwiki_db;shutdown=true</property>
    <property name="connection.username">sa</property>
    <property name="connection.password"></property>
    <property
name="connection.driver_class">org.hsqldb.jdbcDriver</property>
    <property
name="dialect">org.hibernate.dialect.HSQLDialect</property>
    -->
                                                                                          
    <!-- Default MySQL configuration -->
    <property
name="connection.url">jdbc:mysql://localhost/xwiki?useServerPrepStmts=false</property>
    <property name="connection.username">xwiki</property>
    <property name="connection.password">xwiki</property>
    <property
name="connection.driver_class">com.mysql.jdbc.Driver</property>
    <property
name="dialect">org.hibernate.dialect.MySQLDialect</property>
                                                                                          
    <property
name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property>
    <property name="connection.pool_size">2</property>
    <property name="statement_cache.size">2</property>
                                                                                          
    <!-- Mapping files -->
    <mapping resource="xwiki.hbm.xml"/>
    <mapping resource="feeds.hbm.xml"/>
                                                                                          
                                                                                          
  </session-factory>
</hibernate-configuration>
...
--
Jean-Vincent Drean
_______________________________________________
users mailing list
[email protected]
http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________
users mailing list
[email protected]
http://lists.xwiki.org/mailman/listinfo/users
-- 
John V. Skinner <[email protected]>
MICT Advanced Applications