Serverumzug abgeschlossen und Zukunft von your-wbb.de

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:

[mysqld]
# Set default storage engine to MYSQL instead of InnoDB
default-storage-engine = MYISAM
# Set server character set to latin1
character-set-server = latin1
collation-server = latin1_swedish_ci
skip-character-set-client-handshake = 1
#
sql_mode="ALLOW_INVALID_DATES,NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION"
[client]
# Set client character set to latin1
default-character-set = latin1
[mysql]
# Set mysql command-line client character set to latin1
default-character-set = latin1
[mysqldump]
# Set mysqldump character set to latin1
default-character-set = latin1

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:

Step 1: Install CentOS 7
########################

I installed it with KDE Desktop (select during Installation) in Virtualbox because i just wanted to test it locally otherwise you would install it on a real server / vps.

Note 1:
-------

You will have to be root for the installation of aapanel. To do that:
1. Open a Terminal and Execute: sudo passwd root
2. After setting root password, Execute: su
3. After logging in as root proceed with installing aaPanel

Note 2:
-------

You cannot install PHP 5.2 and MYSQL 5.1 on Ubuntu 22.04, Debian 10/11/12 & Almalinux 9.5.
I tried it, the installation fails. MYSQL 5.7 and PHP 5.3 works on these System though.
This only works with CentOS 7.
You can stil get extended updates for CentOS 7 from companies like TuxCare and Freexian.

Step 2: Install aaPanel
#######################

Go to aapanel.com Website vor instructions.
Save the login details in a .txt file after the installation has finished.

Step 3: Update Firefox ESR (Optional, Virtualbox)
#################################################

The CentOS 7 stock Firefox ESR is too old to display aapanel in the browser correctly so in case you installed CentOS 7 in Virtualbox for local testing you have to upgrade firefox
to a newer version by opening a Terminal and executing:

sudo yum install firefox

Step 4: Setup aaPanel
#####################

Login to the Web Interface of aaPanel. After doing this for the First time there will be a setup wizard screen.
Select the following options then start the setup wizard:

- Nginx 1.24
- Mysql 5.1
- PHP 5.2
- phpmyadmin 4.0

Step 5: Fix Screen Resolution (Optional, Virtualbox)
####################################################

If you installed CentOS 7 Locally in Virtualbox you wont be able to change the screen resolution.
In order to fix that open a terminal and execute:

yum -y install epel-release
yum -y update
yum install make gcc kernel-headers kernel-devel perl dkms bzip2
export KERN_DIR=/usr/src/kernels/$(uname -r)

After that, in Virtualbox Navigation Bar go to "Geräte" -> "Gasterweiterungen einlegen" -> It will pop up in CentOS -> Open Folder -> Click on "VBoxLinuxAdditions.run" -> Done! (You may have to reboot)

Source: https://www.tecmint.com/install-virtualbox-guest-additions-in-centos-rhel-fedora/

Step 6: Fix phpmyadmin
######################

phpmyadmin 4.0 (the oldest version supported by aaPanel) does not work with php 5.2. So you will get an "error can't connect to mysql" error when trying to use phpmyadmin 4.0.
This is probably because php 5.2 does not support the mysqli extension. At least not by default, maybe you could add it but i do not know if this is the only issue.

My fix was to simply install php 5.6 as a secondary php version and apply it for phpmyadmin:

1. Go to aaPanel -> App Store -> Search "php" -> Click "install" for "PHP-5.6"
2. Go to aaPanel -> App Store -> Search "phpmyadmin" -> Click on "Settings" -> Go to Tab "PHP Version" -> Select PHP 5.6 and Save!

Step 7: Create (Default) Website
################################

1. Go to aaPanel -> Website -> Add Site -> Enter Domain Name *, Select PHP Version etc. -> Click "Confirm" to Create Website
2. Go to aaPanel -> Website -> Default Website -> Select the Site you just created -> Click "Confirm" to Save
3. You can now visit the Site when typing the server ip in your browser or if it's virtualbox "localhost" in the browser of the virtual machine

* If it's just a local virtualbox for testing the domain does not have to exist or can also be owned by someone else

The Website root will be: /www/wwwroot/yourdomain.com
Drop your Website Files there. You can use the aaPanel Filemanager or KDE Desktop Environment Filemanager if it's a local virtualbox server. Also for changing CHMODs.

Step 8: Create Database
#######################

Unfortunately aaPanel wants you to specify the Charset/Collation when creating a new Database and you cannot choose Latin1.
If you want the Database to be Latin1 you have to do the Following.

1. Create the Database in aaPanel and choose "UTF8" for Charset/Collation
2. Open phpmyadmin and execute the following: ALTER DATABASE your_database_name CHARACTER SET latin1 COLLATE latin1_swedish_ci;
2.1. Make sure to exchange "your_database_name" with the actual name of your Database
3. Done! The standard Charset/Collation of your Database has now been converted from UTF8 to Latin1. If you install WBB2 or Lite1 it will create the Tables using Latin1 instead of UTF8.

Note:
-----

You could also create a new database directly with phpmyadmin instead of aaPanel which will result in Latin1 as the default charset/collation: https://www.aapanel.com/forum/d/20339-how-to-add-latin1-charset-and-latin1-swedish-ci-collation/4
BUT then the Database will not show up in the aaPanel interface!

Step 9: Install Legacy Software like Lite1, WBB2, vBulletin 3 or phpBB 2
########################################################################

Every CMS that has been compatible with MYSQL 5.1 and PHP 5.2 should be compatible right out of the box with NO CHANGES needed at all!

NOTE:
You need to write "Localhost" instead of "localhost" (uppercase) as Database Host when installing a CMS (I'm not sure why)