SQL DB won't connect even though database is set up properly.

[dgrandey]

I am moving my calendar from an old server to a new server. It is currently working with no problem on a server running

PHP ==> 4.4.0
MYSQL ==> 4.14

I connect to the db no problem by using the localhost for a server and user name and password that I setup on MYSQL.

In moving to the new server I am now using:

PHP ==> 5.1.2
MYSQL ==> 5.0.18

I setup a user on MYSQL by using the MYSQL utility. As root I entered the following in the command line mysql utility.

grant all privileges on *.* to <USERNAME>@localhost identified by '<PASSWORD>';

What I entered <USERNAME> and <PASSWORD> is what I ented in my setup username and passowrd.

I logged in via mysql login to verify that I can use that account.

When I change the setup in PHP Calendar for the mysql database, the setup page no longer fully loads. All I see is the header with my login name. I look at the source code and it ends the page on an open <TD> tag. I get no error message at all. It just stops creating the page.

It still works fine on my old server and I would like to bring that server down - however I have spent the last 3 hours trying to figure out why this is happening.

The main differences are the SQL and PHP versions - I made sure the user was setup on MYSQL. I also made sure I downloaded the PHP 5 version.

I am using the ioncube decoder.

I am getting ready to punt - any help will be apprecited!

Thanks,

Doug Grandey

[Brian]

Some things to try:

1) Try the latest loader from http://www.ioncube.com/loaders.

2) Try using a flat-file database and see if it works.

3) Try another application that uses mySQL.

[dgrandey]

I tried the flat file and was able to post events.

I figure SQL would be better and since I had it working on the other server that way I was trying to get it up and running on the new server. I am good with just getting it to work.

I might look into trying to fix SQL in the future. Any ideas what it might be? If the flat file is working - does that mean the ION Cube setup is ok - I believe I downloaded the latest version.

Is there any downside with the flat file - speed/security?

Thanks for the quick help.

Doug

[Brian]

Since the flat-file is working, I would assume that the calendar is installed correctly.

Are there other mySQL applications working correctly or can you test any?

Is there any downside with the flat file - speed/security?

mySQL is recommended for both speed and security.