FAQ Collection

In our FAQ collection we made available a list of frequently asked questions including answers. Should you miss a question to your problem, we will be glad to be at your disposal.

Questions

Answers

    Scripts and Data Bases


      1. How can I set up a MySQL data base?

      You can set up MySQL data bases via pd-admin under the menu item data bases. The login is carried out with your user name we sent you with our salutatory e-mail and the password you define during the installation of your data bases. The hostname of the data base server is localhost.


      4. In which folder do I have to store my CGI-scripts?

      In principle is does not matter where the scripts are stored. However, the following method has proved its worth: You create a folder with the name cgi-bin and copy your scripts into it. Please keep in mind that the scripts need execution rights. You achieve this with “chmod 755 file name”.


      5. How can I insert major data base dumps?

      Unfortunately, major data base dumps cannot be imported via phpMyAdmin. We therefore recommend you one of the following proceedings:


      1. Bigdump (http://www.ozerov.de/bigdump.php)
      Attention, unfortunately, with this method no dumps can be inserted in the “extended insert”-format. Install the bigdump-script in your web space, in the process the following data must be changed in the script:


      // Database configuration $db_name = ‘’; $db_username = ‘’; $db_password = ‘’;


      In $db_name you enter the name of the data base in which the dump is to be imported. In $db_username the login ID of the end customer the data base is assigned to is to be given. Finally, the password for the access on the data base has to be saved in $db_password. After the adjustment of the data base configuration, upload the data base dump under the name dump.sql into the folder in which bigdump is installed. Then, call bigdump.php in the browser.


      2. Import via SSH-login
      Provided that you possess a SSH-access you can also go ahead as follows: Upload the dump on to the server, afterwards log in via SSH on the server and then execute the following command:


      /usr/local/pd-admin2/bin/mysql –u USERNAME -pPASSWORD DATABASE < DUMPFILE


      For USERNAME please enter into the above mentioned command the login ID of the end customer account the data base belongs to. For PASSWORD enter the data base password of this user. DATABASE represents the name of the data base in which the dump is to be inserted (usrdb_USERNAME_...). Finally, DUMPFILE indicates the file name of the data base dump which is to be imported. Should you have any further questions, we shall be glad to be at your disposal.


      6. Can I also install additional PEAR modules?

      You can install PEAR modules for PHP in your web space. You find a convenient installation script under /faq/gopear/.


      For the installation please create a folder /home/$loginid/www.$domain/gopear/ and provide this folder with a password protection via pd-admin. Upload the installation script, which is available for download under http://go-pear.org/, into this folder and call it via http://www.$domain/gopear/ in your browser.


      For the installation click on “Next >>” on the “Welcome”-page. In the following page concerning the configuration of go-pear, you can retain all settings. On this page click on the button “Install” to start the installation. It is possible that the process requires a couple of minutes. When the setup is accomplished, you arrive at the web interface for the installation of PEAR modules with a click on “Start Web Fronted of the PEAR installer>>”.


      To use the installed modules in your scripts you have to provide an own php.ini-file in your home directory and there you have to add the folder /home/$loginid/www.$domain/gopear/PEAR to your include_path.


      8. Is a HTTP authentication via PHP possible?

      Due to the fact that the CGI-version of PHP is used on our servers, a HTTP authentication is unfortunately not possible. Naturally, you can configure an authentication with a .htaccess- file.


      11. Can PHP5-scripts be executed?

      Yes, by default, you can execute PHP5-scripts via the file extension .php5. If you want to execute PHP5-scripts under the file extension .php, please create a .htaccess file in the document folder of your domain with the content


      AddHandler php5wrap .php


      13. How do I install Typo3?

      Download the current packages from the website http://www.typo3.org/. The easiest way to install Typo3 is to use the package “4.1.1 Source with Dummy site ZIP”. If you opt for other packages, you must pay attention to the fact that for security reasons a symbolic link is not executed on our servers. Thus, substitute the symbolic link “index.php” for the destination file.


      If you want to insert RealURL, then you must import this patch to correct an error in the file class.tx_realurl.php:


      - v 4.1.1: 4.1.1-realurl.patch

      - v 4.1.6: 4.1.6-realurl.patch

      Please note that Typo3 requires extremely much memory capacity. It needs at least 64 MB main memory to be completely executable. For the installation of Typo3 extensions or the scale of large graphics even 128 MB can be required per process.


       

    Managed Server


      3. Only one IP address is set up on my server. How can I obtain more?

      Further IP addresses can be ordered by ticket system. Please include the reason for payment with your order. Please pay attention to that we can only assign new addresses, if the demand is in accordance with the conventions of RIPE. We assign maximum 6 IP addresses per server.


      5. How should the resource limits in the proposal management be adjusted to achieve a maximum performance?

      The adjusted limits have no influence on the performance of the web presence. They are merely to avoid an excessive use of the resources which would endanger the stability of the server. On principle, limits are to be assigned as economically as possible. We recommend the following data as maximum:



      • 64 MB main memory per process

      • 16 seconds CPU time

      • 200 file descriptors per process

      • 50 processes, if multiple websites are launched

      • 100 processes, if only one website is launched


      6. Where do I find phpMyAdmin?

      On all managed servers phpMyAdmin is installed under http://$server name/phpMyAdmin/. For $server name please put the name of the server into the URL. The login in phpMyAdmin is carried out with the MySQL access data (8-digit user name + data base password).

      If you want to integrate phpMyAdmin into the end customer menu, as a master reseller you can conclude this via the function of the same name in the menu “Settings”. Select “New Entry” and enter the following data:


      URL: /phpMyAdmin/
      Open in: own browser window
      Sort sequence 1: 500
      Sort sequence 2: 1000
      Description German: phpMyAdmin
      Description English: phpMyAdmin


      7. Where do I find a web-mailer?

      On all managed servers SquirrelMail is installed under http://$server name/sqirrelmail/. For $server name please put the name of your server into the URL.

      If you want to integrate SquirrelMail into the end customer menu, as a master reseller you can conclude this via the function of the same name in the menu “Settings”. Select “New Entry” and enter the following data:

      URL: /squirrelmail/
      Open in: own browser window
      Sort sequence 1: 200
      Sort sequence 2: 1000
      Description German: Webmail
      Description English: Webmail


      8. How do I create a Certificate Signing Request (CSR)?

      Log in on your web server per SSH. Best create a separate folder for which only you have the authorisation and change into this folder. You can do that for example with the commands


      mkdir certs chmod 700 certs cd certs

      Afterwards, create a private key with the command:


      /usr/local/pd-admin2/bin(openssl genrsa –des3 -out server.key.secure 1024

      Remove the password protection with the command:


      /usr/local/pd-admin2/bin/openssl rsa –in server.key.secure –out server.key

      Now you can create the CSR:


      /usr/local/pd-admin2/bin/openssl req –new –days 365 –key server.key –out server.csr

      The information necessary for the desired certificate are predominantly self-explanatory, however, please pay attention to that you must indicate the exact name of your SSL-web server (e.g. ssl.providerservice.com) under ‘common name’. You find the result in the file server.csr. Please note that you also need the private key, which is saved in the file server.key, for the later integration of the certificate. Thus, do not yet delete this file.


      10. Can I call pd.admin per HTTPS?

      Yes, this is possible. You can use the SSL-proxy to protect the communication with pd-admin. To do so, set up a sub domain via which you want to call pd-admin in the future. For this sub domain please install a SSL certificate via the SSL administration in the administrator web interface.

      PathDestination
      htmlhttp://$server name/html/
      administratorhttp://$server name/administrator/
      customerhttp://$server name/customer/
      pop3http://$server name/pop3/
      csshttp://$server name/css/
      imageshttp://$server name/images/
      jshttp://$server name/js/

      $server name must be substituted for the name of your server (e.g. m13.serverdomain.de).


      11. My php.ini file is not loaded. What can I do?

      The adjustment of the php.ini file does only function with PHP via cgiwrap. Please check, as administrator, via Settings  ->   Server configuration if the correct execution method is selected in pd-admin.

    Root Server


      1. Is is possible to use VMWARE on your servers?

      Yes, that's possible. But be aware, that you are not allowed to use more than one MAC address on your switch port. Hence, you need a routed setup, which can be configured as follows:


      IP address of the host system:   192.168.1.23
      IP address of the guest system: 192.168.1.24


      Please set your virtual network adaptor configuration to
      [x] Host-only: A private network shared with the host


      To enable the routing on your guest system, please execute the following command:


      echo 1 > /proc/sys/net/ipv4/ip_forward
      echo 1> /proc/sys/net/ipv4/conf/default/proxy_arp


      In the guest system, you have to configure your host system 192.168.1.23 as the default gateway to achieve internet connectivity:



      route add 192.168.1.23 dev eth0
      route add default gw 192.168.1.23