Page 1 of 2

phpmyadmin blank page

Posted: Sat Jan 24, 2015 4:36 pm
by rainh
Hello

I'm facing strange problem. My http://my_ip/phpmyadmin/ showing just blank white page! but all database is working fine. when I restart httpd it loads properly but after few minutes it is showing just blank white page so every time I need to enter phpmyadmin I have to restart httpd first! can any tell me how to fix this? my server has 8gb memory and I set 512mb memory limit in php.ini.

Thanks

Re: phpmyadmin blank page

Posted: Sat Jan 24, 2015 7:28 pm
by skurudo
It can be several problems... a lot logs say, can you show us error_log? - /var/log/apache2

For debagging, after you see blank screen, try in console:
cd /usr/share/phpmyadmin
php index.php

It may be problem with apc/xcache mod and others... logs, please, how logs )

Re: phpmyadmin blank page

Posted: Sun Jan 25, 2015 1:11 am
by rainh
Hello

I didn't find /var/log/apache2 my OS is cent OS 6.5 64bit. beloww is the last few lines from /var/log/httpd/error_log

[Fri Jan 23 11:08:24 2015] [notice] caught SIGTERM, shutting down
[Fri Jan 23 11:08:25 2015] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Fri Jan 23 11:08:25 2015] [notice] Digest: generating secret for digest authentication ...
[Fri Jan 23 11:08:25 2015] [notice] Digest: done
[Fri Jan 23 11:08:25 2015] [notice] mod_ruid2/0.9.4 enabled
[Fri Jan 23 11:08:25 2015] [notice] Apache/2.2.15 (Unix) DAV/2 mod_fcgid/2.3.9 PHP/5.3.3 mod_ssl/2.2.15 OpenSSL/1.0.0-fips configured -- resuming normal operations
[Fri Jan 23 20:24:26 2015] [notice] caught SIGTERM, shutting down
[Fri Jan 23 20:24:27 2015] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Fri Jan 23 20:24:27 2015] [notice] Digest: generating secret for digest authentication ...
[Fri Jan 23 20:24:27 2015] [notice] Digest: done
[Fri Jan 23 20:24:27 2015] [notice] mod_ruid2/0.9.4 enabled
[Fri Jan 23 20:24:27 2015] [notice] Apache/2.2.15 (Unix) DAV/2 mod_fcgid/2.3.9 PHP/5.3.3 mod_ssl/2.2.15 OpenSSL/1.0.0-fips configured -- resuming normal operations
[Fri Jan 23 21:01:39 2015] [notice] caught SIGTERM, shutting down
[Fri Jan 23 21:01:40 2015] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Fri Jan 23 21:01:40 2015] [notice] Digest: generating secret for digest authentication ...
[Fri Jan 23 21:01:40 2015] [notice] Digest: done
[Fri Jan 23 21:01:40 2015] [notice] mod_ruid2/0.9.4 enabled
[Fri Jan 23 21:01:40 2015] [notice] Apache/2.2.15 (Unix) DAV/2 mod_fcgid/2.3.9 PHP/5.3.3 mod_ssl/2.2.15 OpenSSL/1.0.0-fips configured -- resuming normal operations
[Sat Jan 24 06:33:01 2015] [notice] caught SIGTERM, shutting down
[Sat Jan 24 06:33:02 2015] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Sat Jan 24 06:33:02 2015] [notice] Digest: generating secret for digest authentication ...
[Sat Jan 24 06:33:02 2015] [notice] Digest: done
[Sat Jan 24 06:33:02 2015] [notice] mod_ruid2/0.9.4 enabled
[Sat Jan 24 06:33:02 2015] [notice] Apache/2.2.15 (Unix) DAV/2 mod_fcgid/2.3.9 PHP/5.3.3 mod_ssl/2.2.15 OpenSSL/1.0.0-fips configured -- resuming normal operations
[Sat Jan 24 11:25:39 2015] [notice] caught SIGTERM, shutting down
[Sat Jan 24 11:25:40 2015] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Sat Jan 24 11:25:40 2015] [notice] Digest: generating secret for digest authentication ...
[Sat Jan 24 11:25:40 2015] [notice] Digest: done
[Sat Jan 24 11:25:40 2015] [notice] mod_ruid2/0.9.4 enabled
[Sat Jan 24 11:25:40 2015] [notice] Apache/2.2.15 (Unix) DAV/2 mod_fcgid/2.3.9 PHP/5.3.3 mod_ssl/2.2.15 OpenSSL/1.0.0-fips configured -- resuming normal operations
[Sat Jan 24 11:41:00 2015] [notice] caught SIGTERM, shutting down
[Sat Jan 24 11:41:01 2015] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Sat Jan 24 11:41:01 2015] [notice] Digest: generating secret for digest authentication ...
[Sat Jan 24 11:41:01 2015] [notice] Digest: done
[Sat Jan 24 11:41:01 2015] [notice] mod_ruid2/0.9.4 enabled
[Sat Jan 24 11:41:01 2015] [notice] Apache/2.2.15 (Unix) DAV/2 mod_fcgid/2.3.9 PHP/5.3.3 mod_ssl/2.2.15 OpenSSL/1.0.0-fips configured -- resuming normal operations

