Well, I turned on sql logging, and here is the query.

031101 14:48:39 3 Query SET autocommit=1
3 Query SELECT user.id FROM role_auth LEFT JOIN user ON user.role_id=role_auth.role_id WHERE user.id='admin' AND user.password='0DPiKuNIrrVmD8IUCuw1hQxNqZc=' AND role_auth.handler_name='Drivers' AND role_auth.method_name='getRec'
3 Query SET autocommit=1
3 Query SELECT driver.user_id,driver.callback_url,driver.callback_user_id,driver.callback_password,driver.mime_mask,driver.master_mask,driver.slave_mask,driver.per_user_settings,driver.supports_device_status,driver.is_active,driver.id FROM driver WHERE (driver.id=2) LIMIT 1

And The results:

mysql> SELECT user.id FROM role_auth LEFT JOIN user ON user.role_id=role_auth.role_id WHERE user.id='admin' AND user.password='0DPiKuNIrrVmD8IUCuw1hQxNqZc=' AND role_auth.handler_name='Drivers' AND role_auth.method_name='getRec'
-> ;
+-------+
| id |
+-------+
| admin |
+-------+
1 row in set (0.01 sec)

mysql> SELECT driver.user_id,driver.callback_url,driver.callback_user_id,driver.callback_password,driver.mime_mask,driver.master_mask,driver.slave_mask,driver.per_user_settings,driver.supports_device_status,driver.is_active,driver.id FROM driver WHERE (driver.id=2) LIMIT 1;
+---------+---------------------------------+------------------+-------------------+-----------+-------------+------------+-------------------+------------------------+-----------+----+
| user_id | callback_url | callback_user_id | callback_password | mime_mask | master_mask | slave_mask | per_user_settings | supports_device_status | is_active | id |
+---------+---------------------------------+------------------+-------------------+-----------+-------------+------------+-------------------+------------------------+-----------+----+
| trio | http://localhost:8080/trio/RPC2 | trio | trioserver | 13 | 0 | 0 | 0 | 0 | 1 | 2 |
+---------+---------------------------------+------------------+-------------------+-----------+-------------+------------+-------------------+------------------------+-----------+----+
1 row in set (0.00 sec)




Edited by gerald_clark (01/11/2003 15:00)