I apologize before hand if I am not following the accepted protocol. I've been 
using Ubuntu for only a few weeks and haven't got up to speed with how the 
whole ecosystem works yet.
The following may be a stream of consciousness but I hope you get enough of the 
gist of things to tell me what I am doing wrong and how to fix it. 

I am still experiencing this bug,

sudo bacula-dir -tv

still gives,

bacula-dir: symbol lookup error: /usr/lib/bacula/libbaccats-7.0.5.so:
undefined symbol: mysql_init

Background:-
A clean install on machine with no OS,
lsb_release -a

gives,

No LSB modules are available.
Distributor ID: Ubuntu
Description:    Ubuntu 16.04.1 LTS
Release:        16.04
Codename:       xenial

Followed instructions on,

https://help.ubuntu.com/lts/serverguide/bacula.html,

to install Bacula. Thought it would install the version for mysql by
default. It didn't. So I uninstalled. Installed mysql using,

sudo apt install mysql-server.

Installed OK.
Then,

sudo apt install bacula-client bacula-sd-mysql, bacula-director-mysql

Had few problems with the install menu, got,

'Empty value for 'port' specified , will throw an error in future versions
Error 1067 (42000) at line 90: Invalid default value for 'CleaningDate'.'

the first time around, went around again set up socket type 'tcp/ip',
'localhost', port '3306', and then,

'get error 1050 (42501) at line 7: Table 'Filename' already exists'

