Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!

Bug 157712

Summary: dev-db/phpmyadmin - can't login pma@localhost error
Product: Gentoo Linux Reporter: Francesco Saverio Proto <zioproto>
Component: Current packagesAssignee: Gentoo Linux bug wranglers <bug-wranglers>
Status: VERIFIED INVALID    
Severity: normal    
Priority: High    
Version: 2006.1   
Hardware: All   
OS: Other   
Whiteboard:
Package list:
Runtime testing required: ---

Description Francesco Saverio Proto 2006-12-10 03:53:33 UTC
Here is my config.inc.php, is very simple:

<?php
/*
 * Generated configuration file
  * Generated by: phpMyAdmin 2.9.1.1 setup script by Michal &#268;iha&#345; <michal@cihar.com>
   * Version: $Id: setup.php 9484 2006-10-03 13:11:22Z nijel $
    * Date: Sat, 09 Dec 2006 17:16:00 GMT
     */

     /* Servers configuration */
     $i = 0;

     /* Server localhost (cookie) [1] */
     $i++;
     $cfg['Servers'][$i]['host'] = 'localhost';
     $cfg['Servers'][$i]['extension'] = 'mysql';
     $cfg['Servers'][$i]['connect_type'] = 'tcp';
     $cfg['Servers'][$i]['compress'] = false;
     $cfg['Servers'][$i]['auth_type'] = 'cookie';

     /* End of servers configuration */

     $cfg['blowfish_secret'] = '457aef4e92d013.11952112';
     ?>

Everything works perfect if I use it with the phpmyadmin package downloaded from Sourceforge.

If I:

emerge phpmyadmin

and then use the same config.inc.php I pasted, when I log in my user my browser points to a http://127.0.0.1 URL that is not the IP of the webserver.
Clicking back, comes again the login page saying "Cant login pma@localhost", but I was trying to log in root.

My browser is Firefox and the OS the Browser runs on is MAC OS X.
phpmyadmin and mysql run on a remote machine


tuscolomesh phpmyadmin # emerge --info
Portage 2.1.1-r2 (default-linux/x86/2006.1/desktop, gcc-4.1.1, glibc-2.4-r4, 2.6.17-gentoo-r8 i686)
=================================================================
System uname: 2.6.17-gentoo-r8 i686 Intel(R) Pentium(R) 4 CPU 2.00GHz
Gentoo Base System version 1.12.6
Last Sync: Sat, 09 Dec 2006 08:50:01 +0000
app-admin/eselect-compiler: [Not Present]
dev-java/java-config: 1.3.7, 2.0.30
dev-lang/python:     2.4.3-r4
dev-python/pycrypto: 2.0.1-r5
dev-util/ccache:     [Not Present]
dev-util/confcache:  [Not Present]
sys-apps/sandbox:    1.2.17
sys-devel/autoconf:  2.13, 2.60
sys-devel/automake:  1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2
sys-devel/binutils:  2.16.1-r3
sys-devel/gcc-config: 1.3.13-r4
sys-devel/libtool:   1.5.22
virtual/os-headers:  2.6.17-r2
ACCEPT_KEYWORDS="x86"
AUTOCLEAN="yes"
CBUILD="i686-pc-linux-gnu"
CFLAGS="-march=pentium4 -O2 -pipe"
CHOST="i686-pc-linux-gnu"
CONFIG_PROTECT="/etc /var/bind"
CONFIG_PROTECT_MASK="/etc/env.d /etc/env.d/java/ /etc/gconf /etc/java-config/vms/ /etc/revdep-rebuild /etc/terminfo"
CXXFLAGS="-march=pentium4 -O2 -pipe"
DISTDIR="/usr/portage/distfiles"
FEATURES="autoconfig distlocks metadata-transfer sandbox sfperms strict"
GENTOO_MIRRORS="ftp://ftp.unina.it/pub/linux/distributions/gentoo"
LINGUAS="it"
MAKEOPTS=""
PKGDIR="/usr/portage/packages"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --delete-after --stats --timeout=180 --exclude='/distfiles' --exclude='/local' --exclude='/packages'"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY="/usr/portage/local/layman/voip"
SYNC="rsync://rsync.namerica.gentoo.org/gentoo-portage"
USE="x86 activefilter apache2 arts bash-completion berkdb bitmap-fonts bzip2 cairo cdr chroot cli cracklib crypt cups dbus dhcp dlloader dri dvd dvdr eds elibc_glibc emboss encode esd fam fortran ftp gdbm gif gpm graphviz gstreamer hal iconv input_devices_evdev input_devices_keyboard input_devices_mouse isdnlog java jpeg kerberos kernel_linux l7filter ldap libg++ linguas_it mad mikmod mp3 mpeg mysql ncurses new-login nls nptl nptlonly ogg oss pam pcre pdf perl php png ppds pppd python qt3 qt4 quicktime quotas radius readline reflection samba sdl session simplexml sockets spell spl ssl swat tcpd tiff truetype truetype-fonts type1-fonts udev unicode userland_GNU video_cards_apm video_cards_ark video_cards_ati video_cards_chips video_cards_cirrus video_cards_cyrix video_cards_dummy video_cards_fbdev video_cards_glint video_cards_i128 video_cards_i740 video_cards_i810 video_cards_imstt video_cards_mga video_cards_neomagic video_cards_nsc video_cards_nv video_cards_rendition video_cards_s3 video_cards_s3virge video_cards_savage video_cards_siliconmotion video_cards_sis video_cards_sisusb video_cards_tdfx video_cards_tga video_cards_trident video_cards_tseng video_cards_v4l video_cards_vesa video_cards_vga video_cards_via video_cards_vmware video_cards_voodoo vorbis win32codecs xml xmlreader xmlrpc xmlwriter xorg xv zip zlib"
Unset:  CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LANG, LC_ALL, LDFLAGS, PORTAGE_RSYNC_EXTRA_OPTS
Comment 1 Jakub Moc (RETIRED) gentoo-dev 2006-12-10 03:58:17 UTC
You didn't follow the install/upgrade instructions, did you? Set the pmadb password properly for pma user, as the ebuild instructions told you.
Comment 2 Francesco Saverio Proto 2006-12-10 06:05:08 UTC
I emerged again phpmyadmin

