Login or Register to Ask a Question and Join Our Community


BSD

mysqld

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Operating Systems BSD mysqld
# 1  
Old 05-04-2005
mysqld
Hello

I installed mysql41 this is the end of the installation
Quote:
You already have a group "mysql", so I will use it.
mysql:*:88:88::0:0:MySQL Daemon:/var/db/mysql:/sbin/nologin
You already have a user "mysql", so I will use it.
===> Compressing manual pages for mysql-server-4.1.11_1
===> Registering installation for mysql-server-4.1.11_1
===> SECURITY REPORT:
This port has installed the following files which may act as network
servers and may therefore pose a remote security risk to the system.
/usr/local/libexec/mysqld

If there are vulnerabilities in these programs there may be a security
risk to the system. FreeBSD makes no guarantee about the security of
ports included in the Ports Collection. Please type 'make deinstall'
to deinstall the port if this is a concern.

For more information, and contact details about the security
status of this software, see the following webpage:
http://www.mysql.com/
but when I try to launch the mysqld daemon it write this:
Quote:
$ /usr/local/libexec/mysqld
050504 15:31:13 [Warning] Can't create test file /var/db/mysql/Lodelservoo.lower-test
/usr/local/libexec/mysqld: Can't change dir to '/var/db/mysql/' (Errcode: 13)
050504 15:31:13 [ERROR] Aborting

050504 15:31:13 [Note] /usr/local/libexec/mysqld: Shutdown complete
note: LodelServoo is a CMS which need mysql


I verify that the dir mysql existed under /var/db, but it doesn't so naively I created it and launch again the mysqld but each time i have the same error message.

If someone know something about it he is welcoming

Thanks in advance
# 2  
Old 05-04-2005
You really don't need to call /usr/local/libexec/mysqld directly.

see man mysqld_safe(1)

you also need to run /usr/local/bin/mysql_install_db to install the initial db file structure.

in order to start mysqld for the first time, I did:

# /usr/local/bin/mysqld_safe --user=mysql --dbdir=/path/to/my/db

then secured the initial accounts, etc, etc, etc. This stuff is all covered in the MySQL manual, which should be installed on your system in several formats in:

/usr/local/share/doc/mysql

Good luck!
# 3  
Old 05-05-2005
the right way
Thanks

I will follow those steps

Smilie

Well,

I reinstall the port mysql41-server, but I have still nothing like mysql-server.sh under /usr/local/etc/rc.d/

Nevermind I follow instruction you give me

First the mysql_install_db
Code:
Lodelservoo# /usr/local/bin/mysql_install_db
Installing all prepared tables
Fill help tables

To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/local/bin/mysqladmin -u root password 'new-password'
/usr/local/bin/mysqladmin -u root -h Lodelservoo.workgroup password 'new-password'
See the manual for more instructions.

You can start the MySQL daemon with:
cd /usr/local ; /usr/local/bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the /usr/local/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com
Lodelservoo#

Now Under /var/db/mysql there is two dir : mysql and test

I go under test and I launch mysqld_safe
Code:
Lodelservoo# /usr/local/bin/mysqld_safe --user=mysql
Starting mysqld daemon with databases from /var/db/mysql
STOPPING server from pid file /var/db/mysql/Lodelservoo.workgroup.pid
050505 13:18:22  mysqld ended

So I watch in the Lodelservoo.workgroup.err logfile
Code:
Lodelservoo# vi Lodelservoo.workgroup.err 

050505 13:18:22  mysqld started
050505 13:18:22 [ERROR] bdb:  /var/db/mysql: Permission denied
050505 13:18:22 [ERROR] bdb:  /var/db/mysql/log.0000000001: Permission denied
050505 13:18:22 [ERROR] bdb:  PANIC: Permission denied
050505 13:18:22 [ERROR] bdb:  PANIC: DB_RUNRECOVERY: Fatal error, run database recovery
050505 13:18:22 [ERROR] bdb:  fatal region error detected; run recovery
050505 13:18:22 [ERROR] bdb:  /var/db/mysql: Permission denied
050505 13:18:22  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
050505 13:18:22  mysqld ended

then I chmod 777 /var/db/mysql

and I try again the mysqld_safe
Code:
Lodelservoo# /usr/local/bin/mysqld_safe --user=mysql
Starting mysqld daemon with databases from /var/db/mysql
STOPPING server from pid file /var/db/mysql/Lodelservoo.workgroup.pid
050505 13:22:01  mysqld ended

So I watch one more time in the Lodelservoo.workgroup.err logfile
Code:
Lodelservoo# vi Lodelservoo.workgroup.err

