How to combine fossapup + webcam + motn detect +vrec?

[peppyy]

Created and added the debian.cnf Do I need to put my mysqld password in that file?

Removed the contents of var/lib/mysql.
Started setup again. Went well until the same spot. user mysql was already in use

root# passwd mysql
passwd: /etc/shadow: bad record
passwd: /etc/shadow: bad record
passwd: /etc/shadow: bad record
Changing password for mysql
New password:
Retype password:
passwd: password for mysql changed by root
root# chown -R mysql /var/run/mysqld
root# chown -R mysql /var/log/mysql
root# mysqld --initialize-insecure --user=mysql
root# mysqld &
[1] 14531
root# mysqld -u root &
[2] 14834
[1] Exit 1 mysqld

Still no socket when it is running.

[peppyy]

@rockedge Had a thought. Is there something installed here that I don't need?

[rockedge]

remove the zabbix-server-mysql and default-mysql-client_1.0.5ubuntu

You will not need to add the user mysql again, it is already set.
Then again delete the contents of /var/lib/mysql and re-initialize the mysql server. Once it is initialized use

Code: Select all

mysql -u root & 

to start the server

then try:

Code: Select all

mysql -u root -p

and report what happens. I don't really know why this is not working for you.

[peppyy]

root# mysql -u root &
[1] 6109
root# ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Is the socket not being created? there is nothing in that folder.

[rockedge]

what are the permissions of /var/run/mysqld ?

try

Code: Select all

chown -R mysql:root /var/run/mysqld

then try mysql -u root &

[peppyy]

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I have been getting this from the start.

The log is shorter after chown -R mysql:root /var/run/mysqld and stop / start.

2021-07-11T11:06:42.410162Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2021-07-11T11:06:42.410203Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2021-07-11T11:06:42.411714Z 0 [Warning] [MY-010101] [Server] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory.
2021-07-11T11:06:42.411788Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25-0ubuntu0.20.04.1) starting as process 24951
2021-07-11T11:06:42.420985Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2021-07-11T11:06:42.421191Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2021-07-11T11:06:42.421294Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-07-11T11:06:42.421764Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.25-0ubuntu0.20.04.1) (Ubuntu).

Could the problem be with the mariaDB config? since it says " [ERROR] [MY-011011] [Server] Failed to find valid data directory."

I have checked several times and as far as I can tell it never created the .pid file either, /var/run/mysqld/mysqld.pid .

[peppyy]

@rockedge The camera has died and long story short, it may be a while before I can afford a replacement. eBay buyers beware! Make sure if you want a warranty you buy from a reputable seller.

We now have Bees and no way to monitor them from a distance, however we have made it a choice to visit them several times a day. Sometimes the old ways are better in the long run

Thanks for all the help... Sincerely!

[rockedge]

Oh what a bummer! I will keep an eye out for a good priced and reliable net cam and give you a head's up when one comes across that meets the requirements.

I will help when you are ready again. I am quite interested in getting your setup going....I love honey and bees are cool.

[peppyy]

@rockedge Been looking at Amcrest and SV3C along with a couple others. I am thinking that almost any onvif camera will work.
https://www.amazon.com/SV3C-Security-F ... B08R9RD6W8 This one caught my eye, good reviews and even mentions ZM.
I will buy one from an authorized dealer this time though.

[peppyy]

@rockedge Got the new camera (mentioned above) and it works well. You can control it from the browser interface and it streams well to MPV.
These cameras unfortunately use the now retired flash browser plugin however there are workarounds.
Now to give it a protected space out by the hives and try it on PoE.

[rockedge]

so as far as Zoneminder goes it's the problem installing and running the mysql server that is holding that part of it up as far as I can tell.

Looks like you are making progress and once the cam are up and running we could possibly try ZM and that pesky mysql server again.

[peppyy]

@rockedge I have seen that there are a lot of posts in the past about setting up mysql on certain platforms. I really am starting to think that Fossa 64 just doesn't like it That being said I am getting along really well with a simple script for MPV and having a lot of controls available through the web interface.

There is a lot of proprietary software out there that I could use, (If it wasn't Linux) however I refuse to go back

I may search a few more for solutions when I am not so busy outside. (Have to make hay when the sun shines).