-----Original Message----- From: Ryan Novosielski [mailto:[EMAIL PROTECTED] Sent: den 28 september 2007 05:08 To: Fredrik Gidensköld Cc: bacula-users@lists.sourceforge.net Subject: Re: [Bacula-users] Problem after an uppgrade from 2.0.X to 2.2.0
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Fredrik Gidensköld wrote: > Im runing Bacula under Debian and MySQL 5.0.x. and it worked just fine. > > Until I used "dselect" to uppgrade Bacula from 2.0.X to 2.2.0 and I got this > problmen. > > First I run Bacula as user 'bacula' and got this errorr: > > "nas:/etc/init.d# /usr/sbin/bacula-dir -v -d99 -f -g bacula -u bacula > bacula-dir: dird.c:156 Debug level = 99 > bacula-dir: mysql.c:164 mysql_init done > bacula-dir: mysql.c:185 mysql_real_connect done > bacula-dir: mysql.c:187 db_user=bacula db_name=bacula db_password=kallekula First off, I really wouldn't post my DB server password to a mailing list, but I suppose that may or may not matter to you. > bacula-dir: dird.c:873 Could not open Catalog "MyCatalog", database "bacula". > 27-sep 00:10 bacula-dir: Error: message.c:736 fopen > /var/lib/bacula/bacula-dir.bacula-dir.135186632.mail failed: ERR=Access Denied > 27-sep 00:10 bacula-dir: Error: message.c:736 fopen > /var/lib/bacula/bacula-dir.bacula-dir.135186632.mail failed: ERR=Access Denied This suggests to me that the old Bacula you were using ran as one username and the new one runs as another. Who owns these files listed above? You may need to change the permissions on some directories/files. > bacula-dir: dird.c:878 mysql.c:193 Unable to connect to MySQL server. > Database=bacula User=bacula > MySQL connect failed either server not running or your authorization is > incorrect. Not sure what's happening here, but maybe the same deal... what's the connect method, socket? If so, some other user probably owns the socket. > 27-sep 00:10 bacula-dir ERROR TERMINATION > Please correct configuration file: bacula-dir.conf > 27-sep 00:10 bacula-dir: Error: message.c:736 fopen > /var/lib/bacula/bacula-dir.bacula-dir.135186632.mail failed: ERR=Access > Denied" > > But if I run as root one problem goes away and one stays: > > "nas:/etc/init.d# /usr/sbin/bacula-dir -v -d99 -f -g bacula -u root > bacula-dir: mysql.c:164 mysql_init done > bacula-dir: mysql.c:185 mysql_real_connect done > bacula-dir: mysql.c:187 db_user=bacula db_name=bacula db_password=kallekula > bacula-dir: dird.c:873 Could not open Catalog "MyCatalog", database "bacula". > bacula-dir: dird.c:878 mysql.c:193 Unable to connect to MySQL server. > Database=bacula User=bacula > MySQL connect failed either server not running or your authorization is > incorrect. > 26-sep 23:33 bacula-dir ERROR TERMINATION > Please correct configuration file: bacula-dir.conf" Well, that explains the one problem anyway. I'm guessing the first one is running as "bacula" or something similar, and the files in /var/lib are not writable by this user. > I have testade and connect to MySQL manually with success and bweb displays > data from the databse just fine. I would solve the first problem first and then work from there. > Any one how has any idé what the problem is? > > Fredrik Gidensköld > SWEDEN > > > Solved the problem I think! I corrected the permissions problem for the user bacula, some how under the upgrade debian thought that root should be owner of some files that bacula owned. The second (MySQL connection) problem I solved using an old thread called "Subject: Re: weird problems with bacula + mysql" He changed the BD Address from ex. localhost to 'localhost.localdomain' and that worked for me to. Thanks for the help! //Fredrik Gidensköld ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
