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>
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>
> 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
>> DOVECOTMYSQL=
>>
>> On Wed, Jan 20, 2021 at 10:06 PM Eric Broch <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
>>> && \
>>> 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>
>>> 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
>>> For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com
>>>
>>>
>>
>> --
>>
>>
>> *Regards, Manikandan.C *
>>
>>
>
> --
>
>
> *Regards,Manikandan.C*
>
--
*Regards,Manikandan.C*
