change default user ispconfig installation

Discussion in 'Installation/Configuration' started by Sinchan, May 23, 2010.

  1. Sinchan

    Sinchan New Member

    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
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  3. Sinchan

    Sinchan New Member

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

    Sinchan New Member

    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 ;)
     

Share This Page