CODE integrating drupal and cerberus helpdesk

Mmk a few things:

1) if I mispelled something (ie cebrerus) use your brains, it's obviously not what i spelled, or like db_fethc_object... obviously i meant db_fetch_object... Don't worry about addressing it, spell it write when you implement it... because its obviously not going to effect the overall outcome of the ideas here. I know i suck at spelling, ill live with it.
2)Don't bother bringing up silly syntax errors like i forgot to type a ';' somewhere, if you, the programmer, know there is supposed to be a ';' there, add it when you implement the code.
3)NO I DON'T HAVE THE ANSWER FOR THE BETA DRUPAL 6 so don't ask
4)Feel free to add to this if you want, there are a few good ways to error check for the ldap authentication module, so that if the user is in one database and not the other to only insert or update the appropriate databases, for what i am using the systems for, its not a big deal, so i didn't worry about it. If you feel the need to add the check in, please i ask, post it.
5) for those of you curious how this works read my synopsis.
6)there is a way to do this without LDAP, i haven't implemented it, strictly because we use LDAP. Its the same principle though:
when user logs in, capture log in data, insert into the cerberus database and then trick it into thinking its logged in.
7)USE THIS AT YOUR OWN RISK, THIS WORKS FOR ME AND IT SHOULD WORK FOR YOU, I WILL NOT ASSUME ANY RESPONSIBILITY FOR LOSS OF DATA OR ANYTHING OF THAT NATURE, PLEASE DO NOT BLAME ME IF YOU LOSE ANYTHING, YOU ARE ASSUMING FULL RESPONSIBILITY BY USING THIS CODE.
8) i will only answer serious questions, a serious question is either a problem with the code, or something of that magnitude, a syntax error or spelling error is not a serious question... I will be checking this occasionally

Incorporating Cerberus (sc) into Drupal (LDAP necessary)

Synopsis: This “hack” will allow a Drupal to trick Cerberus (sc) into thinking it is logged in. It utilizes the LDAP authentication routine so that Drupal will populate the Cerberus database with the email, first name, last name, etc of the user that logs in. Thus Cerberus can reference the information it needs to properly allowing the user to track their tickets, submit tickets etc. They cannot log out of Cerberus and they cannot change any information either.

Necessary ‘Do-hickeys’:
o Drupal v(5.1)
o Cerberus Web GUI (3.6 b. 431)
o Cerberus Support Center (3.6 release)
o LDAP Authentication for Drupal (v. 5.x-1.2) found here(http://drupal.org/project/ldap_integration) (date: 2007-Mar-29)

Here’s how to ‘do it’:
The following ‘hack’ takes place in this directory:
/var/www/html/sites/[Cerberus Web GUI Folder]/[Cerberus Support Center Folder]/cerberus-support-center/

In ‘session.php’:
You need to start a connection to the DB:
So add the mysql_connect(‘<i>DB_HOST</i>’,’<i>YOUR_USER_NAME</i>’,’<i>YOUR_PWD</i>’); as the first line in the file.

Next find the following lines of code:
Original:

**YOU NEED TO COMMENT THEM BOTH OUT**
After you comment them out:

Directly underneath those add the following lines of code:

//IF YOU ARE USING 5.2 SCROLL DOWN TO THE NOTED 5.2 HACK//
===============================================================
//continue here after doing the 5.2 hack//

Followed by a MySQL query to pull the proper data from the Drupal DB

**note that drupal and cerberus are the names of YOUR database names for each System respectively**

Mmk, now we are going to actually manipulate the session variables so that we actually physically trick Cerberus into thinking someone has logged in.

So we look to the preceding “if” statement:

Ignore that and go straight for the ‘else’ clause that follows the if statement

Here we will add the products of our query:
Add the following lines AFTER:

else {
$cer_session = unserialize($_SESSION[“cer_login_serialized”]); //DON’T CHANGE
Add:

Now we will shift our focus onto the ldapauth.module found in the following path:
/var/www/html/sites/all/modules/ldapauth.module

[Thank you JRA for getting this LDAP query completed]

This is the tricky one,
What needs to happen here is get the LDAP stuff, put it into the drupal database for keeping, then insert it into the cerberus.address and cerberus.public_gui_users tables. This will effectively “trick” Cerberus into thinking that these users have registered their emails and are legitimate users.

Scroll to the function _ldapauth_check_ldap($name, $pass) {... portion of the code (near the bottom)

Once there continue to the very bottom of the function (consequently the bottom of the file too)… and look for the } right above the

Here we will add the following code:
…

=====================================================================================
NOW FOR THE DRUPAL 5.2 FIX!!!!!!!!!!!!!!!!!!
=====================================================================================
Ok, for Drupal 5.2 almost everything is the same, we really only need to change one line of code. However to do this you have to do this follow these steps:

/var/www/html/sites/[Cerberus Web GUI Folder]/[Cerberus Support Center Folder]/cerberus-support-center/

1)Go to the ‘session.php’ file and AT THE VERY TOP OF THE FILE add this line:
var_dump($_COOKIE);
2)Navigate to cerberus while you are WITHIN DRUPAL (ie visit the story or page, which ever you created) and you will see something like this:
“array(2) { ["PHPSESSID"]=>…” What you are looking for is the second element of the array
3)It will be [“SESSxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx”] (32 alpha-numeric characters). THAT is the important portion of the cookie array.
4)So now go back to your session.php file:
a.Where we are supposed to add the
$temp = $_COOKIE[session_name()];
INSTEAD add:
$temp = $_COOKIE[SESS[your 32 alphanumeric character string];

Now Please scroll up to continue the rest of the hack this is the ONLY difference between the 5.1 and 5.2 drupal/cerberus integrations!!!
========================================================================
END OF INTEGRATION
========================================================================

Enjoy and good luck :)