Followed install/upgrade instructions as the ebuild says

Here is my config.inc.php

<?php
/*
 * Generated configuration file
  * Generated by: phpMyAdmin 2.9.1.1 setup script by Michal ?~Liha?~Y <michal@cihar.com>
   * Version: $Id: setup.php 9484 2006-10-03 13:11:22Z nijel $
    * Date: Sat, 09 Dec 2006 17:16:00 GMT
     */

     /* Servers configuration */
     $i = 0;

     /* Server localhost (cookie) [1] */
     $i++;
     $cfg['Servers'][$i]['host'] = 'localhost';
     $cfg['Servers'][$i]['extension'] = 'mysql';
     $cfg['Servers'][$i]['connect_type'] = 'tcp';
     $cfg['Servers'][$i]['compress'] = false;
     $cfg['Servers'][$i]['auth_type'] = 'cookie';

     /* End of servers configuration */

     $cfg['blowfish_secret'] = '457aef4e92d013.11952112';
?>

How when I log in I get redirected to:
http://localhost//phpmyadmin/index.php?lang=it-utf-8&target=server_privileges.php&token=376be04943f2831de077d58bf84a802d

but when I click "back" on the browser I get to the http://myserverip/phpmyadmin/ URL and I'm logged in correctly.
Comment 3 Jakub Moc (RETIRED) gentoo-dev 2006-12-10 06:07:36 UTC
Sigh, if you server is NOT localhost, then don't set it as such. Thanks.

<snip>
$cfg['Servers'][$i]['host'] = 'localhost';
</snip>
Comment 4 Francesco Saverio Proto 2006-12-10 06:47:30 UTC
(In reply to comment #3)
> Sigh, if you server is NOT localhost, then don't set it as such. Thanks.
> 
> <snip>
> $cfg['Servers'][$i]['host'] = 'localhost';
> </snip>
> 

but if the configuration is wrong, then why my configuration works correctly with the phpmyadmin tarball downloaded from SourceForge?

Francesco Saverio Proto
Comment 5 Jakub Moc (RETIRED) gentoo-dev 2006-12-10 07:24:23 UTC
Please, move this to forums.gentoo.org or #gentoo-web on freenode; this is not a support forum.