Re: [Phpgroupware-users] Installation problem?

[Megan Webb]

Thanks for the suggestion.

Tried this. Dropped the database, created it again and set the user to
root in header.inc.php and the password. Went through the steps again.
Same problem.

I also tried starting mysql with debug mode on. I can update and change
some settings after I log in with the admin user I created. But other
settings just don't stick. Watching the mysql debug, no update/insert is
sent to the database.

Any other suggestions?

Megan



On Fri, 2003-02-28 at 06:30, Brian Jackson wrote:
> The first thing I would check is the user permissions in mysql. Maybe make 
> sure the same user is being used by phpgw. As a last resort to make sure it 
> isn't database/permissions issues, use root as the user for phpgw(major 
> security risk, so don't leave it like that) Maybe somebody else can help more 
> when they wake up.
> 
> --Brian Jackson
> 
> On Wednesday 26 February 2003 11:25 pm, Megan Webb wrote:
> > Hi,
> >
> > I've tried phpgroupware before and liked it. Now I have the chance to
> > have it adopted for our organisation (and another that we share offices
> > with), however I am having problems getting it to run.
> >
> > I figure that I am missing something in the setup.
> >
> > Steps:
> >
> > 1. Untar distro to /var/www/phpgroupware
> > 2. Create database and user, grant permissions.
> > 3. Fill in a few options to create header.inc.php (server root =
> > /var/www/phpgroupware, etc)
> > 4. Login and install the applications
> > 5. Edit the configuration
> > 6. Create the admin user
> > 7. Install the Admin application.
> > 8. I then login as the admin user, and pick 'User Accounts', select my
> > admin user and click 'view', then 'Acl Rights'
> >
> > I'm told that :
> >
> >  Deny access to site configuration
> > _ Deny access to user accounts
> >  Deny access to groups
> >  Deny access to peer servers
> >  Deny access to applications
> >  Deny access to global categories
> >  Deny access to mainscreen message
> >  Deny access to current sessions
> >  Deny access to session log
> >  Deny access to error log
> >  Deny access to application registery
> >  Deny access to phpinfo
> >
> > If I select any of these I get an error like:
> >
> > Database error: Invalid SQL: select * from phpgw_acl where (acl_account
> > in (, 0,1,2))
> >
> > File: /var/www/phpgroupware/phpgwapi/inc/class.acl.inc.php
> > Line: 94
> >
> > Session halted.
> >
> >
> > I have tried to install some applications, but have problems with
> > errors, being unable to save settings, assign rights, and other error
> > messages. I think the above problem is at the base of all the other
> > problems I have.
> >
> > I'm guessing that I have a config option wrong, or need to edit some
> > other file that I am not aware of yet.
> >
> > I have searched the archives, and found people have had problems with
> > LDAP. I am not using LDAP. I am using mysql as the database.
> >
> >
> > Can anyone point me in the right direction?
> > I can supply config files, etc if it would help.
> >
> >
> > Thanks in advance.
> >
> >
> > Megan
> >
> >
> >
> > _______________________________________________
> > Phpgroupware-users mailing list
> > address@hidden
> > http://mail.gnu.org/mailman/listinfo/phpgroupware-users
> 
> 
> 
> _______________________________________________
> Phpgroupware-users mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>