OpenKM 6.2 Community - Postgresql & network access

[jiunnyik]

Hi,

Just finished install OpenKM 6.2 Community x64

Able to bind to postgresql , but unable login.

How to access OpenKM from other machine ? Now only accessible through localhost (http://localhost:8080/OpenKM ) only.

Thanks.

[macjaeger]

By default, tomcat (the application server OpenKM 6.2 is running in) will bind only to localhost (127.0.0.1), thus you can't reach the server from outside. One way to change this is to edit "tomcat/conf/server.xml": search for the line

Code: Select all

<Connector port="8080" address="127.0.0.1" ...

and change 127.0.0.0 it to an asterisk:

Code: Select all

<Connector port="8080" address="*" ...

Now tomcat should bind to all available networks and should be reachable from outside.

[jllort]

or

Code: Select all

<Connector port="8080" address="0.0.0.0"

We need to working on complete documentation, I know !

[jiunnyik]

Thank you guys.

How about default ID ? After I bind to postgresql , I'm not able to login with okmAdmin/admin . Tested with postgresql 8.4 & 9.1

Is there something I missed out ?

I followed configuration here . http://wiki.openkm.com/index.php/PostgreSQL-OpenKM_6.0

I have checked, tables are created, but there is no data for table okm_user.

Thanks.

[jiunnyik]

Hi jllor,

When would be the full documentation available ?

Thanks.

[pavila]

1.- Have you added the PostgreSQL JDBC driver to the "$TOMCAT_HOME/lib" directory?

2.- Stop Tomcat, clean $TOMCAT_GOME/logs directory, set hibernate.hbm2ddl=create and start again. After started, please attach the catalina.log file zipped to this post and I will revise it to check problems.

[jiunnyik]

1.- Have you added the PostgreSQL JDBC driver to the "$TOMCAT_HOME/lib" directory?

2.- Stop Tomcat, clean $TOMCAT_GOME/logs directory, set hibernate.hbm2ddl=create and start again. After started, please attach the catalina.log file zipped to this post and I will revise it to check problems.

Hi pavila.

1. Yes. postgresql-8.4-703.jdbc4.jar

Scientific Linux 6.3 x86_64 :-
postgresql-libs-8.4.13-1.el6_3.x86_64
postgresql-server-8.4.13-1.el6_3.x86_64
postgresql-8.4.13-1.el6_3.x86_64

2. Attached the log file

Thanks.

[jiunnyik]

Tested with openkm-6.2.0-community-linux-x64-installer.run & OpenKM-6.2.0-community-tomcat-bundle.zip

Tables are created , but emtpy data and unable to login with PostgreSQL

[pavila]

There is a bug in the initial database data creation, please update the OpenKM.war from http://integration.openkm.com/6.2 and set hibernate.hbm2ddl=create in OpenKM.cfg

[jiunnyik]

Hi pavila,

Thanks and it is working.

But the login page is different from normal.

[jllort]

Seems some problem with login styles. The problem is only on login or in UI too ?

Take a look if in your server exists the file : /OpenKM/css/desktop.css

[pavila]

There was an error when importing OpenKM code to SurceForge and some file were missing. Please, try tonight nightbuild.

[jiunnyik]

Seem like working fine.

Thank you jllort & pavila.

[agm]

Hi,

I have the same problem, I updated OpenKM.war and set hibernate.hbm2ddl=create in OpenKM.cfg. The table okm_user is void in database. Attach is catalina log before and after make hibernate.hbm2ddl=create again.

Regards.

[agm]

Hi,

I have the same problem, I updated OpenKM.war and set hibernate.hbm2ddl=create in OpenKM.cfg. The table okm_user is void in database. Attach is catalina log before and after make hibernate.hbm2ddl=create again.

Regards.

Ups, I forgot attach log, sorry.