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.
The sFTP link isn’t working!¶
In order to upload files through the sFTP link, you must first have an sFTP client installed on your computer, such as FileZilla, or an sFTP browser plug-in, such as FireFTP.
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).
Bemerkung
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.
Bemerkung
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";
SSL¶
Define your SSL strategy¶
You have the possibility of making use of an SSL strategy for your website in order to force, for example, the use of the https protocol.
There are two ways you can do this:
From Gandi’s website, in the „Sites section of your instance admin, where you can choose:
HTTPS only
HTTPS and HTTP
HTTP only
By modifying your application or website directly.
For example, on a PHP instance, you can create or modify the „.htaccess“ file a the root of the „htdocs“ directory of the site in question via sFTP, and add these lines, in order to redirect all traffic over HTTPS:
RewriteEngine On
RewriteCond %{HTTPS} off
RewriteRule (.*) https://%{HTTPHOST}%{REQUESTURI}
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.
Bemerkung
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