Knowledge base

This guide explains how to uninstall a SSL certificate Whatever its type, initially installed from the Manager Infomaniak.

Delete an SSL certificate

To uninstall a Infomaniak certificate:

1. Click here in order to access the management of your product on the Manager Infomaniak (Need help?).
2. Click directly on the nameallocated to the product concerned:
   
3. Click on the action menu ⋮ located to the right of the element concerned.
4. Click on Uninstall:
   
5. Confirm the certificate's uninstallation.

This guide details the features available in relational database management on accommodation Infomaniak.

Using Views, Triggers, Stored Procedures and Routines

With regard to the management of relational databases, the functionality of the views (VIEWS) is available by default, allowing users to create views to simplify data management and presentation.

However, some advanced features, such as triggers, procédures stockées, routines and the création de fonctions, are only available on Cloud Servers These features allow for finer and more complex manipulation of data, but they are not allowed on shared servers.

This restriction is mainly due to the potential risks to the stability of the infrastructure. Poor configuration or excessive use of these features could create infinite loops or significant overloads, affecting not only the performance of the server concerned, but also the experience of all clients hosted on the same infrastructure.

This guide explains why a website may be "cracked" or no longer display anything, as a result of changing a password at the level of a Web hosting.

Broken link to database

When your website and especially a script (CMS, WordPress, Prestashop or any other application using MySQL databases) is no longer able to connect to the MySQL MariaDB database or other, an error message can be displayed, of type:

• Erreur lors de la connexion à la base de données
• Database Error: Unable to connect to the database:Could not connect to MySQL
• Link to database cannot be established

What's your last action?

In case an error occurs on your site you must always examine the recent history. In this case, has there been...

1. ... an action on your part in the configuration file of the script in question? Was it affected, changed, moved?
   
   Sometimes the involuntary insertion of a space before or after a word can cut the link between the web server and the database server. Go back to your file changes.
   If necessary, deliver an old version of the files that you've changed recently.
    
    
2. ... an action at the database password level in the Infomaniak Manager?
   
   If you change your database password via the Manager Infomaniak, then your script, which will search for its information in the databases, will no longer display anything. Changing something in the Infomaniak Manager means having to change it anywhere else. This change you have made in the Manager, you also have to report it / pass it on to the script configuration file by connecting to FTP and going to modify the correct file, in principle "wp-config.php", "configuration.php" or similar.
    
3. ... a server shift announced by Infomaniak?
   
   If this error results from a server displacement or other operation announced by e-mail and related to the product in question, don't hesitate to contact Infomaniak support.

This guide concerns users who make changes around an Infomaniak hosting on which Joomla is installed.

Preamble

• If you had to update the connection between the MySQL database and your Joomla site (to avoid error "Database connection error: could not connect to mysql" e.g.) then this procedure details how to proceed.
• Often it is a matter of prefix which was simply added in front of the existing database name and username.

Elements to be amended

Here is the information to adapt in the file configuration.php for your Joomla site to work:

1. the name of the MySQL database (e.g. bddname before, abcd_bddname after)
2. the host server of the MySQL database (e.g. mysql.domain.xyz before, abcd.myd.infomaniak.com after)
3. the username that accesses the MySQL database (e.g. userbdd before, abcd_userbdd after)
4. the path of the following two directories: /tmp and /logs
   
   

Edit File configuration.php of Joomla

To this end:

1. Click here in order to access the management of your product on the Manager Infomaniak (Need help?).
2. Click directly on the nameallocated to the product concerned.
3. Click on the button Advanced Parameters.
4. Under the tab PHP click on PHP information.
5. On the line _SERVING['DOCUMENT_ROOT'] copy the path to the right
    
   
    
