Arch Linux

Mazdaspeed6

Member

Registered: 2011-10-12

Posts: 12

(SOLVED) My SQL wont start

So im in the process of setting up cherokee, ,PHP and MYSQL and i think i have the first 2 working but as for my sql it wont start. i run /etc/rc.d/mysqld start and it sits for a while and then fails. I followed the wiki article to set it up but it doest work. Im sure there is a log somewhere if it needs to be uploaded let me know. i did uncomment the lines for php.ini.

Last edited by Mazdaspeed6 (2011-12-18 00:47:45)

wonder

Developer

From: Bucharest, Romania

Registered: 2006-07-05

Posts: 5,941

Website

Re: (SOLVED) My SQL wont start

check the the .err file from /var/lib/mysql/

---

Give what you have. To someone, it may be better than you dare to think.

Mazdaspeed6

Member

Registered: 2011-10-12

Posts: 12

Re: (SOLVED) My SQL wont start

check the the .err file from /var/lib/mysql/

There is only a mysql-bin.index in that folder. No err file

Mazdaspeed6

Member

Registered: 2011-10-12

Posts: 12

Re: (SOLVED) My SQL wont start

actually i was looking in the wrong path, here is the log entry that is repeated several times:

111212 16:01:11 mysqld_safe mysqld from pid file /var/lib/mysql/.pid ended
111212 16:58:42 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
111212 16:58:42 InnoDB: The InnoDB memory heap is disabled
111212 16:58:43 InnoDB: Mutexes and rw_locks use GCC atomic builtins
111212 16:58:43 InnoDB: Compressed tables use zlib 1.2.5
111212 16:58:43 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(135987200 bytes) failed; errno 12
111212 16:58:43 InnoDB: Completed initialization of buffer pool
111212 16:58:43 InnoDB: Fatal error: cannot allocate memory for the buffer pool
111212 16:58:43 [ERROR] Plugin 'InnoDB' init function returned error.
111212 16:58:43 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
111212 16:58:43 [ERROR] Unknown/unsupported storage engine: InnoDB
111212 16:58:43 [ERROR] Aborting

loafer

Member

From: the pub

Registered: 2009-04-14

Posts: 1,772

Re: (SOLVED) My SQL wont start

There is an identical thread here with some links.  It isn't marked solved so I do not know if the suggestions will work:

https://bbs.archlinux.org/viewtopic.php?id=125082

---

All men have stood for freedom...
For freedom is the man that will turn the world upside down.
Gerrard Winstanley.

Mazdaspeed6

Member

Registered: 2011-10-12

Posts: 12

Re: (SOLVED) My SQL wont start

That did it! it starts up and seems to be working from within the cherokee portal.