local installation of ISGA

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

local installation of ISGA

Julian Krauskopf
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 | [hidden email]   | 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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/isga-users
Reply | Threaded
Open this post in threaded view
|

Re: local installation of ISGA

Chris Hemmerich

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 | [hidden email]   | 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
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/isga-users
>
------------------------------------------------------------------------------
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/isga-users
Reply | Threaded
Open this post in threaded view
|

Re: local installation of ISGA

Julian Krauskopf
Hello,
thanks for your prompt reply. so i figuered out that the problem has nothing to do with the database conection. the update_run_status.pl works fine and when i try to create a new account from the webinterface with the same email adress it says that the email adress already exists.

When i try to create a new account nothing happens for a couple of minutes, but then
Your account request was successfully processed, and a confirmation email message was sent to the email address you provided. You must follow the link in that message within 48 hours to confirm the request. .

But now i am aware that i need to create an account through the web nterface and need to confirm it through the link sended by ISGA.

I dont know where i have to tell isga how to send these emails(from which account and which password)?

thanks
Julian

-------- Original-Nachricht --------
> Datum: Fri, 10 Sep 2010 00:41:57 -0400 (EDT)
> Von: Chris Hemmerich <[hidden email]>
> An: Julian Krauskopf <[hidden email]>
> CC: [hidden email]
> Betreff: Re: [Isga-users] local installation of ISGA

>
> 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 | [hidden email]   | 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
> > [hidden email]
> > https://lists.sourceforge.net/lists/listinfo/isga-users
> >

--
GRATIS: Spider-Man 1-3 sowie 300 weitere Videos!
Jetzt freischalten! http://portal.gmx.net/de/go/maxdome


--
GRATIS: Spider-Man 1-3 sowie 300 weitere Videos!
Jetzt freischalten! http://portal.gmx.net/de/go/maxdome

------------------------------------------------------------------------------
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/isga-users