[Phpgroupware-tracker] [bug #6311] Database error: lock(Array, write) failed.

[nobody]

=================== BUG #6311: LATEST MODIFICATIONS ==================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=6311&group_id=509

Changes by: Chris Weiss <address@hidden>
Date: Tue 11/04/03 at 09:35 (America/Chicago)

------------------ Additional Follow-up Comments ----------------------------
LOCK is required for .14, I don't recall if .12 required it too so it may be a 
new for .14 thing.



=================== BUG #6311: FULL BUG SNAPSHOT ===================


Submitted by: derricklo               Project: phpGroupWare                 
Submitted on: Sun 11/02/03 at 20:39
Category:  API - Admin                Bug Group:  0.9.16RC1                 
Severity:  5 - Major                  Priority:  High                       
Resolution:  Invalid                  Assigned to:  None                    
Status:  Closed                       Component Version:  TGZ               
Platform Version:  None               Reproducibility:  Every Time          

Summary:  Database error: lock(Array, write) failed.

Original Submission:  Hi,

 

I have installed phpgroupware 0.9.16.RC1, and successfully setup "Header Admin" 
and "Config Admin". A db and about 193 tables were created. 

 

PHP Version 4.3.2 

Mysql Version 4.0.15-standard 



When I tried to login as the new admin user, I got the following error:

 

"Database error: lock(Array, write) failed.

MySQL Error: 1044 (Access denied for user: 'address@hidden' to database 
'matrixu_gw')

 

Session halted."



Does not seems to be a permission, as 193 tables were created. Is there a 
locking issue? Does anyone knows how to resolve this?? Thanks!



Best Regards,

Derrick Lo



Follow-up Comments
*******************

-------------------------------------------------------
Date: Tue 11/04/03 at 09:35         By: cw
LOCK is required for .14, I don't recall if .12 required it too so it may be a 
new for .14 thing.

-------------------------------------------------------
Date: Tue 11/04/03 at 04:01         By: derricklo
Hi CW, skwashd, and CK:



Thanks for the info, I am able to login to phpGW now. My web server is hosted, 
and I have asked the admin to grant lock permission for my DB user.



Just wondering, we did not have locking control prior to phpgroupware 
0.9.16.RC1? I thought phpgroupware 0.9.14 did not have this?



Thanks again,

Derrick Lo



-------------------------------------------------------
Date: Mon 11/03/03 at 16:48         By: cw
LOCK is seperate permission DB permissions and is used in phpgw to ensure 
consistance, which is not needed in setup as it's a single user type of 
environment.



GRANT ALL gives LOCK but some shared hosts don't give you this by default.  
There is no work around, you must have LOCK permission or corrupt data is 
imminent.



This is a config issue and not a bug.

-------------------------------------------------------
Date: Mon 11/03/03 at 00:57         By: skwashd
is this hosted?  



are you sure that you have grant lock enabled for the user?


CC List
*******

CC Address                          | Comment
------------------------------------+-----------------------------
address@hidden                   | Thanks!



No files currently attached


For detailed info, follow this link:
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=6311&group_id=509

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/