Loading...
 
Skip to main content

Architecture / Installation


Authentification via https webserver and the users_users table using the libapache2-mod-auth-mysql

Hi

I like to use my tikiwiki 3.3 user db as source for the login via https.
So I installed ssl, dav & co and made the correct apache settings and worked, with a small problem.
The password are stored in the users_users table in the hash column as combination of login+password with a MySQL encryption.
Therefore all users have write a long password login+password on every login.

So my question where is the PHP file which writes the password into the db.
Because I like to enhance the code so that a column will hold only the encrypted password.
I know I can enable a plan text password but I like to stay on the secure site.

Thanks

Hi I am happy to give myself the answer:

1.) The password is normaly stord in the hash column with a Crypt_MD5 encryption. --> so I was wrong in the last statement with the (login+password) hash format.

The configuration you need to set everything up is the following.
It was tested on my Server Ubuntu 8.10 LTS with tikiwiki 3.1
Be aware that you cannot use the function Send an email to the user in order to allow him to validate his account. on new users because a validation is not possible to the account is not validated. Just leave the check-box unchecked.

Have fun
Max

https with an authentication via SQL (tikiwiki) hash column

Packages

Copy to clipboard
# sudo apt-get install libapache2-mod-auth-mysql libapache2-mod-php5 php5-mysql mysql-server mysql-client ssl-cert

Certificates

Copy to clipboard
# mkdir ~/ssl-certificates # cd ~/ssl-certificates # openssl genrsa -des3 -out server.key 1024 # openssl rsa -in server.key -out server.key.insecure # openssl req -new -key server.key.insecure -out server.csr # openssl x509 -req -days 365 -in server.csr -signkey server.key.insecure -out server.crt # sudo mkdir /etc/apache2/ssl # sudo cp server.crt /etc/ssl/certs/apache.crt # sudo cp server.key.insecure /etc/ssl/private/apache.key

Starting Modules

Copy to clipboard
# sudo a2enmod auth_mysql # sudo a2enmod ssl # sudo a2enmod dav

SQL user creation

Copy to clipboard
# mysql -u root -p mysql> CREATE USER 'apache-ssl'@'%' IDENTIFIED BY '***'; mysql> GRANT USAGE ON * . * TO 'apache-ssl'@'%' IDENTIFIED BY '***' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ; mysql> GRANT SELECT ON `cdswiki` . * TO 'apache-ssl'@'%';

Changes on the website configuration in

The configuration is located in /etc/apache2/sites-available/

Changes on the begin

Copy to clipboard
NameVirtualHost *:443 SSLEngine On SSLCertificateFile /etc/ssl/certs/apache.crt SSLCertificateKeyFile /etc/ssl/private/apache.key

Changes on site root

Copy to clipboard
AuthBasicAuthoritative Off AuthUserFile /dev/null AuthMySQL On AuthName "acin wiki" AuthType Basic Auth_MySQL_Host localhost Auth_MySQL_Password *** Auth_MySQL_Username apache-ssl AuthMySQL_DB cdswiki AuthMySQL_Password_Table users_users Auth_MySQL_Username_Field login Auth_MySQL_Password_Field hash Auth_MySQL_Empty_Passwords Off Auth_MySQL_Encryption_Types Crypt_MD5 Auth_MySQL_Authoritative On require valid-user

Apache restart

Copy to clipboard
# sudo /etc/init.d/apache restart