Page 1 of 1

[solved]Phpmyadmin won't start

PostPosted: 13. June 2012 15:44
by gimbgimb
Hi Apache Friends,

I'm grateful in advance if anyone can help me on this one.

I've been using Xampp for some time now with no issues. Today my computer restarted after I changed a windows setting (unrelated to xampp) - with Xampp (Apache and MySql) running. After restart I am not able to open Phpmyadmin. The error I see is
"Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly."

MySql and Apache both start OK and I am able to run my applications. I just can't open Phpmyadmin because of the above error.

The Mysql log files shows:

120613 22:07:10 [Note] Plugin 'FEDERATED' is disabled.
120613 22:07:10 InnoDB: The InnoDB memory heap is disabled
120613 22:07:10 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120613 22:07:10 InnoDB: Compressed tables use zlib 1.2.3
120613 22:07:10 InnoDB: Initializing buffer pool, size = 16.0M
120613 22:07:10 InnoDB: Completed initialization of buffer pool
120613 22:07:10 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
120613 22:07:10 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...
120613 22:07:11 InnoDB: Waiting for the background threads to start
120613 22:07:12 InnoDB: 1.1.8 started; log sequence number 193066342
120613 22:07:12 [Note] Event Scheduler: Loaded 0 events
120613 22:07:12 [Note] mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.16' socket: '' port: 3306 MySQL Community Server (GPL)
120613 22:08:16 [Note] Plugin 'FEDERATED' is disabled.
120613 22:08:16 InnoDB: The InnoDB memory heap is disabled
120613 22:08:16 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120613 22:08:16 InnoDB: Compressed tables use zlib 1.2.3
120613 22:08:16 InnoDB: Initializing buffer pool, size = 16.0M
120613 22:08:16 InnoDB: Completed initialization of buffer pool
120613 22:08:16 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
120613 22:08:16 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...
120613 22:08:17 InnoDB: Waiting for the background threads to start
120613 22:08:18 InnoDB: 1.1.8 started; log sequence number 193066342
120613 22:08:18 [Note] Event Scheduler: Loaded 0 events
120613 22:08:18 [Note] mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.16' socket: '' port: 3306 MySQL Community Server (GPL)
120613 22:09:35 [Note] Plugin 'FEDERATED' is disabled.
120613 22:09:35 InnoDB: The InnoDB memory heap is disabled
120613 22:09:35 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120613 22:09:35 InnoDB: Compressed tables use zlib 1.2.3
120613 22:09:35 InnoDB: Initializing buffer pool, size = 16.0M
120613 22:09:35 InnoDB: Completed initialization of buffer pool
120613 22:09:35 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
120613 22:09:35 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...
120613 22:09:36 InnoDB: Waiting for the background threads to start
120613 22:09:37 InnoDB: 1.1.8 started; log sequence number 193066342
120613 22:09:37 [Note] Event Scheduler: Loaded 0 events
120613 22:09:37 [Note] mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.16' socket: '' port: 3306 MySQL Community Server (GPL)

It seems this same log sequence has been occuring for some weeks now so I am not sure that is the issue.

Are there any other log files I need to check? I haven't changed any config settings or passwords in some months.

Any help at all would be appreciated as I am trying to avoid having to dump this Xampp install and start again.

Gen

Re: Phpmyadmin won't start

PostPosted: 13. June 2012 17:22
by JonB
Was the Windows change an IE or browser change???

Like maybe cleaning out cookies or disabling them, or installing a firewall/AV ?

:?:

Re: Phpmyadmin won't start

PostPosted: 13. June 2012 17:29
by Altrea
Hi Gen,

Please try following possible solutions:
  • delete your browser cookies
  • Read out in your \xampp\php\php.ini file your session.save_path (by default it should be something like C/xampp/tmp) and check if this folder
    • exists
    • is readable and writable for Apache
  • Stop your Apache, remove all sessions in your session.save_path folder and restart it again

best wishes,
Altrea

Re: Phpmyadmin won't start

PostPosted: 14. June 2012 05:25
by gimbgimb
Clearing the cache, history and cookies resolved the issue. The config setting I was changing was the "locale" in Windows. In hindsight this should have been patently obvious that it was a browser issue. Obviously I should have just gone to bed instead of banging my head against the wall until all hours of the night. Thanks to Altrea and JonB for your replies.

Re: [solved]Phpmyadmin won't start

PostPosted: 14. June 2012 07:12
by JonB
We are glad you got it resolved...

Good Luck with your project.
8)

Re: [solved]Phpmyadmin won't start

PostPosted: 18. July 2013 09:51
by Beltran
Thanks for reporting it. We have just published a new version for OS X that fixes this issue: 1.8.2-1.