Dan,

There seems to be a problem with the 5.2 script that gives permission to regress --- see my comments below ...

On 01/18/2016 09:00 PM, Dan Langille wrote:
On Jan 18, 2016, at 1:07 AM, Kern Sibbald <k...@sibbald.com <mailto:k...@sibbald.com>> wrote:


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello Dan,

Well, it seems that user "regress" has no privileges on the database.

But the scripts have just applied all the permissions and created the tables... surely it's been configured correctly. See way below in this email where I connect from the command line via mysql.

I'm happy to drop regression testing for 5.2.

Here, my regression scripts run fine.

Are you running regression tests for both 5.2 and 7.4?

I think it would be good to have your results up on http://regress.bacula.org so it's not just me and Frank.

I have 7 FreeBSD jails, one for each database version (MySQL 55, 56 & PostgreSQL 90-94).

In each jail, I run regression for both the 5.2 and the 7.4 branch. Each test uses the same database but runs from a different directory (i.e. a distinct git clone).

The 5.2 and 7.4 tests do not run concurrently.

5.2 is failing to connect.

7.4 succeeds.

each regress/bin/bacula-dir.conf contains the same Catalog entry:

# Generic catalog service
Catalog {
  Name = MyCatalog
  dbname = regress; user = regress; password = ""
}




Best regards,
Kern

On 01/18/2016 02:35 AM, Dan Langille wrote:
>> On Jan 15, 2016, at 11:37 AM, Kern Sibbald <k...@sibbald.com <mailto:k...@sibbald.com>> wrote: >> >> Well Clang seems to be creating some problems, and unfortunately, I have >> no idea what it will do with version 5.2.13 -- I recommend using GNU C >> for that. >> >> For Branch-7.4, I believe all the Clang complaints have been corrected. >> I do not run Clang, so cannot say for sure. If there are problems such >> as the dlink m_link problem, I recommend using GNU C. We know it works >> and we know it generates good code, so you could save yourself a lot of >> trouble. >> >> If you must use Clang, OK no problem, but please see if you can find/fix >> the problem. If I have good patches that I understand, I will be happy >> to apply them. I worked with Martin going back and forth until I think >> he is satisfied with how Bacula compiles with Clang. > > I think this patch helps. It compiles with both gcc and with clang. > > See also https://gist.github.com/dlangille/80596c7fa0a5cddaea0d for full details. > > $ cat ~/bin/patch-bacula-configure > --- bacula/configure.orig 2016-01-18 00:21:42.985405000 +0100 > +++ bacula/configure 2016-01-18 00:22:41.081491000 +0100 > @@ -10997,7 +10997,7 @@ > hardcode_shlibpath_var=no > ;; > > - freebsd1*) > + freebsd1.*) > ld_shlibs=no > ;; > > @@ -11991,7 +11991,7 @@ > shlibpath_var=LD_LIBRARY_PATH > ;; > > -freebsd1*) > +freebsd1.*) > dynamic_linker=no > ;; > > @@ -15824,7 +15824,7 @@ > shlibpath_var=LD_LIBRARY_PATH > ;; > > -freebsd1*) > +freebsd1.*) > dynamic_linker=no > ;; > > > > But then I encounter this issue: > > Creating mysql database > ERROR 1007 (HY000) at line 1: Can't create database 'regress'; database exists > Creation of regress database succeeded. > Deletion of regress MySQL tables succeeded. > Dropped mysql tables > Making mysql tables > Creation of Bacula MySQL tables succeeded. > Granting mysql privileges > Host User Password Select_priv Insert_priv Update_priv Delete_priv Create_priv Drop_priv Reload_priv Shutdown_priv Process_priv File_priv Grant_priv References_priv Index_priv Alter_priv Show_db_priv Super_priv Create_tmp_table_priv Lock_tables_priv Execute_priv Repl_slave_priv Repl_client_priv Create_view_priv Show_view_priv Create_routine_priv Alter_routine_priv Create_user_priv Event_priv Trigger_priv Create_tablespace_priv ssl_type ssl_cipher x509_issuer x509_subject max_questions max_updates max_connections max_user_connections > localhost root Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y 0 > mysql55.unixathome.org <http://mysql55.unixathome.org> <http://mysql55.unixathome.org> root Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y 0 > 127.0.0.1 root Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y 0 > localhost N N N N N N N N N N N N N N N N N N N 0 > mysql55.unixathome.org <http://mysql55.unixathome.org> <http://mysql55.unixathome.org> N N N N N N N N N N N N N N N N N N 0 > localhost regress N N N N N N N N N N N N N N N N N N N 0 > % regress N N N N N N N N N N N N N N N N N N N N 0

The above implies that  "regress"  has no permissions on the database.

Best regards,
Kern

