Re: [Bacula-users] Installing Bacula 5.0.2 in Ubuntu 10.04 with MySQL 5.1
Hi, On Sat, 26 Jun 2010, Graham Sparks wrote: 26-Jun 18:01 bacula-dir JobId 0: Fatal error: Could not open Catalogue MyCatalog, database bacula. 26-Jun 18:01 bacula-dir JobId 0: Fatal error: mysql.c:194 Unable to connect to MySQL server. Database=bacula User=bacula MySQL connect failed either server not running or your authorisation is incorrect. 26-Jun 18:01 bacula-dir ERROR TERMINATION I'd suggest (if you haven't already) that you lift the exact username, password, host and database name from the config file and try a mysql -u username -p -h hostname databasename give the password at the prompt and make sure . It could be, for example, that the mysql database is listening on the eth0 interface but not the loopback or vice versa. By default, I presume bacula connects on the localhost so if that's not specified you should probably use 127.0.0.1. Gavin -- This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Bacula-sd crashing on DVD-RW backup
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello, Recently my Bacula-SD is crashing. The only change that I can remember happening to the system is a kernel update a few weeks back. I've attached the GDB traceback e-mail that I got from the system. Hopefully somebody can find out what's causing the crash. - - Michel -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.10 (MingW32) iEYEARECAAYFAkwnwVQACgkQ2Vs+MkscAyX+AwCeM6ZEUSKAlAJv5f1IUQ8S2Sk+ 7l0AnRJ9/Do/+qjVsxcSRk1R2xjW9a/U =gtek -END PGP SIGNATURE- ---BeginMessage--- [Thread debugging using libthread_db enabled] [New Thread 0xb5f19b70 (LWP 20326)] [New Thread 0xb6f27b70 (LWP 20323)] [New Thread 0xb6726b70 (LWP 20287)] 0xb7720424 in __kernel_vsyscall () $1 = '\000' repeats 29 times $2 = 0x96158a0 bacula-sd $3 = 0x96158c8 /sbin/bacula-sd $4 = 0x0 $5 = 0xb76d86fe 5.0.2 (28 April 2010) $6 = 0xb76d8714 i686-pc-linux-gnu $7 = 0xb76d8726 debian $8 = 0xb76d872d squeeze/sid $9 = shodan, '\000' repeats 43 times #0 0xb7720424 in __kernel_vsyscall () #1 0xb7312291 in select () from /lib/i686/cmov/libc.so.6 #2 0xb76a4dd0 in bnet_thread_server (addrs=0x9616798, max_clients=41, client_wq=0x809a880, handle_client_request=0x8068eb0 handle_connection_request(void*)) at bnet_server.c:161 #3 0x0804e693 in main (argc=value optimized out, argv=0xbfbe9244) at stored.c:312 Thread 4 (Thread 0xb6726b70 (LWP 20287)): #0 0xb7720424 in __kernel_vsyscall () #1 0xb7683482 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/i686/cmov/libpthread.so.0 #2 0xb76cf475 in watchdog_thread (arg=0x0) at watchdog.c:308 #3 0xb767e955 in start_thread () from /lib/i686/cmov/libpthread.so.0 #4 0xb731910e in clone () from /lib/i686/cmov/libc.so.6 Thread 3 (Thread 0xb6f27b70 (LWP 20323)): #0 0xb7720424 in __kernel_vsyscall () #1 0xb7686f4b in waitpid () from /lib/i686/cmov/libpthread.so.0 #2 0xb76c53df in signal_handler (sig=11) at signal.c:229 #3 signal handler called #4 lseek_dvd (dcr=0x0, offset=0, whence=0) at dvd.c:433 #5 0x08065bb7 in DEVICE::rewind (this=0x9625110, dcr=0x0) at dev.c:836 #6 0x0806626b in DEVICE::offline_or_rewind (this=0x9625110) at dev.c:1282 #7 0x080662b0 in DEVICE::close (this=0x9625110) at dev.c:1926 #8 0x080665fc in DEVICE::close_part (this=0x9625110) at dev.c:1985 #9 0x0806ada9 in dvd_open_first_part (dcr=0x96275b8, mode=3) at dvd.c:410 #10 0x0806c8a9 in lseek_dvd (dcr=0x96275b8, offset=0, whence=2) at dvd.c:536 #11 0x080666d3 in DEVICE::eod (this=0x9625110, dcr=0x96275b8) at dev.c:908 #12 0x08077cc6 in DCR::mount_next_write_volume (this=0x96275b8) at mount.c:287 #13 0x08054dee in acquire_device_for_append (dcr=0x96275b8) at acquire.c:400 #14 0x0805712b in do_append_data (jcr=0x9625e08) at append.c:82 #15 0x0806e3ec in append_data_cmd (jcr=0x9625e08) at fd_cmds.c:203 #16 0x0806da9c in do_fd_commands (jcr=0x9625e08) at fd_cmds.c:162 #17 0x0806e575 in run_job (jcr=0x9625e08) at fd_cmds.c:124 #18 0x0806ef1f in run_cmd (jcr=0x9625e08) at job.c:225 #19 0x080692eb in handle_connection_request (arg=0x96243c8) at dircmd.c:233 #20 0xb76cf9f4 in workq_server (arg=0x809a880) at workq.c:346 #21 0xb767e955 in start_thread () from /lib/i686/cmov/libpthread.so.0 #22 0xb731910e in clone () from /lib/i686/cmov/libc.so.6 Thread 2 (Thread 0xb5f19b70 (LWP 20326)): #0 0xb7720424 in __kernel_vsyscall () #1 0xb7683482 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/i686/cmov/libpthread.so.0 #2 0xb76cfb2b in workq_server (arg=0x809a880) at workq.c:323 #3 0xb767e955 in start_thread () from /lib/i686/cmov/libpthread.so.0 #4 0xb731910e in clone () from /lib/i686/cmov/libc.so.6 Thread 1 (Thread 0xb72466d0 (LWP 20283)): #0 0xb7720424 in __kernel_vsyscall () #1 0xb7312291 in select () from /lib/i686/cmov/libc.so.6 #2 0xb76a4dd0 in bnet_thread_server (addrs=0x9616798, max_clients=41, client_wq=0x809a880, handle_client_request=0x8068eb0 handle_connection_request(void*)) at bnet_server.c:161 #3 0x0804e693 in main (argc=value optimized out, argv=0xbfbe9244) at stored.c:312 #0 0xb7720424 in __kernel_vsyscall () No symbol table info available. #1 0xb7312291 in select () from /lib/i686/cmov/libc.so.6 No symbol table info available. #2 0xb76a4dd0 in bnet_thread_server (addrs=0x9616798, max_clients=41, client_wq=0x809a880, handle_client_request=0x8068eb0 handle_connection_request(void*)) at bnet_server.c:161 161 if ((stat = select(maxfd + 1, sockset, NULL, NULL, NULL)) 0) { Current language: auto The current source language is auto; currently c++. maxfd = value optimized out sockset = {fds_bits = {8, 0 repeats 31 times}} clilen = 16 turnon = 1 p = value optimized out buf =
Re: [Bacula-users] Issue backing up Oracle database using Bacula
nagaraj mogaroy wrote: Hello, I've been trying to set up a backup of our Oracle database using Bacula, following the steps in the below link: http://wiki.bacula.org/doku.php?id=application_specific_backups:oracle_rdbms However, I encounter the following errors during the backup process: 25-Jun 08:55 tapti18522-fd JobId 20: ClientRunBeforeJob: SP2-0734: unknown command beginning /var/oracl... - rest of line ignored. 25-Jun 08:55 tapti18522-fd JobId 20: ClientRunBeforeJob: -rw-rw 16785408 2010/06/25 08:55:03 RBL_CORE.dbf 25-Jun 08:55 tapti18522-fd JobId 20: ClientRunBeforeJob: 25-Jun 08:55 tapti18522-fd JobId 20: ClientRunBeforeJob: sent 63 bytes received 20 bytes 23.71 bytes/sec 25-Jun 08:55 tapti18522-fd JobId 20: ClientRunBeforeJob: total size is 16785408 speedup is 202233.83 25-Jun 08:55 tapti18522-fd JobId 20: ClientRunBeforeJob: 25-Jun 08:55 tapti18522-fd JobId 20: ClientRunBeforeJob: SP2-0734: unknown command beginning /var/oracl... - rest of line ignored. 25-Jun 08:55 tapti18522-fd JobId 20: ClientRunBeforeJob: -rw-rw 16785408 2010/06/25 08:55:07 suncata.dbf 25-Jun 09:25 tapti18522-fd JobId 20: ClientRunBeforeJob: SP2-0734: unknown command beginning /var/oracl... - rest of line ignored. 25-Jun 09:26 tapti18522-fd JobId 20: ClientRunBeforeJob: alter system archive log all 25-Jun 09:26 tapti18522-fd JobId 20: ClientRunBeforeJob: * 25-Jun 09:26 tapti18522-fd JobId 20: ClientRunBeforeJob: ERROR at line 1: 25-Jun 09:26 tapti18522-fd JobId 20: ClientRunBeforeJob: ORA-00271: there are no logs that need archiving The control file and the archive redo logs get backedup alright.It's only the data files that I am facing the issue. Being new to Oracle/sqlplus, I am stuck here, and no amount of googling has helped.I have also tried setting sqlblanklines to ON in the script, as suggested in one of the forums, but that didn't help. Would greatly appreciate if someone can guide me here. Note: I have not added the scripts here as I just copied them from the mentioned link and pasted them in my server, changing only the paths where necessary. Have you downloaded and installed the various scripts mentioned on that wiki (namely runbeforebackup.sh, runafterbackup.sh etc - there are 5 named)? If so, what path have you saved them at, and have you made the *.sh scripts executable after downloading them (using the chmod command)? If you have saved them to a different location, have you also changed the sudoers file and any other scripts that refer to them? -- Mike Holden http://www.by-ang.com - the place to shop for all manner of hand crafted items, including Jewellery, Greetings Cards and Gifts Hi, Thanks for the reply, I have double checked all the points highlighted by you, and they all seem OK.All the scripts are in place with 775 permissions, and their paths mentioned correctly in sudoers file.Proper permissions have also been assigned to the bacula and oracle users. Any other suggestions, please? Thanks, NK Mogaroy -- This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users