change default user ispconfig installation

[Sinchan]

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

[till]

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.

[Sinchan]

thanks till for fast reply.
I'll do some test to try this next time and post the result here

[Sinchan]

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 :

$conf['mysql']['ispconfig_user'] = 'ispc2010';

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

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 :

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 :

/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