EGS Forums

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

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')

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.

Hi,

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

Thanks Jake

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.

Ditto, until 10 minutes age I was very comfortable with MYSQL - now I am a hyperventilating wreck again trying to get my mind around another SQL database server.

Please add MYSQL support, my hosting company does not even run a Postgres server so this going to be a local test site and no further. – If I can get the @##@#@ Postgres server sorted.

Hello to all expect programmer, i am a student from APIIT.

I wonder what should i know in order to create a Groupware System.

Thanks for your help.

I'm unable to reach the trac server using the link on the website. Is there anything special I need to do to reach it?

I've had a look through the EGS 2b1 code and it looks much better organized than other O/S CRM projects!

Hi Zenny,

The demo has been live in the interim. I will follow up with where it is and get back to you.

Thanks

Jake

It is more than 4 months since you (Jake Stride) promised that there would be a demo "in the next couple of days", but till these lines are written (20080324, the demo link still says "Site not live". That makes me doubtful to deploy in production environment! Could the developers update about the development and roadmap of the EGS? Thanks.

When I run the egs beta 2 sql in phppgadmin, I get this error:

SQL error: ERROR: parser: parse error at or near "WITH" at character 4362

What is wrong?

Hi everybody,

I am new in the forum and I say hello to everybody :)

After a while I made it to connect to the db-server using wwwrun as a user. Now I can see the login form to be displayed, when I open the url wwww.mydomain.com/egs - fine.

But when I try to log in with user: root pass: root

I got an error: Invalid Username/Password Combination

though the db-table users has a user=root with pass=root (md5).

But why does it not work?

If anyone could please help me I would appreciate a lot.

Thank you, Selim

Hi everybody,

I have a problem with my egs-1.2.8 installation. I have a Suse-Linux Installation and installed the postgres-database egsdb successfully.

Warning: pg_pconnect(): Unable to connect to PostgreSQL server: FATAL: Ident authentication failed for user "root" in /srv/www/vhosts/rodurago.de/subdomains/shop/httpdocs/egs/src/adodb/drivers/adodb-postgres64.inc.php on line 668 Failed to Connect to Database

Is the error message I got when I try to start open http://www.mydomain.de/egs/index.php

Which is the username I usually should use here? I tried it with user: root pass: root but without success.

Any help would be greatly appreciated, Thank you, Soezkan

Hi Jake, I'm trying to install egs2_beta1 on Fedora core6 with Apache 2.0 PHP5.1.6, Don't worry. I have already install the Json modules on php. So i've not problem of extension. When i'm trying to get on the EGS on the server http://demo.iesgames.com/egs/egs2/index.php I receive a blank page. I'have already create my Database. I've followed all the instrutions. Could you please Help me? Waiting for your reply, nice day. Best regards GYREX

Hi Jake, I'm trying to EGS on Fedora core6 with Apache 2.0 PHP5.1.6, Don't worry. I have already install the Json modules on php. So i've not problem of extension. When i'm trying to get on the EGS on the server http://demo.iesgames.com/egs/egs2.index.php I receive a blank page. I'have already create my Database. I've followed all the instrutions. Could you please Help me? Waiting for your reply, nice day Best regards GYREX

the version i am using is not the latest svn download. Instead, it is the egs2_beta1.tar downloaded from sourceforge...

any recommendations on how to fix this?

Thanks!

Are you using the database dump that came with that download, or one from a previous version? The reason I ask is that the 'projects' table doesn't have a "companyid" field - it's "company_id" now.

let me emphasize that the version i have running is the latest '2 beta 1'

Hello,

Recently I got the latest stable version uploaded to a local server and it seems to be operating great (I love the look, by the way!) except that when I try to add a new company, user, project, etc. I receive an error. I notice that the company is blank, even though I have setup a default company to work with.

Here is the error I receive when I try to add a new project:

Fatal error: Uncaught exception 'Exception' with message 'Save of Project failed: ERROR: null value in column "companyid" violates not-null constraint' in /usr/local/apache2/htdocs/lib/classes/DataObject.php:524 Stack trace: #0 /usr/local/apache2/htdocs/lib/classes/Controller.php(158): DataObject->save() #1 /usr/local/apache2/htdocs/app/controllers/projects/ProjectsController.php(843): Controller->save('Project') #2 [internal function]: ProjectsController->save() #3 /usr/local/apache2/htdocs/index.php(65): calluser_func(Array) #4 {main} thrown in /usr/local/apache2/htdocs/lib/classes/DataObject.php on line 524

I appreciate any help with this issue,

Eric

Hi,

Is Apache definitely running? You don't still have IIS running and clashing with it?

Thanks

Jake