I'd talk to the mailing lists of either MariaDB or MySQL depending on
your back end.
https://mariadb.com/kb/en/mailing-lists/
or
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
/*
