Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Topics - scottdr

Pages: [1]
1
I wanted to upload a PDF attachment to show dialogue boxes with this report, but was unable to do so. The PDF was 179KB but there was no upload space.
Hope it helps



My attempt at carrying out an upgrade to Zentyal Version 8 from an up to date version of Zentyal 7.1.1
Platform: QEMU-KVM Hypervsisor host on HPE Proliant DL380 Gen9 running Ubuntu 22.04.4 LTS server with updates to 28th March 2024 including ESM updates.
VM 8vCPU, 8G Ram scsi drives on *.qcow2 2 x virtio bridge network connections

 
The dialogue below is misleading as it suggests that the Upgrade is finished and you can click close, but leave it open, In a separate shell monitor dpkg.log for progress ‘tail -f /var/log/dkpg.log’


 
 
Even though it will display ‘Finishing the upgrade’ watch the dpkg.log for the update finished message before clicking on ‘Close’
From dkpg.log
 
Click Close on Upgrading to Zentyal 8.0 dialogue and then reboot the system.
A stop job for Zentyal will delay the reboot for 1min 30sec
When the system restarted, the Zentyal logger daemon repeatedly stopped and started which might be a clue to issues ahead.
 
 
On restart, the Dashboard looked OK, but the Antivirus service failed to start. Also, the mysql service also failed due to permission issues on lock directory and missing log folder /var/log/mysql
This prevented the zentyal-core update script running to complete the install process.

Mar 29 11:23:28 hcs-zentyal6 systemd[1]: mysql.service: Start request repeated too quickly.
Mar 29 11:23:28 hcs-zentyal6 systemd[1]: mysql.service: Failed with result 'exit-code'.
░░ Subject: Unit failed
░░ Defined-By: systemd
░░ Support: http://www.ubuntu.com/support
░░ The unit mysql.service has entered the 'failed' state with result 'exit-code'.
Mar 29 11:23:28 hcs-zentyal6 systemd[1]: Failed to start MySQL Community Server.
░░ Subject: A start job for unit mysql.service has failed
░░ Defined-By: systemd
░░ Support: http://www.ubuntu.com/support
░░ A start job for unit mysql.service has finished with a failure.
░░ The job identifier is 9012 and the job result is failed.
Setting up zentyal-core (8.0.0) ...
Connection DB Error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
dpkg: error processing package zentyal-core (--configure):
 installed zentyal-core package post-installation script subprocess returned error exit status 2
Errors were encountered while processing:
 zentyal-core
E: Sub-process /usr/bin/dpkg returned an error code (1)

Had to create a folder for mysql /var/log/mysql and chown mysql to that folder for mysql to start
Now clamav failing
Unable to work out clamav issues
Removed Antivirus module from Zentyal and rebooted
Mysql failed again, so had to chown mysql /var/log/mysql
Setting up zentyal-core (8.0.0) ...
Synchronizing state of apparmor.service with SysV service script with /lib/systemd/systemd-sysv-install.
Executing: /lib/systemd/systemd-sysv-install disable apparmor
sed: can't read /etc/apt/apt.conf.d/20auto-upgrades: No such file or directory
dpkg: error processing package zentyal-core (--configure):
 installed zentyal-core package post-installation script subprocess returned error exit status 2
Errors were encountered while processing:
 zentyal-core
E: Sub-process /usr/bin/dpkg returned an error code (1)
Removed Antivirus module, mailfilter and antivirus

Unable to process /etc/apt/apt.conf.d/20auto-upgrades: No such file or directory

Gave up!! Reverted VM to V7.1.1 with no outstanding updates as at 29th March 2024

Hope this helps somebody.

Thank you Zentyal for the community version.


2
Thanks to Zentyal briefing to use this feature in the Community version.

Suggested updates to /usr/share/zentyal/smart-admin-report: -

########
## Server packages
########

Issue, the report states that there are 1 upgradable packages available when there is no packages in that state.

Line 140: Change "apt list --upgradable 2> /dev/null | wc -l" to "apt list --upgradable 2> /dev/null|awk '{if(NR>1)print}' | wc -l"


###################
# Antivirus module #
###################

Issue, Last ClamAV database update: the output is blank

Line 387  change "grep 'Database updated' /var/log/clamav/freshclam.log | tail -1 | awk '{print $1,$2,$3,$4,$5}'" to "clamscan --version |  awk '{split($0,a,"/");print a[3]}'"

This will detail the database date of the current signatures.

Tested successfully on Zentyal Community Edition Version 6.1.2 running on Ubuntu Linux 18.04.3, running as a VM on Hyper-V.

Added 10-Apr-2020

Line 142 Change "grep -ai zentyal-auto-updater /var/log/syslog | awk '{print $1,$2,$3}' | tail -1" to "grep -ai auto-updater /var/log/syslog | awk '{print $1,$2,$3}' | tail -1"

Line 144 Change "        grep -ai zentyal-auto-updater /var/log/syslog.1 | awk '{print $1,$2,$3}' | tail -1" to "        grep -ai auto-updater /var/log/syslog.1 | awk '{print $1,$2,$3}' | tail -1"


3
 run-parts --report /etc/cron.hourly
/etc/cron.hourly/90zentyal-manage-logs:
Can't locate object method "throw" via package "Can't locate object method "tableInfo" via package "EBox::AntiVirus" at /usr/share/perl5/EBox/Logs.pm line 321.
" (perhaps you forgot to load "Can't locate object method "tableInfo" via package "EBox::AntiVirus" at /usr/share/perl5/EBox/Logs.pm line 321.
"?) at /usr/share/zentyal/manage-logs line 31.
run-parts: /etc/cron.hourly/90zentyal-manage-logs exited with return code 25

I would be interested if this means something to those 'perl' experts  :)

4
I am running 4.25 (still on Ubuntu 14.04LTS)
I keep a Network Object list of Banned IP's from mail spammers that try and use us either to send spam or relay. Those servers that continually fail SASL login or use false FQDN get added to this list weekly. A little like Fail2Ban (but I haven't got that to work yet :( )

Can anyone point me to how Zentyal generates this list of objects when selected through the WEB GUI interface where I can add, delete or modify them. I cannot find any text file or SQL table where they are stored and am not Perl savvy enough to work out the code.

Your help would be most appreciated.

Thank you

Pages: [1]