I purchased your Password Protection 2.8 and am having trouble setting it up. I installed Apache, PHP and MySql using Xampp. Everything seems fine, Apache runs properly and I can go to the command prompt and connect to MySQL. However, when I run the setup.php I get the following error:

"Database Not OK
The setup script can not connect to your database. Make sure you have filled in correct variables for $mySQL_host, $mySQL_user, $mySQL_pwd and $DataBase in settings.php. If you do not know your database settings then you need to contact your web hosting company to find out.
Please also note that the database name you fill as value for $DataBase in settings.php must already have been created before you can continue."

The values in settings.php are:

$MySQL_host = "localhost";
$MySQL_user = "root";
$MySQL_pwd = "";
$DataBase = "SMSRT_db";

Any help would be greatly appreciated.

Make sure you're allowed to connect as root from a PHP script. You may ahve to setup a new user with a password to use in settings.php.

Q1: Do I need to allocate the user on MySQL via GRANT and if so what priviledges are required?

Q2: Do I need to create the database before running setup.php?

Thanks

Q1: Yes, the user must be able to read from and write to the database and also to create new tables when you run setup.php.

Q2: Yes.

Thanks, that worked.

Now I have an additional problem o rmaybe 2.

On the admin page, when I select an option (Settings...) it requires me to login again and then merely returns me to the same admin page.

I've tried the solutions from the forum but they didn't work.

The files are at:

localhost/SMSR

Here's what my settings.pho files looks like:

// Info about the database; user id and password
$mySQL_host = "localhost";
$mySQL_user = "smsrt";
$mySQL_pwd = "fred";

// The name of the database
$DataBase = "smsrt_db";

// The table with all user information
$UserTable = "smsrt_users";

// The table with all settings
$SettingsTable = "smsrt_settings";

// The table with all user groups
$GroupsTable = "smsrt_ugroups";

// The table with all log files
$LogTable = "smsrt_logs";


// Cookie path. Usually /
$CookiePath = "/";

// The domain name where the cookie will be used
$CookieDomain = "SMSR";

// Cookie time. This is how long time the cookie will be valid.
// 3600 = one hour
// 84600 = one day (24 hours)
// 604800 = one week (7 days)
$CookieTime = 3600;

// Where your password protected pages are located.
$ScriptURL = "http://localhost/";

Thanks in advance.

The problem is that you must set this to the domain name where you're using CPP otherwise the cookie will not be saved in a correct way.

If you for example will use CPP on your site www.sampleaddress.com then $CookieDomain should be www.sampleaddress.com or .sampleaddress.com. The later will work on www.sampleaddress.com, sampleaddress.com and subdomain.sampleaddress.com.

When the sight is deployed I understand the solution. However, the site is currently under development and is located in the "localhost/SMSR" directory. Under these conditions what should $CookieDomain be set to?

$CookieDomain = "localhost"; ?
$CookieDomain = "localhost/SMSR"; ?

Thanks for the help.

I'm not sure because I have never installed the script on localhost, but I think you should try with just localhost because that's the most logical option.

/Andreas

Just thought you would like to know. I tried setting:

$CookieDomain = "localhost";
$CookieDomain = "localhost/SMSR";

with:

$CookiePath = "/SMSR";
$CookiePath = "/";

None of these combinations worked. What ended up working was this:

$CookiePath = "/SMSR";
$CookieDomain = "";

Thanks for your help

$CookieDomain = "localhost";
$CookieDomain = "localhost/SMSR";

with:

$CookiePath = "/SMSR";
$CookiePath = "/";


above code can solve your problem.