Add new comment
|
Well, I did some tweaking to IlohaMail that allows me to login using email address instead of username. Here is the procedure:
1)Setup a new MySQL username for accessing db_ispconfig database. For example, let's say it will be ilohamail. I did this step using phpmyadmin as root user. DO NOT MAKE ANY PRIVILEGES FOR ACCESSING ISPConfig's DATABASE YET! 2)Add privileges to ilohamail user for certain ISPConfig tables and their fields: GRANT SELECT ( `doc_id` , `user_username` , `user_emailalias` , `user_email`) ON `db_ispconfig`.`isp_isp_user` TO 'ilohamail'@'localhost'; This will enable IlohaMail access to only username - hostname parts of the tables and not any further info. If you named your database otherwise than db_ispconfig be sure to change that. 3)Change ./conf/db_config.php and add following lines: $DB_ISP_HOST="localhost"; 4)Change ./conf/conf.php and add this: $ISP=1 Put it somewhere into php tags (and not at the end of the file!) 5)Copy include/idba.MySQL.inc into include/idba_isp.MySQL.inc cp include/idba.MySQL.inc include/idba_isp.MySQL.inc 6)Open include/idba_isp.MySQL.inc and replace all: $DB_HOST, $DB_USER, $DB_PASSWORD and $DB_NAME with $DB_ISP_HOST, $DB_ISP_USER, $DB_ISP_PASSWORD, $DB_ISP_NAME Leave $DB_PERSISTENT as it is. 7)
Open source/index.php. Look for includes (lines 51+). Add the following after include_once("../conf/login.php") : // check if we're in ISP config mode Find this lines at around line 110: //attempt to initiate session
//attempt to initiate session
Reply |





Recent comments
6 hours 6 min ago
7 hours 49 min ago
10 hours 14 min ago
10 hours 20 min ago
14 hours 54 min ago
16 hours 55 min ago
20 hours 19 min ago
22 hours 25 min ago
22 hours 36 min ago
1 day 1 hour ago