Re: [Bacula-users] Error Director /usr/lib64/libbaccats-7.4.0.so: undefined symbol: mysql_init

2016-06-15 Thread Kern Sibbald 
Hello,

To everyone who is having problems building Bacula to support MySQL 
version 5.7.x.  This is indeed a linking problem.  This version is found 
on Ubuntu 16.04, and probably other OSes with the most recent MySQL 
releases.  MySQL has eliminated the libmysqlclient_r.so library, which 
is the thread safe library by making the standard libmysqlclient.so 
thread safe.  While this is logical and desirable, to do so, they 
modified the way that MySQL is linked and rely on mysql_config to 
provide the correct parameters.  All is OK to that point.  
Unfortunately, since Bacula has a lot of detection code for old versions 
of MySQL, the Bacula implementation was not quite up to par.

I have now fixed that problem and pushed a somewhat complicated patch 
into the Bacula public repositories for Branch-7.0, Branch-7.2, and 
Branch-7.4.

If you want a quickie work around without getting the latest code:

- cd 
- run your ./configure
  - cd /src/cats
- edit Makefile
- Change the line that reads:
MYSQL_LIBS =
to
MYSQL_LIBS = -L/usr/lib/x86_64-linux-gnu -lmysqlclient -lpthread -lz -lm 
-lrt -ldl
- cd 
- make -j9
- ...

You should then have a Bacula that is correctly built.  Note: it is 
possible that the mysqlclient library is in a different place on your 
system.  To get the correct values to assign to MYSQL_LIBS, on your 
system simply do:

mysql_setup --libs_r

A final note about MySQL: for version 5.7, it seems that either they 
have a bug or more likely some default sync/fsync has been made the 
default, which means that using an out of the box MySQL and delivered on 
Ubuntu 16.04 is 10-15 times slower than either PostgreSQL out of the box 
or prior MySQL versions.  For me, this makes even running regression 
tests on that particular MySQL totally unusable (i.e. the normal set of 
regression tests run in about 2 hours; with this version of MySQL, it 
will probably take between 20 and 30 hours).  Hopefully Ubuntu or Oracle 
(MySQL) will fix this problem, which I will officially report today.

Best regards,
Kern

PS:

If any of you are C/C++ experienced Linux or Windows developers, Bacula 
Systems is hiring two new developers.  These jobs are in Switzerland.  
If you are interested, please see:

 http://www.baculasystems.com/company/careers


On 01/30/2016 03:16 AM, Phil Stracchino wrote:
> On 01/29/16 19:41, Hector Javier Agudelo Corredor wrote:
>> HI team
>>
>>
>> I installed centos 6.7.
>>
>> I have installed bacula 7.4 with postgres  5.7.10 but when I set the
>> mysql password in the file director.
> [...]
>
>> But when I test settings file manager with the command
>>
>> bacula-dir sudo -tc /etc/bacula/bacula-dir.conf
>>
>> get the following error:
>>
>> bacula-dir: symbol lookup error: /usr/lib64/libbaccats-7.4.0.so
>> : undefined symbol: mysql_init
>
> Um..   What's wrong with this picture?
>
> Did you mean you installed with *MySQL* 5.7.10?
>
>
> Personally, if I were you, I would not be using MySQL 5.7 yet.  It seems
> to still have some teething issues, some of them serious.  You might try
> backing out to MySQL (or Percona Server) 5.6.28.
>
> That said, as Michael suggested, it looks as though there is something
> wrong (or simply odd) about either your configure options or your build
> environment.
>
>


--
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are 
consuming the most bandwidth. Provides multi-vendor support for NetFlow, 
J-Flow, sFlow and other flows. Make informed decisions using capacity planning
reports. http://pubads.g.doubleclick.net/gampad/clk?id=1444514421=/41014381
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Error Director /usr/lib64/libbaccats-7.4.0.so: undefined symbol: mysql_init

2016-01-30 Thread Alex Domoradov 
Could you show output of the following command?

# alternatives --config libbaccats.so

Because there is postgresql activated by default on CentOS6

# alternatives --config libbaccats.soThere are 3 programs which
provide 'libbaccats.so'.  Selection
Command---   1
/usr/lib64/libbaccats-mysql.so   2
/usr/lib64/libbaccats-sqlite3.so*+ 3
/usr/lib64/libbaccats-postgresql.soEnter to keep the current
selection[+], or type selection number:



On Sat, Jan 30, 2016 at 4:16 AM, Phil Stracchino 
wrote:

> On 01/29/16 19:41, Hector Javier Agudelo Corredor wrote:
> > HI team
> >
> >
> > I installed centos 6.7.
> >
> > I have installed bacula 7.4 with postgres  5.7.10 but when I set the
> > mysql password in the file director.
> [...]
>
> > But when I test settings file manager with the command
> >
> > bacula-dir sudo -tc /etc/bacula/bacula-dir.conf
> >
> > get the following error:
> >
> > bacula-dir: symbol lookup error: /usr/lib64/libbaccats-7.4.0.so
> > : undefined symbol: mysql_init
>
>
> Um..   What's wrong with this picture?
>
> Did you mean you installed with *MySQL* 5.7.10?
>
>
> Personally, if I were you, I would not be using MySQL 5.7 yet.  It seems
> to still have some teething issues, some of them serious.  You might try
> backing out to MySQL (or Percona Server) 5.6.28.
>
> That said, as Michael suggested, it looks as though there is something
> wrong (or simply odd) about either your configure options or your build
> environment.
>
>
> --
>   Phil Stracchino
>   Babylon Communications
>   ph...@caerllewys.net
>   p...@co.ordinate.org
>   Landline: 603.293.8485
>
>
> --
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>
--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] Error Director /usr/lib64/libbaccats-7.4.0.so: undefined symbol: mysql_init

