Lamp Mariadb install error

Current Development version likely to have breaking changes
DVB Hardware
Posts: 201
Joined: Thu Jan 01, 2015 5:12 pm
Location: Rhode Island

Lamp Mariadb install error

Post by DVB Hardware »

I was having this problem
viewtopic.php?f=44&t=31306

I could not resolve (beyond my skills)
I wiped the pc and installed Linux Mint 20.2 again to be fresh
I've installed ZM many times before

I'm using https://wiki.zoneminder.com/Ubuntu_Serv ... der_1.36.x BUT FOR MASTER

The problem is with LAMP
After entering mysql_secure_installation
Prompted to enter (return) because of new install (no password established yet)
ERROR:
error 2002 (hy000): can't connect to local mysql server through socket '/var/run/mysqld/mysqld.sock' (2)

Is there something missing in the install steps ??
3 days of searching and trying...I give up
Linux Mint 21 Cinnamon Mariadb 10.6.x using Master 1.37.x latest always

DVB stands for Digital VIdeo Broadcasting , retired satellite downlink supplier
Magic919
Posts: 1381
Joined: Wed Sep 18, 2013 6:56 am

Re: Lamp Mariadb install error

Post by Magic919 »

Just sounds like the DB is not running.
-
DVB Hardware
Posts: 201
Joined: Thu Jan 01, 2015 5:12 pm
Location: Rhode Island

Re: Lamp Mariadb install error

Post by DVB Hardware »

You know I was saying the same thing, but I cannot find my old zm wiki bash scripts.
I'm trying to make sure the server is for zm with its install commands.
Linux Mint 20.2 Cin
Linux Mint 21 Cinnamon Mariadb 10.6.x using Master 1.37.x latest always

DVB stands for Digital VIdeo Broadcasting , retired satellite downlink supplier
User avatar
kitkat
Posts: 193
Joined: Sun Jan 27, 2019 5:17 pm

Re: Lamp Mariadb install error

Post by kitkat »

It's not simply a case of

Code: Select all

service mariadb start
or

Code: Select all

systemctl start mariadb
is it?
DVB Hardware
Posts: 201
Joined: Thu Jan 01, 2015 5:12 pm
Location: Rhode Island

Re: Lamp Mariadb install error

Post by DVB Hardware »

Needs to start and always start on OS boot
Linux Mint 21 Cinnamon Mariadb 10.6.x using Master 1.37.x latest always

DVB stands for Digital VIdeo Broadcasting , retired satellite downlink supplier
DVB Hardware
Posts: 201
Joined: Thu Jan 01, 2015 5:12 pm
Location: Rhode Island

Re: Lamp Mariadb install error

Post by DVB Hardware »

I suspect it is my pc a P5Q with a Q6600 processor
I installed on my DV6 laptop no problem
Picking up newer retired PC today, I will swap out the hard drive to rule out the drive
Maybe there are instructions in MariaDB too new for the old processor /mb
Linux Mint 21 Cinnamon Mariadb 10.6.x using Master 1.37.x latest always

DVB stands for Digital VIdeo Broadcasting , retired satellite downlink supplier
Magic919
Posts: 1381
Joined: Wed Sep 18, 2013 6:56 am

Re: Lamp Mariadb install error

Post by Magic919 »

I'd be amazed if the hardware was a factor here.
-
User avatar
kitkat
Posts: 193
Joined: Sun Jan 27, 2019 5:17 pm

Re: Lamp Mariadb install error

Post by kitkat »

DVB Hardware wrote: Sun Nov 21, 2021 2:54 am Is there something missing in the install steps ??
Possibly.

They don't specifically mention enabling the database to start at boot, and it's possible that the installer doesn't do that. (They do mention it for ZM itself so it may even be normal to not auto-start or enable a service at installation time.)

I would probably expect

Code: Select all

systemctl enable mariadb
to work, or perhaps

Code: Select all

chkconfig mariadb on
DVB Hardware
Posts: 201
Joined: Thu Jan 01, 2015 5:12 pm
Location: Rhode Island

Re: Lamp Mariadb install error

Post by DVB Hardware »

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 - 32M

I don't know if it is still needed, see my server config pic for current software versions
Still need to install zm

zm_server.jpg
zm_server.jpg (132.91 KiB) Viewed 38467 times
Linux Mint 21 Cinnamon Mariadb 10.6.x using Master 1.37.x latest always

DVB stands for Digital VIdeo Broadcasting , retired satellite downlink supplier
Magic919
Posts: 1381
Joined: Wed Sep 18, 2013 6:56 am

Re: Lamp Mariadb install error

Post by Magic919 »

Leave them out and crack on with ZM.
-
DVB Hardware
Posts: 201
Joined: Thu Jan 01, 2015 5:12 pm
Location: Rhode Island

Re: Lamp Mariadb install error

Post by DVB Hardware »

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
Linux Mint 21 Cinnamon Mariadb 10.6.x using Master 1.37.x latest always

DVB stands for Digital VIdeo Broadcasting , retired satellite downlink supplier
Magic919
Posts: 1381
Joined: Wed Sep 18, 2013 6:56 am

Re: Lamp Mariadb install error

Post by Magic919 »

Take it up with the person that edits the wiki page. Looks like bbunge.
-
DVB Hardware
Posts: 201
Joined: Thu Jan 01, 2015 5:12 pm
Location: Rhode Island

Re: Lamp Mariadb install error

Post by DVB Hardware »

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
Linux Mint 21 Cinnamon Mariadb 10.6.x using Master 1.37.x latest always

DVB stands for Digital VIdeo Broadcasting , retired satellite downlink supplier
Magic919
Posts: 1381
Joined: Wed Sep 18, 2013 6:56 am

Re: Lamp Mariadb install error

Post by Magic919 »

You need to look at the history tab along the top.
-
User avatar
kitkat
Posts: 193
Joined: Sun Jan 27, 2019 5:17 pm

Re: Lamp Mariadb install error

Post by kitkat »

DVB Hardware wrote: Thu Nov 25, 2021 2:51 pm 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 - 32M
You may need to delete the old log files after changing innodb_log_file_size.

Check the mariadb log for errors along the lines of

Code: Select all

InnoDB: Error: log file ./ib_logfile0 is of different size 0 123456789  bytes
InnoDB: than specified in the .cnf file 0 987654321 bytes!
(And indeed for errors generally!)

On CentOS the way that works for me is to shut down mariadb and make sure it does so cleanly; delete (or move or rename if you prefer) /var/lib/mysql/ib_logfile0 and /var/lib/mysql/ib_logfile1; restart mariadb and wait for it to recreate the files.

You may have to do something after changing innodb_buffer_pool_size as well, but I'm not entirely sure about that one.


e2a: There seems to be a space in innodb_buffer_pool_ size and if that's a copy/paste from the .cnf then it'll probably be throwing an error when it loads.
Post Reply