Re: [Isga-users] local installation of ISGA

[Chris H. <che...@cg...>]

Julian,

When perl loads the ISGA module, quite a few rows are read from the 
database, so if you are not connected to the database you should see 
errors on apache startup. A simple way to test this is to execute one of 
the housekeeping scripts installed in the bin directory

   perl update_run_status.pl

If this throws an error, please send it to the list and I'll help you work 
trough it.

The only error that I see in your entry below is that the password needs 
to be run through a MD5 digest:

Digest::MD5::md5_hex($pass)

This will definitely keep you from being able to login until it is fixed 
though.

Have you tried creating an account through the web interface? If that 
doesn't work I would be interested in seeing what errors you receive.

Cheers,

  Chris


On Wed, 8 Sep 2010, Julian Krauskopf wrote:

> Hello,
> I allready installed Ergatis and Isga on my System(Debian 5) and it runs on apache2. But i can not log in. i created the following records in PostgreSQL 8.3.
>
> table account
>
>  party_id | account_email |         account_password         |userclass_id
> ----------+---------------+----------------------------------+--------------
>        1 | bl...@bl...   | 123                              |            1
>
> party
>
> party_id | partypartition_id | party_name | partystatus_id |      party_createdat       | party_institution | party_isprivate | party_iswalkthroughdisabled | party_iswalkthroughhidden
> ----------+-------------------+------------+----------------+----------------------------+-------------------+-----------------+-----------------------------+---------------------------
>        1 |                 1 | test       |              1 | 2010-09-08 17:49:48.949177 | test              | f               | f
>
> groupmembership
>
> party_id | partypartition_id | party_name | partystatus_id |      party_createdat       | party_institution | party_isprivate | party_iswalkthroughdisabled | party_iswalkthroughhidden
> ----------+-------------------+------------+----------------+----------------------------+-------------------+-----------------+-----------------------------+---------------------------
>        1 |                 1 | test       |              1 | 2010-09-08 17:49:48.949177 | test              | f               | f
>
> in CONFIG.yaml i entered the following database connection parameters:
> database: { name: isga_dev, user: isga, type: Pg }
>
> Is there a way to check if isga is able to connect to the database at all? or did we make some error within the user creation?
> Thanks for any help
> Julian Krauskopf
>
> -- 
> GMX DSL SOMMER-SPECIAL: Surf & Phone Flat 16.000 für nur 19,99 Euro/mtl.!*
> http://portal.gmx.net/de/go/dsl
>
> ------------------------------------------------------------------------------
> Automate Storage Tiering Simply
> Optimize IT performance and efficiency through flexible, powerful,
> automated storage tiering capabilities. View this brief to learn how
> you can reduce costs and improve performance.
> http://p.sf.net/sfu/dell-sfdev2dev
> _______________________________________________
> Isga-users mailing list
> Isg...@li...
> https://lists.sourceforge.net/lists/listinfo/isga-users
>