6. In the left side menu, click on Databases.
7. Find and store your current MySQL information according to the above list (help: https://faq.infomaniak.com/1981).
8. In the left side menu, click on FTP/SSH.
9. Create an FTP account: https://faq.infomaniak.com/1982
10. Log in via FTP: https://faq.infomaniak.com/1130
11. Edit file configuration.php which is in the root folder of your Joomla.
12. Find the relevant paragraph and update the 4 information (according to the list above).
13. Don't forget to replace the old way (including "www") by the new way:
     
    
     
14. Save the file and that's it, your Joomla will now connect to the correct database!

a

Check for changes made

In the Joomla interface, it is possible to check folder paths /logs and /tmp:

• For the folder /logs: Go under System / Configuration then System
• For the folder /tmp: Go under System / Configuration then Server

This guide concerns the time limits for connection to MySQL databases on the Web hosting Infomaniak in the context of a web application using PHP to interact with the database.

Connection time to MySQL databases

Limited to 30 real seconds

This means that when a connection is established between the PHP application and the MySQL database, it has 30 seconds to perform all the necessary operations before the connection is automatically closed by the MySQL server.

This limit is usually defined in the MySQL server configuration and can be adjusted to the specific needs of the application.

PHP CPU time

Limited to 10 seconds

This limit refers to the CPU time allocated to running PHP scripts on the server; when a PHP script is executed, the Web server allocates some CPU time to process this script... so if the script takes more than 10 seconds to run, it will be automatically interrupted by the Web server to avoid excessive consumption of server resources.

By combining these two limits, this means that for any operation involving a connection to a MySQL database from PHP, the application has 30 real seconds to establish the connection, execute the queries and process the results, while respecting the limit of 10 seconds of CPU time allocated to the execution of the PHP script.

If an operation exceeds one of these limits, it may be interrupted by the MySQL server or the Web server, as the case may be, which may result in unexpected errors or behaviors in the application.

This guide explains how to remove a site from a Web hosting.

Preamble

• Once removed, the site will no longer appear on the Internet at its previous URL.
• The quota of sites available on your accommodation will return to a free location.

Remove a site from paid web hosting

To access Web Hosting to remove a site:

1. Click here in order to access the management of your product on the Manager Infomaniak (Need help?).
2. Click directly on the nameallocated to the product concerned.
3. Click on the action menu ⋮ to the right of the object concerned in the array that appears.
4. Click on Remove site:
   

Untie a site from a free Starter accommodation

Accommodation Starter (Basic Web page) contains only one site that is specific to the domain name itself, therefore it is not possible as for paid offers to make multisite or to remove one site to deliver another.

You can however follow the above procedure and a warning will offer you the termination of your accommodation Starter:

 

You can also directly terminate Starter accommodation:

• This will terminate your Starter web hosting product only, i.e. the part concerning your website without impact on other products, email or domain name e.g..
• You'll have to confirm the request for termination by e-mail otherwise no data will be deleted.
• Confirmation of termination shall be sent to any other Professional staff of the Organization.
• The backups will be irreparably deleted upon termination, making any restoration impossible.

To terminate:

1. Click here in order to access the management of your product on the Manager Infomaniak (Need help?).
2. Click on the action menu ⋮ located to the right of the element concerned.
3. Select option Discontinue:
   
4. Follow the procedure to the end.

This guide explains how to convert a free Web Starter offer into a more complete and enhanced paid offer, such as a shared Web Hosting plan or a Web hosting plan on a Cloud Server.

Introduction

• By purchasing a domain name from Infomaniak, you get 1 free email address as well as a basic 10 MB web space.
• With just a few clicks, you can upgrade these offers to enjoy an enhanced experience.

Modify the Starter offer - Basic Web Page

To upgrade this free offer:

1. Click here to access your product management on the Infomaniak Manager (need help?).
2. Click on the action menu ⋮ located to the right of the relevant item.
3. Click on Modify the offer:
    
   
    
4. Follow the assistant to choose the new hosting type, then proceed with payment to complete the offer change.

This guide explains how to transfer files between Web hosting and/or Cloud Server in a secure and simplified manner.

Preamble

• The FXP (File eXchange Protocol) is a method of transferring files directly between two FTP servers without the data passing through the local client.
• Using the FTP PORT and PASV commands, it allows to establish a connection between the two servers for faster and more efficient file transfer, thus saving bandwidth.
• However, this method may pose security risks if connections are not secured by FPPS, and requires a more complex configuration compared to traditional FTP transfers.

Transfer data between servers

FXP is enabled by default on Web hosting and Cloud Servers.

You can e.g. use CrossFTP, a multiplatform software to make FXP (but also FTP, SFTP, WebDav, S3, OpenStack Swift).

This guide covers server synchronization via the NTP (Network Time Protocol) protocol and timezone configuration on Infomaniak servers.

Precise synchronization of servers via NTP

Infomaniak servers are all synchronized via the NTP protocol. The company makes available its own publicly available NTP stratum-1 servers for flexible use.

To integrate these servers into your settings, use the following recording: pool.ntp.infomaniak.ch.

The default timezone configuration is UTC. However, PHP functions are designed to take into account different timezones according to specific needs.

To adjust the timezone in your PHP scripts, use the function date_default_timezone_set('UTC').

MySQL: temporal specificities

The Infomaniak infrastructure supports the functionality to work with time data accurately and efficiently, taking into account time zones, which is crucial for many modern applications:

• MySQL uses a time zone database to store and manage time zone information.
• The table mysql.time_zone contains time zone data, including information on time lags, time zone names, etc.
• The CONVERT_TZ function is used to convert one hour from one time zone to another in MySQL with the following syntax: CONVERT_TZ(dt, from_tz, to_tz), where:
  • dt is the date/time to be converted.
  • from_tz is the source time zone.
  • to_tz is the target time zone.
• Example: CONVERT_TZ('2024-05-14 12:00:00', 'UTC', 'America/New_York') Convert time 12:00:00 UTC to local time in New York.

This guide explains how to change the WordPress management password or any other Web application (Joomla, Drupal, Typo3, PrestaShop, ownCloud, etc.) installed via Infomaniak tools included in the offersWeb hosting paid.

Preamble

• Some applications also allow a change of user password directly from their dedicated interface:
  • Example: WordPress (manage users, names, passwords, roles, etc.).

Change the password of a Web app

To change the password to the administration panel of your web application, perform the following actions:

1. Click here in order to access the management of your product on the Manager Infomaniak (Need help?).
2. Click directly on the nameallocated to the product concerned:
   
3. Click on the action menu ⋮ located to the right of the relevant Web Application.
4. Click on Parameters of the application:
   
5. Click on Edit to the right of the Application:
   
6. Under Password Enter the new password (for connection to the identifier indicated above):
   
7. Click on the button Save at the bottom of the page.