You are not logged in.
Hi,
I am running an ArchLinux as my Server. It's a fresh install. I just configured nginx as my Webserver and then configured MySQL. I wanted to use phpMyAdmin as a manager. I installed it via wget and it worked fine. But all of a sudden it would not let me log in anymore. The log in screen just keeps on popping up, without any errors or anything. It tried reinstalling phpMyAdmin, I also tried the alternative chive. In chive I get the error "CDbConnection failed to open the DB connection." I really am at a loss here, has anyone else encountered a similar issue and can point me in the right direction?
Disclaimer: Please excuse my possibly poor english, as it is not my native language, also please excuse any questions that may sound noob-like, because I am quite new to Arch.
Last edited by oengelha (2012-12-15 17:40:09)
Offline
Actually this is not an Arch related question. It seems like your mysql server is down, have you tried connecting from command line?
Offline
Yes, connecting to it from the command-line works just fine.
Offline
What php version are you using? -> php -v
Which php.ini is used? -> php -i | grep php.ini
What's your php.ini tells about "extension_dir"? -> grep extension_dir path/to/your/php.ini
Are correct modules loaded? -> php -m |egrep "mysql|pdo"
Did your problem showed up after an upgrade?
Offline
It pretty much worked on the first few logins, but then suddelny stopped working. I did not really change anything, I maybe did a reboot.
My outputs are:
[root@netzmelone ~]# php -v
PHP 5.4.9 (cli) (built: Nov 23 2012 07:51:32)
Copyright (c) 1997-2012 The PHP Group
Zend Engine v2.4.0, Copyright (c) 1998-2012 Zend Technologies
[root@netzmelone ~]# php -i | grep php.ini
Configuration File (php.ini) Path => /etc/php
Loaded Configuration File => /etc/php/php.ini
[root@netzmelone ~]# grep extension_dir /etc/php/php.ini
extension_dir = "/usr/lib/php/modules/"
; extension_dir = "ext"
;sqlite3.extension_dir =
[root@netzmelone ~]# php -m |egrep "mysql|pdo"
mysql
mysqli
mysqlnd
pdo_mysql
Last edited by oengelha (2012-12-10 14:54:40)
Offline
Looks fine, may you pastebin your nginx logs please?
Offline
Okay, heres my logs: they are pretty fresh, since i did not enable them before. http://pastebin.com/XpkXKhy7 Additionally, I have once again trieb to install phpMyAdmin, but now i get this error:
Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly.
and also this error:
The mysqli extension is missing. Please check your PHP configuration. <a href="Documentation.html#faqmysql" target="documentation"><img src="themes/dot.gif" title="Documentation" alt="Documentation" class="icon ic_b_help" /></a>
This cant't be right, since I do have the mysqli extension enabled in my php.ini also, my phpinfo shows it. http://oliverengelhardt.de/info.php
Offline
I see no relevant info at these truncated lines!
If php -m lists mysqli then it should be enabled and the mysqli.so is under /usr/lib/php/modules/
Can't help much this way.
Offline
It php -m says mysqli is enabled. Well then I should probably just do a reinstall and hope for the best. Thanks for your help.
Offline
Ok
Last edited by ackt1c (2022-11-05 15:44:24)
Offline
I tried loading both mannually, no change.
Offline
Irregardless
Last edited by ackt1c (2022-11-05 15:40:20)
Offline
How do I acces it when i installed it using pacman?
Last edited by oengelha (2012-12-12 15:07:25)
Offline
Closed
Last edited by ackt1c (2022-11-05 15:38:22)
Offline
Okay, this topic can be closed, I just resigned and reinstalled my sytem, now it works... Thanks for all your help.
Offline