02-25-2020 07:45 AM
In a new installation of Expedition upon first login we had three issues to remediate:
1. The instructions for "Verify that the SQL_Log_bin flag in MariaDB is set to off" were clear enough. So that was addressed successfully.
2. Insufficient instructions for "Verify that the Log_bin flag in MariaDB is set to off".
Verify that the Log_bin flag in MariaDB is set to off
Log_bin is ON
Remediation: Set log_bin to OFF
A search did not come up with instances of log_bin:
root:/etc/mysql# grep -i log_bin `find /etc/mysql -type f`
/etc/mysql/my.cnf:skip-log_bin = /var/log/mysql/mariadb-bin
/etc/mysql/my.cnf:skip-log_bin_index = /var/log/mysql/mariadb-bin.index
3. Insufficient instructions for "Verify the PanOrders agent is running to accept background jobs"
Verify the PanOrders agent is running to accept background jobs
PanOrders Agent is stopped
Remediation: Start the agent
A look at services located panReadOrders, but no PanOrders
root:/etc/mysql# service --status-all | grep -i pan
[ - ] panReadOrders
root:/etc/mysql# service panReadOrders status
● panReadOrders.service - LSB: starts panReadOrders agent for Expedition
Loaded: loaded (/etc/init.d/panReadOrders; bad; vendor preset: enabled)
Active: active (running) since Fri 2020-02-21 08:57:37 PST; 3 days ago
Process: 40502 ExecStart=/etc/init.d/panReadOrders start (code=exited, status=0/SUCCESS)
├─40508 sudo -u www-data php /var/www/html/console/messaging/readOrders.php
└─40512 php /var/www/html/console/messaging/readOrders.php
Feb 21 08:57:27 asa2pan systemd: Starting LSB: starts panReadOrders agent for Expedition...
Feb 21 08:57:37 asa2pan systemd: Started LSB: starts panReadOrders agent for Expedition.
Feb 21 08:57:37 asa2pan sudo: root : TTY=unknown ; PWD=/ ; USER=www-data ; COMMAND=/usr/bin/php /var/www/html/console
Feb 21 08:57:37 asa2pan sudo: pam_unix(sudo:session): session opened for user www-data by (uid=0)
A bit more checking revealed a script:
root:/tmp# find / -print > filelist
root:/tmp# grep -i panorder filelist
No change in symptoms after
root@asa2pan:/tmp# service panReadOrders restart
root@asa2pan:/tmp# service panReadOrders stop
root@asa2pan:/tmp# service panReadOrders start
Suggestions on how to overcome these are welcome. Thanks.
02-25-2020 07:52 AM
After reading the discussion a bit more, found a reference to a button in the user interface. Located the "RESTART" button in the Dashboard for PanReadOrders and that issue is now resolved.
There is still that MariaDB log_bin issue.
02-25-2020 07:57 AM
Restarting the mysql and apache2 services in that order seems to have resolved the "log_bin" issue.
Apologies for the wasted bandwidth.
03-20-2020 10:41 AM
That worked for me too:
sudo service mysql restart
sudo service apache2 restart
Click Accept as Solution to acknowledge that the answer to your question has been provided.
The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!
These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the LIVEcommunity as a whole!
The LIVEcommunity thanks you for your participation!