Welcome to Centmin Mod Community
Become a Member

phpmyadmin.sh Addon

Discussion in 'Add Ons' started by eva2000, May 25, 2014.

  1. FAPM

    FAPM Member

    58
    4
    8
    Jul 16, 2015
    Ratings:
    +6
    Local Time:
    6:38 AM
    1.9.2
    10.0.20
    Hi ALL,

    The addon phpmyadmin does not work correctly on the Centmin Mod Version 1.2.3 eva2000.08

    The version installed by default: 4.5.0-dev

    Git Version: 2ffaaf9 fron master branch

    Php Version: 5.5.27
    MariaDB: 10.0.20
    For example, when creating a new user:

    # 1064 - You have an error in your SQL syntax; check the manual That corresponds to your version of MariaDB server for the right syntax to use near 'BY' password '' at line 1

    The selected user was not found in the privilege table.

    The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why.
    Or alternately go to 'Operations' tab of any database to set it up there.

    Note: phpMyAdmin gets the users' privileges directly from MySQL's privilege tables. The content of these tables may differ from the privileges the server uses, if they have been changed manually. In this case, you should reload the privileges before you continue.
     
  2. eva2000

    eva2000 Administrator Staff Member

    45,435
    10,312
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,992
    Local Time:
    3:38 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    sounds like you're trying to select a user not create one ? can you list the exact steps you are doing to create a new user in phpmyadmin ?

    if not you can try the addons/mysqladmin_shell.sh addon instead mysqladmin_shell.sh Shell based Addon | Centmin Mod Community
     
  3. FAPM

    FAPM Member

    58
    4
    8
    Jul 16, 2015
    Ratings:
    +6
    Local Time:
    6:38 AM
    1.9.2
    10.0.20
    User accounts / Add user account / User name, host %, password, authentification plugin mysql native password, create database with same name and grant all privilefes, and GO

    #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'BY 'tWbRRmh3CGsE6acE'' at line 1

    CREATE USER 'pshop'@'%' IDENTIFIED WITH mysql_native_password BY '***';GRANT USAGE ON *.* TO 'database'@'%' REQUIRE NONE WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;

    The selected user was not found in the privilege table.
     
  4. FAPM

    FAPM Member

    58
    4
    8
    Jul 16, 2015
    Ratings:
    +6
    Local Time:
    6:38 AM
    1.9.2
    10.0.20
    And for a creation of a database:

    Notice
    in ./libraries/navigation/Nodes/Node_Database.class.php#386
    Undefined index: navigationhiding

    Backtrace

    ./libraries/navigation/NavigationTree.class.php#566: Node_Database->getHiddenItems(string 'group')
    ./libraries/navigation/NavigationTree.class.php#342: PMA_NavigationTree->_addDbContainers(
    object,
    string '',
    integer 0,
    )
    ./libraries/navigation/NavigationTree.class.php#298: PMA_NavigationTree->_buildPathPart(
    array,
    string '',
    string '',
    string '',
    string '',
    )
    ./libraries/navigation/NavigationTree.class.php#866: PMA_NavigationTree->_buildPath()
    ./libraries/navigation/Navigation.class.php#50: PMA_NavigationTree->renderPath()
    ./navigation.php#75: PMA_Navigation->getDisplay()
     
  5. eva2000

    eva2000 Administrator Staff Member

    45,435
    10,312
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,992
    Local Time:
    3:38 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    extra ' in password probably throwing things off.. make sure password characters are accepted by mysql
    what version of PHP are you using ?

    or clear browser cache phpMyAdmin update to 4.3.6 generates "Undefined index: navwork" error - Stack Overflow

    interesting Undefined index: navwork · Issue #11142 · phpmyadmin/phpmyadmin · GitHub
     
  6. FAPM

    FAPM Member

    58
    4
    8
    Jul 16, 2015
    Ratings:
    +6
    Local Time:
    6:38 AM
    1.9.2
    10.0.20
    Is a password generated by phpmyadmin
    It works perfectly with a similar password on mysqladmin_shell.sh
    Tested on freshly installed centminmod (base config)
     
  7. eva2000

    eva2000 Administrator Staff Member

    45,435
    10,312
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,992
    Local Time:
    3:38 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    no phpmyadmin you need to generate your own password as does mysqladmin_shell.sh
     
  8. FAPM

    FAPM Member

    58
    4
    8
    Jul 16, 2015
    Ratings:
    +6
    Local Time:
    6:38 AM
    1.9.2
    10.0.20
    This is phpmyadmin that generates the password: "Generate password" => tWbRRmh3CGsE6acE
     
  9. eva2000

    eva2000 Administrator Staff Member

    45,435
    10,312
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,992
    Local Time:
    3:38 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    i see what you mean you can generate a password via phpmyadmin.. never used it myself or use phpmyadmin for user management or database creation as i use SSH command line - same steps used in addons/mysqladmin_shell.sh which always works

    create-user-bug-00.png

    Problem seems to be phpmyadmin using IDENTIFIED WITH mysql_native_password BY instead of IDENTIFIED BY PASSWORD instead this works

    create-user-00.png
     
  10. FAPM

    FAPM Member

    58
    4
    8
    Jul 16, 2015
    Ratings:
    +6
    Local Time:
    6:38 AM
    1.9.2
    10.0.20
    Yes, mysqladmin_shell it's perfect, it works fine :)

    I just want to escalate the issue to the forum ;)
     
  11. eva2000

    eva2000 Administrator Staff Member

    45,435
    10,312
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,992
    Local Time:
    3:38 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
  12. eva2000

    eva2000 Administrator Staff Member

    45,435
    10,312
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,992
    Local Time:
    3:38 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    This query should work too with IDENTIFIED VIA mysql_native_password USING

    create-user-01.png

    so not working
    Code:
    IDENTIFIED WITH mysql_native_password BY
    working
    Code:
    IDENTIFIED BY PASSWORD
    or
    Code:
    IDENTIFIED VIA mysql_native_password USING
     
  13. FAPM

    FAPM Member

    58
    4
    8
    Jul 16, 2015
    Ratings:
    +6
    Local Time:
    6:38 AM
    1.9.2
    10.0.20
    Noted :)

    Thank you Eva2000
     
  14. Vija

    Vija New Member

    11
    2
    3
    Aug 7, 2015
    Ratings:
    +2
    Local Time:
    10:38 PM
    I just installed Centmin Mod 1.2.3-eva2000.08 with phpmyadmin addon.. I am not able to get the phpmyadmin to work.. i keep getting 404 error..
     
  15. eva2000

    eva2000 Administrator Staff Member

    45,435
    10,312
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,992
    Local Time:
    3:38 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    what url you trying to access ? is it behind https as phpmyadmin.sh addon only sets up install on https:// and not http://
    what if you try uninstall and reinstall ?

    to uninstall
    Code:
    /root/tools/phpmyadmin_uninstall.sh
     
  16. Vija

    Vija New Member

    11
    2
    3
    Aug 7, 2015
    Ratings:
    +2
    Local Time:
    10:38 PM
    I did that and didn't work.. the problem I am seeing is how the server hostname is created https://hostname.cinebuffer.com/2471_mysqladmin21680
    - It is the correct server hostname but for some reason not working outside.. so, I tried changing the url to cinebuffer.com/2471_mysqladmin21680 even that's not working


    also tried going to with ip address of server still 404
     
  17. eva2000

    eva2000 Administrator Staff Member

    45,435
    10,312
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,992
    Local Time:
    3:38 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    problem is you don't have a valid A record for DNS if that is the actual server main hostname = hostname.cinebuffer.com

    you can check at https://www.whatsmydns.net/#A/hostname.cinebuffer.com should return an ip for your server for A record check like your domain cinebuffer.com does https://www.whatsmydns.net/#A/cinebuffer.com

    Getting Started Guide Step 1 covers ensuring having valid DNS record for your main hostname

    FYI, ip works for me when I access https://YOURIP/2471_mysqladmin21680 remember only https:// will work not http://

    FYI, for privacy and security, you'd want to uninstall and reinstall so you get a new url with random generated url characters that isn't the one posted above :)
     
  18. Vija

    Vija New Member

    11
    2
    3
    Aug 7, 2015
    Ratings:
    +2
    Local Time:
    10:38 PM
    IP works for you? for me it doesnt?
     
  19. eva2000

    eva2000 Administrator Staff Member

    45,435
    10,312
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,992
    Local Time:
    3:38 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    ah correction yes i see 404 after the self-signed ssl cert prompt where i click continue.
     
  20. eva2000

    eva2000 Administrator Staff Member

    45,435
    10,312
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,992
    Local Time:
    3:38 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    what do you get from output from SSH command line as root user when you type the following ?

    /usr/local/nginx/html is the public web root for main hostname's nginx vhost setup
    Code:
    ls -lah /usr/local/nginx/html | grep 'mysqladmin'