How to create a user database for the login tools?

Frequently Asked Questions about WYSIWYG Web Builder
Locked
User avatar
Pablo
 
Posts: 21578
Joined: Sun Mar 28, 2004 12:00 pm
Location: Europe
Contact:

How to create a user database for the login tools?

Post by Pablo »

The login tools use a database file on the server to store the user information. The data will be stored in a semicolon separated text file. The passwords will be hashed using md5 so they will be securely saved.

The following login tools will use this database file:
· Admin
· Change Password
· Login
· Password Recovery
· Signup

Note:
You should set the same database name for all login tools!

How do I automatically create a user database on the server?
All objects mentioned above do have a button in their properties window called 'Create database'.

1. Click the 'Create database'

2. Enter a name for the database, for example 'usersdb.php'. Click Next.

3. Select the publish location where you are going to publish this website to. Click Next.

Note:
If you do not see any publish locations, then you should add them first in the Publish window! You can only create the user database on a FTP server.

4. The wizard will make a connection with the server and show the folder structure.

5. Select the folder where the database should be created.

6. Click 'Finish' to create the file.
WYSIWYG Web Builder will automatically change the permission of the file so that it's write enabled, so new users can be added.
It may be useful to check if the file was sucesfully created by loggin in to your web account and check the permission.

There should be an option in your web hosting control panel to set write permissions. If it's not present, you may can contact your web hosting service and request the write permissions for the PHP code.

How do I manually create a user database on the server?
A user database is basically just a text file on the server. So if for whatever reason the instructions above fail, you can try to upload the file manually yourself.

1. Open notepad or any other plain text editor and create an empty file named 'usersdb.php'.

2. Upload the file to the same folder as your protected pages. To upload the file you can use then built-in FTP tool or any other FTP application.

3. After the file has been uploaded you must modify the permissions so that the PHP script can write data to it. The correct permissions are 757 or 777.

4. Alternatively you can use the file transfer tool of your host's control panel. There should be an option in your web hosting control panel to set write permissions. If it's not present, you may can contact your web hosting service and request the write permissions for the file.

Using a MySQL database to store the user information (for advanced users only!)As alternative for the plain text user database you can also choose to store the users in a MySQL database.
Each object has a special MySQL Database category, where you can configure the properties of the MySQL database.
However before you can use this option you must create the table on the server.

1. Log in to your MySQL administrator utility.

2. Create the USERS table:

Code: Select all

CREATE TABLE `USERS` (
`id` int(10) NOT NULL auto_increment,
`username` varchar(50) collate latin1_german1_ci NOT NULL,
`fullname` varchar(75) collate latin1_german1_ci NOT NULL,
`password` varchar(50) collate latin1_german1_ci NOT NULL,
`email` varchar(75) collate latin1_german1_ci NOT NULL,
`active` tinyint(1) NOT NULL,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;
3. You can configure the MySQL settings in the properties of the login tools.

What to do if the login tools do not work?
1. Verify if the user database was succesfully created.

2. Make sure that the user database has write permissions.

3. Make sure to have created a user by using the admin object.

The login tools will not work if the user database cannot be created due to permisson restrictions on the server. Please verify that the user database is write enabled!
Locked