On 11/17/15 11:18 PM, Christopher Lamitie wrote: > Update #2. > > It was the Quota table creation statement. The mysql.sql script has: > > CREATE TABLE Quota ( > ClientId INT UNSIGNED DEFAULT NULL, > GraceTime BIGINT DEFAULT 0, > QuotaLimit BIGINT UNSIGNED DEFAULT 0, > PRIMARY KEY (ClientId) > ); > > But in the version of MySQL I'm running, it doesn't like null primary keys so > I changed the default value to 0 and now the make_bareos_tables script runs > without complaint. > It seems Oracle really made a mess of things this time by changing the default behavior of MySQL in 5.7 which mostly renders a lot of applications useless. I wouldn't be surprised you will run into much more subtle problems even when you now can create a database now.
When searching for the problem with DATETIME DEFAULT 0 you find that in 5.7 they changed the so called default session parameters of a database session to some strange strict value that makes a lot of stuff all of a sudden not acceptable anymore. It even seems they changed things multiple times in the 5.7 series so its now such an enormous mess that most people just disable the strict session settings to be able to use it (That really shows what a great Job they have done if people have to disable your great new settings.) Your change to the Quota table might work but I would propose the following change: ClientId INTEGER DEFAULT 0 REFERENCES Client, Which is the same as used in the NDMPLevelMap. On a closing note, from a performance standpoint PostgreSQL always won hands down so I wonder if MySQL will ever catchup and is also not a database we do a lot of performance tuning for. So for bigger installs we always advice to use PostgreSQL in combination with Bareos. -- Marco van Wieringen [email protected] Bareos GmbH & Co. KG Phone: +49-221-63069389 http://www.bareos.com Sitz der Gesellschaft: Köln | Amtsgericht Köln: HRA 29646 Komplementär: Bareos Verwaltungs-GmbH Geschäftsführer: Stephan Dühr, M. Außendorf, J. Steffens, P. Storz, M. v. Wieringen -- You received this message because you are subscribed to the Google Groups "bareos-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. For more options, visit https://groups.google.com/d/optout.