Re: phpmyadmin blank page

Posted: Mon Jan 26, 2015 3:18 am
by rainh
No solution? I think there is some easy solution cause everything is ok, after restating httpd phpmyadmin loading fine but sometime later it shows again blank white page. where to increase memory usage for phpmyadmin?

Re: phpmyadmin blank page

Posted: Thu Jan 29, 2015 1:08 am
by rainh
Hello

I'm still looking for solutions. I realize when httpd cpu usage going over 10% and memory over 5000mb it is showing blank phpmyadmin page! any idea?

Re: phpmyadmin blank page

Posted: Thu Jan 29, 2015 4:53 am
by joem
rainh wrote:Hello

I'm still looking for solutions. I realize when httpd cpu usage going over 10% and memory over 5000mb it is showing blank phpmyadmin page! any idea?

Is mysql crashing too, or just phpmyadmin? Also what does this error log say? /var/log/mysqld.log

Re: phpmyadmin blank page

Posted: Thu Jan 29, 2015 4:14 pm
by rainh
Hello

Mysqld is working fine when my phpmyadmin showing blank page. below is the log file as u asked

150126 12:04:46 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150126 12:04:46 [Note] Plugin 'FEDERATED' is disabled.
150126 12:04:46 InnoDB: The InnoDB memory heap is disabled
150126 12:04:46 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150126 12:04:46 InnoDB: Compressed tables use zlib 1.2.3
150126 12:04:46 InnoDB: Using Linux native AIO
150126 12:04:46 InnoDB: Initializing buffer pool, size = 128.0M
150126 12:04:46 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
150126 12:04:46 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
150126 12:04:46 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...
150126 12:04:46 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: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
150126 12:04:47 InnoDB: Waiting for the background threads to start
150126 12:04:48 InnoDB: 5.5.41 started; log sequence number 0
150126 12:04:48 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
150126 12:04:48 [Note] - '0.0.0.0' resolves to '0.0.0.0';
150126 12:04:48 [Note] Server socket created on IP: '0.0.0.0'.
150126 12:04:48 [Note] Event Scheduler: Loaded 0 events
150126 12:04:48 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.41' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) by Remi
150126 13:04:25 [Warning] IP address '198.13.108.247' could not be resolved: Temporary failure in name resolution
150126 13:04:35 [Warning] IP address '198.13.108.247' could not be resolved: Temporary failure in name resolution
150126 13:04:45 [Warning] IP address '198.13.108.247' could not be resolved: Temporary failure in name resolution
150126 13:04:55 [Warning] IP address '198.13.108.247' could not be resolved: Temporary failure in name resolution
150126 19:22:25 [Warning] IP address '61.147.107.66' could not be resolved: Name or service not known
150127 6:13:20 [Note] /usr/libexec/mysqld: Normal shutdown

150127 6:13:20 [Note] Event Scheduler: Purging the queue. 0 events
150127 6:13:20 InnoDB: Starting shutdown...
150127 6:13:22 InnoDB: Shutdown completed; log sequence number 28170458
150127 6:13:22 [Note] /usr/libexec/mysqld: Shutdown complete

150127 06:13:22 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
150127 06:13:22 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150127 6:13:22 [Note] Plugin 'FEDERATED' is disabled.
150127 6:13:22 InnoDB: The InnoDB memory heap is disabled
150127 6:13:22 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150127 6:13:22 InnoDB: Compressed tables use zlib 1.2.3
150127 6:13:23 InnoDB: Using Linux native AIO
150127 6:13:23 InnoDB: Initializing buffer pool, size = 128.0M
150127 6:13:23 InnoDB: Completed initialization of buffer pool
150127 6:13:23 InnoDB: highest supported file format is Barracuda.
150127 6:13:23 InnoDB: Waiting for the background threads to start
150127 6:13:24 InnoDB: 5.5.41 started; log sequence number 28170458
150127 6:13:24 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
150127 6:13:24 [Note] - '0.0.0.0' resolves to '0.0.0.0';
150127 6:13:24 [Note] Server socket created on IP: '0.0.0.0'.
150127 6:13:24 [Note] Event Scheduler: Loaded 0 events
150127 6:13:24 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.41' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) by Remi
150127 6:17:17 [Note] /usr/libexec/mysqld: Normal shutdown

150127 6:17:17 [Note] Event Scheduler: Purging the queue. 0 events
150127 6:17:17 InnoDB: Starting shutdown...
150127 6:17:19 InnoDB: Shutdown completed; log sequence number 28170468
150127 6:17:19 [Note] /usr/libexec/mysqld: Shutdown complete

