Probleme with jdbc driver an openxhange.

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Probleme with jdbc driver an openxhange.

Sylvain Boily
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 : [hidden email] - 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 [hidden email] 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 - [hidden email]
juin 03 16:36:54 localhost openexchange: logout session=2a8fc62c1999345ab49e1a5ee3e4ebab - [hidden email]
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 - [hidden email]
juin 07 08:46:23 localhost openexchange: ERROR: uid=[hidden email], Error while getting the special folders from db:
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=[hidden email], Error while getting private and public readable oxfolders 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=[hidden email], Error while getting private and public readable oxfolders 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=[hidden email], Error while getting private and public readable oxfolders 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=[hidden email], Error while getting private and public readable oxfolders 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=[hidden email], Error while getting private and public readable oxfolders 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=[hidden email], Error while getting private and public readable oxfolders 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=[hidden email], Error while getting private and public readable oxfolders 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 - [hidden email]
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


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [hidden email]
Reply | Threaded
Open this post in threaded view
|

Re: Probleme with jdbc driver an openxhange.

Kris Jurka


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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match