|
|
|
|
|||||||
| BSD BSD, sometimes called Berkeley Unix, is a Unix operating system developed by the Computer Systems Research Group of the UC Berkeley. |
 |
|
|
Submit Tools | LinkBack | Thread Tools | Display Modes |
05-04-2005
|
||||
|
||||
|
mysqld
Hello
I installed mysql41 this is the end of the installation Quote:
Quote:
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 
|
| Forum Sponsor | ||
|
|
|
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!
|
|
05-05-2005
|
||||
|
||||
|
the right way
Thanks
I will follow those steps  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# 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 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 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 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 don't understand why I have to chmod 777 mysql whereas a 700 should be enough  Last edited by SoulCoder; 05-05-2005 at 04:48 AM.
|
|
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 ~
|
|
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 10:11 AM.
|
||||
| Google UNIX.COM |
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
