Hello, Kern, Another Ubuntu 16 issue is running the make_mysql_tables results in error:
ERROR 1067 (42000) at line 91: Invalid default value for 'CleaningDate' ERROR 1067 (42000) at line 111: Invalid default value for 'SchedTime' ERROR 1067 (42000) at line 145: Invalid default value for 'SchedTime' ERROR 1067 (42000) at line 187: Invalid default value for 'Date' ERROR 1067 (42000) at line 201: Invalid default value for 'CreateTime' ERROR 1067 (42000) at line 225: Invalid default value for 'FirstWritten' ERROR 1067 (42000) at line 321: Invalid default value for 'Time' The workaround for this is: sed -i s/'DATETIME DEFAULT 0'/'DATETIME'/g /etc/bacula/scripts/make_mysql_tables I wasn't able to reproduce it in any Debian yet. If it is needed I'll be glad to open a bug report. Regards, ----- Original Message ----- > From: "Kern Sibbald" <k...@sibbald.com> > To: bacula-users@lists.sourceforge.net, "bacula-devel" > <bacula-de...@lists.sourceforge.net> > Sent: Wednesday, June 15, 2016 4:51:18 AM > Subject: Re: [Bacula-devel] [Bacula-users] Error Director > /usr/lib64/libbaccats-7.4.0.so: undefined symbol: mysql_init > 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 <bacula> > - run your ./configure > - cd <bacula>/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 <bacula> > - 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 >>> <http://libbaccats-7.4.0.so>: undefined symbol: mysql_init >> >> Ummmmm...... 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&iu=/41014381 > _______________________________________________ > Bacula-devel mailing list > bacula-de...@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-devel -- ======================================================================= Heitor Medrado de Faria | Bacula do Brasil Próximas aulas telepresencial ao-vivo - 02 de maio: http://www.bacula.com.br/agenda/ Ministro treinamento e implementação in-company Bacula: http://www.bacula.com.br/in-company/ 61 8268-4220 Site: www.bacula.com.br ======================================================================== ------------------------------------------------------------------------------ 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&iu=/41014381 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
