DB Coonection - unidentified error after upgrading from php 4 to 5.0.3

RichardODreamweaver wrote:
> David... we've now upgraded Linux, php and MySQL and enabled all the points
> that you referred to.
>
> It works like a dream!!!!

Great.

> Thanks for all your help.

My pleasure. At least we got there in the end. :)

--
David Powers
Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
http://foundationphp.com/

David... we've now upgraded Linux, php and MySQL and enabled all the points that you referred to.

It works like a dream!!!!

Session variables work great.

User login is now sooo easy!

Thanks for all your help.

(ps - yes I have changed my username due to a login user error.... can't mark this topic as solved now - sorry guys!)

RichardOMarketing wrote:
> Guess what - no connection - another unidentified error has ocurred. - It's
> not even trying!!!

Dreamweaver's trying all right, but it can't do anything if the
PHP/MySQL configuration is wrong.

> Just looking at the configure command in phpinfo, mysql and mysqli doesn't
> seem to be enabled (as per Davids query):

That's right. They're not enabled. Tell your IT department to read the
following pages in the PHP documentation:

http://www.php.net/manual/en/ref.mysql.php
http://www.php.net/manual/en/ref.mysqli.php
http://www.php.net/manual/en/ref.mbstring.php
http://www.php.net/manual/en/ref.xsl.php

You need the first three. The fourth is optional, but it's required if
you ever want to use the Dreamweaver XSL Transformation server behavior,
so it's worth enabling at the same time.

Since you're running MySQL 5.0, you don't strictly need the PHP MySQL
extension, since MySQLI is better. However, Dreamweaver doesn't support
MySQLI. Why install both if you can use only one? Two reasons:
Dreamweaver may one day support MySQLI, so it's good to be ready. More
importantly, there seem to be problems logging in to MySQL 4.1 or higher
if MySQLI isn't also enabled.

I see that your configuration uses zend-multibyte. I don't know if there
are any conflicts using it in conjunction with mbstring, but in my
experience, mbstring is necessary for working with MySQL 4.1 and higher.

--
David Powers
Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
http://foundationphp.com/

This is ridiculous....

We have now upgraded the Linux box and upgraded MySQL to V 5.0.18 and php to 5.1.2. - running on Apache 2.2.0

Because the Linux upgrade in not backwards compatible, I can't go back to a version that works!

Guess what - no connection - another unidentified error has ocurred. - It's not even trying!!!

Just looking at the configure command in phpinfo, mysql and mysqli doesn't seem to be enabled (as per Davids query):

'../configure' '--prefix=/usr' '--datadir=/usr/share/php5' '--mandir=/usr/share/man' '--bindir=/usr/bin' '--with-libdir=lib' '--includedir=/usr/include' '--sysconfdir=/etc/php5/apache2' '--with-config-file-path=/etc/php5/apache2' '--with-config-file-scan-dir=/etc/php5/conf.d' '--with-exec-dir=/usr/lib/php5/bin' '--enable-magic-quotes' '--enable-libxml' '--enable-session' '--with-mm' '--with-pcre-regex' '--enable-xml' '--enable-simplexml' '--enable-spl' '--enable-safe-mode' '--disable-debug' '--enable-memory-limit' '--enable-inline-optimization' '--enable-zend-multibyte' '--disable-rpath' '--with-apxs2=/usr/sbin/apxs2' '--disable-all' '--disable-cli'

Or am I looking at the wrong place???

When opening the original .php files, none of the scripts seem to be working now which suggestes that even some of the basic functionality is no longer working!

Do I need to get our IT body to do some better basic configuration?

I attach the text from the phpinfo.php results page for reference.

.oO(RichardOMarketing)

> I understand from another source that php 5.0.3 is not compatible with a MySQL
>version anything less than 4.1.3, which would explain a lot.

The standard MySQL extension in PHP should work with all older versions
(even a 3.x), while the extended interface MySQLi and PDO require a more
recent version (4.1 and higher) to make use of all the new features.

What's the version of the MySQL client library (check the output of
phpinfo())? It could be the source of problems too if it doesn't match
the server version. Did your "IT guru" build the PHP installation from
scratch or did he just install a precompiled binary?

Micha

RichardOMarketing wrote:
> I understand from another source that php 5.0.3 is not compatible with a MySQL
> version anything less than 4.1.3, which would explain a lot.

I doubt it. My remote server is running PHP 5.0.0 and MySQL 4.0.22.

> Trying to get us upgraded to a MySQL version higher than 4.1.3 is the next
> step - I guess thats severly out of date too!

Installing MySQL 4.1.3 would be highly inadvisable, as it was a beta
version. The first production version of the 4.1 series was 4.1.7,
released in October 2004. The current MySQL series is 5.0, which was
first released in October 2005.

--
David Powers
Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
http://foundationphp.com/

Thanks David

Temporarily, without an earlier answer, we have downgraded back to php 4.1.10a!!!!

I understand from another source that php 5.0.3 is not compatible with a MySQL version anything less than 4.1.3, which would explain a lot.

I have spoken to our IT guru who says that everything was enabled, including the MySQLi.

Trying to get us upgraded to a MySQL version higher than 4.1.3 is the next step and that is dependant on the Linux version we currently run on. - I guess thats severly out of date too!

RichardOMarketing wrote:
> I have had a sucessful connection with php 4 but it didn't support sessions so
> our IT guru has upgraded to php 5.0.3

Strange decision to upgrade to a version that's two years old, but I
suppose that may be because of dependencies on an old version of Linux.
Did your IT guru enable MySQL when compiling PHP 5? It's not enabled by
default.

If you're running MySQL 4.1 or higher, did he also enable MySQLi? The
authentication protocol in MySQL 4.1 changed, and requires MySQLi to be
enabled as well. MySQL 4.1 and higher also requires mbstring to be
enabled in PHP.

> When going back into the database connection, there were no tables so I
> checked the DB connection and I keep getting "unidentified error" when looking
> for a database.
>
> is this a recognised compatibility issue or is it more likely to be a
> permissions problem?

The code generated by Dreamweaver is fine, but your server needs to be
configured correctly to process it.

--
David Powers
Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
http://foundationphp.com/