Critter

Hi, Downloaded and installed this application today and managed to get everything running except that now I am unable to login via the web interface for some reason. README file says to use root and password but tht did not work, tried root root, no luck. anyone have any suggestions as to how to resolve this issue? I would really like to give this application a try.

Hi,

Are you getting any error messages in the logs or the postgresql import?

Thanks Jake

I ran into some issues with the hard drive in this test PC and am currently re-installing system, will try again with this application as soon as the system is up and running and hopefully have better success. Will let you know one way or the other.

Re-installed everything and same thing happened. Tried both password and root as the root user password: Error in log is as follows:

2008-08-06 11:43:52 AST LOG: database system is ready

2008-08-06 12:00:18 AST ERROR: permission denied for relation users

2008-08-06 12:00:18 AST STATEMENT: SELECT u.username FROM users u LEFT JOIN usercompanyaccess uca ON (u.username=uca.username) LEFT JOIN systemcompanies sc ON (uca.companyid=sc.company_id) WHERE sc.enabled AND uca.enabled AND u.username='root' AND password=md5('password')

2008-08-06 12:00:31 AST ERROR: permission denied for relation users

2008-08-06 12:00:31 AST STATEMENT: SELECT u.username FROM users u LEFT JOIN usercompanyaccess uca ON (u.username=uca.username) LEFT JOIN systemcompanies sc ON (uca.companyid=sc.company_id) WHERE sc.enabled AND uca.enabled AND u.username='root' AND password=md5('root')

Resolved the problem myself. Dropped database and created it with a different user other than the postgres user.

This thread sure came in handy.

Must say, README.txt is pretty much rubbish. As gerrya already points out, the PostgresQL actually needs built something like as follows:

$ psql

postgres=# CREATE USER "user" WITH PASSWORD '';

postgres=# ALTER USER "user" CREATEDB;

postgres=# \q

$ createdb egs2db -U "user" -h localhost

$ psql -h localhost -U "user" -d egs2db

postgres=# \i /"path-to"/egs2beta1initial.sql

All that, PLUS having to remove two illegal UTF8 characters from egs2beta1initial.sql (see the thread on that) around line 10765 and the undocumented requirement to install the software in the root web service directory (see the other thread on that - WTF!?!) are pretty much the three main hurdles to getting this going.

After the undocumented struggles, however, the software DOES run and provides exactly what I was looking for - a lean, minimalist CRM & Project web service