maria-discuss team mailing list archive

[Kenneth Penza <kpenza@xxxxxxxxx>]

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 default, both
MariaDB and MySQL read the options from /etc/mysql/my.cnf. A side effect of
this is that the MariaDB installation under /opt is reading from
/etc/mysql that has the options for MySQL, which is causing all your
errors. To get around this you need to use the
"--defaults-file=/opt/mariadb-data/my.cnf"
option with every MariaDB command.

In the example below, I started MariaDB using systemctl.

# Verify MySQL 5.7 is running
root@ubuntu:/etc/systemd/system# mysqladmin  -uroot -p version
...
Server version          5.7.22-0ubuntu0.16.04.1
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/run/mysqld/mysqld.sock
Uptime:                 12 min 7 sec

Threads: 1  Questions: 9  Slow queries: 0  Opens: 107  Flush tables: 1
Open tables: 26  Queries per second avg: 0.012
root@ubuntu:/etc/systemd/system#

Start MariaDB:
# systemctl start  mariadb
# /opt/mariadb/bin/mysqladmin --defaults-file=/opt/mariadb-data/my.cnf
-uroot -p version
...
Server version          10.2.14-MariaDB-log
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /opt/mariadb-data/mariadb.sock
Uptime:                 1 min 18 sec

Threads: 8  Questions: 1  Slow queries: 0  Opens: 17  Flush tables: 1  Open
tables: 11  Queries per second avg: 0.012
root@ubuntu:/etc/systemd/system#

To view which option a command has set use "--print-defaults", for example:

root@ubuntu:/etc/mysql# mysqladmin --print-defaults
mysqladmin would have been started with the following arguments:

root@ubuntu:/etc/mysql# mysqladmin
--defaults-file=/opt/mariadb-data/my.cnf  --print-defaults
mysqladmin would have been started with the following arguments:
--port=3308 --socket=/opt/mariadb-data/mariadb.sock
root@ubuntu:/etc/mysql#


Hope this clarified the matters
Kenneth

On Sat, May 12, 2018 at 10:26 AM, Muhammad Bashir Al-Noimi <
mbnoimi@xxxxxxxxx> wrote:

> 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 mariadb.service
> ● mariadb.service - LSB: start and stop MariaDB
>    Loaded: loaded (/etc/init.d/mariadb; bad; vendor preset: enabled)
>   Drop-In: /etc/systemd/system/mariadb.service.d
>            └─migrated-from-my.cnf-settings.conf
>    Active: failed (Result: exit-code) since Thu 2018-05-03 04:54:02 +03;
> 15min ago
>      Docs: man:systemd-sysv-generator(8)
>   Process: 17145 ExecStart=/etc/init.d/mariadb start (code=exited,
> status=1/FAILURE)
>
> 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 Logging to '/var/lib/mysql/domain.com.err'.
> May 03 04:54:01 domain.com mysqld[17145]: 2018-05-03T01:54:01.551305Z
> mysqld_safe A mysqld process already exists
> May 03 04:54:02 domain.com systemd[1]: mariadb.service: Control process
> exited, code=exited status=1
> May 03 04:54:02 domain.com systemd[1]: Failed to start LSB: start and
> stop MariaDB.
> May 03 04:54:02 domain.com systemd[1]: mariadb.service: Unit entered
> failed state.
> May 03 04:54:02 domain.com systemd[1]: mariadb.service: Failed with
> result 'exit-code'.
>
> How can I fix this issue?
>
> IMPORTANT:
>
>    - In the attachments you can find *"/opt/mariadb-data/my.cnf"* AND
>    *"/etc/init.d/mariadb** files"*
>    - Ubuntu Linux 16.04.2 x64
>    - Downloaded mariadb-10.2.14-linux-x86_64.tar.gz
>
>
>
> --
> Best Regards,
> Muhammad Bashir Al-Noimi
> Skype+Telegram+GMail: mbnoimi
>
> Guys, may I get some help here. I'm unable to bypass this issue since days
> weeks!
>
> I posted a full format version of this issue in ubuntu forums too:
> https://ubuntuforums.org/showthread.php?t=2391680&p=13765881#post13765881
>
> --
> Best Regards,
> Muhammad Bashir Al-Noimi
> Skype+Telegram+GMail: mbnoimi
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>
>