ZoneMinder Forums

Magic919 wrote: ↑Fri Dec 03, 2021 4:47 pm MariaDB 10.3.31.

Ok so 10.3.31 works with innodb mod
10.6.5 does not

I have a few spare drives will try 10.3.31 or what ever the repository will give me

Version mariadb ? im on 10.6.5

Your logs show it is using the default of 128MB 2021-12-01 15:54:21 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 I'm not sure why you'd want to change it. I was just following this https://wiki.zoneminder.com/Ubuntu_Server_or_Desktop_Zoneminder_1.36.x I ...

Well I think I had enough beating a dead horse on this. I spent days researching Innodb beyond my skills to reason why the settings are there I have a xampp install for Point of sale testing, same mariadb version on win 10 I used the Innodb settings from xampp in linux and it worked I also increased...

I tried to set "log_error = /home/ljimmy/desktop/error.log" so I don't have to dig for it ( no good) won't write to it. enabled it at log_error = /var/log/mysql/error.log 2021-12-01 15:54:21 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-12-01 15:54:21 0 [Note] InnoDB: Number of p...

Maybe paste your entire my.cnf here so we can see what it looks like, with the edits and without. There is no my.cnf, well there is but empty, Mariadb uses 50-server.cnf Inno is commented out with #, this is a clean install ---------------------------------------------------------------------------...

I was logged in as root

I also did a filesystem search for mariadb.log, nothing

In the order of your code execute grep -i error /var/log/mariadb/mariadb.log | tail root@POS-SERVER:/home/jimmy# grep -i error /var/log/mariadb/mariadb.log | tail grep: /var/log/mariadb/mariadb.log: No such file or directory ---------------------------------------------------------------------------...

Any problems when you changed the size of the InnoDB logfile? I tried 1/2 the values no go innodb_buffer_pool_size and innodb_log_file_size have default values if not set acorfing to mariadb so I entered those values and it still tanked. wish I wrote them down. If I comment out the innodb all boots...

The guide contains another error that's probably preventing the database from starting... innodb_log_file_size - 32M should be innodb_log_file_size = 32M (equals instead of minus) You have hawk eyes, good find !!! I will try it now ALSO an extra space innodb_buffer_pool_ size = 256M innodb_buffer_p...

Magic919 wrote: ↑Sat Nov 27, 2021 7:24 am Take it up with the person that edits the wiki page. Looks like bbunge.

Thanks, I could not find any reference on that wiki page of the author

Thats the easy way out, If the bash script is in error based on using mariadb 10.3 it needs t be corrected before ZM gets "bashed" by people, youtube, FB, forums etc.
I don't want to see that happen

Jimmy

As I said, there is a javascript error. I can tell because various javascript libraries have not styled the widget correctly. Right click, inspect element, choose console tab... see what there is.. I tried to look but did not know what I was lookin for I solved it by wiping the PC starting fresh fo...

I think I solved this When I install the above lamp in the wiki it server mariadb 10.3 works fine BUT when I edit below it crashes sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf Add the following in the [mysql] area: innodb_file_per_table = ON innodb_buffer_pool_ size = 256M innodb_log_file_size ...