ajaxplorer:login from mysql table

Question

Hi i am using ajaxplorer, here i want to use mysql database table to login to ajaxplorer.. here is the table structure

CREATE TABLE IF NOT EXISTS `user` (
`Guid` char(38) COLLATE latin1_general_ci NOT NULL,
`UserName` varchar(250) COLLATE latin1_general_ci NOT NULL,
`Organization` char(38) COLLATE latin1_general_ci DEFAULT NULL,
`rsguid` char(38) COLLATE latin1_general_ci NOT NULL,
`temppassword` varchar(50) COLLATE latin1_general_ci NOT NULL,
`SessionExpires` datetime DEFAULT NULL,
`IsAdmin` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`Guid`)
)  

here user name is "admin" and temppassword is "ajaxplorer" using these credentials from user table i want to login in ajaxplorer..

please help me out

Answer 1

1: Replace the auth driver and conf driver in bootstrap_plugins.php with the following:

    "CONF_DRIVER" => array(
        "NAME"      => "sql",
        "OPTIONS"   => array(
            "SQL_DRIVER"    => array(
                "driver"    => "mysql",
                "host"      => "db_server",
                "database"  => "db_name",
                "user"      => "db_username",
                "password"  => "db_password",
            ),
            )
),    

"AUTH_DRIVER" => array(
            "NAME"          => "sql",
             "OPTIONS"       => array(
            "SLAVE_MODE"  => true,  
                "SQL_DRIVER"    => array(
                                        "driver"    => "mysql",
                                        "host"      => "db_server",
                                        "database"  => "db_name",
                                        "user"      => "db_username",
                                        "password"  => "db_password"
                                            ),

               "TRANSMIT_CLEAR_PASS"   => false  // Don't touch this. It's unsafe (and useless here) to transmit clear password.
                                        )
                ),

2: You can find all the queries regarding user table and column names in pligins/auth.sql/class.sqlAuthDriver.php where you can customize them according to your requirement like renaming "ajaxp_user" to "user" etc.