Error Message

[jaminjavajoe]

Hi, I'm trying to get this calendar http://open.appideas.com/Calendar/ working but for some reason I'm not able to login in even though I'm using the exact user name and password that I put in the common.php file of the script. I get this message Your username and password combination did not match any known administrators of this system. Please try again.


I went to MySql and was looking around and found this:

PMA Database ... not OK[ Documentation ]
General relation features Disabled

Can someone explain this to me?

TIA

Joe

[mitchind]

The phpMySQL error you see can be ignored - it's just an informational message about certain features that are not enabled for MySQL - nothing you can do about it - nothing to worry about.

To get your login working properly you'll have to login to your OPS Control Panel, go to MySQL and check to see what privileges are assigned to the user that your are trying to login with in the Calendar App.

Also read the documentation for the App and see what kind of privileges it needs. If it's trying to create the database it won't be able to - you need to set the database up first yourself. The app can then create tables as it needs.

[mitchind]

Looking at the README file .. did you create the database as per the instructions? It seems like they require YOU to manually create the database and tables. Have you done that - and can see them all in phpMyAdmin?


2) Move into the "tools" directory and create the database.
This can usually be accomplished with the following
command (assuming that you have a database already setup
and that database is called "db_name"):
mysql -h database.host.name -u database_username -p db_name < DB
You will be prompted for a password and the contents of
the "DB" file will be dumped into the database called
"db_name"

3) Go to the main distribution directory and open the
common.php file. You'll need to change the values for
connecting to the database as well as the variables
related to your server in the following section. The
$glbl_WebRoot is relative to your web site's root
directory. You will need to change the $glbl_WebAddress
variable and might need to change the $glbl_WebRoot
variable. You can probably leave the others alone.

[jaminjavajoe]

This part threw me.........

2) Move into the "tools" directory and create the database.
This can usually be accomplished with the following
command (assuming that you have a database already setup
and that database is called "db_name"):
mysql -h database.host.name -u database_username -p db_name < DB
You will be prompted for a password and the contents of
the "DB" file will be dumped into the database called
"db_name"

What I ended up doing was creating the database in MySQL and then importing the 9 kb DB file which give me 15 tables.....hum? I know next to nothing about MySQL so I'm not able to see or tell if that is correct.

maybe that isn't the way to do it.......... Hum?

Is there better way to install db manually ?

TIA

Joe

[mitchind]

Sounds like you've done step 2 right. Especially if you can see the 15 new tables.

To check step 3 then you'll need to give us what you're using for variables in the common.php file. Comment out passwords.

[jaminjavajoe]

Thanks, this is what I got for the DB:

$DBHost = "mysql10.powweb.com";
$DBUser = "sosmin";
$DBPass = "XXXXXX";
$DBName = "sosmincalendar";

[jaminjavajoe]

Sorry, this is the rest of the varibles in the common.php file

$glbl_WebAddress = "http://www.sosmin.com";
$glbl_SecureWebAddress = "https://sosmin.powweb.com";
$glbl_UnixPath = "/home/users/web/b894/pow.sosmin/htdocs/calendar";
$glbl_WebRoot = "/calendar";
//$glbl_AdminRoot = "$glbl_WebRoot/admin";
$glbl_WebAdminRoot = "$glbl_WebRoot/admin";
$glbl_CssRoot = "$glbl_WebRoot/css";
$glbl_CssPath = "$glbl_UnixPath/css";
$glbl_TemplatePath = "$glbl_UnixPath/templates";
//$glbl_ImagePath = $unixPath."/img";
//$glbl_ImageRoot = $webRoot."/img";
$glbl_MailFrom = "calendar@yourdomain.com";
$glbl_EmailSubject = "Calendar Submission";

Thanks again,

Joe

[mitchind]

Well if you can login to phpMySQL using those parameters and create tables, then I think the only next step is to contact the people who made the software. It looks like very old stuff though so I wouldn't keep my hopes up.

Also because they appear to not have many recent updates their software may be susceptible to SQL injection and unpatched holes. Something to think about - and ask about.