Re: [Bacula-users] [Non-DoD Source] Re: database upgrade problem

2017-09-03 Thread Kern Sibbald
Sorry, I see that Phil has answered this in detail. On 09/03/2017 09:03 AM, Kern Sibbald wrote: For both of you with this issue: it is not possible to respond correctly if you do not provide the following information:  1. What databa

Re: [Bacula-users] [Non-DoD Source] Re: database upgrade problem

2017-09-03 Thread Kern Sibbald
For both of you with this issue: it is not possible to respond correctly if you do not provide the following information:  1. What database server are you using (MySQL, MariaDB, PostgreSQL)?  2. What version of that database server are you using?  3. Have you modified any

Re: [Bacula-users] [Non-DoD Source] Re: database upgrade problem

2017-09-01 Thread Phil Stracchino
On 09/01/17 21:50, Jerry Lowry wrote: > > Okay, on the one system that I upgraded to 9.0.3 I also upgraded the > database engine to mariadb 12.2.8.  Was still getting the error.  I then > went back to the July email and saw that they removed the > |STRICT_TRANS_TABLES| >

Re: [Bacula-users] [Non-DoD Source] Re: database upgrade problem

2017-09-01 Thread Jerry Lowry
Okay, on the one system that I upgraded to 9.0.3 I also upgraded the database engine to mariadb 12.2.8. Was still getting the error. I then went back to the July email and saw that they removed the STRICT_TRANS_TABLES

Re: [Bacula-users] [Non-DoD Source] Re: database upgrade problem

2017-09-01 Thread Phil Stracchino
On 09/01/17 17:28, Davide Franco wrote: > Do you use MySQL or MariaDb ? > > It is something related to default value for datetime fields. > > MariaDb does not accept 0 or Null ( I don't remember). You need the > check previous thread in this mailing list. This is correct, it is not a MariaDB vs

Re: [Bacula-users] [Non-DoD Source] Re: database upgrade problem

2017-09-01 Thread Davide Franco
Do you use MySQL or MariaDb ? It is something related to default value for datetime fields. MariaDb does not accept 0 or Null ( I don't remember). You need the check previous thread in this mailing list. To fix the problem you need to update the database schema manually, or find someone who prod

Re: [Bacula-users] [Non-DoD Source] Re: database upgrade problem

2017-09-01 Thread Hicks, Daniel CTR OSD DMEA
Davide, I am having this same issue. Can you clarify how to make sure the catalog upgrade is done. I did the update to tables without error but am not sure it is the same. Thank you Dan Hicks | 916-999-2711 From: Davide Franco [mailto:bacula-...@dflc.ch] Sent: Friday, September 1, 2017 12:11