On Mon, Jun 26, 2006 at 02:55:35PM +0100, mark alston (IFR) wrote: > Hi everyone, > I have one test and one production server, each running their own BASE > 1.2.15. After backing up both machines, I did some tinkering on my test > box. I now want to get both machines back into the same state. I had the > brilliant(!) idea of copying the base and basedynamic databases from one > to the other. This worked - I can use mysql to look at base tables and > the test box now looks like the prod box - BUT, none of the BASE > user/passwords work anymore so I can't get into BASE. > All the BASE user tables seem OK, so what's changed? > Had a look at the discussion forum but nothing quite like it. > > Apache error_log: > MySQL query failed: "INSERT INTO EventLog > (`name`,`descr`,`addedDate`,`owner`,`removed`,`eventType`,`linkInfo`,`gi > d`,`groupAccess`,`worldAccess`) VALUES ('', 'from 149.155.118.217', > '2006-06-26 10:14:27', '7', '0', '1', '', '0', '0', '0')" : > Table 'EventLog' is read onlyMySQL query failed: "DELETE FROM Cookie > WHERE `lastSeen` < NOW() - INTERVAL 900 SECOND" : Table 'Cookie' is read > only
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 ? 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]