2016-01-29 Thread Hector Javier Agudelo Corredor 
HI team


I installed centos 6.7.

I have installed bacula 7.4 with postgres  5.7.10 but when I set the mysql
password in the file director.

Catalog {
  Name = MyCatalog
  dbname = "bacula"; dbuser = "root"; dbpassword = "Bacula2016.,"
}


But when I test settings file manager with the command

bacula-dir sudo -tc /etc/bacula/bacula-dir.conf

get the following error:

bacula-dir: symbol lookup error: /usr/lib64/libbaccats-7.4.0.so: undefined
symbol: mysql_init

previously install the following packages:


gcc gcc-c ++ eadline-devel zlib-devel libacl mtx-devel and openssl-devel
postfix

How I can fix this error? that the director does not connect to the
database.


-- 
HECTOR
--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Error Director /usr/lib64/libbaccats-7.4.0.so: undefined symbol: mysql_init

2016-01-29 Thread Michael Munger 
I’ve seen this issue before. On Debian Wheezy 7.9 x86.

I *think* it is a conflict between x86 and x64 versions of the libs. For some 
reason, when you compile on x86 (am I to assume you are running on x86 too?) 
configure does not fail when it should. It clearly cannot find the binaries it 
needs, so the resulting make file in the src/cat directory has MYSQL_LIBS = 
{nothing} when it should have something like: MYSQL_LIBS = 
-L/usr/lib/i386-linux-gnu -lmysqlclient_r

So, it compiles just fine, but MySQL connectivity is broken.

If you’re on a 64-bit system, however, that blows my theory on why it happens.

However, I *know* one fix is to fix the makefile, and recompile. I’ve done it.

If you’ve installed from RPM, I am not sure how you can fix this issue except 
(perhaps) if you ARE indeed on x86, moving to an x64 OS. (This may be overkill, 
and hopefully someone has a better answer to this).

Although, it was previously commented that “compiling from source is a really 
bad idea” in this case, the fix is simple. Put  MYSQL_LIBS = 
-L/usr/lib/i386-linux-gnu -lmysqlclient_r in the make file under /src/cat.

Since you are installing from RPMs, I hope someone else on this list has the 
fix for you.

Michael Munger, dCAP, MCPS, MCNPS, MBSS
High Powered Help, Inc.
Microsoft Certified Professional
Microsoft Certified Small Business Specialist
Digium Certified Asterisk Professional
mich...@highpoweredhelp.com<mailto:mich...@highpoweredhelp.com>

From: Hector Javier Agudelo Corredor [mailto:hej...@gmail.com]
Sent: Friday, January 29, 2016 7:42 PM
To: bacula-users@lists.sourceforge.net
Subject: [Bacula-users] Error Director /usr/lib64/libbaccats-7.4.0.so: 
undefined symbol: mysql_init

HI team


I installed centos 6.7.

I have installed bacula 7.4 with postgres  5.7.10 but when I set the mysql 
password in the file director.

Catalog {
  Name = MyCatalog
  dbname = "bacula"; dbuser = "root"; dbpassword = "Bacula2016.,"
}


But when I test settings file manager with the command

bacula-dir sudo -tc /etc/bacula/bacula-dir.conf

get the following error:

bacula-dir: symbol lookup error: 
/usr/lib64/libbaccats-7.4.0.so<http://libbaccats-7.4.0.so>: undefined symbol: 
mysql_init

previously install the following packages:


gcc gcc-c ++ eadline-devel zlib-devel libacl mtx-devel and openssl-devel postfix

How I can fix this error? that the director does not connect to the database.


--
HECTOR
--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Error Director /usr/lib64/libbaccats-7.4.0.so: undefined symbol: mysql_init

2016-01-29 Thread Phil Stracchino 
On 01/29/16 19:41, Hector Javier Agudelo Corredor wrote:
> HI team
> 
> 
> I installed centos 6.7.
> 
> I have installed bacula 7.4 with postgres  5.7.10 but when I set the
> mysql password in the file director.
[...]

> But when I test settings file manager with the command
> 
> bacula-dir sudo -tc /etc/bacula/bacula-dir.conf
> 
> get the following error:
> 
> bacula-dir: symbol lookup error: /usr/lib64/libbaccats-7.4.0.so
> : undefined symbol: mysql_init


Um..   What's wrong with this picture?

Did you mean you installed with *MySQL* 5.7.10?


Personally, if I were you, I would not be using MySQL 5.7 yet.  It seems
to still have some teething issues, some of them serious.  You might try
backing out to MySQL (or Percona Server) 5.6.28.

That said, as Michael suggested, it looks as though there is something
wrong (or simply odd) about either your configure options or your build
environment.


-- 
  Phil Stracchino
  Babylon Communications
  ph...@caerllewys.net
  p...@co.ordinate.org
  Landline: 603.293.8485

--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users