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
I still get the message:
MySQL query failed: "DELETE FROM Cookie WHERE `lastSeen` < NOW() - INTERVAL 900 SECOND" : Table 'Cookie' is read only
>Does the Apache user on the test server have all rights
>to base databases? Is the UID same as on the prod server?
Sorry, but what do you mean as to ‘all rights to base databases’? Where can I check/set Apache’s rights??
Here’s a snippet of my BASE config.inc.php
$config["userName"] = "apache";
$config["RDBMS"] = "mysql";
$config["dbHost"] = "localhost";
// Changed by MAF Sept 2005
// $config["dbUser"] = "base";
$config["dbUser"] = "apache";
$config["dbPassword"] = "";
$config["dbDatabase"] = "base";
$config["dbDynamic"] = "basedynamic";
Thanks for your efforts.
Best regards,
Mark
******************************************
Dr Mark Alston,
Computational Biologist,
Institute of Food Research,
Norwich Research Park, Colney,
Norwich NR4 7UA, UK.
Tel +44 (0)1603 251432
e-mail [EMAIL PROTECTED]
e-disclaimer at http://www.ifr.ac.uk/edisclaimer/
******************************************
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]