050505 13:22:00  mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
050505 13:22:00  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
050505 13:22:01  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
050505 13:22:01  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
050505 13:22:01  InnoDB: Started; log sequence number 0 0
050505 13:22:01 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
050505 13:22:01 [ERROR] Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno:
13)
050505 13:22:01  mysqld ended

I am lost, I don't understand why it can't find the host.rfm whereas I launch mysqld_safe in the work directory /var/db/mysql/test and the host.frm exist at this place /var/db/mysql/mysql/host.frm

I don't understand why I have to chmod 777 mysql whereas a 700 should be enough Smilie
Last edited by SoulCoder; 05-05-2005 at 08:48 AM..
# 4  
Old 05-05-2005
YES :P

I found an answer at this url http://sunsite.mff.cuni.cz/MIRRORS/f...ng_server.html

Posted by davidhj@mail.com on Tuesday January 29 2002, @8:30am [Delete] [Edit]
If your error log file has something like:

Can't find file: './mysql/host.frm' (errno: 13)

, and you've tried setting
--datadir=/path/to/my/data/directory but you
still get the same error, it may be because the
databases installed in the mysql data directory
(usually /var/lib/mysql) are not owned by the
mysql daemon, but by the user who ran
mysql_install_db. chown them to mysql and chgrp
them to the appropriate group e.g.

chown -R mysql /var/lib/mysql/mysql
chgrp -R daemons /var/lib/mysql/mysql


And now the mysqld daeomn run
the content of the logfile is
Code:
050505 15:40:03  mysqld started
050505 15:40:04  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
050505 15:40:04  InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 43634.
InnoDB: Doing recovery: scanned up to log sequence number 0 43634
050505 15:40:04  InnoDB: Flushing modified pages from the buffer pool...
050505 15:40:04  InnoDB: Started; log sequence number 0 43634
/usr/local/libexec/mysqld: ready for connections.
Version: '4.1.11'  socket: '/tmp/mysql.sock'  port: 3306  FreeBSD port: mysql-server-4.1.11_1
~

Thanks everybody
# 5  
Old 05-06-2005
Hello, I have the problem that mysql wont start at boot.

First, even after the install of mysql41-server ports there was no /usr/local/etc/rc.d/mysql-server.sh
So Naevely I copy the /usr/ports/database/mysql41-server/files/mysql-server.in.sh at the usual place /usr/local/etc/rc.d/, then I wrote mysql_enable="YES" in the rc.conf. The result is nothing, I'm still having to start mysql manually by /usr/local/bin/mysqld_safe
Does some one know something about it

Thanks in advance

I install from scratch all the installation, the mysqld-server is at the right place and now it's run well

Special thanks to Jolko for his help

this topic can be close
Last edited by SoulCoder; 05-11-2005 at 02:11 PM..
Login or Register to Ask a Question

Previous Thread | Next Thread

5 More Discussions You Might Find Interesting

1. Homework & Coursework Questions

Mysql missing mysqld.sock (Linux)

I am trying to start a server for a class I am in but... mysql won't start with this error ( ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) ) ---------- Post updated at 03:51 PM ---------- Previous update was at 03:50 PM ---------- ... (2 Replies)
Discussion started by: Slayer939
2 Replies

2. Programming

PHP exec to restart mysqld

I want to do something very very bad. I want to create a button that restarts mysqld. Why is irrelevant for my issue. Here is my php script ... <?php if(isset($_POST)){ exec("sudo /etc/init.d/mysqld restart"); } ?> <form method="POST"> <input type="submit" name="restart"... (3 Replies)
Discussion started by: noPermissions
3 Replies

3. Red Hat

MySQL (mysqld) fails to start!

Hello, I have recently installed MySql and I encourage an error. I am using Fedora 15 and when I am trying to start mysqld service i am getting the following error message: Starting mysqld (via systemctl): Job failed. See system logs and 'systemctl status' for details. If I try to start it... (4 Replies)
Discussion started by: dot_pro
4 Replies

4. UNIX for Dummies Questions & Answers

mysqld overloading cpu of VPS

Hi bros I have a VPS 512mb (Burst 2GB) with Kloxo installed and hosting few sites on it with not much traffic I am facing high cpu load for the last few days and seems mysqld is overloading the cpu Any suggestion will be appreciated Regards Rizwan Top output is as under top -... (2 Replies)
Discussion started by: rizwan65
2 Replies

5. Red Hat

comm: mysqld Not tainted ... Kernel Panic , System totally unresponsive

Hi, I am experiencing frequent system hangs, hard kernel panics, etc almost thrice a day. The system would be totally unresponsive and the only way is to reboot is hard power recycling (plug out the power cable and plug in back after 30 secs). I enabled kdump, but unfortunately the kdump files... (3 Replies)
Discussion started by: massoo
3 Replies
Login or Register to Ask a Question