My last try: Go to phpMyAdmin Log in as root Select database "dbispconfig" from the left On top (right side) click on "SQL" Code: UPDATE `server` SET `server_name` = 'yourdomain.bz' WHERE 1; Replace "yourdomain.bz" with your real server host name in this query.
Firstly i changed the column name in to server_name. Secondly i logged in to my server then given mysql -uroot -p command and entered into mysql. then i gave use dbispconfig command output is..Reading table information for completion of a table and column names You can turn of this feature to get a quicker startup with -A Database changed Then again i gave UPDATE 'dbispconfig'.'server' SET 'server_name'='my server name' WHERE 'server'.server_id'=1; output is Error 1064 (42000): you have an error in your SQL syntax;check the manual that corresponds to your MYSQL server version for the right syntax to use near.. Please suggest me what to do.. Thanks for your patience.
Dear Croydon... Thanks alot for your patience and help.. When i done like the way u said-----go to phpmyadmin and enter a command in sql tab of dbispconfig. It worked....but the thing is my hostname is centos.test.com but instead of centos.test.com in the server field it was showing only 'c'
Login to ispconfig, go to System > server servives, click on th server anmed "c" and change the server name from c to your full hostname, then press save.
To be honest: Do yourself a favour and leave everything as it is. You should now be able to select your "c" server for websites, so you can happily deliver your work to your client. Just an additional thought: You might be better off, looking for a managed server next time
Yes it is very happy that now i can select 'c' server to add websites.. Thanks a ton to you. Without you guys i couldn't move forward on this. I am already doing a favour to my company by installing ispconfig on vmware server. As my profession is network engineer and am not aware of this.. Thanks again for your help.
