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 <http://test.parpl.com> systemd[1]: Starting MySQL 8.0 database server... Feb 05 05:55:18 test.parpl.com <http://test.parpl.com> mysql-prepare-db-dir[34170]: Initializing MySQL > Feb 05 05:55:27 test.parpl.com <http://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/ <https://raw.githubusercontent.com/qmtoaster/mirrorlist/> master/qmt-md-centos8.repo Resolving raw.githubusercontent.com <http://raw.githubusercontent.com> (raw.githubusercontent.com <http://raw.githubusercontent.com>)... 151.101.8.133 Connecting to raw.githubusercontent.com <http://raw.githubusercontent.com> (raw.githubusercontent.com <http://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 <https://raw.githubusercontent.com/qmtoaster/scripts/mas> ter/dovecot.repo Resolving raw.githubusercontent.com <http://raw.githubusercontent.com> (raw.githubusercontent.com <http://raw.githubusercontent.com>)... 151.101.8.133 Connecting to raw.githubusercontent.com <http://raw.githubusercontent.com> (raw.githubusercontent.com <http://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 <https://raw.githubusercontent.com/qmtoaster/scripts/mas> ter/dovecot.conf Resolving raw.githubusercontent.com <http://raw.githubusercontent.com> (raw.githubusercontent.com <http://raw.githubusercontent.com>)... 151.101.8.133 Connecting to raw.githubusercontent.com <http://raw.githubusercontent.com> (raw.githubusercontent.com <http://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 <https://raw.githubusercontent.com/qmtoaster/scripts/mas> ter/dovecot-sql.conf.ext Resolving raw.githubusercontent.com <http://raw.githubusercontent.com> (raw.githubusercontent.com <http://raw.githubusercontent.com>)... 151.101.8.133Connecting to raw.githubusercontent.com <http://raw.githubusercontent.com> (raw.githubusercontent.com <http://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 clamd@scan.service does not exist.
--2021-02-05 05:59:14-- https://raw.githubusercontent.com/qmtoaster/scripts/mas <https://raw.githubusercontent.com/qmtoaster/scripts/mas> ter/toaststat.cos8 Resolving raw.githubusercontent.com <http://raw.githubusercontent.com> (raw.githubusercontent.com <http://raw.githubusercontent.com>)... 151.101.8.133 Connecting to raw.githubusercontent.com <http://raw.githubusercontent.com> (raw.githubusercontent.com <http://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 <ebr...@whitehorsetc.com <mailto:ebr...@whitehorsetc.com>> 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
    <ebr...@whitehorsetc.com <mailto:ebr...@whitehorsetc.com>> 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/
        <https://mariadb.com/kb/en/mailing-lists/>

        or

        https://lists.mysql.com <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
        <kand...@gmail.com <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 <via user signal>.
            Shutting down mysqld (Version: 8.0.21).
            2021-01-21T09:47:38.679147Z 0 [System] [MY-010910]
            [Server] /usr/libexec/mysqld: Shutdown complete (mysqld
            8.0.21)  Source distribution.
            2021-01-21T09:47:39.279669Z 0 [System] [MY-010116]
            [Server] /usr/libexec/mysqld (mysqld 8.0.21) starting as
            process 1408
            2021-01-21T09:47:39.300187Z 1 [System] [MY-013576]
            [InnoDB] InnoDB initialization has started.
            2021-01-21T09:47:39.960292Z 1 [System] [MY-013577]
            [InnoDB] InnoDB initialization has ended.
            2021-01-21T09:47:40.313454Z 0 [System] [MY-011323]
            [Server] X Plugin ready for connections. Bind-address:
            '::' port: 33060, socket: /var/lib/mysql/mysqlx.sock
            2021-01-21T09:47:40.533072Z 0 [Warning] [MY-010068]
            [Server] CA certificate ca.pem is self signed.
            2021-01-21T09:47:40.533714Z 0 [System] [MY-013602]
            [Server] Channel mysql_main configured to support TLS.
            Encrypted connections are now supported for this channel.
            2021-01-21T09:47:40.583319Z 0 [System] [MY-010931]
            [Server] /usr/libexec/mysqld: ready for connections.
            Version: '8.0.21'  socket: '/var/lib/mysql/mysql.sock'
             port: 3306  Source distribution.

            On Fri, Jan 22, 2021 at 12:30 AM Eric Broch
            <ebr...@whitehorsetc.com
            <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 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
                
