Importing alias domains

Discussion in 'General' started by vistree, Sep 19, 2012.

  1. vistree

    vistree Member

    Hi, I want to set up a new ispconfig 3 server. Now I have one big problem - for one web domain, I have > 1000 alias-domains. Is there any way to import a list of alias domains inside ispconfig? Or is there any other way to do this? Maybe directly through mysql queries?

    Have a nice evening!
     
  2. Croydon

    Croydon ISPConfig Developer ISPConfig Developer

    Hi, you can use the api for this. Just check out the examples in the api client directory of your ispconfig download.
    There should be a sample file for creating domain alias.

    remoting_client/examples/sites_web_aliasdomain_add.php
    Just extend this file to loop through an array (or import a csv). Dont forget to create a remote user in ispconfig that has the rights to create the domains :)
     
    Last edited: Sep 20, 2012
  3. vistree

    vistree Member

    Hi Marius,
    thank your for your reply. This is a great hint! I will try to use this. Thought, that it could be easier to just create a mysql query, as it seems, that all the alias domains are just in one table without links to other tables?!
     
  4. Croydon

    Croydon ISPConfig Developer ISPConfig Developer

    Oh no ;) Please do not use mysql queries.
    If you would do this, the alias domains would not be created inside the apache vhost. For this the system needs a datalog entry that would not be created then.
     
  5. vistree

    vistree Member

    Ah, OK. Thank you again! I will use the remote api.
     
  6. vistree

    vistree Member

    Some values are NULL

    Hi again,
    know I tried the script mentioned by Marius. I am wondering, that some values in the database are set to NULL while they have string values when I create an alias through the web gui itself. As I want to create the alias-domains without a redirect, I am not sure if this can cause problems?!

    All this fields are set to NULL in the database independent the string I put in the php-script. In brackets, I put values which are created when I create the alias through the ispconfig GUI:

    document_root (/var/www/clients/client1/web5)
    system_user (web5)
    system_group (client1)
    php_open_basedir (/var/www/clients/client1/web5/web:/var/www/clients/client1/web5/tmp:/var/www/bgesundes-krefeld.de/web:/srv/www/bgesundes-krefeld.de/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin:/etc/phpmyadmin:/var/lib/phpmyadmin:/usr/share/php)

    Any thoughts on this? Can I ignore this matter?
     
  7. Croydon

    Croydon ISPConfig Developer ISPConfig Developer

    Some values are only for the main website domain, not for alias domains (like document root or open basedir). Alias domains do not have a system_user either.
    You can have a look inside the interface/web/sites/form/web_aliasdomain.tform.php - only the fields listed there (and some basic fields like the server_id and sys_user etc) are used.
     
  8. vistree

    vistree Member

    Hi Marius,
    thank you again. I was just wondering, as this fields are inside the alias_add-script and also filled by the web-GUI of ispconfig ...
    So, I will ignore this fact ;-)
     

Share This Page