MariaDB installation - dependancy problems and failed to start service
Debian 8. Moving from MySql to MariaDB. Have tried the following and iterations of it.
sudo apt-get install software-properties-common sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xcbcb082a1bb943db sudo add-apt-repository 'deb [arch=amd64,i386,ppc64el] http://sfo1.mirrors.digitalocean.com/mariadb/repo/10.2/debian jessie main'
apt-get install mariadb-server mariadb-client
This leads to the following:
Setting up mariadb-server-core-10.2 (10.2.6+maria~jessie) ... Setting up mariadb-server-10.2 (10.2.6+maria~jessie) ... 2017-07-07 0:47:00 140034277914496 [Warning] Ignoring user change to 'mysql' because the user was set to 'root' earlier on the command line 2017-07-07 0:47:00 140034277914496 [Note] /usr/sbin/mysqld (mysqld 10.2.6-MariaDB-10.2.6+maria~jessie) starting as process 12240 ... /usr/sbin/mysqld: Can't change to run as user 'dressify'. Please check that the user exists! 2017-07-07 0:47:00 140034277914496 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-07-07 0:47:00 140034277914496 [Note] InnoDB: Uses event mutexes 2017-07-07 0:47:00 140034277914496 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-07-07 0:47:00 140034277914496 [Note] InnoDB: Using Linux native AIO 2017-07-07 0:47:00 140034277914496 [Note] InnoDB: Number of pools: 1 2017-07-07 0:47:00 140034277914496 [Note] InnoDB: Using SSE2 crc32 instructions 2017-07-07 0:47:00 140034277914496 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2017-07-07 0:47:00 140034277914496 [Note] InnoDB: Completed initialization of buffer pool 2017-07-07 0:47:00 140033739474688 [Note] InnoDB: page_cleaner coordinator priority: -20 2017-07-07 0:47:00 140034277914496 [Note] InnoDB: Highest supported file format is Barracuda. 2017-07-07 0:47:00 140034277914496 [Note] InnoDB: 128 out of 128 rollback segments are active. 2017-07-07 0:47:00 140034277914496 [Note] InnoDB: Creating shared tablespace for temporary tables 2017-07-07 0:47:00 140034277914496 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2017-07-07 0:47:00 140034277914496 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2017-07-07 0:47:00 140034277914496 [Note] InnoDB: Waiting for purge to start 2017-07-07 0:47:00 140034277914496 [Note] InnoDB: 5.7.14 started; log sequence number 136877173 2017-07-07 0:47:00 140033382151936 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2017-07-07 0:47:00 140033382151936 [Note] InnoDB: Buffer pool(s) load completed at 170707 0:47:00 2017-07-07 0:47:00 140034277914496 [Note] Plugin 'FEEDBACK' is disabled. 2017-07-07 0:47:00 140034277914496 [ERROR] /usr/sbin/mysqld: unknown variable 'password=xSdjrcKrwIByHu9l2w' 2017-07-07 0:47:00 140034277914496 [ERROR] Aborting Job for mariadb.service failed. See 'systemctl status mariadb.service' and 'journalctl -xn' for details. invoke-rc.d: initscript mysql, action "start" failed. dpkg: error processing package mariadb-server-10.2 (--configure): subprocess installed post-installation script returned error exit status 1 Setting up libmysqlclient18 (10.2.6+maria~jessie) ... Setting up libdbd-mysql-perl (4.028-2+deb8u2) ... Setting up mariadb-client (10.2.6+maria~jessie) ... dpkg: dependency problems prevent configuration of mariadb-server: mariadb-server depends on mariadb-server-10.2 (>= 10.2.6+maria~jessie); however: Package mariadb-server-10.2 is not configured yet. dpkg: error processing package mariadb-server (--configure): dependency problems - leaving unconfigured Processing triggers for libc-bin (2.19-18+deb8u10) ...
If I do not enter a password for the user (leave it blank), then the the error changes to:
Setting up mariadb-server-10.2 (10.2.6+maria~jessie) ... Job for mariadb.service failed. See 'systemctl status mariadb.service' and 'journalctl -xn' for details. invoke-rc.d: initscript mysql, action "start" failed. dpkg: error processing package mariadb-server-10.2 (--configure): subprocess installed post-installation script returned error exit status 1 Setting up libmysqlclient18 (10.2.6+maria~jessie) ... Setting up libdbd-mysql-perl (4.028-2+deb8u2) ... Setting up mariadb-client (10.2.6+maria~jessie) ... dpkg: dependency problems prevent configuration of mariadb-server: mariadb-server depends on mariadb-server-10.2 (>= 10.2.6+maria~jessie); however: Package mariadb-server-10.2 is not configured yet. dpkg: error processing package mariadb-server (--configure): dependency problems - leaving unconfigured Processing triggers for libc-bin (2.19-18+deb8u10) ...
Please help, been trying to get it working for a few hours now.
Answer Answered by kanika satija in this comment.
solution:-
Please follow below commands to solve the issue :-
1) sudo apt-get remove --purge mariadb-server mariadb-client 2) sudo apt-get autoremove 3) sudo apt-get autoclean 4) sudo apt-get install mariadb-server mariadb-client
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.