<https://raw.githubusercontent.com/qmtoaster/mirrorlist/master/qmt-centos8.repo>
                DOVECOTMYSQL=

                On Wed, Jan 20, 2021 at 10:06 PM Eric Broch
                <ebr...@whitehorsetc.com
                <mailto:ebr...@whitehorsetc.com>> wrote:

                    Did you check the script?

                    Here is that section:

                    echo -e "\n"
                    MYSQLPW=$password
                    credfile=~/sql.cnf
                    echo -e
                    "[client]\nuser=root\npassword='$MYSQLPW'\nhost=localhost"
                    > $credfile
                    echo "Starting $DBD Server..."
                    systemctl start $DBD && systemctl enable $DBD
                    && systemctl status $DBD
                    echo "Started $DBD Server"
                    sleep 2
                    echo "Setting $DBD admin password..."
                    mysqladmin -uroot password $MYSQLPW &> /dev/null
                    echo "Admin password set"
                    echo "Creating vpopmail database..."

                    It doesn't look like the script is getting to
                    this line (line 7 in the segment above):

                    echo "Started $DBD Server"

                    Have you tried starting and checking the
                    status of mysqld manually to see if it hangs?


                    On 1/20/2021 12:04 AM, ChandranManikandan wrote:
                    Hi Eric,

                    I have freshly installed SPDL 8.1 on a
                    virtual box then ran a yum update.
                    After done the updates rebooted the system to
                    install QMT with the below commands.
                    curl -O
                    
https://raw.githubusercontent.com/qmtoaster/scripts/master/qt_install_cos8.sh
                    
<https://raw.githubusercontent.com/qmtoaster/scripts/master/qt_install_cos8.sh>
                    && \
                    chmod 755 qt_install_cos8.sh &&
                    ./qt_install_cos8.sh
                    then installed relevant packages and then
                    asking for database selection, i selected
                    mysql and i put the new password there.
                    After that mysql services started and nothing
                    moved.
                    FYI screenshot attached and messages below.
                    Enter mysqld password:

                    Starting mysqld Server...
                    Created symlink
                    /etc/systemd/system/multi-user.target.wants/mysqld.service
                    → /usr/lib/systemd/system/mysqld.service.
                    ● mysqld.service - MySQL 8.0 database server
                       Loaded: loaded
                    (/usr/lib/systemd/system/mysqld.service;
                    enabled; vendor pres>
                       Active: active (running) since Wed
                    2021-01-20 14:54:46 +08; 562ms ago
                     Main PID: 5805 (mysqld)
                       Status: "Server is operational"
                        Tasks: 39 (limit: 12455)
                       Memory: 426.3M
                       CGroup: /system.slice/mysqld.service
                               └─5805 /usr/libexec/mysqld
                    --basedir=/usr

                    Jan 20 14:54:35 localhost.localdomain
                    systemd[1]: Starting MySQL 8.0 database s>
                    Jan 20 14:54:35 localhost.localdomain
                    mysql-prepare-db-dir[5723]: Initializing >
                    Jan 20 14:54:46 localhost.localdomain
                    systemd[1]: Started MySQL 8.0 database se>
                    lines 1-13/13 (END)

                    Appreciate your help.



                    On Sat, Jan 16, 2021 at 5:29 AM Eric Broch
                    <ebr...@whitehorsetc.com
                    <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,
                    Manikandan.C
                    /*

                    
---------------------------------------------------------------------
                    To unsubscribe, 
e-mail:qmailtoaster-list-unsubscr...@qmailtoaster.com  
<mailto:qmailtoaster-list-unsubscr...@qmailtoaster.com>
                    For additional commands, 
e-mail:qmailtoaster-list-h...@qmailtoaster.com  
<mailto:qmailtoaster-list-h...@qmailtoaster.com>



-- */Regards,
                Manikandan.C
                /*



-- */Regards,
            Manikandan.C
            /*



-- */Regards,
        Manikandan.C
        /*



-- */Regards,
    Manikandan.C
    /*



--
*/Regards,
Manikandan.C
/*

Reply via email to