Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-15 Thread Reindl Harald
Am 15.05.2018 um 18:06 schrieb Reindl Harald: > Am 15.05.2018 um 17:53 schrieb Muhammad Bashir Al-Noimi: >> On 05/15/2018 01:34 PM, Reindl Harald wrote: >>> * that's all plaintext >>> * post it deirectly >>> * look in the errorlog >>> * post systemctl outputs (also for systemctl status) >>> >>> *

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-15 Thread Reindl Harald
Am 15.05.2018 um 17:53 schrieb Muhammad Bashir Al-Noimi: > On 05/15/2018 01:34 PM, Reindl Harald wrote: >> Am 15.05.2018 um 12:22 schrieb Muhammad Bashir Al-Noimi: >>> On 05/15/2018 01:12 PM, Reindl Harald wrote: so it works and " error: 'Access denied for user 'root'@'localhost' (using

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-15 Thread Muhammad Bashir Al-Noimi
On 05/15/2018 01:34 PM, Reindl Harald wrote: Am 15.05.2018 um 12:22 schrieb Muhammad Bashir Al-Noimi: On 05/15/2018 01:12 PM, Reindl Harald wrote: so it works and " error: 'Access denied for user 'root'@'localhost' (using passwor

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-15 Thread Reindl Harald
and BTW the "--pid-file=/dev/null" has a damned good reason because you don't need to care about subfolders below /run to get re-created with corerct permissions at reboot while a restriucted user can't create folders and files there and run is tmpfs aka memory since mariadb is a single-process mu

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-15 Thread Reindl Harald
Am 15.05.2018 um 12:22 schrieb Muhammad Bashir Al-Noimi: > On 05/15/2018 01:12 PM, Reindl Harald wrote: >> so it works and " error: 'Access denied for user 'root'@'localhost' >> (using password: YES)'" is what it is >> >> are you aware that 'root' on unix-socket (localhost) is not the same >> tha

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-15 Thread Muhammad Bashir Al-Noimi
On 05/15/2018 01:12 PM, Reindl Harald wrote: so it works and " error: 'Access denied for user 'root'@'localhost' (using password: YES)'" is what it is are you aware that 'root' on unix-socket (localhost) is not the same than 'root' over TCP (127.0.0.1) beause you h

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-15 Thread Reindl Harald
Am 15.05.2018 um 12:06 schrieb Muhammad Bashir Al-Noimi: > On 05/15/2018 12:09 PM, Kenneth Penza wrote: >> /opt/mariadb/bin/mysqladmin  --defaults-file=/opt/mariadb-data/my.cnf  >> -uroot -p version > I tried to call it with mariadb user instead of root so I get this result: > > # /opt/mariadb/b

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-15 Thread Muhammad Bashir Al-Noimi
On 05/15/2018 12:09 PM, Kenneth Penza wrote: /opt/mariadb/bin/mysqladmin  --defaults-file=/opt/mariadb-data/my.cnf  -uroot -p version I tried to call it with mariadb user instead of root so I get this result: # /opt/mariadb/bin/m

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-15 Thread Muhammad Bashir Al-Noimi
On 05/15/2018 12:52 PM, Reindl Harald wrote: in fact each tool has it's own config section in the defaults file while port is for TCP (127.0.0.1) and socket for socket-connections (localhost) [mysqld] socket = /var/lib/mysql/mysql-replication.sock port = 3307 [cli

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-15 Thread Reindl Harald
Am 15.05.2018 um 11:49 schrieb Reindl Harald: > > > Am 15.05.2018 um 11:39 schrieb Muhammad Bashir Al-Noimi: >> # /opt/mariadb/bin/mysqladmin  --defaults-file=/opt/mariadb-data/my.cnf  >> -uroot -p shutdown >> Enter password: >> /opt/mariadb/bin/mysqladmin: connect to server at 'localhost' fail

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-15 Thread Reindl Harald
Am 15.05.2018 um 11:39 schrieb Muhammad Bashir Al-Noimi: > # /opt/mariadb/bin/mysqladmin  --defaults-file=/opt/mariadb-data/my.cnf  > -uroot -p shutdown > Enter password: > /opt/mariadb/bin/mysqladmin: connect to server at 'localhost' failed > error: 'Access denied for user 'root'@'localhost' (us

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-15 Thread Muhammad Bashir Al-Noimi
Thanks a lot Kenneth, On 05/15/2018 12:09 PM, Kenneth Penza wrote: Good morning Muhammad, I have checked and I am using your mariadb.service file. For some reason, mariadb is failing to start.  We need to determine

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-15 Thread Kenneth Penza
Good morning Muhammad, I have checked and I am using your mariadb.service file. For some reason, mariadb is failing to start. We need to determine if the issue is coming from systemd or something in MariaDB datadir. To start it without systemd, run: /opt/mariadb/bin/mysqld --defaults-file=/op

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-15 Thread Muhammad Bashir Al-Noimi
On 05/12/2018 11:56 PM, Kenneth Penza wrote: I have installed a new Ubuntu VM 16.04, installed MySQL 5.7 from Ubuntu repositories and MariaDB using the outline provided in the link https://ubuntuforums.org/showthread.php?t=2391680&p=137

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-12 Thread Kenneth Penza
Hi, I have installed a new Ubuntu VM 16.04, installed MySQL 5.7 from Ubuntu repositories and MariaDB using the outline provided in the link https://ubuntuforums.org/showthread.php?t=2391680&p=13765881#post13765881 and got it working. The problem is stemming from the configuration files. By defaul

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-12 Thread Muhammad Bashir Al-Noimi
On 05/03/2018 05:16 AM, Muhammad Bashir Al-Noimi wrote: Hi, I applied exactly the mentioned instructions in MariaDB documentation but unfortunately I always receive the following error message: # systemctl status

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-07 Thread Erik Cederstrand
Hi Reindl, Den 5. maj 2018 kl. 12.42 skrev Reindl Harald : > > get rid of that damned /etc/init.d/mariadb crap > WTF is "ExecStart=/etc/init.d/mariadb start" > > put your service in /etc/systemd/system/mariadb.service and you are done > > no idea what you did not understand in the ExecStart fro

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-06 Thread Muhammad Bashir Al-Noimi
On 05/07/2018 12:20 AM, Reindl Harald wrote: Am 06.05.2018 um 23:18 schrieb Reindl Harald: Am 06.05.2018 um 22:53 schrieb Muhammad Bashir Al-Noimi: I use /etc/systemd/system/mariadb.service as mentioned before but I struggle w

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-06 Thread Muhammad Bashir Al-Noimi
On 05/07/2018 12:18 AM, Reindl Harald wrote: Am 06.05.2018 um 22:53 schrieb Muhammad Bashir Al-Noimi: I use /etc/systemd/system/mariadb.service as mentioned before but I struggle with a new problem and I spent a whole day trying to fix it but I fai

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-06 Thread Reindl Harald
Am 06.05.2018 um 23:18 schrieb Reindl Harald: > > > Am 06.05.2018 um 22:53 schrieb Muhammad Bashir Al-Noimi: >> I use /etc/systemd/system/mariadb.service as mentioned before but I >> struggle with a new problem and I spent a whole day trying to fix it but >> I failed :( >> >> I always get this

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-06 Thread Reindl Harald
Am 06.05.2018 um 22:53 schrieb Muhammad Bashir Al-Noimi: > I use /etc/systemd/system/mariadb.service as mentioned before but I > struggle with a new problem and I spent a whole day trying to fix it but > I failed :( > > I always get this error message through journalctl -xe although my.cnf > alr

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-06 Thread Muhammad Bashir Al-Noimi
On 05/05/2018 01:42 PM, Reindl Harald wrote: Am 05.05.2018 um 12:28 schrieb Muhammad Bashir Al-Noimi: On 05/05/2018 12:49 PM, Reindl Harald wrote: Am 05.05.2018 um 11:43 schrieb Muhammad Bashir Al-Noimi:

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-05 Thread Reindl Harald
Am 05.05.2018 um 12:28 schrieb Muhammad Bashir Al-Noimi: > On 05/05/2018 12:49 PM, Reindl Harald wrote: >> Am 05.05.2018 um 11:43 schrieb Muhammad Bashir Al-Noimi: > May 03 04:54:01 domain.com systemd[1]: Starting LSB: start and stop > MariaDB... > May 03 04:54:01 domain.com mysqld[17

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-05 Thread Muhammad Bashir Al-Noimi
On 05/05/2018 12:49 PM, Reindl Harald wrote: Am 05.05.2018 um 11:43 schrieb Muhammad Bashir Al-Noimi: May 03 04:54:01 domain.com systemd[1]: Starting LSB: start and stop MariaDB... May 03 04:54:01 domain.com mysqld[17145]: St

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-05 Thread Muhammad Bashir Al-Noimi
On 05/05/2018 12:49 PM, Reindl Harald wrote: Am 05.05.2018 um 11:43 schrieb Muhammad Bashir Al-Noimi: May 03 04:54:01 domain.com systemd[1]: Starting LSB: start and stop MariaDB... May 03 04:54:01 domain.com mysqld[17145]: St

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-05 Thread Reindl Harald
Am 05.05.2018 um 11:43 schrieb Muhammad Bashir Al-Noimi: >>> May 03 04:54:01 domain.com systemd[1]: Starting LSB: start and stop >>> MariaDB... >>> May 03 04:54:01 domain.com mysqld[17145]: Starting MariaDB >>> May 03 04:54:01 domain.com mysqld[17145]: >>> .2018-05-03T01:54:01.525119Z mysqld_safe

Re: [Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-05 Thread Muhammad Bashir Al-Noimi
On 05/03/2018 05:16 AM, Muhammad Bashir Al-Noimi wrote: Hi, I applied exactly the mentioned instructions in MariaDB documentation but unfortunately I always receive the following error message: # systemctl status

[Maria-discuss] Installing MariaDB Alongside MySQL

2018-05-02 Thread Muhammad Bashir Al-Noimi
Hi, I applied exactly the mentioned instructions in MariaDB documentation but unfortunately I always receive the following error message: # systemctl status mariadb.service ● mariadb.service - LSB: start and stop MariaDB    Loaded: loa