Problem creating mySQL db

[Milan]

I have reviewed previous posts but have not managed to create a mySQL db on my local machine.
mySQL install seems fine and the service is running.

In the Database setup I am specifying the following info:
Hostname
Root Username
Root Password
name for db.

When I click save - nothing happens. Infact I need to log out and then when i log in again I cannot get to any set up menu option. I am having to edit the config.inc.php to remove the above settings - which then allows me to log in again.

Help please......

[Brian]

Sounds like a mySQL configuration issue... Have you configured other mySQL applications successfully on this server?

What version of PHP and mySQL are you using?

[Milan]

mySQL version is 5.0
PHP version is 5.1.1

This is the first attempt of an app install on mySQL.

I then tried using a flat file configuration however am not able to add an event. In fact, the add event page is not presented. I am also not able to amend the categories - after some time the page builds with with many amend categiy sections with the following error: Fatal error: Maximum execution time of 30 seconds exceeded in C:\web_root\calendar\setup\verifyLogin.php on line 3.

Not sure if they are related.

[Milan]

Have installed mySQL Query and mySQL Admin - db setup appears ok.

[Brian]

Are you using the ionCube or Zend version? (Can you try the other than the one you are using now?)

[Milan]

I was using ionCube.
I installed Zend 2.6 and then downloaded and zend version.

The tester does not pick up the Zend install. I have found similar recent posts to this.

I am now able to modify the Categories - but cannot add events in a flat file or configure the db......

---- When adding an event I get the following message:
Fatal error: Maximum execution time of 30 seconds exceeded in C:\web_root\calendar\events\index.php on line 1867

The contents of this index.php are:
<?php @Zend;
3272;
/*

---- When trying to create a db, I enter the details and then press Save. The view proceeds to header view with events icon and the log off icon.

[Brian]

I'm guessing this has to do with Zend 2.6?

If it possible, can you open a support ticket about this so we can discuss possible solutions?

[Milan]

I have progressed further......
I installed Zend WinEnabler and am now able to configure the flat file. I am now faced with the following:

There was an error connecting to the mySQL database.
The error was reported as:
Access denied for user 'root'@'localhost' (using password: YES)

[Brian]

(Your car?) Nice!

The error is a mySQL error because it couldn't authenticate the user's credential as they were entered into the Setup Manager. Make sure the user and password combination exists for the mySQL user.

[Milan]

Thanks... it goes like stink.. the car that is...

The db is closer to resolution. I have the table created now in the db however I am adding events but they are not appearing in the db... have also made sure that they are also not being saved to the flatfile....

[Brian]

Is this on a server that I can access?

[Milan]

nope, sorry... local install....

[Brian]

Can you do a phpinfo(); and copy and past the results in a ticket?

[Milan]

done......

[Brian]

Everything looks normal. My best guess is an issue with PHP? Perhaps something was changed in the latest release. I'll configure a server the same as what you have now to test...

[Brian]

Please download the newest tester script (just updated), then download the calendar distribution from the tester page, then re-install the entire calendar script.