Puppy Linux Discussion Forum Forum Index Puppy Linux Discussion Forum
Puppy HOME page : puppylinux.com
"THE" alternative forum : puppylinux.info
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

The time now is Tue 25 Sep 2018, 02:51
All times are UTC - 4
 Forum index » House Training » HOWTO ( Solutions )
How I resolved Mariadb first installation issues
Moderators: Flash, Ian, JohnMurga
Post new topic   Reply to topic View previous topic :: View next topic
Page 1 of 1 [2 Posts]  
Author Message
kachro

Joined: 23 Nov 2013
Posts: 1

PostPosted: Sun 17 Jun 2018, 06:33    Post subject:  How I resolved Mariadb first installation issues
Subject description: Information on some issues and options you may try to resolve them
 

Slacko Puppy 6.3

5.5.32-MariaDB-30.2

I was doing a first time install of Puppy and MariaDB

I had issues getting to a clean setup which others may hit so here is some info that could help. The information is available on various sites and I found resolutions by trial and error on options others had suggested.

I used Puppy Package Manager to install MariaDB

PATH variable was updated by the install and I did not have to change it

These are the directories used by MariaDB on Puppy installations:

/etc/my.cnf.d (config files)
/var/lib/mysql (logs....)
/var/run/mysql (mysql.sock....)
/usr/bin (execs and scripts - mysqld_safe; mysql_config...)
/usr/lib/mysql/plugin
/usr/share/mysql (examples, templates?)

Set Owner 'mysql' and Group 'root' on the directories. (May have security implications)

Copied an appropriate template /usr/share/mysql/my_xxxx.cnf to my.cnf in /etc/my.cnf.d

Used this option to start mysqld. It started, but with table errors reported in the log.
mysqld_safe --skip-grant-table

Initially tried to
mysql_upgrade
but that failed - 'FATAL ERROR: Upgrade failed'

Recreated mysql table with
mysql_install_db --user=mysql
which ran OK.

Reran
mysql_upgrade
which also ran OK

Started
mysqld_safe
with no errors


180617 11:47:31 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
180617 11:47:31 InnoDB: The InnoDB memory heap is disabled
180617 11:47:31 InnoDB: Mutexes and rw_locks use GCC atomic builtins
180617 11:47:31 InnoDB: Compressed tables use zlib 1.2.6
180617 11:47:31 InnoDB: Using Linux native AIO
180617 11:47:31 InnoDB: Initializing buffer pool, size = 256.0M
180617 11:47:31 InnoDB: Completed initialization of buffer pool
180617 11:47:31 InnoDB: highest supported file format is Barracuda.
180617 11:47:31 InnoDB: Waiting for the background threads to start
180617 11:47:32 Percona XtraDB (http://www.percona.com) 5.5.32-MariaDB-30.2 started; log sequence number 1597971
180617 11:47:32 [Note] Plugin 'FEEDBACK' is disabled.
180617 11:47:32 [Note] Server socket created on IP: '0.0.0.0'.
180617 11:47:32 [Note] Event Scheduler: Loaded 0 events
180617 11:47:32 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.32-MariaDB-log' socket: '/var/run/mysql/mysql.sock' port: 3306 MariaDB Server

Hope it helps!
Back to top
View user's profile Send private message 
rockedge


Joined: 11 Apr 2012
Posts: 813
Location: Connecticut, United States

PostPosted: Fri 29 Jun 2018, 11:45    Post subject:  

I have to add the user "mysql" before installation of mariadb and I need to create /var/run/mysqld and set the directory permissions to the user "mysql" this I did also for the mysql installation.

Code:
#adduser mysql


I run Hiawatha 10.8.1 mariaDB PHP 7.2.5 on Tahr or Xenial and now Bionic.
This is for systems that will run ZoneMinder
I install Apache (if not using Hiawatha) and all the LAMP compnonts with the PPM except for Hiawatha which I download and install the Debian .deb version with petget
Back to top
View user's profile Send private message Visit poster's website 
Display posts from previous:   Sort by:   
Page 1 of 1 [2 Posts]  
Post new topic   Reply to topic View previous topic :: View next topic
 Forum index » House Training » HOWTO ( Solutions )
Jump to:  

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum


Powered by phpBB © 2001, 2005 phpBB Group
[ Time: 0.0318s ][ Queries: 12 (0.0052s) ][ GZIP on ]