MariaDB testing

[jeekkd]

TODO - test scripts with MariaDB, currently it is untested.

Feel free to post here if you test this or find bugs running the scripts as is on MariaDB

[corvy]

Hello, just tested create_new_user.sh with MariaDB on Debian, works just perfect.

root@mail:~/gits/iRedMail-scripts/Scripts# ./create-new-user.sh testuser@domainscrabmled.com testpassword123 
Create users maildir with the following command: 
mkdir -p /var/vmail/vmail1/domainscrabmled.com/t/e/s/testuser-2020.08.21.07.10.25/ 
chown -R vmail:vmail /var/vmail/vmail1/domainscrabmled.com/t/ 

Run the following query in your vmail db: 
INSERT INTO mailbox (username, password, name, storagebasedirectory,storagenode, maildir, quota, domain, active, passwordlastchange, created)
             VALUES ('testuser@domainscrabmled.com', '{SSHA512}hPU/5Z2SrgFoU47p0oWBaT1hDcd3kxMXdptDQ8ljjzF5iHpUhdq9SJEkSyrzuytPt2fxxNDT4Grx9aC7sV9gyUtfqeY5Ooql', 'testuser', '/var/vmail','vmail1', 'domainscrabmled.com/t/e/s/testuser-2020.08.21.07.10.25/', '1024', 'domainscrabmled.com', '1', NOW(), NOW());
INSERT INTO forwardings (address, forwarding, domain, dest_domain, is_forwarding)
             VALUES ('testuser@domainscrabmled.com', 'testuser@domainscrabmled.com','domainscrabmled.com', 'domainscrabmled.com', 1); 
UPDATE domain SET mailboxes = mailboxes + 1 WHERE domain = 'domainscrabmled.com';
root@mail:~/gits/iRedMail-scripts/Scripts# mkdir -p /var/vmail/vmail1/domainscrabmled.com/t/e/s/testuser-2020.08.21.07.10.25/ 
root@mail:~/gits/iRedMail-scripts/Scripts# chown -R vmail:vmail /var/vmail/vmail1/domainscrabmled.com/t/ 
root@mail:~/gits/iRedMail-scripts/Scripts# mysql -u root vmail -p << EOF
> INSERT INTO mailbox (username, password, name, storagebasedirectory,storagenode, maildir, quota, domain, active, passwordlastchange, created)
>              VALUES ('testuser@domainscrabmled.com', '{SSHA512}hPU/5Z2SrgFoU47p0oWBaT1hDcd3kxMXdptDQ8ljjzF5iHpUhdq9SJEkSyrzuytPt2fxxNDT4Grx9aC7sV9gyUtfqeY5Ooql', 'testuser', '/var/vmail','vmail1', 'domainscrabmled.com/t/e/s/testuser-2020.08.21.07.10.25/', '1024', 'domainscrabmled.com', '1', NOW(), NOW());
> INSERT INTO forwardings (address, forwarding, domain, dest_domain, is_forwarding)
>              VALUES ('testuser@domainscrabmled.com', 'testuser@domainscrabmled.com','domainscrabmled.com', 'domainscrabmled.com', 1); 
> UPDATE domain SET mailboxes = mailboxes + 1 WHERE domain = 'domainscrabmled.com';
> EOF
Enter password: 

This is my MariaDB version:
mariadb Ver 15.1 Distrib 10.3.23-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2