Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: arjanvl on August 19, 2004, 09:26:45 PM

Title: Opengrouware/postgresql problem SME 6.0.1
Post by: arjanvl on August 19, 2004, 09:26:45 PM: Hi,

Tried to install OpenGroupware on my SME 6.0.1 server but when i tried to connect to it (http://myserver/OpenGroupware )i receive the error:
_________________________________________________
The SKYRIX application server could not connect to the database server !

Please ensure that your database server is running and that the LSConnectionDictionary default is correctly set.
___________________________________________________

I've run a port scan on port 5432(needed for OpenGroupware/postgresql) but it fails so i believe this port isn't opened. Already changed the /etc/e-smith/templates-custom/var/lib/pgsql/data/postgresql.conf file and set the value tcpip_socket to:
#tcpip_socket = true
Restarted postgresql but no result.

Any ideas? I followed the Howto Postgresql 7.4.2 and OpenGroupware from http://vanhees.homeip.net/

Arjan
:-?
Title: Re: Opengrouware/postgresql problem SME 6.0.1
Post by: NickR on August 19, 2004, 10:54:49 PM: Quote from: "arjanvl"
Already changed the /etc/e-smith/templates-custom/var/lib/pgsql/data/postgresql.conf file and set the value tcpip_socket to:
#tcpip_socket = true
Restarted postgresql but no result.

If that really is your .conf file, you need to remove the comment (#) at the start of the line to activate it. Then try expanding the template & restarting postgresql
Title: Opengrouware/postgresql problem SME 6.0.1
Post by: MasterSleepy on August 20, 2004, 08:19:07 AM: Hello,

Postgres 7.4.2 don't work with opengroupware.
You have to install Postgres 7.2.1 as describ
here (http://www.vanhees.cc/index.php?module=ContentExpress&func=display&ceid=6&meid=)

Regards
Title: Opengrouware/postgresql problem SME 6.0.1
Post by: arjanvl on August 20, 2004, 06:49:05 PM: :-D Thanx for the advise. I'am going try it... I will post my results here!

Arjan
:lol:
Title: Opengrouware/postgresql problem SME 6.0.1
Post by: arjanvl on August 20, 2004, 10:14:00 PM: MasterSleepy THANX!!! :lol:

Fixed the problem with the installation of Postgresql 7.2.1. Now I can try OpenGroupware!!! Do i need to install ZideStore for synchronizing with my Mozilla Calendar/Sunbird??? If yes: Is it possible to install on e-smith and is ZideStore free or not? I can't find the exact answers on there site.

Again MasterSleepy thanx for your help!

Arjan
Title: Need some help here
Post by: spittingfire on October 13, 2004, 06:13:56 PM: Hi all,

I'm very new to linux and SME 6 but I can follow instructions well. I was followed the step by step instructions for installing opengroupware by Van Hees Michel and when I got to the end where I have to start opengroupware I got the following error message

/etc/init.d/opengroupware: /root/.bash_profile: Permission denied
/etc/init.d/opengroupware: achievable: command not found
/etc/init.d/opengroupware: line 50: syntax error near unexpected token fi'
/etc/init.d/opengroupware: line 50: fi'

Any help will be appreciated.

Thanks
Title: Opengrouware/postgresql problem SME 6.0.1
Post by: MasterSleepy on October 14, 2004, 10:32:41 AM: Hello,

I've update the Howto.
With your help I've find an other bug in the install procedure.

Greats thanks.
Title: Opengrouware/postgresql problem SME 6.0.1
Post by: spittingfire on October 14, 2004, 01:04:17 PM: Thanks

That change did the trick
Title: Opengrouware/postgresql problem SME 6.0.1
Post by: djhomeless on January 14, 2005, 07:34:14 PM: I h8 it when you are a noob at something and you have to go and ask a noob question.

I looked at Sleepy's howto for OpenGroupWare: http://www.vanhees.cc/index.php?module=ContentExpress&func=display&ceid=7&meid=

But I can't actually find the RPM's he mentions in the article? I've searched all over the OGW site and all I can find are specific RPM's for other distro's, or the full source.

I do have YUM installed but the OGW site mentions only Fedora2 as a valid distro. I've seen a few posts here that say that Fedora RPM's won't work on SME.

Sorry everyone!

Geoffrey
Title: Opengrouware/postgresql problem SME 6.0.1
Post by: MasterSleepy on January 14, 2005, 08:18:31 PM: Hello,

You can find rpm that I used for the Howto
Here (http://www.vanhees.cc/modules.php?op=modload&name=Downloads&file=index&req=viewsdownload)

Regards.
Title: opengroupware and palm
Post by: fpausp on January 15, 2005, 05:54:26 PM: Hi,

I installed opengroupware on my server, thanks for your howto MasterSleepy and now i like to use a palm, is that possible ?

regards
fpausp
austria
Title: Need help please
Post by: linuxguy on January 26, 2005, 06:23:20 AM: Ok, the installation manual is great, I found all files and installed everything without a problem, thank you so much for coming up with such a HOWTO, it is great. Now what's next? How to I access groupware from my winblows workstation? Obviously I do not have X running on my SME server. I've tried to connect to htp://192.168.69.111:20000 which is my sme server internal IP, and no luck, nothing comes up, just the same page I'm currently on. Any ideas anyone, please ... if this works I'll be rolling it out on a production site. Many thanks in advance.
Title: ...
Post by: linuxguy on January 26, 2005, 06:33:00 AM: By the way, I also get a msg saying the document contains no data ..
Title: Opengrouware/postgresql problem SME 6.0.1
Post by: Paperguides on February 03, 2005, 11:40:07 PM: Quote from: "MasterSleepy"
Hello,

You can find rpm that I used for the Howto
Here (http://www.vanhees.cc/modules.php?op=modload&name=Downloads&file=index&req=viewsdownload)

Unfortunately this link is not currently working.

Are there any other mirrors/sources?
Title: Opengrouware/postgresql problem SME 6.0.1
Post by: Paperguides on February 13, 2005, 02:39:57 PM: Quote from: "Paperguides"

Unfortunately this link is not currently working.

Now working again, Thanks.
Title: Re: ...
Post by: Paperguides on February 18, 2005, 06:43:59 PM: Quote from: "linuxguy"
By the way, I also get a msg saying the document contains no data ..

I got a similar result but in my case it may due to the error messages I got when I started opengroupware.
e.g.
__________________________________________________
[root@charles-sq WebServerResources]# /etc/init.d/opengroupware start
/etc/init.d/opengroupware: /root/.bash_profile: Permission denied
/etc/init.d/opengroupware: achievable: command not found
Starting OpenGroupware:
/etc/init.d/opengroupware: ----------------------------------------------------------------------: command not found
[ OK ]
[root@charles-sq WebServerResources]#
_____________________________________________________________

I suspect I've done silly but I cannot see what.

Tony
Title: Re: ...
Post by: Paperguides on February 18, 2005, 06:52:48 PM: Quote from: "Paperguides"

I suspect I've done silly but I cannot see what.

Tony

It was very silly! :-( a problem with word wrap.

Tony