FAQ

sFTP

What if I can’t remember my sFTP password?

The password for your Control Panel and sFTP access is the same, and can be changed from the “Password Management” tab on your instance’s management page in your account.

How can I connect to FTP on my instance?

You can’t; FTP is not supported. You must use a compatible sFTP client.

How and where do I upload files to my instance?

Upload your files with sFTP into the htdocs/ folder located int he directory name for your site, under vhosts/.

I transferred my files to my instance, but I still see the default message “It works!” on my website. Why?

When your virtual host was created, the system added an index.html file in the directory htdocs/. This is the file that displays the “It works!” message. Just delete or replace this file, so if your index file is called index.php, for example, it will then be recognized as the index file for your host.

SFTP signatures for Gandi Simple Hosting instances

The key fingerprint will have the following signature, whether your instance is hosted in our Paris or Luxembourg datacenter:

2048 35:e0:5a:a9:54:12:55:6b:ce:41:8c:c1:9e:35:1d:f6 (RSA)

1024 80:c7:a8:05:dc:79:92:f1:9c:b7:61:46:a7:ad:2d:f7 (DSA)

Database

How do I make a database for my website?

You can use the tools for the database you select. For MySQL, phpMyAdmin is a free and open source tool written in PHP used to administer MySQL databases using a web browser. It provides a graphical interface you can use to create, modify and delete databases, tables, and users.

For PostgreSQL, there is a tool called phpPgAdmin which works in a similar way. For MongoDB, the tool is called Adminer.

I cannot remember my password for MySQL, or I accidentally deleted the root account on my MySQL server. How can I retrieve it?

Initially, there is no password on the root account of your MySQL database. If you set one and you do not remember it, or you deleted the root account, you will lose root access to the database. Recovery is possible by clicking the “Reset the password” button on the Database tab on the Simple Hosting instance’s management page within your account.

How to change the MySQL 5.7 strict mode?

There is no my.cnf available on Simple Hosting, and it’s not possible to change the global settings through the CLI (SET GLOBAL).

Note

You can change the session’s settings with the ‘root’ right; defaults settings will be restored on MySQL restart.

mysql> SET SESSION sql_mode = '    ';

DNS

My registrar does not allow me to add a TXT record in the DNS zone file of my domain name.

Some registrars, when you use their DNS servers and manage the domain name DNS zone file on their control panel, do not support TXT records, which are required for adding a virtualhost to your Simple Hosting instance.

There are two ways to solve this issue:

  • Transfer your domain name to a registrar which allows TXT records in the DNS zone file when using their DNS servers (why, yes, Gandi DNS servers are able to manage TXT records), OR
  • Use external DNS servers. There are some DNS providers that can manage only the DNS servers for your domain name and allow the TXT records in their DNS zone file management interface.

PHP

Can I use the ioncube PHP Decoder with Simple Hosting?

Yes. You can upload the Ioncube Loader module via sFTP into the /lamp0/home/ folder.

Then, declare the extension in the /lamp0/etc/php/php-custom.ini file using the following line :

zend_extension = /srv/data/home/my_version_ioncube/ioncube_loader.so

Save the changed file, and then restart the instance.

Note

On PHP 5.4 instances, the module is already pre-installed and available at the following path : /usr/lib/php5/20100525/ioncube_loader.so, so you just have to include the path in the php-custom.ini file mentioned above.

Can I install and use Atos payments?

Yes. On older instances, such as the PHP 5.4 instance, we have installed the SIPS Atos modules for you to use for processing payments.

On newer instances, you must upload the modules yourself. You can place the Atos files in a subdirectory of the /lamp0/home/ directory, or in a subdirectory of the corresponding vhost. You will specify this path in the pathfile file, for example:

/srv/data/home/your_subdirectory

or:

/srv/data/web/vhosts/www.example.com/your_subdirectory

Similarly, the path specified in the pathfile parameter in the code of the request or response should specify the full (absolute) path:

$parm="$parm pathfile=/srv/data/web/vhosts/www.example.com/your_subdirectory/pathfile";

Next, in your code for making requests to the SIPS system, as well as in the response pages, you will need to specify the paths to the request and response binaries using the $path_bin variable.

On older instances :

$path_bin = "/usr/local/bin/atos/request";
$path_bin = "/usr/local/bin/atos/response";

On newer instances, for example (you can name these however you’d like):

$path_bin = "/srv/data/home/atos/request";
$path_bin = "/srv/data/home/atos/response";

Wordpress

How do I install wp-cli?

You don’t have the rights in the Simple Hosting system’s directories, but you can use alias instead.

At first, you need your SSH console to be activated, and then connect to it.

Then, run the following commands :

$ cd /srv/data/home
$ wget https://raw.githubusercontent.com/wp-cli/builds/gh-pages/phar/wp-cli.phar
$ echo "alias wp='/srv/data/home/wp-cli.phar'" >> /srv/data/etc/bash/bashrc

Afterwards, press CTRL-D (to leave current session), then press ENTER (to open a new session). And test it:

$ wp --info

Other

Can I debug my code remotely with xdebug?

Using xdebug to debug your code remotely from within your favorite IDE is perfectly possible on PHP/MySQL Simple Hosting instances as long as you have a public IP address for the instance to connect to.

To do so, indicate the following directives in your instance’s php-custom.ini configuration file:

zend_extension = /usr/lib/php5/20100525/xdebug.so
xdebug.default_enable=on
xdebug.remote_autostart = On
xdebug.remote_connect_back = Off
xdebug.remote_enable = On
xdebug.remote_handler =  dbgp
xdebug.remote_host = X.X.X.X
xdebug.remote_port = 9000

The xdebug.remote_host directive must contain your public IP address.

Once the file has been modified, the instance must be restarted for the parameters to be taken into account.

Note

Xdebug connects to the client machine on port 9000 via TCP by default. Make sure your firewall is configured to allow incoming connections on this port!

Client-side configuration depends on the software used. A list of clients is available at xdebug.org.

How do I get Google Image Preview to show my site?

Please refer to Google’s FAQ on this topic at: https://sites.google.com/site/webmasterhelpforum/en/faq-instant-previews

Public IP addresses of instances for authorization

A Simple Hosting instance does not have an public IP Address, but rather, a private IP address; this is because they are not intended to be accessed directly. All of the connections that are made to the instance (notably for websites that they host) are made through web accelerators (varnish) that are ahead of the instances.

Consequently, the IP addresses to authorize in order to allow the passage of requests coming from an instance are those from the datacenter where the instance is located:

  • LU-BI1: 217.70.186.133 and 217.70.186.134
  • FR-SD3: 155.133.132.64/26
  • FR-SD5: 155.133.138.64/26
  • FR-SD6: 155.133.142.64/26

Warning

It is important to keep in mind that any Simple Hosting instance can make requests from these IPs, whether it is your own or not.