Koozali.org: home of the SME Server

Opengrouware/postgresql problem SME 6.0.1

arjanvl

Opengrouware/postgresql problem SME 6.0.1
« 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
 :-?

Offline NickR

  • *
  • 283
  • +0/-0
    • http://www.witzendcs.co.uk/
Re: Opengrouware/postgresql problem SME 6.0.1
« Reply #1 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
--
Nick......

Offline MasterSleepy

  • *
  • 386
  • +0/-0
    • http://www.vanhees.cc
Opengrouware/postgresql problem SME 6.0.1
« Reply #2 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

Regards

arjanvl

Opengrouware/postgresql problem SME 6.0.1
« Reply #3 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:

arjanvl

Opengrouware/postgresql problem SME 6.0.1
« Reply #4 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

spittingfire

Need some help here
« Reply #5 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

Offline MasterSleepy

  • *
  • 386
  • +0/-0
    • http://www.vanhees.cc
Opengrouware/postgresql problem SME 6.0.1
« Reply #6 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.

spittingfire

Opengrouware/postgresql problem SME 6.0.1
« Reply #7 on: October 14, 2004, 01:04:17 PM »
Thanks

That change did the trick

djhomeless

Opengrouware/postgresql problem SME 6.0.1
« Reply #8 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

Offline MasterSleepy

  • *
  • 386
  • +0/-0
    • http://www.vanhees.cc
Opengrouware/postgresql problem SME 6.0.1
« Reply #9 on: January 14, 2005, 08:18:31 PM »
Hello,

You can find rpm that I used for the Howto
Here

Regards.

Offline fpausp

  • *
  • 728
  • +0/-0
opengroupware and palm
« Reply #10 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
Viribus unitis

linuxguy

Need help please
« Reply #11 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.

linuxguy

...
« Reply #12 on: January 26, 2005, 06:33:00 AM »
By the way, I also get a msg saying the document contains no data ..

Offline Paperguides

  • ****
  • 118
  • +0/-0
Opengrouware/postgresql problem SME 6.0.1
« Reply #13 on: February 03, 2005, 11:40:07 PM »
Quote from: "MasterSleepy"
Hello,

You can find rpm that I used for the Howto
Here


Unfortunately this link is not currently working.

Are there any other mirrors/sources?
...

Offline Paperguides

  • ****
  • 118
  • +0/-0
Opengrouware/postgresql problem SME 6.0.1
« Reply #14 on: February 13, 2005, 02:39:57 PM »
Quote from: "Paperguides"


Unfortunately this link is not currently working.


Now working again, Thanks.
...