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
8 hours 26 min ago
11 hours 10 min ago
16 hours 36 min ago
19 hours 3 min ago
19 hours 46 min ago
20 hours 58 min ago
22 hours 32 min ago
1 day 4 hours ago
1 day 5 hours ago
1 day 8 hours ago