Page 1 of 2

OpenKM 6.2 Community - Postgresql & network access

PostPosted:Thu Oct 11, 2012 8:53 am
by 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.

Re: OpenKM 6.2 Community - Postgresql & network access

PostPosted:Thu Oct 11, 2012 11:59 am
by 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.

Re: OpenKM 6.2 Community - Postgresql & network access

PostPosted:Thu Oct 11, 2012 5:09 pm
by jllort
or
Code: Select all
<Connector port="8080" address="0.0.0.0"
We need to working on complete documentation, I know !

Re: OpenKM 6.2 Community - Postgresql & network access

PostPosted:Fri Oct 12, 2012 12:20 am
by 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.

Re: OpenKM 6.2 Community - Postgresql & network access

PostPosted:Fri Oct 12, 2012 6:30 am
by jiunnyik
Hi jllor,

When would be the full documentation available ?

Thanks.

Re: OpenKM 6.2 Community - Postgresql & network access

PostPosted:Sat Oct 13, 2012 4:44 pm
by 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.

Re: OpenKM 6.2 Community - Postgresql & network access

PostPosted:Mon Oct 15, 2012 12:10 am
by jiunnyik
pavila wrote: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.

Re: OpenKM 6.2 Community - Postgresql & network access

PostPosted:Wed Oct 17, 2012 9:00 am
by 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

Re: OpenKM 6.2 Community - Postgresql & network access

PostPosted:Thu Oct 18, 2012 11:35 am
by 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

Re: OpenKM 6.2 Community - Postgresql & network access

PostPosted:Fri Oct 19, 2012 2:36 am
by jiunnyik
Hi pavila,

Thanks and it is working.

But the login page is different from normal.

Re: OpenKM 6.2 Community - Postgresql & network access

PostPosted:Fri Oct 19, 2012 7:59 pm
by 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

Re: OpenKM 6.2 Community - Postgresql & network access

PostPosted:Sun Oct 21, 2012 10:02 am
by pavila
There was an error when importing OpenKM code to SurceForge and some file were missing. Please, try tonight nightbuild.

Re: OpenKM 6.2 Community - Postgresql & network access

PostPosted:Mon Oct 22, 2012 1:04 am
by jiunnyik
Seem like working fine.

Thank you jllort & pavila.

Re: OpenKM 6.2 Community - Postgresql & network access

PostPosted:Mon Oct 29, 2012 4:38 pm
by 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.

Re: OpenKM 6.2 Community - Postgresql & network access

PostPosted:Mon Oct 29, 2012 11:04 pm
by agm
agm wrote: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.