Results 1 to 2 of 2

Thread: OSZ 13.2 - phpmyadmin - controluser access

  1. #1
    Join Date
    Jun 2008
    Location
    South-West France
    Posts
    1,032

    Default OSZ 13.2 - phpmyadmin - controluser access

    Hello.
    On a multiple instance config, the pma tables (database phpmyadmin) are installed in the first mysql instance.
    There is no .htaccess

    All commands are done from the server.
    The server is dhcp and dns server for local subnet using dnsmasq

    From command line the pma controller user can connect using this command by giving the pma_controller_password
    Code:
    mysql -t --socket=/path_to_mysql_sock/mysql.sock -u pma_controller -p -h localhost phpmyadmin
    Code:
    Welcome to the MariaDB monitor.  Commands end with ; or \g.
    Your MariaDB connection id is 19
    Server version: 10.0.13-MariaDB-log openSUSE package
    Copyright (c) 2000, 2014, Oracle, SkySQL Ab and others.
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    MariaDB [phpmyadmin]>
    But the pma controller user cannot connect to the pma database within phpmyadmin if phpmyadmin is started from localhost
    Code:
    http://localhost/phpMyAdmin
    In that case after choosing the 1st mysql instance and giving some_user/some_pasword, phpmyadmin open normally but give an error for accessing pma tables by the pma controller user
    Code:
    Connection for controluser as defined in your configuration failed.
    see : http://paste.opensuse.org/51279957

    But from command line the pma controller user cannot connect using this command
    Code:
    mysql -t --socket=/path_to_mysql_sock/mysql.sock -u pma_controller -p -h 127.0.0.1  phpmyadmin
    But there is no erropr when starting phpmyadmin from 127.0.0.1
    Code:
    http://127.0.0.1/phpMyAdmin
    In that case after choosing the 1st mysql instance and giving some_user/some_pasword, phpmyadmin open normally and give no error for accessing pma tables by the pma controller user

    All this from root account.
    #----
    From a standard user account

    Code:
    mysql -t --socket=/path_to_mysql_sock/mysql.sock -u pma_controller -p -h localhost phpmyadmin
    [CODE]
    Connexion success (as above)
    Code:
    mysql -t --socket=/path_to_mysql_sock/mysql.sock -u pma_controller -p -h 127.0.0.1  phpmyadmin
    [CODE]
    Connexion failed (as above)

    Code:
    http://localhost/phpMyAdmin
    Error as above

    Code:
    http://127.0.0.1/phpMyAdmin
    Failed contrary to above.

    $cfg['Servers'][$i]['host'] = 'localhost' or 127.0.0.1 ?
    hostname -f return :
    Code:
    server.mydomain.local
    Here is php config file : http://http://paste.opensuse.org/15071325
    Here host file : http://paste.opensuse.org/3036838

    Any help is welcome.
    Thanks for helping. JCD
    __________
    server leap 15.0 -- ASUS g75vw KDE leap 15.0 -- ASUS g750JZ Optimus KDE leap 15.1 -- acer aspire s13 win 10 home -- HP Omen win 10 home - scan EPSON V500 - Brother HL2250DN - Samsung CLP-325W

  2. #2
    Join Date
    Jun 2008
    Location
    San Diego, Ca, USA
    Posts
    11,262
    Blog Entries
    2

    Default Re: OSZ 13.2 - phpmyadmin - controluser access

    The only thing I can think of at the moment is that you might have an error in your nameserver cache (ie localhost entry resolving incorrectly).

    Try the following which stops/restarts the name server cache daemon which should clear your existing cache allowing it to re-build
    Code:
    systemctl restart nscd
    HTH,
    TSU

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •