EN Ikoula wiki - User contributions [en]

Dump my MSSQL database from my WebHosting

2024-01-04T14:39:56Z

Tboillotcaaab:

==Introduction== 

We will see how to make a dump (backup) of your MSSQL database.

To do this, log on to your Plesk interface: https://en-wiki.ikoula.com/en/Access_to_the_management_interface_(Plesk)_of_my_hosting

This example show how to change the version of your database by exporting and importing your dump.

==Procedure== 

First, you need to make a backup of your database.

[[File:ExportHEB.png]]

<div style="background-color: #FF9999;">'''/!\ Check that your backup has been successful /!\'''</div>

Next, delete the existing database

[[File:Supprimer.png]]

Now create the database in the new version you want:

[[File:Créer.png]]

Finally, you can import your backup.

[[File:ImportHEB.png]]

==Conclusion== 

This new version may bring changes to certain functions, so be sure to test your new installation.

You should also check that your connection channels are the correct version.

Dump my MSSQL database from my WebHosting

2024-01-04T14:38:50Z

Tboillotcaaab:

Dump my MSSQL database from my WebHosting

2024-01-04T11:53:25Z

Tboillotcaaab:

==Introduction== 

Let's take a look at how to change your MSSQL version.

To do this, log on to your Plesk interface: https://en-wiki.ikoula.com/en/Access_to_the_management_interface_(Plesk)_of_my_hosting

==Procedure== 

First, you need to make a backup of your database.

[[File:ExportHEB.png]]

/!\ Check that your backup has been successful /!\

Next, delete the existing database

[[File:Supprimer.png]]

Now create the database in the new version you want:

[[File:Créer.png]]

Finally, you can import your backup.

[[File:ImportHEB.png]]

==Conclusion== 

This new version may bring changes to certain functions, so be sure to test your new installation.

Dump my MSSQL database from my WebHosting

2024-01-04T11:51:46Z

Tboillotcaaab: Created page with "==Introduction==  Let's take a look at how to change your MSSQL version. To do this, log on to your Plesk interface: https://fr-wiki.ikoula.com/index.php?title=Ac..."

==Introduction== 

Let's take a look at how to change your MSSQL version.

To do this, log on to your Plesk interface: https://fr-wiki.ikoula.com/index.php?title=Acc%C3%A9der_%C3%A0_mon_interface_Plesk&modqueued=1

==Procedure== 

First, you need to make a backup of your database.

[[File:ExportHEB.png]]

/!\ Check that your backup has been successful /!\

Next, delete the existing database

[[File:Supprimer.png]]

Now create the database in the new version you want:

[[File:Créer.png]]

Finally, you can import your backup.

[[File:ImportHEB.png]]

==Conclusion== 

This new version may bring changes to certain functions, so be sure to test your new installation.

File:ExportHEB.png

2024-01-04T11:50:24Z

Tboillotcaaab:

File:ImportHEB.png

2024-01-04T11:50:40Z

Tboillotcaaab:

File:Supprimer.png

2024-01-04T11:50:49Z

Tboillotcaaab:

File:Créer.png

2024-01-04T11:51:06Z

Tboillotcaaab:

Management on your Plesk Onyx management interface

2023-07-19T12:13:53Z

Tboillotcaaab:

Please note that the master NS or primary NS, i.e. the SOA field, must be the reverse DNS of the server hosting your site.

Enter your domain name and click on Info

You need to retrieve the information from the Host field and the IP address field.

You'll get a field like linheb0X.ikoula.com or winheb0X.ikoula.com, which should be the first ns to be filled in.

Secondary NS servers are : 
ns1.ikoula.nl 154.59.112.113 ns2.host2vps.com 109.238.6.158

[[Category:DNS]]

Management on your Plesk Onyx management interface

2023-07-19T12:12:33Z

Tboillotcaaab: Created page with "Please note that the master NS or primary NS, i.e. the SOA field, must be the reverse DNS of the server hosting your site. Enter your domain name and click on Info You need..."

How to install an IPv4 address on my Raspian

2023-05-27T22:32:28Z

Tboillotcaaab:

{{#seo:
|title=How to install an IPv4 address on my Raspbian
|title_mode=append
|keywords=these,are,your,keywords
|description=Discover in this article how to install an IPv4 address on your Raspian.
|image=Uploaded_file.png
|image_alt=Wiki Logo
}}

'''Problem:''' 

I have ordered an additional '''''IPv4 address''''' for my Raspberry Pi, however I can not reach it after delivery.

'''Solution:''' 
It is a normal behaviour, IKOULA provides you an additional '''''IPv4 address''''', but does not configure it on your server:
*You have to connect via IPv6 : https://en-wiki.ikoula.com/en/Connect_to_a_server_in_IPv6_via_Putty
*Edit the network configuration file and and add this block (to modify with your IP, including the gateway line)

'''nano /etc/network/interfaces'''

auto eth0:1
iface eth0:1 inet static
address 178.170.Y.X
netmask 24
gateway 178.170.Y.1
dns-nameservers 213.246.33.144

*Reboot the network service

'''systemctl restart networking.service'''

*Check the IP statue by executing:

'''ip addr show'''

*You should see:

eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP group default qlen 1000
link/ether dc:a6:32:5e:b8:f3 brd ff:ff:ff:ff:ff:ff
'''''inet 178.170.10.14/24''''' brd 178.170.10.255 scope global eth0:1
'''''inet6 2a00:c70:130:1::110/64''''' scope global
valid_lft forever preferred_lft forever

*You are now able to connect to your server via IPv4

'''/!\ There may be an error message indicating that the Eth0 interface is not created, because it has not fully restarted. After rebooting, this message should be gone. /!\'''

[[Category:Dedicated server]]
[[Category:Microserver]]

Ajouter un tutoriel

2022-04-27T13:18:45Z

Tboillotcaaab:

{{#seo:
|title=How to secure my shared hosting
|title_mode=append
|keywords=these,are,your,keywords
|description=Find in this article how to secure your shared hosting
|image=Uploaded_file.png
|image_alt=Wiki Logo
}}

==Introduction== 
You will see in this article how to secure your '''''shared hosting'''''.
 

==Sending mail==
 
To be sure that the sending of your mail is authorized only from your hosting for your domain, we invite you to check if there is an SPF record in your DNS zone.
If none is present, you can follow this article to do it : https://en-wiki.ikoula.com/en/What_is_SPF%3F 
If an mail is sent with your domain name via an unauthorized server, it will be considered SPAM and will be blocked.
For your information, you can manage your DNS zone like this : https://en-wiki.ikoula.com/en/How_to_administer_my_since_my_PLESK_DNS_zone
 
==Password==
 
Use complex password for your mailbox, your FTP access, your Ikoula accont, your WordPress interface and your database.
You can use this website to generate your password : https://www.lastpass.com/fr/features/password-generator.

* To change your FTP password, you can do it via the FTP access management on the Plesk interface : https://en-wiki.ikoula.com/en/Access_to_the_management_of_my_FTP_accounts_(PLESK)
* To change your mailbox password, you can do it via the mailbox management on the Plesk interface : https://en-wiki.ikoula.com/en/Access_to_the_Mail_management_(PLESK)
* To change your Ikoula account password, you can do it like this : https://en-wiki.ikoula.com/en/How_to_change_password
* To change your database user password, you can do it from your Plesk interface

==Keep your CMS Updated==
 
If you are using a CMS, we recommend that you keep it updated, in fact most of the hacks come from loopholes.

You can check those website that lists the loopholes :

* Wordpress : https://www.cvedetails.com/vulnerability-list/vendor_id-2337/product_id-4096/
* Joomla : https://www.cvedetails.com/vulnerability-list/vendor_id-3496/product_id-16499/Joomla-Joomla-.html
* Prestashop : https://www.cvedetails.com/vulnerability-list/vendor_id-8950/Prestashop.html 

Those loopholes are generally corrected in the updates 

Here are the links that explain how to update some CMS :

* For WordPress : https://wordpress.org/support/article/updating-wordpress/
* For Joomla : https://docs.joomla.org/J3.x:Updating_from_an_existing_version
* For Prestashop : https://addons.prestashop.com/en/data-migration-backup/5496-1-click-upgrade.html

==Plugins/Themes==
 
Use trusted plugins/themes, we are invinting you to use official websites to obtain those. for example for Wordpress, https://en-gb.wordpress.org/themes/ , https://en-gb.wordpress.org/plugins/
'''Don't forget to update them'''

