dbpassword function

[deemurphyus]

I am installing timesheet.php to use with Sugar4.5 Open Source.

Has anyone used the new timesheet.php? How do I incorporate it into Sugar so it can be seen on the dashboard?

I also am having a problem logging in, here is the code and the results:

I thought it would help if I post the code and the error I am getting.

Code:

<?php

$DATABASE_HOST = "localhost";
$DATABASE_USER = "root";
$DATABASE_PASS = "mypassword";
$DATABASE_DB = "sugarcrm";
$DATABASE_PASSWORD_FUNCTION = "__DBPASSWORDFUNCTION__";

Error:

Can't perform query: FUNCTION sugarcrm.__DBPASSWORDFUNCTION__ does not exist
SELECT password AS passwd1, __DBPASSWORDFUNCTION__('mypassword') AS passwd2 FROM timesheet_user WHERE username='admin'

?>

Admin is the timesheet username. I am using timesheet.php and put the database in sugarcrm. The password for all is the same.

Thank you
Dee

[uoa7]

Hello, your problem is the non-existant function __DBPASSWORDFUNCTION__ as you might have figured from the Error message. Try replacing with

$DATABASE_PASSWORD_FUNCTION = "PASSWORD";

which will result in this sql statement

SELECT password AS passwd1, PASSWORD('mypassword') AS passwd2 FROM timesheet_user WHERE username='admin'

which is valid.

You may also choose to use a different password function such as md5 or sha1 but if you followed the manual install you will notice the default password is hashed with PASSWORD

INSERT INTO user VALUES ('admin', 10, PASSWORD('mypassword'), '.*', 'Timesheet', 'Admin', '', '', '0.00', '', 'OUT', '1');

Hope this is helpful to someone, even though it's 2 years late.