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

[rockedge]

SeverName is misspelled! It should be ServerName = localhost

You only need the 00_default.conf for now!

[peppyy]

I looked at that so many times, Can't believe I needed somehow to sever my server
Now we are looking better.

[rockedge]

Excellent.....examine the phpinfo list of modules. Go to /etc/php/7.4
It may look similar to this:

Screenshot(24).png (11.61 KiB) Viewed 1037 times

open /etc/php/7.4/mods-available, mine looks like this:

Screenshot(25).png (31.54 KiB) Viewed 1036 times

the trick is to symlink these php modules in /etc/php/7.4/apache2/conf.d

Screenshot(27).png (10.72 KiB) Viewed 1035 times

mine looks like this:

Screenshot(28).png (31.74 KiB) Viewed 1035 times

in a terminal:

Code: Select all

apache2ctl restart

Now run http://localhost/info.php again, scroll through it and see if the modules you added are present.

[rockedge]

If you do not have the .ini files I will compress the ones I have a let you download.
You will also need a php.ini file. I can include a sample. It will be placed in /etc/php/7.4/apache2/php.ini

[peppyy]

I only have 2 in the available folder.

[rockedge]

Here is a collection of php module ini's and a php.ini
Important make sure to open the php.ini and go to the Date section and add your correct timezone!

fossa_php_ini+ini.tar.gz

(26.36 KiB) Downloaded 32 times

Extract and place in /etc/php/7.4/mods-available then symlink and place the php.ini in it's spot.

restart apache

Code: Select all

apache2ctl restart

[peppyy]

Where do I find the php.ini ? Edit Found it.

[rockedge]

Looks good so far. Now for the MySQL.....open the PPM and search for mysql-server and install it

[peppyy]

Done. 116MB with deps.

[rockedge]

add a directory : /var/run/mysqld
add a directory : /var/log/mysql
For some reasons Installing in Puppy doesn't complete the installation all the way and we need to do some manually. This is out of experience
create a user:

Code: Select all

adduser mysql

this may be needed later. for now the next step is to initialize mysql in a terminal with :

mysqld --initialize-insecure --user=mysql

we will add the security in the next steps.

more info: https://dev.mysql.com/doc/mysql-linuxun ... ation.html

[peppyy]

Couldn't type a password

root# adduser mysql
passwd: /etc/shadow: bad record
passwd: /etc/shadow: bad record
passwd: /etc/shadow: bad record
Changing password for mysql
New password:

root# adduser mysql
adduser: user 'mysql' in use
root#

and
root# mysqld --initialize-insecure --user=mysql
2021-06-25T12:49:56.925684Z 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-06-25T12:49:56.925761Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.25-0ubuntu0.20.04.1) initializing of server in progress as process 18788
2021-06-25T12:49:56.929484Z 0 [ERROR] [MY-010187] [Server] Could not open file '/var/log/mysql/error.log' for error logging: Permission denied
2021-06-25T12:49:56.929535Z 0 [ERROR] [MY-013455] [Server] The newly created data directory /var/lib/mysql/ by --initialize is unusable. You can remove it.
2021-06-25T12:49:56.929544Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-06-25T12:49:56.929654Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.25-0ubuntu0.20.04.1) (Ubuntu).

[rockedge]

You will not see any text when typing the password and the cursor does not move!! enter the password press enter and confirm password.
now do this:

passwd mysql

and type the password you want. remember nothing will move or appear.

I ran into this as well when I started with Fossapup64, it was easier with mariaDB on Bionic64 but this did not work correctly on Fossapup64. As long as the user "mysql" exists we should be okay.

Delete /var/lib/mysql/

forgot to change the permissions. In a terminal:

Code: Select all

chown -R mysql /var/run/mysqld
chown -R mysql /var/log/mysql

and try again:

Code: Select all

mysqld --initialize-insecure --user=mysql

I fit is successful in a terminal:

Code: Select all

mysqld &

On my system I use root so I need to add a -u switch

Code: Select all

mysqld -u root &

if that looks good open a terminal:

Code: Select all

mysql_secure_connection

I have had success with this method also:

Code: Select all

mysqladmin -u root password NEWPASSWORD

