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*
