PDA

View Full Version : Issue with MySQL


anfernyjohnsun
11-12-2007, 04:40 PM
I am trying to get the software installed on a development server to test. I have created a database and user in MySQL.

One question, why is there not clear step by step instructions on how to do this in the docs?

Once I enter the information in setup though, all I get is the Easy PHP Calendar header, and nothing else. There is nothing helpful in mysql.log, or any of the httpd logs.

This looks like an awesome program, and I would love to purchase and move on, but I have to tell you at this point, my initial excitement is diminishing quickly.

ve9gra
11-12-2007, 05:44 PM
That is not normal behavior. Normally you'd get right back to the same page you were on with an additional area if the script detects that the table is not present. If you're only getting the header, it would seem to indicate that a connection to your mysql server times out, or errors out.

You can open a support ticket, and provide your login info for the Setup manager as well as your FTP login info.

anfernyjohnsun
11-12-2007, 06:01 PM
You can open a support ticket, and provide your login info for the Setup manager as well as your FTP login info.

What exactly do you mean, my FTP login info? This instance is not available on the internet. I would not put something like this out on the internet if I could not get it working in a test environment first. Especially I would not install code I had no ability to vet on my servers or the internet and then give out login information.

I am able to login to the mysql instance at the command line and via standard PHP methods without problems, using the username/password information entered into the Easy PHP Calendar setup process. I am also able to create/modify tables with this account.

If I am the only user *ever* to have experienced this problem and the only solution is to give out access to my machine, then I'll go ahead and remove the software and move on.

Brian
11-12-2007, 09:54 PM
One question, why is there not clear step by step instructions on how to do this in the docs?As the docs say, there are many, many possible combinations of server configurations and each requires it's own way to set up a mySQL datbase. We really can't cover all of the possible ways to do this, but your host/server admin would and should be the best to ask how to do this on your particular server setup.

I don't recall seeing a report of this particular issue before. It would seem there is a mySQL issue with your server (not the calendar), so we would be glad to help you troubleshoot your issue to determine the cause.

You should try a flat-file database and see if that works. If it does, I would be 95% sure there is an issue with mySQL and possibly PHP's "connection" to the database.

anfernyjohnsun
11-13-2007, 03:44 PM
Thread should be changed to "PEBCAC". I found the problem, which was that I did not have the account configured correctly in MySQL.

My Bad. Thanks for the quick responses...

Brian
11-13-2007, 03:54 PM
No worries! Glad to help. :)