Topic: smeserver-phpmyadmin-multiuser-2.10.2-1.noarch.rpm

[cvlcc]

I have smeserver-phpmyadmin-multiuser-2.10.2-1.noarch.rpm installed on my server 7.0.
I get this error: Error
#1045 - Access denied for user 'admin'@'localhost' (using password: YES)
When I log into the root of the server I have no problem. But when I try to log into Welcome to phpMyAdmin 2.10.2 using admin or root I get this error. It is not accepting my Passwords from on the same network

I went to /etc/e-smith/templates/etc/httpd/conf/httpd.conf/86PhpmyadminmultiAlias

and got this in the file:

# Administration: phpMyAdmin
<Directory /opt/administration/phpmyadminmulti>
    SSLRequireSSL on
    Options -Indexes 
    AllowOverride None
    order deny,allow
    deny from all
{
    my $phpmyadminaxs = $phpmyadminmulti{'access'} || "private";
    if ($phpmyadminaxs eq "private")
    {
   $OUT .= "    allow from $localAccess $externalSSLAccess";   
    } else {
   $OUT .= "    allow from all";
    }
}
    Satisfy all
    AddType application/x-httpd-php .php .php3
    php_flag  magic_quotes_gpc  on
    php_flag  track_vars        on
</Directory>

<Directory /opt/administration/phpmyadminmulti/scripts>
    SSLRequireSSL on
    Options -Indexes
    AllowOverride None
    order deny,allow
    deny from all
    allow from { "$localAccess $externalSSLAccess"; }
    AuthName "phpMyadmin Scripts (Admin)"
    AuthType Basic
    AuthExternal pwauth
    require user admin
    Satisfy all
    AddType application/x-httpd-php .php .php3
    php_flag  magic_quotes_gpc  on
    php_flag  track_vars        on
</Directory>
                     
<Directory /opt/administration/phpmyadminmulti/libraries >
    order deny,allow
    deny from all
</Directory>


How do I fix this? A line by line from the root prompt please.

Also is it possible to up grade to PHP 5.2.4 on RHEL and CentOS with no problems?

[cactus]

I have smeserver-phpmyadmin-multiuser-2.10.2-1.noarch.rpm installed on my server 7.0.
I get this error: Error
#1045 - Access denied for user 'admin'@'localhost' (using password: YES)
When I log into the root of the server I have no problem. But when I try to log into Welcome to phpMyAdmin 2.10.2 using admin or root I get this error. It is not accepting my Passwords from on the same network

The password on the SME Server shell is entered by a clever trick that automatically looks up the password in a file on your system when you are logged in as root user. This trick does not work when you login from other things than the SME Server shell.

The admin user is not configured for MySQL access by default. AFAIK it is normal practice to configure MySQL users yourself, this is not done by the system itself, and passwords are not synced either as MySQL does not use PAM, LDAP or anything else that it's own user database.

If you read this page in the wiki you find how to log in as admin: http://wiki.contribs.org/Phpmyadminmulti .

To configure MySQL access for certain users have a look at the wiki: http://wiki.contribs.org/MySQL

[cvlcc]

Well I removed the old smeserver-phpmyadmin-multiuser-2.10.2-1 and installed the new  phpMyAdmin 2.11.0 and got the same problem. I followed the instruction exatly! I can see the login I put under  Username:admin and Password: XXXXXXX I still get the error
Error
#1045 - Access denied for user 'admin'@'localhost' (using password: YES)

-> --execute="grant all privileges on *.* to admin@localhost identified by 'admin' WITH GRANT OPTION"
    -> --execute="flush privileges"
    -> --execute="grant all privileges on *.* to admin@localhost identified by 'admin' WITH GRANT OPTION"
    -> --execute="flush privileges"
    -> \q
Bye
[root@xxxx ~]#

Do I need to set a password for admin@localhost?


I just Don't seem to get right

Awating Your Reply
Thank You