Hi Eric,
I didn't touch with the mysql list instead, i have been trying to
reinstall spdl 8 on the same virtual box and tried the qmt script and
got the below errors.
Did I miss something? how to fix this?
FYI below
Starting mysqld Server...
● mysqld.service - MySQL 8.0 database server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled;
vendor pres>
Active: active (running) since Fri 2021-02-05 05:55:27 EST; 3min
20s ago
Main PID: 34252 (mysqld)
Status: "Server is operational"
Tasks: 39 (limit: 25013)
Memory: 446.6M
CGroup: /system.slice/mysqld.service
└─34252 /usr/libexec/mysqld --basedir=/usr
Feb 05 05:55:18 test.parpl.com <http://test.parpl.com> systemd[1]:
Starting MySQL 8.0 database server...
Feb 05 05:55:18 test.parpl.com <http://test.parpl.com>
mysql-prepare-db-dir[34170]: Initializing MySQL >
Feb 05 05:55:27 test.parpl.com <http://test.parpl.com> systemd[1]:
Started MySQL 8.0 database server.
Started mysqld Server
Setting mysqld admin password...
Admin password set
Creating vpopmail database...
mysqladmin: CREATE DATABASE failed; error: 'Can't create database
'vpopmail'; da tabase exists'
Adding vpopmail users and privileges...
ERROR 1396 (HY000) at line 1: Operation CREATE USER failed for
'vpopmail'@'local host'
Done with vpopmail database...
% Total % Received % Xferd Average Speed Time Time Time
Current
Dload Upload Total Spent Left
Speed
100 1076 100 1076 0 0 2656 0 --:--:-- --:--:--
--:--:-- 2656
Do you want Many-Domain setup? If you're unsure press [ENTER] (Y/N): y
--2021-02-05 05:59:06--
https://raw.githubusercontent.com/qmtoaster/mirrorlist/
<https://raw.githubusercontent.com/qmtoaster/mirrorlist/>
master/qmt-md-centos8.repo
Resolving raw.githubusercontent.com <http://raw.githubusercontent.com>
(raw.githubusercontent.com <http://raw.githubusercontent.com>)...
151.101.8.133
Connecting to raw.githubusercontent.com
<http://raw.githubusercontent.com> (raw.githubusercontent.com
<http://raw.githubusercontent.com>)|151.101.8.13 3|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 1178 (1.2K) [text/plain]
Saving to: ‘/etc/yum.repos.d/qmt-md.repo’
/etc/yum.repos.d/qm 100%[===================>] 1.15K --.-KB/s in 0s
2021-02-05 05:59:06 (23.0 MB/s) - ‘/etc/yum.repos.d/qmt-md.repo’ saved
[1178/117 8]
--2021-02-05 05:59:07--
https://raw.githubusercontent.com/qmtoaster/scripts/mas
<https://raw.githubusercontent.com/qmtoaster/scripts/mas> ter/dovecot.repo
Resolving raw.githubusercontent.com <http://raw.githubusercontent.com>
(raw.githubusercontent.com <http://raw.githubusercontent.com>)...
151.101.8.133
Connecting to raw.githubusercontent.com
<http://raw.githubusercontent.com> (raw.githubusercontent.com
<http://raw.githubusercontent.com>)|151.101.8.13 3|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 230 [text/plain]
Saving to: ‘/etc/yum.repos.d/dovecot.repo’
dovecot.repo 100%[===================>] 230 --.-KB/s in 0s
2021-02-05 05:59:07 (2.15 MB/s) - ‘/etc/yum.repos.d/dovecot.repo’
saved [230/230 ]
Dovecot 2.3 CentOS 8 - x86_64 36 kB/s | 40 kB
00:01
QMT Testing mysql Repository (Many Domain) 28 kB/s | 23 kB
00:00
Error: Failed to download metadata for repo 'qmt-md-testing':
repomd.xml parser error: Parse error at line: 394 (Opening
and ending tag mismatch: base line 0 an d HEAD
)
QMT Testing mysql Repository (Many Domain) 86 kB/s | 23 kB
00:00
Error: Failed to download metadata for repo 'qmt-md-testing':
repomd.xml parser error: Parse error at line: 394 (Opening
and ending tag mismatch: base line 0 an d HEAD
)
QMT Testing mysql Repository (Many Domain) 78 kB/s | 23 kB
00:00
Error: Failed to download metadata for repo 'qmt-md-testing':
repomd.xml parser error: Parse error at line: 394 (Opening
and ending tag mismatch: base line 0 an d HEAD
)
sed: can't read
/usr/share/squirrelmail/plugins/qmailadmin_login/config_default.
php: No such file or
directory
sed: can't read /etc/clamd.d/scan.conf: No such file or directory
chown: invalid user: ‘clamupdate:clamupdate’
--2021-02-05 05:59:13--
https://raw.githubusercontent.com/qmtoaster/scripts/mas
<https://raw.githubusercontent.com/qmtoaster/scripts/mas> ter/dovecot.conf
Resolving raw.githubusercontent.com <http://raw.githubusercontent.com>
(raw.githubusercontent.com <http://raw.githubusercontent.com>)...
151.101.8.133
Connecting to raw.githubusercontent.com
<http://raw.githubusercontent.com> (raw.githubusercontent.com
<http://raw.githubusercontent.com>)|151.101.8.13 3|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 1543 (1.5K) [text/plain]
Saving to: ‘/etc/dovecot/dovecot.conf’
dovecot.conf 100%[===================>] 1.51K --.-KB/s in 0s
2021-02-05 05:59:13 (11.7 MB/s) - ‘/etc/dovecot/dovecot.conf’ saved
[1543/1543]
--2021-02-05 05:59:13--
https://raw.githubusercontent.com/qmtoaster/scripts/mas
<https://raw.githubusercontent.com/qmtoaster/scripts/mas>
ter/dovecot-sql.conf.ext
Resolving raw.githubusercontent.com <http://raw.githubusercontent.com>
(raw.githubusercontent.com <http://raw.githubusercontent.com>)...
151.101.8.133Connecting to raw.githubusercontent.com
<http://raw.githubusercontent.com> (raw.githubusercontent.com
<http://raw.githubusercontent.com>)|151.101.8.13 3|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 1796 (1.8K) [text/plain]
Saving to: ‘/etc/dovecot/dovecot-sql.conf.ext’
dovecot-sql.conf.ex 100%[===================>] 1.75K --.-KB/s in 0s
2021-02-05 05:59:14 (13.1 MB/s) - ‘/etc/dovecot/dovecot-sql.conf.ext’
saved [179 6/1796]
sendmail present...
Enable QMT man pages...
Downloading ClamAV database...
./qt_install_cos8.sh: line 121: freshclam: command not found
Starting QMT...
./qt_install_cos8.sh: line 125: qmailctl: command not found
Starting clamd freshclam dovecot spamassassin httpd chronyd acpid atd
autofs sma rtd named, this may take a while...
Failed to enable unit: Unit file clamd@scan.service does not exist.
--2021-02-05 05:59:14--
https://raw.githubusercontent.com/qmtoaster/scripts/mas
<https://raw.githubusercontent.com/qmtoaster/scripts/mas>
ter/toaststat.cos8
Resolving raw.githubusercontent.com <http://raw.githubusercontent.com>
(raw.githubusercontent.com <http://raw.githubusercontent.com>)...
151.101.8.133
Connecting to raw.githubusercontent.com
<http://raw.githubusercontent.com> (raw.githubusercontent.com
<http://raw.githubusercontent.com>)|151.101.8.13 3|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 1377 (1.3K) [text/plain]
Saving to: ‘/usr/bin/toaststat’
/usr/bin/toaststat 100%[===================>] 1.34K --.-KB/s in 0s
2021-02-05 05:59:14 (2.91 MB/s) - ‘/usr/bin/toaststat’ saved [1377/1377]
Status of toaster services
mysql mysqld
systemd service: clamd@scan: [ FAILED ]
systemd service: clamav-freshclam: [ FAILED ]
systemd service: spamassassin: [ FAILED ]
systemd service: dovecot: [ FAILED ]
systemd service: mysqld: [ OK ]
systemd service: httpd: [ FAILED ]
systemd service: chronyd: [ OK ]
systemd service: sshd: [ OK ]
systemd service: crond: [ OK ]
systemd service: acpid: [ FAILED ]
systemd service: atd: [ FAILED ]
systemd service: autofs: [ FAILED ]
systemd service: smartd: [ FAILED ]
systemd service: irqbalance: [ OK ]
On Tue, Feb 2, 2021 at 9:27 PM Eric Broch <ebr...@whitehorsetc.com
<mailto:ebr...@whitehorsetc.com>> wrote:
Did you look into trying the mysql/maria mailing lists?
I've had no issues like your describing. I use proxmox.
I couldn't say what the problem is. I know it's not a qmail issue
but a mysql/maria issues, though.
On 2/1/2021 11:20 PM, ChandranManikandan wrote:
Hi Eric,
Any luck on this issue.
Is this issue for me only or others?
Is that working on a standalone server?
I am running a virtual machine using a virtual box.
On Thu, Jan 28, 2021 at 12:18 AM Eric Broch
<ebr...@whitehorsetc.com <mailto:ebr...@whitehorsetc.com>> wrote:
I'd talk to the mailing lists of either MariaDB or MySQL
depending on your back end.
https://mariadb.com/kb/en/mailing-lists/
<https://mariadb.com/kb/en/mailing-lists/>
or
https://lists.mysql.com <https://lists.mysql.com>
On 1/27/2021 12:50 AM, ChandranManikandan wrote:
Hi Friends,
Could anyone help what's wrong on my spdl of above mysql log.
I have run SPDL on my virtualbox.
On Fri, Jan 22, 2021 at 4:33 PM ChandranManikandan
<kand...@gmail.com <mailto:kand...@gmail.com>> wrote:
Hi Eric,
The log is below:
2021-01-20T06:54:35.371125Z 0 [System] [MY-013169]
[Server] /usr/libexec/mysqld (mysqld 8.0.21)
initializing of server in progress as process 5760
2021-01-20T06:54:35.390913Z 1 [System] [MY-013576]
[InnoDB] InnoDB initialization has started.
2021-01-20T06:54:37.227839Z 1 [System] [MY-013577]
[InnoDB] InnoDB initialization has ended.
2021-01-20T06:54:40.372006Z 6 [Warning] [MY-010453]
[Server] root@localhost is created with an empty
password ! Please consider switching off the
--initialize-insecure option.
2021-01-20T06:54:45.070729Z 0 [System] [MY-010116]
[Server] /usr/libexec/mysqld (mysqld 8.0.21) starting as
process 5805
2021-01-20T06:54:45.113328Z 1 [System] [MY-013576]
[InnoDB] InnoDB initialization has started.
2021-01-20T06:54:45.893047Z 1 [System] [MY-013577]
[InnoDB] InnoDB initialization has ended.
2021-01-20T06:54:46.213236Z 0 [System] [MY-011323]
[Server] X Plugin ready for connections. Bind-address:
'::' port: 33060, socket: /var/lib/mysql/mysqlx.sock
2021-01-20T06:54:46.630955Z 0 [Warning] [MY-010068]
[Server] CA certificate ca.pem is self signed.
2021-01-20T06:54:46.632118Z 0 [System] [MY-013602]
[Server] Channel mysql_main configured to support TLS.
Encrypted connections are now supported for this channel.
2021-01-20T06:54:46.691288Z 0 [System] [MY-010931]
[Server] /usr/libexec/mysqld: ready for connections.
Version: '8.0.21' socket: '/var/lib/mysql/mysql.sock'
port: 3306 Source distribution.
2021-01-21T09:41:57.151167Z 0 [System] [MY-010116]
[Server] /usr/libexec/mysqld (mysqld 8.0.21) starting as
process 976
2021-01-21T09:41:58.136685Z 1 [System] [MY-013576]
[InnoDB] InnoDB initialization has started.
2021-01-21T09:41:59.962706Z 1 [System] [MY-013577]
[InnoDB] InnoDB initialization has ended.
2021-01-21T09:42:00.728235Z 0 [System] [MY-011323]
[Server] X Plugin ready for connections. Bind-address:
'::' port: 33060, socket: /var/lib/mysql/mysqlx.sock
2021-01-21T09:42:00.804466Z 0 [System] [MY-010229]
[Server] Starting XA crash recovery...
2021-01-21T09:42:00.829954Z 0 [System] [MY-010232]
[Server] XA crash recovery finished.
2021-01-21T09:42:01.063337Z 0 [Warning] [MY-010068]
[Server] CA certificate ca.pem is self signed.
2021-01-21T09:42:01.064658Z 0 [System] [MY-013602]
[Server] Channel mysql_main configured to support TLS.
Encrypted connections are now supported for this channel.
2021-01-21T09:42:01.142698Z 0 [System] [MY-010931]
[Server] /usr/libexec/mysqld: ready for connections.
Version: '8.0.21' socket: '/var/lib/mysql/mysql.sock'
port: 3306 Source distribution.
2021-01-21T09:47:37.427200Z 0 [System] [MY-013172]
[Server] Received SHUTDOWN from user <via user signal>.
Shutting down mysqld (Version: 8.0.21).
2021-01-21T09:47:38.679147Z 0 [System] [MY-010910]
[Server] /usr/libexec/mysqld: Shutdown complete (mysqld
8.0.21) Source distribution.
2021-01-21T09:47:39.279669Z 0 [System] [MY-010116]
[Server] /usr/libexec/mysqld (mysqld 8.0.21) starting as
process 1408
2021-01-21T09:47:39.300187Z 1 [System] [MY-013576]
[InnoDB] InnoDB initialization has started.
2021-01-21T09:47:39.960292Z 1 [System] [MY-013577]
[InnoDB] InnoDB initialization has ended.
2021-01-21T09:47:40.313454Z 0 [System] [MY-011323]
[Server] X Plugin ready for connections. Bind-address:
'::' port: 33060, socket: /var/lib/mysql/mysqlx.sock
2021-01-21T09:47:40.533072Z 0 [Warning] [MY-010068]
[Server] CA certificate ca.pem is self signed.
2021-01-21T09:47:40.533714Z 0 [System] [MY-013602]
[Server] Channel mysql_main configured to support TLS.
Encrypted connections are now supported for this channel.
2021-01-21T09:47:40.583319Z 0 [System] [MY-010931]
[Server] /usr/libexec/mysqld: ready for connections.
Version: '8.0.21' socket: '/var/lib/mysql/mysql.sock'
port: 3306 Source distribution.
On Fri, Jan 22, 2021 at 12:30 AM Eric Broch
<ebr...@whitehorsetc.com
<mailto:ebr...@whitehorsetc.com>> wrote:
Thanks Philip. I think it might be a memory (or
something) issue. It's hard to say without knowing
what's in the log.
On 1/21/2021 9:13 AM, Philip Nix Guru wrote:
Hello every1
I tested an installation on spdl 8.1 on a vm (xen)
choosing mariadb
All went fine w/o a glitch
On 1/21/21 10:50 AM, ChandranManikandan wrote:
Hi Eric,
Yes, the script is correct and I have tried to
check the status manually and it hangs also.
Here is full script of qt_install_cos8.sh
# Set DNF variables
echo "$DB" > /etc/yum/vars/db
DB=`cat /etc/yum/vars/db` && [[ "$DB" == *mysql*
]] && DBD="${DB}d" || DBD="${DB}"
echo "Using $DBD backend..."
yum -y install $DB $DB-server
# MySQL admin password
read -s -p "Enter $DBD password: " password
if [ -z "$password" ]; then
echo "Empty password, exiting..."
exit 1
fi
echo -e "\n"
MYSQLPW=$password
credfile=~/sql.cnf
echo -e
"[client]\nuser=root\npassword='$MYSQLPW'\nhost=localhost"
> $credfile
echo "Starting $DBD Server..."
systemctl start $DBD && systemctl enable $DBD &&
systemctl status $DBD
echo "Started $DBD Server"
sleep 2
echo "Setting $DBD admin password..."
mysqladmin -uroot password $MYSQLPW &> /dev/null
echo "Admin password set"
echo "Creating vpopmail database..."
mysqladmin --defaults-extra-file=$credfile reload
mysqladmin --defaults-extra-file=$credfile refresh
mysqladmin --defaults-extra-file=$credfile create
vpopmail
mysqladmin --defaults-extra-file=$credfile reload
mysqladmin --defaults-extra-file=$credfile refresh
echo "Adding vpopmail users and privileges..."
mysql --defaults-extra-file=$credfile -e "CREATE
USER vpopmail@localhost IDENTIFIED BY 'SsEeCcRrEeTt'"
mysql --defaults-extra-file=$credfile -e "GRANT
ALL PRIVILEGES ON vpopmail.* TO vpopmail@localhost"
mysqladmin --defaults-extra-file=$credfile reload
mysqladmin --defaults-extra-file=$credfile refresh
echo "Done with vpopmail database..."
# Add repos
curl -o /etc/yum.repos.d/qmt.repo
https://raw.githubusercontent.com/qmtoaster/mirrorlist/master/qmt-centos8.repo
<https://raw.githubusercontent.com/qmtoaster/mirrorlist/master/qmt-centos8.repo>
DOVECOTMYSQL=
On Wed, Jan 20, 2021 at 10:06 PM Eric Broch
<ebr...@whitehorsetc.com
<mailto:ebr...@whitehorsetc.com>> wrote:
Did you check the script?
Here is that section:
echo -e "\n"
MYSQLPW=$password
credfile=~/sql.cnf
echo -e
"[client]\nuser=root\npassword='$MYSQLPW'\nhost=localhost"
> $credfile
echo "Starting $DBD Server..."
systemctl start $DBD && systemctl enable $DBD
&& systemctl status $DBD
echo "Started $DBD Server"
sleep 2
echo "Setting $DBD admin password..."
mysqladmin -uroot password $MYSQLPW &> /dev/null
echo "Admin password set"
echo "Creating vpopmail database..."
It doesn't look like the script is getting to
this line (line 7 in the segment above):
echo "Started $DBD Server"
Have you tried starting and checking the
status of mysqld manually to see if it hangs?
On 1/20/2021 12:04 AM, ChandranManikandan wrote:
Hi Eric,
I have freshly installed SPDL 8.1 on a
virtual box then ran a yum update.
After done the updates rebooted the system to
install QMT with the below commands.
curl -O
https://raw.githubusercontent.com/qmtoaster/scripts/master/qt_install_cos8.sh
<https://raw.githubusercontent.com/qmtoaster/scripts/master/qt_install_cos8.sh>
&& \
chmod 755 qt_install_cos8.sh &&
./qt_install_cos8.sh
then installed relevant packages and then
asking for database selection, i selected
mysql and i put the new password there.
After that mysql services started and nothing
moved.
FYI screenshot attached and messages below.
Enter mysqld password:
Starting mysqld Server...
Created symlink
/etc/systemd/system/multi-user.target.wants/mysqld.service
→ /usr/lib/systemd/system/mysqld.service.
● mysqld.service - MySQL 8.0 database server
Loaded: loaded
(/usr/lib/systemd/system/mysqld.service;
enabled; vendor pres>
Active: active (running) since Wed
2021-01-20 14:54:46 +08; 562ms ago
Main PID: 5805 (mysqld)
Status: "Server is operational"
Tasks: 39 (limit: 12455)
Memory: 426.3M
CGroup: /system.slice/mysqld.service
└─5805 /usr/libexec/mysqld
--basedir=/usr
Jan 20 14:54:35 localhost.localdomain
systemd[1]: Starting MySQL 8.0 database s>
Jan 20 14:54:35 localhost.localdomain
mysql-prepare-db-dir[5723]: Initializing >
Jan 20 14:54:46 localhost.localdomain
systemd[1]: Started MySQL 8.0 database se>
lines 1-13/13 (END)
Appreciate your help.
On Sat, Jan 16, 2021 at 5:29 AM Eric Broch
<ebr...@whitehorsetc.com
<mailto:ebr...@whitehorsetc.com>> wrote:
Odd, I just did a Springdale Install
today. It went off without a hitch.
Any errors to report?
On 1/13/2021 3:13 AM, ChandranManikandan
wrote:
Hi Eric,
I have tried to install QMT in Opensuse
leap15 & SPDL as per qmailtoaster guide
on the portal,
but after mardiab installed and started
the mariadb service nothing has moved
forward to further package installation.
I have tried the virtualbox testing
environment.
--
*/Regards,
Manikandan.C
/*
--
*/Regards,
Manikandan.C
/*
---------------------------------------------------------------------
To unsubscribe,
e-mail:qmailtoaster-list-unsubscr...@qmailtoaster.com
<mailto:qmailtoaster-list-unsubscr...@qmailtoaster.com>
For additional commands,
e-mail:qmailtoaster-list-h...@qmailtoaster.com
<mailto:qmailtoaster-list-h...@qmailtoaster.com>
--
*/Regards,
Manikandan.C
/*
--
*/Regards,
Manikandan.C
/*
--
*/Regards,
Manikandan.C
/*
--
*/Regards,
Manikandan.C
/*
--
*/Regards,
Manikandan.C
/*