There are other ways to set the root password on the mysql server if this fails. Plus there are some MySQL pages that have information on how to initialize and set the root password.
Our goal is this:

Screenshot(30).png (30.85 KiB) Viewed 1031 times

[peppyy]

Got the pass set then.

root# chown -R mysql /var/run/mysqld
root# chown -R mysql /var/log/mysql
root# mysqld --initialize-insecure --user=mysql
root# mysqld &
[1] 30731
root# mysqld: Error on realpath() on '/var/lib/mysql-files' (Error 2 - No such file or directory)
mysqld -u root &
[2] 31724
[1] Exit 1 mysqld
root# mysqld: Error on realpath() on '/var/lib/mysql-files' (Error 2 - No such file or directory)

Created the directory and got to.

root# mysql_secure_connection
bash: mysql_secure_connection: command not found
[2]+ Exit 1 mysqld -u root

[rockedge]

Look with Htop to see if mysqld is running. then
Try out in a terminal:

Code: Select all

mysqladmin -u root password NEWPASSWORD

This command will only work if mysqld is up and running

[peppyy]

Didn't see mysql in htop. Started it and ran pfile on system for mysqld.sock.
File not found. See empty folder.

msqsl2.jpg (49.09 KiB) Viewed 1016 times

Tried root# mysqladmin -u root password NEWPASSWORD
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

I have a password set as far as I can tell.

[peppyy]

After my morning boot I was noticing a lot of network traffic so I started htop and found this.

htop-apache2-49.jpg (130.73 KiB) Viewed 1014 times

There are 49 instances, is this normal?

[rockedge]

Yes it is. Mysql wil also show many threads. Make sure you have created /var/run/mysqld then try to set the password again

[peppyy]

I created the folder /var/run/mysqld
I did find an error log if that helps.

[Mon Jun 28 06:07:26.216200 2021] [http2:warn] [pid 5679] AH10034: The mpm module (prefork.c) is not supported by mod_http2. The mpm determines how things are processed in your server. HTTP/2 has more demands in this regard and the currently selected mpm will just not do. This is an advisory warning. Your server will continue to work, but the HTTP/2 protocol will be inactive.

[Mon Jun 28 06:07:26.216678 2021] [lbmethod_heartbeat:notice] [pid 5679] AH02282: No slotmem from mod_heartmonitor

