On Mon, Jun 26, 2006 at 05:35:20PM +0100, mark alston (IFR) wrote: > Hi > Thanks for the feedback so far, but I'm still unclear as to what's going > on. > > >It seems that all your tables are read-only !!! > >After your DB copie, did you ensure that the MySQL user had > >write-access to the DB files ? > I had checked file/directory permissions for base and basedynamic on the > broken server and changed them to ones like on the working server. Is > this what you mean? > e.g. in base directory: > 12 -rw-rw---- 1 mysql mysql 9092 May 11 2005 > ArrayBatch.frm > 4 -rw-rw---- 1 mysql mysql 404 Apr 19 17:01 ArrayBatch.MYD > 4 -rw-rw---- 1 mysql mysql 4096 Apr 20 10:46 ArrayBatch.MYI > etc etc
yes, this is. So, did you reported the correct rights ("Insert privileges", "Update privileges"...) on the DB for the user in MySQL that use that DB (e.g. value of $config['dbuser']). It is stored in the tables "user" and "db" of the "mysql" DB. Rq: it's strange that the user in MySQL is called "apache" because users in MySQL have nothing to do with Apache Unix user !!! a+, -- Julien << Vous n'avez rien a dire... Parlons-en! >>
signature.asc
Description: Digital signature
Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________ The BASE general discussion mailing list basedb-users@lists.sourceforge.net unsubscribe: send a mail with subject "unsubscribe" to [EMAIL PROTECTED]