Hi, I hope the questions didn't mislead you. What the questions meant was the Apache (or Web) server should be run by user 'base' (as instructed in BASE docs) which should have the same UID/GID as on your prod server. Your original config.inc.php has the correct "userName" and "dbUser" to be 'base'. They DO NOT need to change. Surely it should have the "dbPassword" which should be the same as on your prod server (Please don't include the password in your future email though).
1. Apache Web configuration to make sure it will be run by user 'base' 2. MySQL should grant all rights to the user 'base' to the databases 'base' and 'basedynamic' 3. Stop BASE, Apache, and MySQL, and then start them in a reverse order. I would suggest you seek some help from your site system administrators if you need help for server configurations. Good luck. Zong-Pei ------------------------------------- Dr Zong-Pei Han UNIX Systems Administrator Computational Biology Research Group University of Oxford Tel: 01865 285731 http://www.compbio.ox.ac.uk/ ------------------------------------- On Mon, 26 Jun 2006, mark alston (IFR) wrote: ... >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/ www.ifr.ac.uk www.foodandhealthnetwork.com ****************************************** 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]
