Hi Eric, Let me try standalone computer as you suggested and update you.
On Fri, Feb 5, 2021 at 10:59 PM Eric Broch <[email protected]> wrote: > It looks like you're not connecting to any of the repos qmail or otherwise. > > hmmm....I wonder why? > On 2/5/2021 4:05 AM, ChandranManikandan wrote: > > 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 systemd[1]: Starting MySQL 8.0 database > server... > Feb 05 05:55:18 test.parpl.com mysql-prepare-db-dir[34170]: Initializing > MySQL > > Feb 05 05:55:27 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/ > > master/qmt-md-centos8.repo > Resolving raw.githubusercontent.com (raw.githubusercontent.com)... > 151.101.8.133 > Connecting to raw.githubusercontent.com > (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 > > ter/dovecot.repo > Resolving raw.githubusercontent.com (raw.githubusercontent.com)... > 151.101.8.133 > Connecting to raw.githubusercontent.com > (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 > > ter/dovecot.conf > Resolving raw.githubusercontent.com (raw.githubusercontent.com)... > 151.101.8.133 > Connecting to raw.githubusercontent.com > (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 > > ter/dovecot-sql.conf.ext > Resolving raw.githubusercontent.com (raw.githubusercontent.com)... > 151.101.8.133Connecting to raw.githubusercontent.com ( > 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 [email protected] does not exist. > --2021-02-05 05:59:14-- > https://raw.githubusercontent.com/qmtoaster/scripts/mas > > ter/toaststat.cos8 > Resolving raw.githubusercontent.com (raw.githubusercontent.com)... > 151.101.8.133 > Connecting to raw.githubusercontent.com > (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 <[email protected]> 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 <[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 * >> >> > > -- > > > *Regards, Manikandan.C * > > -- *Regards,Manikandan.C*
