Thread: Probleme with jdbc driver an openxhange.

Probleme with jdbc driver an openxhange.

From
Sylvain Boily
Date:
Hi,

I use Openxchange with pg74.215.jdbc3.jar, i got a problem with permission.
I have open a bug to openxchange bugzilla but it seems is my driver.
http://www.open-xchange.org/cgi-bin/bugzilla/show_bug.cgi?id=443

Have you got idea, how does it possible to debug for more information ?

At the openxchange wiki, people related problem with 216 version.
http://www.open-xchange.org/oxwiki/WorkingLibraries

I've got linux debian sarge, with postgresql from apt-get.

Best regards,
Sylvain.

--
Sylvain BOILY
Proformatique - 14 rue Anatole France - 92800 Puteaux
Tel. : 01 41 02 92 80 - Fax. : 01 47 74 63 75
Email : sboily@proformatique.com - http://proformatique.com/

"Vers un monde plus libre"
------------------------------------
Proformatique est membre de l'ASS2L
http://www.ass2L.org

n 02 20:35:56 localhost openexchange: Netline Application Server [NAS 5.0]
juin 02 20:35:56 localhost openexchange: (c) Netline Internet Service GmbH
juin 02 20:35:56 localhost openexchange: Linux i386 2.6.11
juin 02 20:35:56 localhost openexchange: 1.4.2_07-b05
juin 02 20:35:56 localhost openexchange: VM Total Memory       : 20�288 KB
juin 02 20:35:56 localhost openexchange: VM Free Memory        : 19�811 KB
juin 02 20:35:56 localhost openexchange: VM Used Memory        : 477 KB
juin 02 20:35:56 localhost openexchange: System version        : OPEN-XCHANGE [0.8.0-2] initializing ...
juin 02 20:35:56 localhost openexchange: Using path: /usr/local/openxchange/
juin 02 20:35:56 localhost openexchange: Loglevel set to: 5
juin 02 20:35:57 localhost openexchange: Setting timeout           : 60000
juin 02 20:35:57 localhost openexchange: Setting start_server      : 1
juin 02 20:35:57 localhost openexchange: Setting thread_pool       : 0
juin 02 20:35:57 localhost openexchange: Setting db_pool           : 5
juin 02 20:35:57 localhost openexchange: Allow non pooled threads  : true
juin 02 20:35:57 localhost openexchange: Setting upload directory  : /tmp/
juin 02 20:35:57 localhost openexchange: INTERNAL TLS Support: OFF
juin 02 20:35:57 localhost openexchange: bind to port 6661
juin 02 20:35:57 localhost openexchange: upload bind to port 6663
 done
juin 02 20:37:08 localhost openexchange: Error reading attributes of user demo-ox@proformatique.com from ldap!
juin 02 20:37:08 localhost openexchange: [LDAP: error code 32 - No Such Object]
java.lang.NullPointerException
        at com.openexchange.thread.ComfireThread.validateSession(ComfireThread.java:369)
        at com.openexchange.thread.ComfireThread.run(ComfireThread.java:158)
        at java.lang.Thread.run(Thread.java:534)
java.lang.NullPointerException
        at com.openexchange.thread.ComfireThread.validateSession(ComfireThread.java:369)
        at com.openexchange.thread.ComfireThread.run(ComfireThread.java:158)
        at java.lang.Thread.run(Thread.java:534)
juin 03 16:36:54 localhost openexchange: timeout session=2a8fc62c1999345ab49e1a5ee3e4ebab - demo-ox@pro-formatique.com
juin 03 16:36:54 localhost openexchange: logout session=2a8fc62c1999345ab49e1a5ee3e4ebab - demo-ox@pro-formatique.com
doSelectErr ERROR: canceling query due to user request

Error while getting the special folders from db.
org.postgresql.util.PSQLException: Bad Integer test
        at org.postgresql.jdbc1.AbstractJdbc1ResultSet.toInt(AbstractJdbc1ResultSet.java:862)
        at org.postgresql.jdbc1.AbstractJdbc1ResultSet.getInt(AbstractJdbc1ResultSet.java:287)
        at com.openexchange.tools.OXFolderTools.getSystemFolders(OXFolderTools.java:339)
        at com.openexchange.groupware.OXFolderView.writeFolderStructure(OXFolderView.java:89)
        at com.openexchange.groupware.RightAreaManagement.writeFolder(RightAreaManagement.java:438)
        at com.openexchange.groupware.RightAreaManagement.doSortedOutput(RightAreaManagement.java:167)
        at com.openexchange.groupware.RightAreaManagement.onAfterNASGetObject(RightAreaManagement.java:82)
        at com.openexchange.thread.ComfireThread.fillVars(ComfireThread.java:574)
        at com.openexchange.thread.ComfireThread.checkVars(ComfireThread.java:505)
        at com.openexchange.thread.ComfireThread.validateSession(ComfireThread.java:436)
        at com.openexchange.thread.ComfireThread.run(ComfireThread.java:158)
        at java.lang.Thread.run(Thread.java:534)
