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 <[email protected]> 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/ > > 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 <[email protected]> > 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 <[email protected]> >> 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 <[email protected]> >>> 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 <[email protected]> >>>> 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: [email protected] >>>> For additional commands, e-mail: [email protected] >>>> >>>> >>> >>> -- >>> >>> >>> *Regards, Manikandan.C * >>> >>> >> >> -- >> >> >> *Regards, Manikandan.C * >> > > > -- > > > *Regards, Manikandan.C * > > -- *Regards,Manikandan.C*
