Adding website in ispconfig

Discussion in 'General' started by faizanelahi09, Apr 29, 2014.

  1. Croydon

    Croydon ISPConfig Developer ISPConfig Developer

    My last try:
    Go to phpMyAdmin
    Log in as root
    Select database "dbispconfig" from the left
    On top (right side) click on "SQL"

    UPDATE  `server` SET  `server_name` =  '' WHERE 1;
    Replace "" with your real server host name in this query.
  2. faizanelahi09

    faizanelahi09 New Member

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

    faizanelahi09 New Member

    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
    but instead of in the server field it was showing only 'c'
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
  5. faizanelahi09

    faizanelahi09 New Member

    Not changing...

    Do i need to uncheck the fields like mailserver,webserver,dnsserver etc.?????
  6. Croydon

    Croydon ISPConfig Developer ISPConfig Developer

    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 :)
  7. faizanelahi09

    faizanelahi09 New Member

    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.

Share This Page