> localhost nagios N N N N N N N N N N N N N N N N N N N 0 > Privileges for user regress granted on database regress. > Starting the Bacula Storage daemon > Starting the Bacula File daemon > Starting the Bacula Director daemon > bacula-dir: dird.c:1015-0 Could not open Catalog "MyCatalog", database "regress". > 18-Jan 01:29 bacula-dir ERROR TERMINATION > Please correct configuration file: /usr/home/dan/src/BaculaRegressionTesting-TRUNK/regress/bin/bacula-dir.conf > Stopping the Bacula File daemon > Stopping the Bacula Storage daemon > Stopping the Bacula Director daemon > > > I have checked that I can connect: > > [dan@mysql55:~] $ mysql -u regress regress > Reading table information for completion of table and column names > You can turn off this feature to get a quicker startup with -A > > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 3898 > Server version: 5.5.46 Source distribution > > Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved. > > Oracle is a registered trademark of Oracle Corporation and/or its > affiliates. Other names may be trademarks of their respective > owners. > > Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. > > mysql> show databases; > +--------------------+ > | Database | > +--------------------+ > | information_schema | > | regress | > | test | > +--------------------+ > 3 rows in set (0.00 sec) > > mysql> show tables; > +-------------------+ > | Tables_in_regress | > +-------------------+ > | BaseFiles | > | CDImages | > | Client | > | Counters | > | Device | > | File | > | FileSet | > | Filename | > | Job | > | JobHisto | > | JobMedia | > | Location | > | LocationLog | > | Log | > | Media | > | MediaType | > | Path | > | PathHierarchy | > | PathVisibility | > | Pool | > | RestoreObject | > | Snapshot | > | Status | > | Storage | > | UnsavedFiles | > | Version | > +-------------------+ > 26 rows in set (0.01 sec) > > mysql> > > > And from the command line: > > [dan@mysql55:~/src/BaculaRegressionTesting-TRUNK/regress/bin] $ ./bacula-dir -f -c ./bacula-dir.conf -d 200 > bacula-dir: dird.c:223-0 Debug level = 200 > bacula-dir: runscript.c:296-0 runscript: debug > bacula-dir: runscript.c:297-0 --> RunScript > bacula-dir: runscript.c:298-0 --> Command=/usr/home/dan/src/BaculaRegressionTesting-TRUNK/regress/bin/make_catalog_backup.pl MyCatalog > bacula-dir: runscript.c:299-0 --> Target= > bacula-dir: runscript.c:300-0 --> RunOnSuccess=1 > bacula-dir: runscript.c:301-0 --> RunOnFailure=0 > bacula-dir: runscript.c:302-0 --> FailJobOnError=1 > bacula-dir: runscript.c:303-0 --> RunWhen=2 > bacula-dir: runscript.c:296-0 runscript: debug > bacula-dir: runscript.c:297-0 --> RunScript > bacula-dir: runscript.c:298-0 --> Command=/usr/home/dan/src/BaculaRegressionTesting-TRUNK/regress/bin/delete_catalog_backup > bacula-dir: runscript.c:299-0 --> Target= > bacula-dir: runscript.c:300-0 --> RunOnSuccess=1 > bacula-dir: runscript.c:301-0 --> RunOnFailure=0 > bacula-dir: runscript.c:302-0 --> FailJobOnError=1 > bacula-dir: runscript.c:303-0 --> RunWhen=1 > bacula-dir: bsys.c:556-0 Could not open state file. sfd=-1 size=192: ERR=No such file or directory > bacula-dir: dir_plugins.c:160-0 Load dir plugins > bacula-dir: dir_plugins.c:162-0 No dir plugin dir! > bacula-dir: dird.c:1015-0 Could not open Catalog "MyCatalog", database "regress". > 18-Jan 01:22 bacula-dir ERROR TERMINATION > Please correct configuration file: ./bacula-dir.conf > > >> >> Best regards, >> Kern >> >> On 01/15/2016 04:49 PM, Dan Langille wrote: >>>> On Jan 15, 2016, at 7:42 AM, Heitor Faria <hei...@bacula.com.br <mailto:hei...@bacula.com.br>> wrote: >>>> >>>> Hello Dan, >>>> >>>>> All regression testing is failing on my nodes: >>>>> >>>>> >>>>> ==>Entering directory >>>>> /usr/home/dan/src/BaculaRegressionTesting-TRUNK/regress/build/src/plugins/fd >>>>> /usr/home/dan/src/BaculaRegressionTesting-TRUNK/regress/build/libtool --silent >>>>> --tag=CXX --mode=compile /usr/bin/c++ -g -O2 -Wall -I../.. -I../../filed -c >>>>> bpipe-fd.c >>>>> c++: warning: treating 'c' input as 'c++' when in C++ mode, this behavior is >>>>> deprecated >>>>> In file included from bpipe-fd.c:34: >>>>> In file included from ../../bacula.h:175: >>>>> In file included from ../../lib/lib.h:40: >>>>> ../../lib/dlist.h:207:10: warning: private field 'm_link' is not used >>>>> [-Wunused-private-field] >>>>> dlink m_link; >>>>> ^ >>>>> 1 warning generated. >>>> What version are you using? According to Kern this was a false warning. >>>> Anyway there is a closed bug report filled by Martin: http://sourceforge.net/p/bacula/mailman/message/32687776/ >>>> It resulted in a patch to Bacula 7.0.6. >>> >>> These are building Bacula 5.2.13 >>> >>> I also run regression tests on 7.x but they seem OK over the past 24 hours. >>> ------------------------------------------------------------------------------ >>> 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&iu=/4140 >>> _______________________________________________ >>> Bacula-devel mailing list >>> Bacula-devel@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/bacula-devel >>> >> >> > > > > ------------------------------------------------------------------------------ > 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&iu=/4140 > > > _______________________________________________ > Bacula-devel mailing list > Bacula-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-devel

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iEYEARECAAYFAlacgTIACgkQNgfoSvWqwEhuwgCfdSbq3fYsqjmtGfAv8cDDrQ5n
ZoIAoLiLA4ffSDCKxNHLxI/FSdUfRKqB
=+j89
-----END PGP SIGNATURE-----

------------------------------------------------------------------------------
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&iu=/4140_______________________________________________
Bacula-devel mailing list
Bacula-devel@lists.sourceforge.net <mailto:Bacula-devel@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/bacula-devel


------------------------------------------------------------------------------
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&iu=/4140
_______________________________________________
Bacula-devel mailing list
Bacula-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-devel

Reply via email to