AFAIK, when we create new ispconfig 3 installation, default username in mysql for ispconfig installation is ispconfig. Can we change the default user name database to other name ? And how can i do that? Any help is very very apreciated
You can set the ispconfig username in the install/dist/conf/* files before ispconfig is installed. But I never tried this, so it might be that there is still some other place where the name is hardcoded.
testing result : ISPConfig 3.0.2.1 in debian lenny I've been doing testing to change ispconfig default user database. Iam debian user, so i just change username db in conf/debian40.conf.php in line 65 : Code: $conf['mysql']['ispconfig_user'] = '[B]ispc2010[/B]'; Installation process is work like usual, i didnt see any error message. I'd double check in ispconfig_install.log So there is no problem in installation process. This is my test result changing ispconfig default user database: 1. Checking mysql user default : PASSED Code: mysql> select user,host from user; +------------------+-----------------+ | user | host | +------------------+-----------------+ | root | 127.0.0.1 | | debian-sys-maint | localhost | | ispc2010 | localhost | | root | localhost | +------------------+-----------------+ 4 rows in set (0.00 sec) 2. Login to ispconfig web using user admin : PASSED 3. Create client, email domain, sites (php=fast-cgi), and DNS record, dig domain name : PASSED 4. Login to ispconfig web using user client : PASSED 5. Create ftp user, create 2 user email, login to squirrelmail, test send and receive email and add new DNS A record (ftp) : PASSED 6. create new mysql database, upload wordpress via ftp, install wordpress, do some test like post, install plugins etc in wordpress environment : PASSED 7. ISPConfig log and monitoring : FAIL I found 2 error : - Email warning log : Code: May 25 20:49:09 debian amavis[3849]: (03849-01) (!!)TROUBLE in process_request: connect_to_sql: unable to connect to any dataset at (eval 86) line 241, line 3. May 25 20:49:09 debian postfix/smtp[3885]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem May 25 20:49:09 debian postfix/smtp[3886]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem May 25 20:49:10 debian postfix/error[3889]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem May 25 20:49:10 debian postfix/error[3890]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem May 25 20:49:10 debian postfix/error[3891]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem May 25 20:49:11 debian postfix/qmgr[3884]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem May 25 20:50:11 debian amavis[3888]: (03888-01) (!!)TROUBLE in process_request: connect_to_sql: unable to connect to any dataset at (eval 86) line 241, line 3. May 25 20:50:11 debian postfix/smtp[4153]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem - ISPC Cron log : Code: /bin/sh: /usr/local/ispconfig/server/server.sh: No such file or directory /bin/sh: /usr/local/ispconfig/server/server.sh: No such file or directory /bin/sh: /usr/local/ispconfig/server/server.sh: No such file or directory SIOCDELRT: No such process Ignoring unknown interface eth1=eth1. iptables: No chain/target/match by that name iptables: No chain/target/match by that name iptables: No chain/target/match by that name so.. in my opinion, changing default user database is not recommended, especially to ispconfig junior user like me