PHP Warning: PHP Startup: Unable to load dynamic library 'apc.so' (tried: /usr/lib/php/20190902/apc.so (/usr/lib/php/20190902/apc.so: cannot open shared object file: No such file or directory), /usr/lib/php/20190902/apc.so.so (/usr/lib/php/20190902/apc.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0

PHP Warning: PHP Startup: Unable to load dynamic library 'bcmath.so' (tried: /usr/lib/php/20190902/bcmath.so (/usr/lib/php/20190902/bcmath.so: cannot open shared object file: No such file or directory), /usr/lib/php/20190902/bcmath.so.so (/usr/lib/php/20190902/bcmath.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0

PHP Warning: PHP Startup: Unable to load dynamic library 'bz2.so' (tried: /usr/lib/php/20190902/bz2.so (/usr/lib/php/20190902/bz2.so: cannot open shared object file: No such file or directory), /usr/lib/php/20190902/bz2.so.so (/usr/lib/php/20190902/bz2.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0

[Mon Jun 28 06:07:26.304540 2021] [mpm_prefork:notice] [pid 5679] AH00163: Apache/2.4.41 (Ubuntu) OpenSSL/1.1.1f PHP/7.4.3 configured -- resuming normal operations

[Mon Jun 28 06:07:26.304578 2021] [core:notice] [pid 5679] AH00094: Command line: '/usr/sbin/apache2'

[rockedge]

@peppyy Sorry I've been out of commission recently!

These errors mean we are trying to load modules that are not yet actually installed on the system. So open the PPM and update it as usual and search for those php modules and install them. They appear to be:

Code: Select all

php7.4-bz2
php7.4-apcu
php7.4-apcu-bc (if present)
php7.4-bcmath

Is the mysql server started?/ If we can get the LAMP going we can install ZM and create it's database

[peppyy]

Hope you are feeling better. I have been slow too lately with temps near 100f.
Got the math and the bz2
Looks like apcu is already there.

apcu1.jpg (53.81 KiB) Viewed 971 times

Stops and starts without errors, Will look at the log.

Still getting 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'

Made sure the directory was there and the directory was writable.

Now have 52 running from /usr/bin/apache2 -k start

Will have to review the thread to find some of the commands to test more.

When I go to 127.0.0.1/info.php I can see all the info from the server. Tried to attach the page a couple ways but it didn't want to go.

[rockedge]

if you use Htop and F4 and type in apache then press F5 to switch to tree mode, you will see all of what you see is all really one instance

Use preferably: http://localhost or the local network address like: http://192.168.1.5 for example. When using the subnet IP you will need to include a virtual host config in /etc/apache2/sites-enabled that describes the address. We already did it for localhost

Why are we having a problem starting the mysql server? send some screen shots if possible.

[peppyy]

Here is htop filtered

htop-2.jpg (136.34 KiB) Viewed 1019 times

Here is the login. It appears I have my password set?

[peppyy]

@rockedge I went to LDD and checked mysql, Miriadb, php etc and they all said there were no missing libs, however.

When all packages were checked there is a long list missing. I am guessing that one or more of these are needed?

[rockedge]

@peppyy
we will not need those packages from the list as of yet.

Try this from the command line and report the results!

Code: Select all

mysqld

mysqld is the mysql server daemon and does not need the -p switch.

to stop mysqld use killall mysqld But let's try out this now just as it is typed:

Code: Select all

mysqld -uroot &

Report the results please. I think you are just missing something simple to start the server.

[rockedge]

we are 2-3 steps away from ZM running!

[peppyy]

root# mysqld (5 second pause)

root# killall mysqld
killall: mysqld: no process killed

root# mysqld -uroot &
[1] 26881
root#

[peppyy]

Just tried this too , if it helps.
root# service mysql start

(20 second pause)

* Starting MySQL database server mysqld logger: unrecognized option: i
BusyBox v1.31.0 (2019-08-05 23:29:36 +08) multi-call binary.

Usage: logger [OPTIONS] [MESSAGE]

Write MESSAGE (or stdin) to syslog

-s Log to stderr as well as the system log
-t TAG Log using the specified tag (defaults to user name)
-p PRIO Priority (numeric or facility.level pair)
[fail]

[rockedge]

To remove this error you have to modify the /etc/init.d/mysql file and create the file /etc/mysql/debian.cnf.

in the /etc/init.d/mysql search for the line with the "-i" switch and delete the "-i".

can you post what the error logs say? /var/log/mysql

[peppyy]

After removing the "-i" I stopped and started and got this.

2021-07-08T12:45:32.907885Z 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure.
2021-07-08T12:45:32.908334Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2021-07-08T12:45:32.908676Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2021-07-08T12:45:32.909038Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2021-07-08T12:45:32.909405Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2021-07-08T12:45:32.909740Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2021-07-08T12:45:32.910084Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2021-07-08T12:45:32.910418Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2021-07-08T12:45:32.922453Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '0.0.0.0' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2021-07-08T12:45:32.969999Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2021-07-08T12:45:33.050102Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2021-07-08T12:45:33.060180Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-07-08T12:45:33.060413Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-07-08T12:45:33.070841Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2021-07-08T12:45:33.071291Z 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001146 - Table 'mysql.component' doesn't exist
2021-07-08T12:45:33.071571Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-003543 - The mysql.component table is missing or has an incorrect definition.
2021-07-08T12:45:33.071922Z 0 [ERROR] [MY-000067] [Server] unknown variable 'myisam-recover=BACKUP'.
2021-07-08T12:45:33.072601Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-07-08T12:45:34.447097Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.25-0ubuntu0.20.04.1) (Ubuntu).

create the file /etc/mysql/debian.cnf.

Do I create a blank file or use something as a template?

[rockedge]

here is what I am using as debian.cnf. It seems in our case that it needs to present.

Code: Select all

[client]
host     = localhost
user     = root
password = XXXX
socket   = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host     = localhost
user     = root
password = XXXX
socket   = /var/run/mysqld/mysqld.sock
basedir  = /usr

I am pretty sure the first (important) mysql initialization failed. The errors seem to indicate the tables are missing.
which would mean delete the contents of /var/lib/mysql and repeat the mysql setup process.