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
11 hours 45 min ago
17 hours 33 min ago
19 hours 24 min ago
21 hours 9 min ago
1 day 59 min ago
1 day 6 hours ago
1 day 6 hours ago
1 day 11 hours ago
1 day 16 hours ago
1 day 22 hours ago