java.lang.NullPointerException
        at com.openexchange.groupware.OXFolderView.writeFolderStructure(OXFolderView.java:199)
        at com.openexchange.groupware.RightAreaManagement.writeFolder(RightAreaManagement.java:438)
        at com.openexchange.groupware.RightAreaManagement.doSortedOutput(RightAreaManagement.java:167)
        at com.openexchange.groupware.RightAreaManagement.onAfterNASGetObject(RightAreaManagement.java:82)
        at com.openexchange.thread.ComfireThread.fillVars(ComfireThread.java:574)
        at com.openexchange.thread.ComfireThread.checkVars(ComfireThread.java:505)
        at com.openexchange.thread.ComfireThread.validateSession(ComfireThread.java:436)
        at com.openexchange.thread.ComfireThread.run(ComfireThread.java:158)
        at java.lang.Thread.run(Thread.java:534)
juin 07 08:44:43 localhost openexchange: logout session=ca5bde5c32f09945c037fa436091d4e6 - demo-ox@pro-formatique.com
juin 07 08:46:23 localhost openexchange: ERROR: uid=demo-ox@pro-formatique.com, Error while getting the special folders
fromdb: 
org.postgresql.util.PSQLException: The column index is out of range.
        at org.postgresql.jdbc1.AbstractJdbc1ResultSet.checkResultSet(AbstractJdbc1ResultSet.java:825)
        at org.postgresql.jdbc1.AbstractJdbc1ResultSet.getString(AbstractJdbc1ResultSet.java:200)
        at org.postgresql.jdbc1.AbstractJdbc1ResultSet.getFixedString(AbstractJdbc1ResultSet.java:792)
        at org.postgresql.jdbc1.AbstractJdbc1ResultSet.getInt(AbstractJdbc1ResultSet.java:287)
        at com.openexchange.tools.OXFolderTools.getSystemFolders(OXFolderTools.java:339)
        at com.openexchange.groupware.Management.onCheckUserAuth(Management.java:567)
        at com.openexchange.thread.ComfireThread.validateSession(ComfireThread.java:386)
        at com.openexchange.thread.ComfireThread.run(ComfireThread.java:158)
        at java.lang.Thread.run(Thread.java:534)
juin 07 08:46:23 localhost openexchange: ERROR: uid=demo-ox@pro-formatique.com, Error while getting private and public
readableoxfolders in load settings: 
org.postgresql.util.PSQLException: Bad Integer system_ldap
        at org.postgresql.jdbc1.AbstractJdbc1ResultSet.toInt(AbstractJdbc1ResultSet.java:862)
        at org.postgresql.jdbc1.AbstractJdbc1ResultSet.getInt(AbstractJdbc1ResultSet.java:287)
        at com.openexchange.groupware.Management.onCheckUserAuth(Management.java:580)
        at com.openexchange.thread.ComfireThread.validateSession(ComfireThread.java:386)
        at com.openexchange.thread.ComfireThread.run(ComfireThread.java:158)
        at java.lang.Thread.run(Thread.java:534)
juin 07 08:46:26 localhost openexchange: ERROR: uid=demo-ox@pro-formatique.com, Error while getting private and public
readableoxfolders in load settings: 
org.postgresql.util.PSQLException: Bad Integer system_ldap
        at org.postgresql.jdbc1.AbstractJdbc1ResultSet.toInt(AbstractJdbc1ResultSet.java:862)
        at org.postgresql.jdbc1.AbstractJdbc1ResultSet.getInt(AbstractJdbc1ResultSet.java:287)
        at com.openexchange.groupware.Management.onCheckUserAuth(Management.java:580)
        at com.openexchange.thread.ComfireThread.validateSession(ComfireThread.java:386)
        at com.openexchange.thread.ComfireThread.run(ComfireThread.java:158)
        at java.lang.Thread.run(Thread.java:534)
juin 07 08:46:27 localhost openexchange: ERROR: uid=demo-ox@pro-formatique.com, Error while getting private and public
readableoxfolders in load settings: 
org.postgresql.util.PSQLException: Bad Integer system_ldap
        at org.postgresql.jdbc1.AbstractJdbc1ResultSet.toInt(AbstractJdbc1ResultSet.java:862)
        at org.postgresql.jdbc1.AbstractJdbc1ResultSet.getInt(AbstractJdbc1ResultSet.java:287)
        at com.openexchange.groupware.Management.onCheckUserAuth(Management.java:580)
        at com.openexchange.thread.ComfireThread.validateSession(ComfireThread.java:386)
        at com.openexchange.thread.ComfireThread.run(ComfireThread.java:158)
        at java.lang.Thread.run(Thread.java:534)
