Topic: Howto Opengroupware

[MasterSleepy]

Hello,

I finally finish both howto for installation of opengroupware.
These howtos are in french and english.

you could find it here:
http://vanhees.homeip.net/modules.php?op=modload&name=indexer&file=index&dir=/5.6//HowTo/

If you have any problem with the install, don't hesitate to send me a private message;

Regards,
MasterSleepy

[Warren Blackbeard]

Thnx MasterSleepy ,

The howto for opengroupware and postgres is extremely helpful,
much appreciated.!

Warren

[IDar]

I have installed opengroupware but i get this 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.


--------------------------------------------------------------------------------
Current database configuration: database: ogo
server: localhost
user: ogo

How can i correct this?

[MasterSleepy]

Hello,

Connect on a console with opengroupware user.
at the prompt type :
Defaults read NSGlobalDomain and assure that all value fit with the howto.
Or send it to me, I'll check asap.

By

[MasterSleepy]

Sorry, maybe I'll made a mistake,
I see that for the hostname you enter localhost, don't use localhost.
Put the name of your server.

[IDar]

Ok i did, but i also get this error:

root@servidor root]# /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@servidor root]#

any idea?
BTW, thanks

[IDar]

I solved the previous error... I had an error on ^c ^v ....
but how can i make the lsconnectiondictionary work?
I make:
Defaults write NSGlobalDomain LSConnectionDictionary '{databaseName = ogo; hostName = gaf.ruizlizondo.com; password = ""; port = 5432; userName = ogo}'
but i still get this 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.


--------------------------------------------------------------------------------
Current database configuration: database: ogo
server: localhost
user: ogo

[IDar]

Despite my changes i get:

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.


--------------------------------------------------------------------------------
Current database configuration: database: ogo
server: gaf.ruizlizondo.com
user: ogo

It can work??

[MasterSleepy]

Try to replace the gaf.ruizlizondo.com by "gaf".

Just another question, can you connect the database with :
psql postgrestest-h gaf -U ogo
???

[IDar]

let's see

i have changed gaf to servidor (i understanded this point at last)
and i can do:

[root@servidor root]#  psql postgrestest -h servidor  -U ogo
Welcome to psql, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

postgrestest=>



and the error it's naw:
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.


--------------------------------------------------------------------------------
Current database configuration: database: ogo
server: servidor
user: ogo


mybe i need to delete the tables and reinstall them? but How can this be done?
do you know something like phpmyadmin? (I know, i ask for a lot of things... but it's my first time face to face with postgre... ...)
Thanks anyway

[MasterSleepy]

The problem is not you table.
The problem is the connector you define for user opengroupware.
Everythings seems to be good,

Hmmmmm, I'll looking for that problem and come back to you with the solution.

[IDar]

I don't know what i did... but it works...
Thanks MaasterSleepy

[IDar]

ejem... it works... but i can't login....

[IDar]

Let's see... I can't login, may be i made a mistake configuring the database, i try to drop the tables or the db but i can't and i can't reload the original sql...

Can you help me to delete the db or the tables?

By the way, I'm sorry for asking so much...
Thanks a lot

[MasterSleepy]

Ok here the method to delete the database.
1 . stop opengroupware service
     -> service opengroupware stop
2 . connect with postgres user
     -> su - postgres
3 . drop database
     -> dropdb ogo

and restart howto at step 3

I notice that I have made the howto for postgres to quickly, now I've change it. I just forget to specifie to expand the template.
And I also made a modification in step 5, "Modify configuration files"
So please go back see the howto and adapt your parameter.

Sorry for that mistake