presumably because it had already been created first time round.
The menu in this part of the installation (the explanation page for 'abort, 
retry, retry(without questions), ignore' part) could only be exited by pressing 
'esc' as using the arrow keys to navigate to the '<ok>' would not work. The 
only option that seemed to terminate the installation at this stage was the 
'abort' option.

Anyway, it did produce a database for bacula in mysql, can anyone
confirm that the following,

+---------------+
|    Tables     |
+---------------+
| File          |
| Filename      |
| MediaType     |
| Path          |
| RestoreObject |
| Storage       |
+---------------+

is correct for bacula ?

Used,

sudo apt install bacula

to install the remaining packages 'bacula' & 'bacula-server'
Modified '.conf' files as required.
Tested '.conf' files,

sudo bacula-sd -t -c /etc/bacula/bacula-sd.conf

O.K.

sudo bacula-fd -t -c /etc/bacula/bacula-fd.conf

O.K.

sudo bacula-dir -t -c /etc/bacula/bacula-dir.conf

not O.K. got,

bacula-dir: symbol lookup error: /usr/lib/bacula/libbaccats-7.0.5.so:
undefined symbol: mysql_init

Did a search on this on Google and ended up here.

Followed Brian Murray's instruction in #51 above, did as per,

https://wiki.ubuntu.com/Testing/EnableProposed

All O.K. except:-

sudo aptitude -t xenial-proposed

gives,

'sudo: aptitude: command not found'

changed to,

sudo apt -t xenial-proposed

gives,

'E: Command line option 't' [from -t] is not understood in combination
with the other options.'

So gave up on this and tried,

sudo apt-get install bacula/xenial-proposed

which gave,

'Reading package lists... Done
Building dependency tree       
Reading state information... Done
Selected version '7.0.5+dfsg-4ubuntu0.1' (Ubuntu:16.04/xenial-proposed [all]) 
for 'bacula'
Selected version '7.0.5+dfsg-4ubuntu0.1' (Ubuntu:16.04/xenial-proposed [all]) 
for 'bacula-server' because of 'bacula'
Selected version '7.0.5+dfsg-4ubuntu0.1' (Ubuntu:16.04/xenial-proposed [amd64]) 
for 'bacula-sd' because of 'bacula-server'
Selected version '7.0.5+dfsg-4ubuntu0.1' (Ubuntu:16.04/xenial-proposed [amd64]) 
for 'bacula-common' because of 'bacula-sd'
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies.
 bacula : Depends: bacula-server (= 7.0.5+dfsg-4ubuntu0.1) but 
7.0.5+dfsg-4build1 is to be installed
E: Unable to correct problems, you have held broken packages.'

rebooted.

So after this, still the same error,

sudo bacula-dir -t -c /etc/bacula/bacula-dir.conf

not O.K. got,

bacula-dir: symbol lookup error: /usr/lib/bacula/libbaccats-7.0.5.so:
undefined symbol: mysql_init

Any of you wise unix heads know if the fault is my process of
installation or not ?

Versions:-

apt-cache madison mysql-server

gives,

mysql-server | 5.7.15-0ubuntu0.16.04.1 | http://gb.archive.ubuntu.com/ubuntu 
xenial-updates/main amd64 Packages
mysql-server | 5.7.15-0ubuntu0.16.04.1 | http://gb.archive.ubuntu.com/ubuntu 
xenial-updates/main i386 Packages
mysql-server | 5.7.15-0ubuntu0.16.04.1 | http://security.ubuntu.com/ubuntu 
xenial-security/main amd64 Packages
mysql-server | 5.7.15-0ubuntu0.16.04.1 | http://security.ubuntu.com/ubuntu 
xenial-security/main i386 Packages
mysql-server | 5.7.11-0ubuntu6 | http://gb.archive.ubuntu.com/ubuntu 
xenial/main amd64 Packages
mysql-server | 5.7.11-0ubuntu6 | http://gb.archive.ubuntu.com/ubuntu 
xenial/main i386 Packages
mysql-server | 5.7.11-0ubuntu6 | http://us.archive.ubuntu.com/ubuntu 
xenial/main amd64 Packages
mysql-server | 5.7.11-0ubuntu6 | http://us.archive.ubuntu.com/ubuntu 
xenial/main i386 Packages

apt-cache madison bacula

gives,

    bacula | 7.0.5+dfsg-4ubuntu0.1 | http://gb.archive.ubuntu.com/ubuntu 
xenial-proposed/universe amd64 Packages
    bacula | 7.0.5+dfsg-4ubuntu0.1 | http://gb.archive.ubuntu.com/ubuntu 
xenial-proposed/universe i386 Packages
    bacula | 7.0.5+dfsg-4build1 | http://gb.archive.ubuntu.com/ubuntu 
xenial/universe amd64 Packages
    bacula | 7.0.5+dfsg-4build1 | http://gb.archive.ubuntu.com/ubuntu 
xenial/universe i386 Packages
    bacula | 7.0.5+dfsg-4build1 | http://us.archive.ubuntu.com/ubuntu 
xenial/universe amd64 Packages
    bacula | 7.0.5+dfsg-4build1 | http://us.archive.ubuntu.com/ubuntu 
xenial/universe i386 Package

Has the '-proposed' installed correctly ?

Another thing:-

service --status-all

reports (the relevant parts reproduced here),

 [ + ]  bacula-director
 [ + ]  bacula-fd
 [ + ]  bacula-sd

but,

ps -ef | grep bacula

reports,

bacula    1077     1  0 Oct14 ?        00:00:00 /usr/sbin/bacula-sd -c 
/etc/bacula/bacula-sd.conf -u bacula -g tape
root      1091     1  0 Oct14 ?        00:00:00 /usr/sbin/bacula-fd -c 
/etc/bacula/bacula-fd.conf
<username>    16167 14603  0 14:10 pts/2    00:00:00 grep --color=auto bacula

bacula-director is running, yet not running!

sudo systemctl status bacula-director.service

gives,

● bacula-director.service - LSB: Start Bacula Director at boot time
   Loaded: loaded (/etc/init.d/bacula-director; bad; vendor preset: enabled)
   Active: active (exited) since Fri 2016-10-14 23:15:03 BST; 14h ago
     Docs: man:systemd-sysv-generator(8)
  Process: 4602 ExecStop=/etc/init.d/bacula-director stop (code=exited, 
status=0/SUCCESS)
  Process: 5309 ExecStart=/etc/init.d/bacula-director start (code=exited, 
status=0/SUCCESS)

Oct 14 23:15:03 ......... systemd[1]: Starting LSB: Start Bacula Director at 
boot time...
Oct 14 23:15:03 ......... bacula-director[5309]:  * Starting Bacula Director... 
bacula-dir
Oct 14 23:15:03 ......... bacula-director[5309]:    ...done.
Oct 14 23:15:03 ......... systemd[1]: Started LSB: Start Bacula Director at 
boot time.

I can start and stop bacula-director with systemctl and 'service
--status-all' will show the change.

But if I run 'bconsole' all I get is,

Connecting to Director localhost:9101

which then just returns to the terminal prompt with no messages.

In directory '/var/lib/bacula', I only get the files,

-rw-r----- 1 root root 196 Oct 15 13:54 bacula-fd.9102.state
-rw-r----- 1 root root 196 Oct 15 13:53 bacula-sd.9103.state

not a 'bacula-dir.9101.state' file.

In summary:-
1) Can someone please tell me what I am doing wrong.
2) Is bacula-dir running or not.
3) Is the '-proposed' patch actually installed on my machine.

Oh, P.S. I'm not getting a bacula log file created in '/var/log/bacula'
anymore either.

P.P.S. How do I add a tag ?
Do I just put,

tags: verification-failed

at the end of a message ?

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1570923

Title:
  bacula-dir won't start with "undefined symbol: mysql_init"

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/bacula/+bug/1570923/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to