need help getting phpmysqladmin setup on win03 server

[mopacfan]

I just installed phpmyadmin on my windows server. First off, I'll start by saying I'm php illiterate. I'm an asp developer. But in order to offer hosting for others on my server, I need to offer this tool. I installed the latest version of php then installed this program.

When you first bring up the page, it generates an error (

http://phpmyadmin.otbv.com)

But if you clear the query string and re-open the home page, it brings up the login page. I was told by one of the folks on souceforge that it's not loading the css.

I've set up the working config file based on the example config file, but changed the control user name and password. I also ran the commands to add the necessary permissions for the new control user. I've also set the file paths correctly and have the permissions set for those paths.

So my first question is: What is causing the error and how can it be eliminated?

My next question is: Once this is running properly, how do I set user limits on how many databases they can create?

Any and all help will be greatly appreciated.

MoPacFan

 

[jpadie]

limits on databases:

normally you don't set limits. if a user buys three databases you create three databases for him/her and assign privileges to his/her user name, keeping the create database privileges for root (or another higher level user).

make sure that the user cannot "see" other databases from within mysql. this is a flag within the database privileges. more information can be obtained from the mysql forum.

on the css error:
i am not seeing any error so I assume that you have fixed this.

 

[mopacfan]

jpadie,

Thanks for the help w mysql.

As for the error, it's still there. It takes me to:

http://phpmyadmin.otbv.com/error.php?lang=en&dir=ltr&type=Error&error=

 

[jpadie]

when i click on the first link, there is no error. just a login screen.

when I click on the second link i get a blank (ish) screen with no error message (but there is a bordered red box saying pypmyadmin error).

 

[mopacfan]

Yep, that's the error. I don't understand what's causing it.

 

[jpadie]

but, as i said, i do not get the error on your login page. are you saying that you get an error when you log in?

if so, i'd guess the issue is with your config file

 

[mopacfan]

No, this error is on the "home" page. Once I get there, if I clear away the query string and re-enter the page, I get the login screen.

I think this has something to do with the sessions. In the sourceforge forum, this was brought to my attention:

http://phpmyadmin.otbv.com/sessions.php

but I don't know what it means or how to correct it.

 

[jpadie]

this means that you have not correctly configured php yet. in the php.ini you will (or should) have specified a value for the session directory. the relevant directive is

session_save_hander=files
session_save_path="c:\path\to\some\directory"

the directory that you choose must exist. you must also make sure that the credentials under which php runs (typically IUSR_[machinename]) has read, write and create access on that directory. do this by right clicking on the directory, select security and add the IUSR.

if you make changes to php.ini then remember to restart your webserver afterwards

 

[mopacfan]

That's what I thought. I have "everyone" set to rwxd on that folder. So this is why I'm perplexed. I'll add the iis user as well.