Integration of Sugar CRM with an audit application

[lionelM]

HEllo All,
I'm not a Sugar CRM user but from another APP.
I need to get some inorfmation to add few lines of codes at the login of Sugar
Can someone help me on this
My app is an audit system for DB
I need to find where I can collect :
- application username ( what is the name of the variable ? )
- DB username ( if I'm not wrong, I found db_username)
- Database name ( again, if not wrong db_name )
- username prefix and postfix (if they exist )
- session pattern
-session prefix and postfix ( if they exist as well )

- Session ID pattern
- Session ID pattern postfix and prefix ( if they exist )

Second step ... where am I supposed to add a line which will execute at user session start a query ( means , user enter login and pass, then click login. I want to run a specific query at this time )

Thanks in advance for your help !!!
Lionel

[andopes]

- DB username ( if I'm not wrong, I found db_username)
Correct

- Database name ( again, if not wrong db_name )
Correct

- username prefix and postfix (if they exist )
It does not exist

- session pattern
session on sugar can be retrieved through $_REQUEST['PHPSESSID']

-session prefix and postfix ( if they exist as well )
It does not exist

- Session ID pattern
- Session ID pattern postfix and prefix ( if they exist )
??????

Second step ... where am I supposed to add a line which will execute at user session start a query ( means , user enter login and pass, then click login. I want to run a specific query at this time )

The logic_hook after_login can accomplish that to you.

Regards

[lionelM]

Hello andré, sorry for this basic question ,but in which file ?
I found the class in include/Utils/
Is it entrypoint.php ?
Thanks
Lionel

[lionelM]

Hello
I'm sorry, but I'm not very good in PHP and I don't see where I'm supposed to put the 3 code lines I need to add...
Can you please indecate me which file I must edit ?
Thanks
L.

[lionelM]

Hello,
Can anyone else can help me on this ?
In which file can I find the PHP code for login-in and login-out ?
Thanks in advance
Lionel

[mvngti]

Have a look at the Logic Hooks section(s) of the Dev manual in my sig.

You need to create an after_login logic hook that does your magic on the other app...
The editLogicHooks tool in my sig can also help you build some logic hooks (if only to start understanding them better). Unforyunately it does not cater for after_login.

You can try to use my tool to create an after_retrieve logic hook on ALL modules and then just change everything in logic_hooks.php and mjvn-*** in custom/modules folder to after_login instead of after_retrieve.

M

[lionelM]

hello mvngti
Thanks for your answer
I will search with this