Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 23rd May 2010, 11:20
Sinchan Sinchan is offline
Member
 
Join Date: Nov 2006
Posts: 48
Thanks: 14
Thanked 2 Times in 2 Posts
Default change default user ispconfig installation

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
Reply With Quote
Sponsored Links
  #2  
Old 24th May 2010, 15:50
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,015
Thanks: 840
Thanked 5,652 Times in 4,461 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 24th May 2010, 16:20
Sinchan Sinchan is offline
Member
 
Join Date: Nov 2006
Posts: 48
Thanks: 14
Thanked 2 Times in 2 Posts
Default

thanks till for fast reply.
I'll do some test to try this next time and post the result here
Reply With Quote
  #4  
Old 25th May 2010, 18:37
Sinchan Sinchan is offline
Member
 
Join Date: Nov 2006
Posts: 48
Thanks: 14
Thanked 2 Times in 2 Posts
 
Default 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'] = '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
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
Reply With Quote
Reply

Bookmarks

Tags
ispconfig3, user install

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Proftpd + MySQL virtual users, can't connect geekman HOWTO-Related Questions 28 27th September 2010 19:03
Vhosts...conf not synced to changes crypted General 50 24th April 2010 01:54
Loads of mysql connections to dbispconfig StrikerNL General 2 5th March 2009 15:31
Mail System Error - Returned Mail tristanlee85 General 16 16th March 2008 10:40
High Availability Samba cluster - DRBD + Heartbeat djalex Server Operation 58 25th May 2007 20:38


All times are GMT +2. The time now is 18:04.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.