MySQL Startup

thegluups · 10-16-2011, 10:54 AM

Hey,

I'm currently running Ubuntu. When I attempt to install mysql from source, I get the following error
(I ran cmake . and make make install, followed by the db-install script)

Code:

/usr/local/mysql/bin$ ./mysqld
./mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
111016 16:36:54 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
111016 16:36:54 InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
111016 16:36:54 InnoDB: The InnoDB memory heap is disabled
111016 16:36:54 InnoDB: Mutexes and rw_locks use GCC atomic builtins
111016 16:36:54 InnoDB: Compressed tables use zlib 1.2.3.4
111016 16:36:54 InnoDB: Initializing buffer pool, size = 128.0M
111016 16:36:54 InnoDB: Completed initialization of buffer pool
111016 16:36:54  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: 'open'.
InnoDB: Cannot continue operation.

The contents of /var/lib/mysql are
debian-5.1.flag ibdata1 ib_logfile0 ib_logfile1 mysql mysql_upgrade_info phpmyadmin test (all set to owner/group mysql)

Contents of /usr/local/mysql/bin
init.txt myisampack mysql-bin.index mysql_convert_table_format mysql_find_rows mysqlshow mysql_zap
innochecksum my_print_defaults mysqlbinlog mysqld mysql_fix_extensions mysqlslap perror
msql2mysql mysql mysqlbug mysqld_multi mysqlhotcopy mysqltest replace
myisamchk mysqlaccess mysqlcheck mysqld_safe mysqlimport mysql_tzinfo_to_sql resolveip
myisam_ftdump mysqlaccess.conf mysql_client_test mysqldump mysql_secure_installation mysql_upgrade resolve_stack_dump
myisamlog mysqladmin mysql_config mysqldumpslow mysql_setpermission mysql_waitpid

and contents of /usr/local/mysql/data are
ibdata1 ib_logfile0 ib_logfile1 mysql mysql-bin.index performance_schema test my-laptop.err
(permissions in all cases are mysql mysql)

Any help would be much appreciated!!

Snark1994 · 10-16-2011, 11:25 AM

Well, have you tried running "mysql_upgrade" like it asks you to do?

thegluups · 10-16-2011, 01:24 PM

That won't work unless the server is actually running, and the errors above prevent that.

But basically, all the correct files seem to be located in /usr/local/mysql/data but, despite the permissions saying that the files belong to mysql, it doesn't work. (I solved a similar problem to finding plugin.frm by putting it in /usr/local/mysql/bin

sundialsvcs · 10-16-2011, 01:38 PM

You need to address this problem in three steps:

First, determine that the build-from-source actually succeeded: that all of the expected libraries and executables were, in fact, built, and that they are placed where you expect them to be.
Next, verify (don't assume...) that the command you're using to invoke the executable does, in fact, invoke that executable and that it does so under the user-id and group-id that you expect.
Finally, verify the MySQL configuration files. It is easily possible that the make install step replaced some values in such files. (Easily remedied by just restoring that file from the back... uhhh...)

"Trust, but verify." At each step, determine for yourself exactly what the expected outcome should be, and then visually and methodically inspect the present situation to see that it is. I suggest that you grab a legal pad and maintain a journal of the process. Then, file the notes away where you can actually find them again.