juin 07 08:46:46 localhost openexchange: ERROR: uid=demo-ox@pro-formatique.com, Error while getting private and public
readableoxfolders in load settings: 
org.postgresql.util.PSQLException: Bad Integer system_ldap
        at org.postgresql.jdbc1.AbstractJdbc1ResultSet.toInt(AbstractJdbc1ResultSet.java:862)
        at org.postgresql.jdbc1.AbstractJdbc1ResultSet.getInt(AbstractJdbc1ResultSet.java:287)
        at com.openexchange.groupware.Management.onCheckUserAuth(Management.java:580)
        at com.openexchange.thread.ComfireThread.validateSession(ComfireThread.java:386)
        at com.openexchange.thread.ComfireThread.run(ComfireThread.java:158)
        at java.lang.Thread.run(Thread.java:534)
juin 07 08:46:56 localhost openexchange: ERROR: uid=demo-ox@pro-formatique.com, Error while getting private and public
readableoxfolders in load settings: 
org.postgresql.util.PSQLException: Bad Integer system_ldap
        at org.postgresql.jdbc1.AbstractJdbc1ResultSet.toInt(AbstractJdbc1ResultSet.java:862)
        at org.postgresql.jdbc1.AbstractJdbc1ResultSet.getInt(AbstractJdbc1ResultSet.java:287)
        at com.openexchange.groupware.Management.onCheckUserAuth(Management.java:580)
        at com.openexchange.thread.ComfireThread.validateSession(ComfireThread.java:386)
        at com.openexchange.thread.ComfireThread.run(ComfireThread.java:158)
        at java.lang.Thread.run(Thread.java:534)
juin 07 08:46:57 localhost openexchange: ERROR: uid=demo-ox@pro-formatique.com, Error while getting private and public
readableoxfolders in load settings: 
org.postgresql.util.PSQLException: Bad Integer system_ldap
        at org.postgresql.jdbc1.AbstractJdbc1ResultSet.toInt(AbstractJdbc1ResultSet.java:862)
        at org.postgresql.jdbc1.AbstractJdbc1ResultSet.getInt(AbstractJdbc1ResultSet.java:287)
        at com.openexchange.groupware.Management.onCheckUserAuth(Management.java:580)
        at com.openexchange.thread.ComfireThread.validateSession(ComfireThread.java:386)
        at com.openexchange.thread.ComfireThread.run(ComfireThread.java:158)
        at java.lang.Thread.run(Thread.java:534)
juin 07 08:46:58 localhost openexchange: ERROR: uid=demo-ox@pro-formatique.com, Error while getting private and public
readableoxfolders in load settings: 
org.postgresql.util.PSQLException: Bad Integer system_ldap
        at org.postgresql.jdbc1.AbstractJdbc1ResultSet.toInt(AbstractJdbc1ResultSet.java:862)
        at org.postgresql.jdbc1.AbstractJdbc1ResultSet.getInt(AbstractJdbc1ResultSet.java:287)
        at com.openexchange.groupware.Management.onCheckUserAuth(Management.java:580)
        at com.openexchange.thread.ComfireThread.validateSession(ComfireThread.java:386)
        at com.openexchange.thread.ComfireThread.run(ComfireThread.java:158)
        at java.lang.Thread.run(Thread.java:534)
juin 07 08:47:09 localhost openexchange: logout session=f655afad53c9b629609df92e36261b21 - demo-ox@pro-formatique.com
juin 07 08:49:10 localhost openexchange: ERROR: LOGIN: Unable to load users module rights:
org.postgresql.util.PSQLException:The column index is out of range. 
juin 07 08:49:10 localhost openexchange: ERROR: LOGIN: Unable to load users module rights:
org.postgresql.util.PSQLException:The column index is out of range. 
juin 07 08:49:10 localhost openexchange: ERROR: LOGIN: Unable to load users module rights:
org.postgresql.util.PSQLException:The column index is out of range. 
juin 07 08:49:10 localhost openexchange: ERROR: LOGIN: Unable to load users module rights:
org.postgresql.util.PSQLException:The column index is out of range. 
juin 07 08:49:10 localhost openexchange: ERROR: LOGIN: Unable to load users module rights:
org.postgresql.util.PSQLException:The column index is out of range. 
juin 07 08:49:10 localhost openexchange: ERROR: LOGIN: Unable to load users module rights:
org.postgresql.util.PSQLException:The column index is out of range. 
java.lang.NullPointerException

Re: Probleme with jdbc driver an openxhange.

From
Kris Jurka
Date:

On Tue, 7 Jun 2005, Sylvain Boily wrote:

> I use Openxchange with pg74.215.jdbc3.jar, i got a problem with permission.
> I have open a bug to openxchange bugzilla but it seems is my driver.
> http://www.open-xchange.org/cgi-bin/bugzilla/show_bug.cgi?id=443
>
> Have you got idea, how does it possible to debug for more information ?
>

This really looks like a problem with openexchange or its configuration.
The stacktrace shows the OXFolderTools.getSystemFolders call
ResultSet.getInt(), but the data in the column is "test" which is clearly
not an integer, so the postgresql driver complains.

Kris Jurka