Also, check the score/opinion of plugins to see if some users had problems before.

==Malwares analysiss==
 
You can launch a scan of your website to detect existing malwares via online tools like : https://sitecheck.sucuri.net/

==Sending mail with an unauthorized script==
 
If a mail is sent with a script, you can identify it in the mail header (https://en-wiki.ikoula.com/en/Recover_my_mail_headers) with the field : '''X-PHP-Originating-Script: nomduscript.php''' , then you can rename or delete so it won't execute again.

Example of a mail sent with a script :

<pre>
Return-Path: <sitename@server.example.com>
Received: from [x.x.x.x] by example.com
(MTA v5/:PGFiZWxsZW5AbWFuYWdlZHNoYXJlZDIuYXJyb3dxdWljay5uZXQ_)
with SMTP id <20130717204350103198600015> for <example@example.com>;
Wed, 17 Jul 2013 20:43:50 -0500 (CDT)
(envelope-from sitename@server.example.com, notifiable emailhost server.example.com)
Received: by server.example.com (Postfix, from userid 1040)
id 888C414E32F; Wed, 17 Jul 2013 20:27:09 -0500 (CDT)
To: example@example.com
Subject: Order Detail
X-PHP-Originating-Script: 1040:kka3f2.php
From: "First-Class Mail Service" <test@example.com>
Reply-To: "First-Class Mail Service" <test@example.com>
Mime-Version: 1.0
Content-Type: multipart/alternative;boundary="----------137411082951E7446D85129"
Message-Id: <20130718012709.888C44414E32F@server.example.com>
Date: Wed, 17 Jul 2013 20:27:09 -0500 (CDT)
</pre>

In that case, we will delete or rename *kka3f2.php* to stop it from being executed.
 

==Securing your WordPress installation==
 
For WordPress, you can secure it by following this article : https://fr-wiki.ikoula.com/fr/Comment_s%C3%A9curiser_et_maintenir_son_installation_Wordpress

==Encrypt exchanges between client and server==
 
Encrypt exchanges between client and server by issuing a SSL certificate, you can use 'Let's Encrypt' on hosting with Plesk : https://en-wiki.ikoula.com/en/How_to_install_a_certificate_Let%27s_encrypt_since_my_access_Plesk%3F
It will stopped a third-party from seeing what passes between the browser (client) and the server so they can't get important information.

We also offer SSL certificates here : https://www.ikoula.com/en/ssl-certificates

==Permissions==
It is not recommended to use full permissions for your files on your hosting (777), by default we advise you to use '755' or '705' permissions like this (755) :

[[Fichier:Permissions_HEB.PNG]]

[[Category:Web Hosting]]

File:Permissions HEB.PNG

2022-04-27T13:10:53Z

Tboillotcaaab:

File:Permissiosn.PNG

2022-04-27T13:12:10Z

Tboillotcaaab:

How to install an IPv4 address on my Ubuntu

2022-02-25T13:26:00Z

Tboillotcaaab: Created page with "<span data-link_transla..."

==Introduction== 
You ordered and additional '''''IPv4 address''''' for your Raspberry PI, but you can't reach it after delivery ?
We will explain how it is done

==Explanation== 
Firstly, it's a normal behavior, Ikoula will provide you with an additional '''''IPv4 address''''' but you still have to configure it on your server.
So to do that you will have to follow this few points :

* You need to connect via the IPv6 by following this article : https://en-wiki.ikoula.com/en/Connect_to_a_server_in_IPv6_via_Putty

* Edit the network configuration file

'''nano /etc/netplan/01-netcfg.yaml'''

* The file should look like this :

network:
version: 2
renderer: networkd
ethernets:
eth0:
dhcp4: no
addresses: [2a00:0c70:0130:0001:0000:0000:0000:XXXX/64]
gateway6: 2a00:0c70:0130:0001:0000:0000:0000:0001
nameservers:
addresses: [2a00:c70:1:213:246:33:144:53,2a00:c70:1:213:246:36:14:53]

'''DO NOT USE THE TAB KEY'''

* Add those lines :

addresses:
- 178.170.X.Y/24
gateway4: 178.170.X.1

* Now it should be like this :

network:
version: 2
renderer: networkd
ethernets:
eth0:
dhcp4: no
addresses: [2a00:0c70:0130:0001:0000:0000:0000:0310/64]
addresses:
- 178.170.X.Y/24
gateway4: 178.170.X.1
gateway6: 2a00:0c70:0130:0001:0000:0000:0000:0001
nameservers:
addresses: [2a00:c70:1:213:246:33:144:53,2a00:c70:1:213:246:36:14:53]

* Apply the changes with the command :

'''netplan try'''

(You might encounter an error, if so you need to go back to the file and fix it)

* Check that the IP is UP

'''ip addr show'''

* It should be like this :

eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP group default qlen 1000
link/ether dc:a6:32:5e:b8:f3 brd ff:ff:ff:ff:ff:ff
'''''inet 178.170.X.Y/24''''' brd 178.170.X.255 scope global eth0:1
'''''inet6 2a00:c70:130:1::110/64''''' scope global
valid_lft forever preferred_lft forever

* Now you can use the IPv4 to reach your server.


[[Dedicated server]] | [[Microserver]]