[MDEV-15142] mariaDB starting error Created: 2018-01-31  Updated: 2018-01-31  Resolved: 2018-01-31

Status: Closed
Project: MariaDB Server
Component/s: Packaging
Fix Version/s: N/A

Type: Task Priority: Blocker
Reporter: Jose Eslava Assignee: Unassigned
Resolution: Won't Do Votes: 0
Labels: None

Attachments: PNG File error_console.PNG     PNG File mysqld_safe_helper.PNG     PNG File patch.PNG    
Issue Links:
Blocks
blocks MDEV-14044 mysql_safe_helper not found Closed

 Description   

Hello,

I am currently triing to use MySQL on a Yocto based distribution.
My yocto branch is pyro and my target is imx7. Just for information I am using this repository https://github.com/varigit/variscite-bsp-platform.git

I have added ${bindir}/mysqld_safe_helper to FILES_${PN}-server on meta-openembedded/meta-oe/recipes-support/mysql/mariadb.inc

I am using 0001-disable-ucontext-on-musl.patch patch as recommended by post : https://jira.mariadb.org/browse/MDEV-14044

I generated the image and I tried to boot with his new image, but I got the following error:

**180130 20:00:37 [Note] /usr/sbin/mysqld (mysqld 5.5.55-MariaDB) starting as process 916 ...
180130 20:00:38 [Note] /usr/sbin/mysqld (mysqld 5.5.55-MariaDB) starting as process 925 ...

PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
To do so, start the server, then issue the following commands:

'/usr/bin/mysqladmin' -u root password 'new-password'
'/usr/bin/mysqladmin' -u root -h imx7-var-som password 'new-password'

Alternatively you can run:
'/usr/bin/mysql_secure_installation'

which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.

See the MariaDB Knowledgebase at http://mariadb.com/kb or the
MySQL manual for more instructions.

Please report any problems at http://mariadb.org/jira

The latest information about MariaDB is available at http://mariadb.org/.
You can find additional information about the MySQL part at:
http://dev.mysql.com
Consider joining MariaDB's strong and vibrant community:
https://mariadb.org/get-involved/

done.
Starting MySQL.180130 20:00:39 mysqld_safe Logging to '/var/log/mysqld.err'.
180130 20:00:39 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/usr/bin/mysqld_safe_helper: Can't create/write to file '/var/log/mysqld.err' (Errcode: 13)
ERROR!
*
*
Do you have any suggestion please?

Regards.



 Comments   
Comment by Daniel Black [ 2018-01-31 ]

http://cgit.openembedded.org/meta-openembedded/tree/meta-oe/recipes-support/mysql/mariadb/my.cnf?h=pyro

log-error is /var/log/mysqld.err however mysql user is the user for mariadb. This user doesn't have write access to /var/log.

This should be reported to yocto to fix.

Comment by Daniel Black [ 2018-01-31 ]

closing as its Yocto's bug in their packaging of MariaDB.

Generated at Thu Feb 08 08:19:00 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.