Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: MasterSleepy on September 03, 2003, 05:12:09 PM

Title: Howto Opengroupware
Post by: MasterSleepy on September 03, 2003, 05:12:09 PM
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
Title: Re: Howto Opengroupware
Post by: Warren Blackbeard on September 03, 2003, 06:32:44 PM
Thnx MasterSleepy ,

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

Warren
Title: Re: Howto Opengroupware
Post by: IDar on September 04, 2003, 04:53:49 PM
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?
Title: Re: Howto Opengroupware
Post by: MasterSleepy on September 04, 2003, 05:28:21 PM
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
Title: Re: Howto Opengroupware
Post by: MasterSleepy on September 04, 2003, 06:07:57 PM
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.
Title: Re: Howto Opengroupware
Post by: IDar on September 04, 2003, 06:16:13 PM
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 ;)
Title: Re: Howto Opengroupware
Post by: IDar on September 04, 2003, 06:44:39 PM
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
Title: Re: Howto Opengroupware
Post by: IDar on September 04, 2003, 07:26:46 PM
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?? ;)
Title: Re: Howto Opengroupware
Post by: MasterSleepy on September 04, 2003, 08:24:08 PM
Try to replace the gaf.ruizlizondo.com by "gaf".

Just another question, can you connect the database with :
psql postgrestest-h gaf -U ogo
???
Title: Re: Howto Opengroupware
Post by: IDar on September 04, 2003, 09:38:29 PM
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
Title: Re: Howto Opengroupware
Post by: MasterSleepy on September 04, 2003, 11:05:06 PM
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.
Title: Re: Howto Opengroupware
Post by: IDar on September 05, 2003, 12:11:11 PM
I don't know what i did... but it works...
Thanks MaasterSleepy
Title: Re: Howto Opengroupware
Post by: IDar on September 05, 2003, 12:15:53 PM
ejem... it works... but i can't login....
:( :(
Title: Re: Howto Opengroupware
Post by: IDar on September 05, 2003, 05:06:50 PM
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
Title: Re: Howto Opengroupware
Post by: MasterSleepy on September 05, 2003, 07:48:59 PM
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
Title: Re: Howto Opengroupware
Post by: IDar on September 05, 2003, 07:59:07 PM
Thanks man, but now Am I supposed to login with my sme account or with any other? And if so.. wich one? there's no way to find it
Title: Re: Howto Opengroupware
Post by: MasterSleepy on September 05, 2003, 08:21:41 PM
You have to been root.
Title: Re: Howto Opengroupware
Post by: IDar on September 05, 2003, 08:23:11 PM
I have gone through the manual again and there's no way to login... as far as i know my root accout should be enabled to access... but it fails to authentify...
oh my god... this groupware it's breaking my head.... (my be the expresion it's senseless but it's spanish (me está rompiendo la cabeza...) )

how did you manage to get it working? you are my hero
Title: Re: Howto Opengroupware
Post by: MasterSleepy on September 05, 2003, 08:29:48 PM
The first time you connect to opengroupware.
http://[name of your host]/OpenGroupware
You have to arrive directly to the main screen of the application.
No login to specify nor password.

When the DB is initialised there is ony one use "roor" without password.
Title: Re: Howto Opengroupware
Post by: IDar on September 05, 2003, 08:33:58 PM
No man...
You can try by yourself: http://gaf.ruizlizondo.com/OpenGroupware
It doesn't work
Title: Re: Howto Opengroupware
Post by: MasterSleepy on September 05, 2003, 08:46:02 PM
OK I have try your website, strange ....
did you drop the database and recreate it????
Title: Re: Howto Opengroupware
Post by: IDar on September 05, 2003, 08:48:44 PM
i dropped both the db and the user and recreated them again
Title: Re: Howto Opengroupware
Post by: IDar on September 05, 2003, 10:01:41 PM
I reinstalled everything and... noway :( I'm about to desist...
Does somebody know any application like this one?
Title: Re: Howto Opengroupware
Post by: MasterSleepy on September 06, 2003, 02:25:55 AM
I really don't understand what is appenning.
I reinstall a test pc and follow both howto, and it work.

I'm sorry but I don't have any idea of your problem.