150127 06:17:19 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
150127 06:17:19 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150127 6:17:19 [Note] Plugin 'FEDERATED' is disabled.
150127 6:17:19 InnoDB: The InnoDB memory heap is disabled
150127 6:17:19 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150127 6:17:19 InnoDB: Compressed tables use zlib 1.2.3
150127 6:17:19 InnoDB: Using Linux native AIO
150127 6:17:19 InnoDB: Initializing buffer pool, size = 1000.0M
150127 6:17:19 InnoDB: Completed initialization of buffer pool
150127 6:17:19 InnoDB: highest supported file format is Barracuda.
150127 6:17:20 InnoDB: Waiting for the background threads to start
150127 6:17:21 InnoDB: 5.5.41 started; log sequence number 28170468
150127 6:17:21 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
150127 6:17:21 [Note] - '0.0.0.0' resolves to '0.0.0.0';
150127 6:17:21 [Note] Server socket created on IP: '0.0.0.0'.
150127 6:17:21 [Warning] 'proxies_priv' entry '@ [email protected]' ignored in --skip-name-resolve mode.
150127 6:17:21 [Note] Event Scheduler: Loaded 0 events
150127 6:17:21 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.41-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) by Remi
150127 6:18:29 [Note] /usr/libexec/mysqld: Normal shutdown

150127 6:18:29 [Note] Event Scheduler: Purging the queue. 0 events
150127 6:18:29 InnoDB: Starting shutdown...
150127 6:18:30 InnoDB: Shutdown completed; log sequence number 28170478
150127 6:18:30 [Note] /usr/libexec/mysqld: Shutdown complete

150127 06:18:30 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
150127 06:18:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150127 6:18:30 [Note] Plugin 'FEDERATED' is disabled.
150127 6:18:30 InnoDB: The InnoDB memory heap is disabled
150127 6:18:30 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150127 6:18:30 InnoDB: Compressed tables use zlib 1.2.3
150127 6:18:30 InnoDB: Using Linux native AIO
150127 6:18:30 InnoDB: Initializing buffer pool, size = 128.0M
150127 6:18:30 InnoDB: Completed initialization of buffer pool
150127 6:18:30 InnoDB: highest supported file format is Barracuda.
150127 6:18:30 InnoDB: Waiting for the background threads to start
150127 6:18:31 InnoDB: 5.5.41 started; log sequence number 28170478
150127 6:18:31 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
150127 6:18:31 [Note] - '0.0.0.0' resolves to '0.0.0.0';
150127 6:18:31 [Note] Server socket created on IP: '0.0.0.0'.
150127 6:18:31 [Note] Event Scheduler: Loaded 0 events
150127 6:18:31 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.41' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) by Remi
150127 13:35:20 [Warning] IP address '210.212.98.235' could not be resolved: Name or service not known
150128 7:04:50 [Warning] IP address '198.13.108.246' could not be resolved: Temporary failure in name resolution
150128 7:05:00 [Warning] IP address '198.13.108.246' could not be resolved: Temporary failure in name resolution
150128 7:05:10 [Warning] IP address '198.13.108.246' could not be resolved: Temporary failure in name resolution
150128 7:05:20 [Warning] IP address '198.13.108.246' could not be resolved: Temporary failure in name resolution
150128 7:05:31 [Warning] IP address '198.13.108.246' could not be resolved: Temporary failure in name resolution
150128 7:05:41 [Warning] IP address '198.13.108.246' could not be resolved: Temporary failure in name resolution
150128 7:05:51 [Warning] IP address '198.13.108.246' could not be resolved: Temporary failure in name resolution
150128 7:06:01 [Warning] IP address '198.13.108.246' could not be resolved: Temporary failure in name resolution
150128 7:06:12 [Warning] IP address '198.13.108.246' could not be resolved: Temporary failure in name resolution
150128 7:06:23 [Warning] IP address '198.13.108.246' could not be resolved: Temporary failure in name resolution
150128 7:06:33 [Warning] IP address '198.13.108.246' could not be resolved: Temporary failure in name resolution
150128 7:06:43 [Warning] IP address '198.13.108.246' could not be resolved: Temporary failure in name resolution
150129 10:21:17 [Warning] IP address '60.190.132.74' could not be resolved: Name or service not known



let me know what to do in this situation.

Re: phpmyadmin blank page

Posted: Fri Jan 30, 2015 3:09 pm
by rainh
Is here no vestacp expert who can realize my problem!?

Re: phpmyadmin blank page

Posted: Wed Mar 11, 2015 1:15 pm
by rainh
At last I have figure it out and what I thought it is a very easy solution! just changed

/etc/php.d/apc.ini

from apc.shm_size=64M to
apc.shm_size=512M

and problem is solved.

Thanks

Re: phpmyadmin blank page

Posted: Thu Mar 10, 2016 10:33 am
by solitary
check the solution on fixing phpmyadmin blank page here: http://forum.vestacp.com/viewtopic.php?f=11&t=10901