Closed TopicStart new topicStart Poll

> XMail + Courier IMAP + Squirrel mail + User2Mysql, script for adding users to mysql
Mihec
  Posted: Nov 3 2006, 01:17 PM
Quote Post


Newbie
*

Group: Members
Posts: 5
Member No.: 1739
Joined: 30-August 05



For those who have problems with adding XMail users to Mysql database for IMAP login.
Install instructions :

All you have to do is change the following fields:
- HOSTNAME
- DBNAME
- DBUSER
- DBPASSWORD
- DBTABLE

That's it.

I cannot attach file so here's the link www.paknet.org/xmail2mysql.zip

Xmail is using XMCrypt algoritm to crypt passwords, but imap is using plain passwords so we need a decryptor which is built in script.
I'm not using any special characters in my passwords (like %$#"!& ...), but you can add them. (line 78)

Enjoy !

Mihec
PMEmail Poster
Top
hschneider
Posted: Nov 6 2006, 04:58 PM
Quote Post


No - I'm not an answering script ...
Group Icon

Group: Admin
Posts: 6631
Member No.: 195
Joined: 19-June 02



Thanks for the contribution !


--------------------
Bye,
Harald


-- Download XMail Queue Manager 1.46 NOW: XMail Server Tools
-- Cross platform remote queue management!
-- Message analyzing on the fly!
-- Builtin diagnostics knowledge base!
-- Manages multiple mail queues!

Sponsored by
CD-Produktion und DVD-Produktion and Homestaging Saarland - Immobilien schneller verkaufen in der Region Saarland, Rheinland-Pfalz und Luxembourg
PMEmail PosterUsers Website
Top
NomadCF
Posted: Nov 11 2006, 05:56 AM
Quote Post


Wizard
*********

Group: Members
Posts: 428
Member No.: 434
Joined: 21-January 03



incase you wanted to shrink your php decoder code, here the function from my xmail sync script.

CODE


function DecryptXMailPassword($EncryptedPassword) {
$EncryptedPasswordLength = strlen($EncryptedPassword);
$DecryptedPassword = '';

for($Counter=0;$Counter<$EncryptedPasswordLength;$Counter+=2) {
  $SubEncPass = substr($EncryptedPassword,$Counter,2);
  sscanf($SubEncPass,"%02x",$CharNum);
  $DecryptedCharacterNum = $CharNum^101;
  $DecryptedCharacter = sprintf("%c",$DecryptedCharacterNum);
  $DecryptedPassword .= $DecryptedCharacter;
}

return($DecryptedPassword);
}



--------------------
-- Chris L. Franklin --
www.NomadCF.com

All my scripts are written for linux servers.
My XMail scripts
PMEmail PosterUsers WebsiteAOL
Top
0 User(s) are reading this topic (0 Guests and 0 Anonymous Users)
0 Members:
« Next Oldest | Documentation and Knowledge Base | Next Newest »

Closed TopicStart new topicStart Poll