Re: [qmailtoaster] Issue in opensuse leap 15 and SPDL

2021-02-09 Thread ChandranManikandan
Hi Eric,

Let me try standalone computer as you suggested and update you.

On Fri, Feb 5, 2021 at 10:59 PM Eric Broch  wrote:

> It looks like you're not connecting to any of the repos qmail or otherwise.
>
> hmmmI 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   TimeTime Time
>  Current
>  Dload  Upload   Total   SpentLeft
>  Speed
> 100  1076  100  10760 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/sin 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.repo100%[===>] 230  --.-KB/sin 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_6436 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)...
> 

Re: [qmailtoaster] Issue in opensuse leap 15 and SPDL

2021-02-05 Thread Eric Broch

It looks like you're not connecting to any of the repos qmail or otherwise.

hmmmI 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 

Re: [qmailtoaster] Issue in opensuse leap 15 and SPDL

2021-02-05 Thread ChandranManikandan
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   TimeTime Time
 Current
 Dload  Upload   Total   SpentLeft
 Speed
100  1076  100  10760 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/sin 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.repo100%[===>] 230  --.-KB/sin 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_6436 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.conf100%[===>]   1.51K  --.-KB/sin 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

   

Re: [qmailtoaster] Issue in opensuse leap 15 and SPDL

2021-02-02 Thread Eric Broch

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 > 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
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 . 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.
 

Re: [qmailtoaster] Issue in opensuse leap 15 and SPDL

2021-02-01 Thread ChandranManikandan
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  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 
> 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 . 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 
>> 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
>>>
>>>
>>>
>>>

Re: [qmailtoaster] Issue in opensuse leap 15 and SPDL

2021-01-27 Thread Eric Broch
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 > 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 . 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
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 

Re: [qmailtoaster] Issue in opensuse leap 15 and SPDL

2021-01-26 Thread ChandranManikandan
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 
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 . 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 
> 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
>>  

Re: [qmailtoaster] Issue in opensuse leap 15 and SPDL

2021-01-22 Thread ChandranManikandan
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 . 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  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 

Re: [qmailtoaster] Issue in opensuse leap 15 and SPDL

2021-01-21 Thread Eric Broch
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 > 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
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

Re: [qmailtoaster] Issue in opensuse leap 15 and SPDL

2021-01-21 Thread Philip Nix Guru

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 > 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
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,


Re: [qmailtoaster] Issue in opensuse leap 15 and SPDL

2021-01-21 Thread Eric Broch

Okay, if it hangs manually, something else is going on besides the script.

Did you check the mysql logs ?

/var/log/mysql/mysqld.log


On 1/21/2021 2: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 > 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
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 

Re: [qmailtoaster] Issue in opensuse leap 15 and SPDL

2021-01-21 Thread ChandranManikandan
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  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 
> 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*


Re: [qmailtoaster] Issue in opensuse leap 15 and SPDL

2021-01-20 Thread Eric Broch

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 > 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


Re: [qmailtoaster] Issue in opensuse leap 15 and SPDL

2021-01-19 Thread ChandranManikandan
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  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

Re: [qmailtoaster] Issue in opensuse leap 15 and SPDL

2021-01-15 Thread Eric Broch

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
/*