Hi
I'm still not winning with regards to the db_ext authentication from
Joomla jos_users table. Done everything below:
###############################################
# Authentication settings - read AUTHENTICATION
###############################################
$auth["session"] = "php"; # How to get and keep the user ID. One of
# "http" "php" "cookie" "ip" "host" "nt" "omni".
$auth["type"] = "db_ext"; # How to validate the user/password. One of
"none"
# "config" "db" "db_ext" "pop3" "imap" "ldap"
"nis"
# "nw" "ext".
# The list of administrators (can modify other peoples settings)
#$auth["admin"][] = "127.0.0.1"; # localhost IP address. Useful with IP
sessions.
$auth["admin"][] = "admin"; # A user name from the user list. Useful
#with most other session schemes.
# 'auth_config' user database
# Format: $auth["user"]["name"] = "password";
# 'session_http' configuration settings
$auth["realm"] = "mrbs";
# 'auth_ext' configuration settings
$auth["prog"] = "";
$auth["params"] = "";
# 'auth_db_ext' configuration settings
$auth['db_ext']['db_host'] = 'localhost';
$auth['db_ext']['db_username'] = 'dbuser';
$auth['db_ext']['db_password'] = 'secret';
$auth['db_ext']['db_name'] = 'joomla';
$auth['db_ext']['db_table'] = 'jos_users';
$auth['db_ext']['column_name_username'] = 'username';
$auth['db_ext']['column_name_password'] = 'password';
# Either 'md5', 'sha1', 'crypt' or 'plaintext'
$auth['db_ext']['password_format'] = 'joomla';
And added the code in auth_db_ext.inc under the sitch statement;
case 'joomla':
list($hash, $salt) = explode(':', $row[0]);
$cryptpass = md5($pass.$salt);
if ($hash == $cryptpass)
{
$retval = 1;
}
break;
Please help, running on the latest Ubuntu Server, MySql 5 and PHP 5.
