2 Sep
2008
2 Sep
'08
9:06 p.m.
On Tue, 2008-09-02 at 13:10, John V. Skinner wrote:
On Tue, 2008-09-02 at 10:31, Skinner, John (GE
Healthcare) wrote:
Ah, but i found
webapps/xwiki/WEB-INF/hibernate.cfg.hsql.xml also.
In this file the connection.url was jdbc:hsqldb:file:db/xwiki_db
There is also 2 very large files,
xwiki_db.log.delete,
xwiki_db.script.delete
Are these roll-back files of some kind?
I don't find the xwiki_db file at all. Don't know why not.
-----Original Message-----
From: users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] 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
<John.skinner(a)med.ge.com> 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
> users(a)xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users
> _______________________________________________
> users mailing list
> users(a)xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users
--
John V. Skinner <John.skinner(a)med.ge.com>
MICT Advanced Applications