Error Loading All_db Php Phpmyadmin
to you by: ioguix, xzilla Summary Files Reviews Support Wiki Mailing Lists Tickets ▾ Bugs Feature Requests News Discussion Code Create Topic Stats Graph Forums Help 541 phppgadmin-users 7 phppgadmin-lang 4 Open Discussion 88 Help Formatting Help Error Loading all_db.php Forum: Help Creator: jody Created: 2013-01-05 Updated: 2013-06-11 jody - 2013-01-05 Hi (sorry for crossposting - i first put this on wrong forum) I don't know when exactly this started (probably after updating postgres to 9.1.5 or updating phpPgAdmin to 5.0.4). Anyway, after i click on "PostgreSQL (in the tree on the left) and then log in, i get the following messages on top of the window: Strict Standards: Only variables should be assigned by reference in /var/www/localhost/htdocs/phppgadmin/classes/database/Connection.php on line 23 Strict Standards: Only variables should be passed by reference in /var/www/localhost/htdocs/phppgadmin/redirect.php on line 14 Furthermore, instead of a tree representing the data base i only have a line: Error Loading all_db.php?subject=server&action=tree&server=localhost%3A5432%3Aallow (???) below the nodes 'Servers' and 'PostgreSQL'. However, access to the DB (on the right hand side of the window is working correctly. But it is much more comfortable to navigate in the tree. Here are my settings of config.inc.php: $conf['servers'][0]['desc'] = 'PostgreSQL'; $conf['servers'][0]['host'] = 'localhost'; $conf['servers'][0]['port'] = 5432; $conf['servers'][0]['sslmode'] = 'allow'; $conf['servers'][0]['defaultdb'] = 'template1'; $conf['servers'][0]['pg_dump_path'] = '/usr/bin/pg_dump'; $conf['servers'][0]['pg_dumpall_path'] = '/usr/bin/pg_dumpall'; $conf['servers'][0]['slony_support'] = false; $conf['servers'][0]['slony_sql'] = '/usr/share/pgsql'; $conf['default_lang'] = 'auto'; $conf['autocomplete'] = 'default on'; $conf['extra_login_security'] = true; $conf['owned_only'] = false; $conf['show_comments'] = true;
Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Server Fault Questions Tags Users Badges Unanswered Ask Question _ Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute: Sign up Here's how it https://sourceforge.net/p/phppgadmin/discussion/115884/thread/bba30f38/ works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Can't Login to phpPgAdmin up vote 8 down vote favorite 5 I'm trying to set up phpPgAdmin on my test machine so that I can interface with PostgreSQL without always having to use the psql CLI. I have PostgreSQL 9.1 http://serverfault.com/questions/402127/cant-login-to-phppgadmin installed via the RPM repository, while I installed phpPgAdmin 5.0.4 "manually" (by extracting the archive from the phpPgAdmin website). For the record, my host OS is CentOS 6.2. I made the following configuration changes already: PostgreSQL Inside pg_hba.conf, I changed all METHODs to md5. I gave the postgres account a password I added a new account named webuser with a password (note that I did not do anything else to the account, so I can't exactly say that I know what permissions it has and all) phpPgAdmin config.inc.php Changed the line $conf['servers'][0]['host'] = ''; to $conf['servers'][0]['host'] = '127.0.0.1'; (I've also tried using localhost as the value there). Set $conf['extra_login_security'] to false. Whenever I try to log in to phpPgAdmin, I get "Login failed", even if I use successful credentials (ones that work in psql). I've tried to go through some of the steps noted in Question 3 in the FAQ, but it hasn't worked out well so far there. It likely does not help that this is my first day working with PostgreSQL. I'm farily familiar with MySQL, but I
here for a quick overview of http://stackoverflow.com/questions/33011107/phpmyadmin-cant-load-template-error-opening the site Help Center Detailed answers to any questions http://docs.phpmyadmin.net/en/latest/setup.html you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions error loading Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Phpmyadmin, can't load template, error opening error loading all_db up vote -1 down vote favorite Established lampp (Apache 2, PHP, MySql) When prompted localhost and localhost/info.php everything works fine. PHP Version 5.5.9-1ubuntu4.13 System Linux laptop-Lenovo-G580 3.16.0-38-generic #52~14.04.1-Ubuntu SMP Fri May 8 09:43:57 UTC 2015 x86_64 Build Date Sep 29 2015 15:24:22 Server API Apache 2.0 Handler Virtual Directory Support disabled Configuration File (php.ini) Path /etc/php5/apache2 Loaded Configuration File /etc/php5/apache2/php.ini Scan this dir for additional .ini files /etc/php5/apache2/conf.d Additional .ini files parsed /etc/php5/apache2/conf.d/05-opcache.ini, /etc/php5/apache2/conf.d/10-pdo.ini, /etc/php5/apache2/conf.d/20-json.ini, /etc/php5/apache2/conf.d/20-mysql.ini, /etc/php5/apache2/conf.d/20-mysqli.ini, /etc/php5/apache2/conf.d/20-pdo_mysql.ini PHP API 20121113 PHP Extension 20121212 Zend Extension 220121212 Zend Extension Build API220121212,NTS PHP Extension Build API20121212,NTS Debug Build no Thread Safety disabled Zend Signal Handling disabled Zend Memory Manager enabled Zend Multibyte Support provided by mbstring IPv6 Support enabled DTrace Support enabled Registered PHP Streams https, ftps, compress.zlib, compress.bzip2, php, file,
Docker Examples Using docker-compose Quick Install Manually creating the file Using Setup script Setup script on Debian, Ubuntu and derivatives Setup script on openSUSE Verifying phpMyAdmin releases phpMyAdmin configuration storage Zero configuration Manual configuration Upgrading from an older version Using authentication modes HTTP authentication mode Cookie authentication mode Signon authentication mode Config authentication mode Securing your phpMyAdmin installation Known issues Users with column-specific privileges are unable to "Browse" Trouble logging back in after logging out using ‘http' authentication Configuration User Guide FAQ - Frequently Asked Questions Developers Information Distributing and packaging phpMyAdmin Copyright Credits Glossary phpMyAdmin Docs » Installation Edit on GitHub Installation¶ phpMyAdmin does not apply any special security methods to the MySQL database server. It is still the system administrator's job to grant permissions on the MySQL databases properly. phpMyAdmin's Users page can be used for this. Warning Mac users should note that if you are on a version before Mac OS X, StuffIt unstuffs with Mac formats. So you'll have to resave as in BBEdit to Unix style ALL phpMyAdmin scripts before uploading them to your server, as PHP seems not to like Mac-style end of lines character ("\r"). Linux distributions¶ phpMyAdmin is included in most Linux distributions. It is recommended to use distribution packages when possible - they usually provide integration to your distribution and you will automatically get security updates from your distribution. Debian¶ Debian's package repositories include a phpMyAdmin package, but be aware that the configuration file is maintained in /etc/phpmyadmin and may differ in some ways from the official phpMyAdmin documentation. Specifically it does: Configuration of web server (works for Apache and lighttpd). Creating of phpMyAdmin configuration storage using dbconfig-common. Securing setup script, see Setup script on Debian, Ubuntu and derivatives. See also More information can be found in README.Debian (it is installed as /usr/share/doc/phmyadmin/README.Debian with the package). OpenSUSE¶ OpenSUSE already comes with phpMyAdmin package, just install packages from the openSUSE Build Service. U