MySQL fail

[abuzed]

Hi everybody,

I'm a new user of Arch Linux, i've installed it on my pogoplug pro.

I've successfully installed nginx, php. Now i'm trying to install mysql from this guide: https://wiki.archlinux.org/index.php/MySQL

The package was sucessfully installed, when I try to launch MySQL ($this->bbcode_second_pass_code('', '/etc/rc.d/mysqld start')) it's return an error:
$this->bbcode_second_pass_code('', ':: Starting MySQL Server [FAIL]')

$this->bbcode_second_pass_code('', 'find /var/log -type f -name '*mysql*'') Return nothing

$this->bbcode_second_pass_code('', 'ps auxw | grep mysql') Return: $this->bbcode_second_pass_code('', 'root 4820 0.0 0.6 5428 876 pts/0 S+ 13:18 0:00 grep mysql')

When I try to kill the processus ($this->bbcode_second_pass_code('', 'killall --wait mysqld')
$this->bbcode_second_pass_code('', '-bash: root: command not found')

My rights of /tmp folder:
$this->bbcode_second_pass_code('', 'drwxrwxrwt 4 root root 4096 Oct 13 13:09 tmp')

I've try:
$this->bbcode_second_pass_code('', '
# chown mysql:mysql /var/lib/mysql -R
# /etc/rc.d/mysql restart
:: Stopping MySQL Server [FAIL]
:: Starting MySQL Server [FAIL]
# tail /var/lib/mysql/alarm.err
111013 13:26:38 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
111013 13:26:39 InnoDB: The InnoDB memory heap is disabled
111013 13:26:39 InnoDB: Mutexes and rw_locks use GCC atomic builtins
111013 13:26:39 InnoDB: Compressed tables use zlib 1.2.5
111013 13:26:39 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(135987200 bytes) failed; errno 12
111013 13:26:39 InnoDB: Completed initialization of buffer pool
111013 13:26:39 InnoDB: Fatal error: cannot allocate memory for the buffer pool
111013 13:26:39 [ERROR] Plugin 'InnoDB' init function returned error.
111013 13:26:39 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
111013 13:26:39 [ERROR] Unknown/unsupported storage engine: InnoDB
111013 13:26:39 [ERROR] Aborting
111013 13:26:39 [Note] /usr/bin/mysqld: Shutdown complete
111013 13:26:39 mysqld_safe mysqld from pid file /var/lib/mysql/alarm.pid ended
')

And:
$this->bbcode_second_pass_code('', '
# mysqld_safe --datadir=/var/lib/mysql/
111013 13:31:23 mysqld_safe Logging to '/var/lib/mysql//alarm.err'.
111013 13:31:24 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql/
111013 13:31:24 mysqld_safe mysqld from pid file /var/lib/mysql//alarm.pid ended
# mysql_upgrade -u root -p
Enter password:
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock' '--port=3306' '--socket=/var/run/mysqld/mysqld.sock'
mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed
')

PS: I'm a newbi on linux

If anybody can help me...

[pepedog]

First
$this->bbcode_second_pass_code('', 'sudo /etc/rc.d/mysqld start && sudo mysql_secure_installation')
Now start it

[abuzed]

Hi pepedog,
$this->bbcode_second_pass_quote('pepedog', 'F')irst
$this->bbcode_second_pass_code('', 'sudo /etc/rc.d/mysqld start && sudo mysql_secure_installation')
Now start it

[gatobait3]

I had an issue that mysql would start but bomb out later with the InnoDB errors. See my post: http://archlinuxarm.org/forum/viewtopic.php?f=15&t=1700 ... it might help

[PKG]

You have to change the InnoDB size to or less than 40% of your ram

[archanox]

Has anyone successfully got this working? What specific changes would one need to make to the my.conf? Specifically for the Goflex Net. It looks like the my.cnf that is preinstalled is the "medium" configuration and is optimised for 128mb of ram, if I try to use the tiny version (64mb) it still fails to start.

There also seems to be a deep rooted problem regarding /tmp permissions within the distro. Not sure if it's a ArchLinux problem, or just an ArchLinux ARM problem. Is anyone else experiencing this problem on a non-PogoPlug based device?

[pepedog]

Advice only if you are running from a hard drive, set a swap drive. Search forum for swapon
I have had no troubles, apart from when the changed to safe start, and no tmp problems as far as I can see.
https://wiki.archlinux.org/index.php/My ... nnot_start

[archanox]

I'm still getting these errors regardless of swap being on or off, the size is 2048 on a 64mb device. I've even tried using the safe start up, but i'm getting tmp problems still.

$this->bbcode_second_pass_code('', '
111028 03:44:36 mysqld_safe Starting mysqld daemon with databases from /var/lib$
/usr/bin/mysqld: Table 'mysql.plugin' doesn't exist
111028 3:44:36 [ERROR] Can't open the mysql.plugin table. Please run mysql_upg$
111028 3:44:36 InnoDB: The InnoDB memory heap is disabled
111028 3:44:36 InnoDB: Mutexes and rw_locks use GCC atomic builtins
111028 3:44:36 InnoDB: Compressed tables use zlib 1.2.5
^G/usr/bin/mysqld: Can't create/write to file '/tmp/ibj5Kb3a' (Errcode: 13)
111028 3:44:37 InnoDB: Error: unable to create temporary file; errno: 13
111028 3:44:37 [ERROR] Plugin 'InnoDB' init function returned error.
111028 3:44:37 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
111028 3:44:37 [ERROR] Unknown/unsupported storage engine: InnoDB
111028 3:44:37 [ERROR] Aborting

111028 3:44:37 [Note] /usr/bin/mysqld: Shutdown complete
')

[pepedog]

One fix is to start mysqld with the --tmpdir option or to add the option to the [mysqld] section of your option file. For example, to specify a directory of C:\temp, use these lines:
http://dev.mysql.com/doc/refman/5.0/en/ ... reate.html
You mention 64 mb device, what's that?

[archanox]

The Goflex Net.

I've already tried moving the /tmp in the my.cnf to just a physical directory but it yielded the same results. The other peculiarity I should mention is that when I chmod the directory to 1777 or 777 as suggested in places, it never actually sets correctly when I go to check it.

Other things I guess I could mention is that I'm running the device off of an ext3 formatted 32G flash drive. Not that I see this being an issue.

I'm guessing these problems stem from /tmp running out of room. So I'm guessing there's an issue with the swap. I followed the swap guide on this site to the T only changing it from a 512mb size to a 2048mb size (seeing as I have the room). Perhaps it's too big? Which doesn't make sense. The only other thing I guess I could attempt is making a swap partition.