database connection problems

[lawrie]

Hi,
Just tried to create a database connection to a new site and get this error
message:

Client does not support authentication protocol requested by server;
consider upgrading MySQL client

I can create database connections to existing sites that already have a
working database.
any help appreciated.
lawrie

[lawrie]

Googled & found the answer. Checked & my host has upgraded to Mysql 4.1
which needs a new password authorisation.....just need to find out what I
have to do.

"lawrie" <lawrie@nospamplease.com> wrote in message
news:d2gq35$evd$1@forums.macromedia.com...
: Hi,
: Just tried to create a database connection to a new site and get this
error
: message:
:
: Client does not support authentication protocol requested by server;
: consider upgrading MySQL client
:
: I can create database connections to existing sites that already have a
: working database.
: any help appreciated.
: lawrie
:
:

[henuyken]

Hi, I recently had a similar problem with MySQL 4.1x. They(MySQL) changed the
password scheme to make it more secure. Unfortunately this locks out older
MySQL clients that do not support this newer authentication style. You can
contact the host to have them turn on a feature built into MySQL 4.1x server
software called: 'Use Old Passwords' for certain users like yourself. I was
using PHP 4.3.9 which had a php client that was too old. When I switched to PHP
5.0.3 some of my CMS(Content Management Software) based on PHP did not function
anymore. Another problem was that PHPMyAdmin (a common MySQL client admin
web-based interface) did not work with the MySQL 4.1x/PHP 4.3x combo. I am not
sure but I believe that Dreamweaver does not support the newer MySQL 4.1x
formats. For one thing it is recommended to not use the mysql client but the
newer 'mysqli' client to connect. All in all it is quite problematic to work
with MySQL 4.1x or PHP 5.0x because it is not supported yet by enough software
packages yet. Hope this helps. Hassan

[lawrie]

Hassan,
Thanks for the info.
I have contacted my host but am still waiting :(
I am puzzled because I created the database and user/password on the hosts
set up so I cannot understand why this error occurs.
Hope all will be clearer when they respond.
regards
lawrie
"henuyken" <webforumsuser@macromedia.com> wrote in message
news:d2hj8e$ntm$1@forums.macromedia.com...
: Hi, I recently had a similar problem with MySQL 4.1x. They(MySQL) changed
the
: password scheme to make it more secure. Unfortunately this locks out older
: MySQL clients that do not support this newer authentication style. You can
: contact the host to have them turn on a feature built into MySQL 4.1x
server
: software called: 'Use Old Passwords' for certain users like yourself. I
was
: using PHP 4.3.9 which had a php client that was too old. When I switched
to PHP
: 5.0.3 some of my CMS(Content Management Software) based on PHP did not
function
: anymore. Another problem was that PHPMyAdmin (a common MySQL client
admin
: web-based interface) did not work with the MySQL 4.1x/PHP 4.3x combo. I
am not
: sure but I believe that Dreamweaver does not support the newer MySQL 4.1x
: formats. For one thing it is recommended to not use the mysql client but
the
: newer 'mysqli' client to connect. All in all it is quite problematic to
work
: with MySQL 4.1x or PHP 5.0x because it is not supported yet by enough
software
: packages yet. Hope this helps. Hassan
:

[David Powers]

lawrie wrote:

> Hassan,
> Thanks for the info.
> I have contacted my host but am still waiting :(
> I am puzzled because I created the database and user/password on the hosts
> set up so I cannot understand why this error occurs.

Is this problem happening purely locally, or are you using your host as
a remote testing server? Your host should have done all the necessary
changes to the password tables for local connection on the host's
system. If you are trying to connect from your personal computer, you
will also need to update your PHP installation.

MySQL 4.1 uses a new code library, which is only available in the most
up to date versions of PHP. I have been using Dreamweaver MX 2004
successfully with PHP 5 and MySQL 4.1 for several months. The problem
doesn't lie with DW, but with your MySQL code libraries, which are out
of date.

--
David Powers
Author, "Foundation PHP 5 for Flash" (friends of ED)
Co-author "PHP Web Development with DW MX 2004" (Apress)
[url]http://computerbookshelf.com[/url]

[lawrie]

David,

Appreciate some help here as my host is not being too helpful.

Firstly I test locally but I created the database & user on my hosts admin
and link to that.
I usually create the database locally & then upload it but on this occassion
I did not.
I can link to a database on any of my other sites if I use an existing user
but *not* if I create a new one.
Unfortunately this new site does not have an existing user.

I know it is not a DW problem as I created a page in noteapad and used the
Connection String that my host generates when a database is created and
still got the authentication problem.

I

I am using PHP 4.2.3. I downloaded the bundle in 2003 after you recommended
it on the PV11 forum and all has been well.
My host uses PHP 4.3.10 and mysql 4.1

Although my installation is old I cannot see how the problem is local.

I am wary about upgrading my installation as I know enough only to cause
damage but
if you can recommend what to do I would give it a go.

I have a resellers account on a shared server. I am not sure where the
databases are stored but I would assume all reside in a single folder.
As a bottom line, what would the problems be if I linked to a database on a
different site that I host?

thanks

lawrie


"David Powers" <dp@example.com> wrote in message
news:d2i1jo$dql$1@forums.macromedia.com...
: lawrie wrote:
: > Hassan,
: > Thanks for the info.
: > I have contacted my host but am still waiting :(
: > I am puzzled because I created the database and user/password on the
hosts
: > set up so I cannot understand why this error occurs.
:
: Is this problem happening purely locally, or are you using your host as
: a remote testing server? Your host should have done all the necessary
: changes to the password tables for local connection on the host's
: system. If you are trying to connect from your personal computer, you
: will also need to update your PHP installation.
:
: MySQL 4.1 uses a new code library, which is only available in the most
: up to date versions of PHP. I have been using Dreamweaver MX 2004
: successfully with PHP 5 and MySQL 4.1 for several months. The problem
: doesn't lie with DW, but with your MySQL code libraries, which are out
: of date.
:
: --
: David Powers
: Author, "Foundation PHP 5 for Flash" (friends of ED)
: Co-author "PHP Web Development with DW MX 2004" (Apress)
: [url]http://computerbookshelf.com[/url]

[David Powers]

lawrie wrote:

> I am using PHP 4.2.3. I downloaded the bundle in 2003 after you recommended
> it on the PV11 forum and all has been well.

2003 is a long time ago, and I've no recollection of what I might have
recommended then. I certainly hope it wasn't the firepages.co.au
package. I know some people in the PVII forum were saying how wonderful
it was, but I've heard lots of bad things, too. I've never used it
myself, and certainly wouldn't recommend it now (I'm not sure if I ever
did).

> My host uses PHP 4.3.10 and mysql 4.1

When you face problems like this, it's best to use the same setup as
your host. There's nothing mega in the difference between PHP 4.2.3 and
4.3.10 that would affect your working with MySQL, but the huge
difference lies in MySQL. It now has a completely new authentication
protocol. Hence your problems.

> I am wary about upgrading my installation as I know enough only to cause
> damage but
> if you can recommend what to do I would give it a go.

I would start with upgrading MySQL. Grab hold of MySQL 4.1.10a (if you
are on Windows, use the Windows Essentials version). You must uninstall
any existing version, and also remove Mysql as a Windows service before
proceeding. If you're on a Mac, you need to backup your data first. Let
me know which system you're on, and I'll give you a rundown of what you
need to do.

> As a bottom line, what would the problems be if I linked to a database on a
> different site that I host?

If you have an existing database on the same server, you should have no
difficulty linking to it even from a different domain. My
japan-interface and computerbookshelf sites share the same db.

--
David Powers
Author, "Foundation PHP 5 for Flash" (friends of ED)
Co-author "PHP Web Development with DW MX 2004" (Apress)
[url]http://computerbookshelf.com[/url]

[lawrie]

"David wrote :
: 2003 is a long time ago, and I've no recollection of what I might have
: recommended then. I certainly hope it wasn't the firepages.co.au
: package.

Yes, that's what I have although not sure who recommended it. It has
worked, however, without problem.


:
::
: I would start with upgrading MySQL. Grab hold of MySQL 4.1.10a (if you
: are on Windows, use the Windows Essentials version).

I am doing that now

You must uninstall
: any existing version, and also remove Mysql as a Windows service before
: proceeding.

I have looked at some documents before asking you here.
Most of them (regarding uninstall) have mysql installed in the c dir :
....mine is inside the phpdev folder in side the c dir.
Is it OK to delete it from there?
I assume I backup the data folder?

How do I delete it as a windows service? I have looked at services in the
control panel ( administrative tools) and canot find it listed.

: If you have an existing database on the same server, you should have no
: difficulty linking to it even from a different domain. My
: japan-interface and computerbookshelf sites share the same db.

That is reassuring.

This is definately a hosting problem. My host has autoinstall scripts
(polls etc) I I have tried those and they generate the same error. They
have updated to 4.1 but left some issues unresolved.
I have sent another help desk message to them but remain unimpressed when
they blamed DW and advised posting on their own forums for a solution
:
:Thanks for the help

lawrie

[David Powers]

lawrie wrote:

> "David wrote :
> : 2003 is a long time ago, and I've no recollection of what I might have
> : recommended then. I certainly hope it wasn't the firepages.co.au
> : package.
>
> Yes, that's what I have although not sure who recommended it. It has
> worked, however, without problem.

Oh dear. It's when you try to remove firepages that I believe problems
can occur. You should check their site to see what instructions, if any,
they give regarding uninstalling.

> Most of them (regarding uninstall) have mysql installed in the c dir :
> ...mine is inside the phpdev folder in side the c dir.
> Is it OK to delete it from there?

You shouldn't just delete it, but uninstall it through Control Panel.

> I assume I backup the data folder?

Normally, the data folder is untouched by an uninstall, but definitely
back it up.

> How do I delete it as a windows service? I have looked at services in the
> control panel ( administrative tools) and canot find it listed.

You must remove the service *before* uninstalling MySQL. Open a Windows
Command Prompt, and type:

net stop mysql

When it has stopped, you need to change directory to the mysql\bin
folder. Then type:

mysqld --remove

You can now safely uninstall MySQL.

When you install the Windows Essentials version, the configuration
wizard will ask you if you want a Multifunctional Database (the
default). Unless your host supports InnoDB tables (most don't), you
should select "Non-transactional database only". You can always change
the setting later, if you ever want to enable InnoDB tables.

If you can't uninstall mysql as a Windows service, the configuration
wizard will warn you that it already exists. *Don't* accept the option
of using it, because it will point to the wrong program files. Choose a
different name, such as "mysqlnew".

--
David Powers
Author, "Foundation PHP 5 for Flash" (friends of ED)
Co-author "PHP Web Development with DW MX 2004" (Apress)
[url]http://computerbookshelf.com[/url]

[lawrie]

"David wrote :
: Oh dear. It's when you try to remove firepages that I believe problems
: can occur. You should check their site to see what instructions, if any,
: they give regarding uninstalling.

I have been on the site and it starts to look flaky.
I am not sure if you know the package but in the phpdev folder is the apache
monitor application as well as all the php dev stuff.
There installation instructions are reasonably clear but also involve
removing the apache monitor.
Should I do this or is there another bundle I can download that will install
this?
:
: > Most of them (regarding uninstall) have mysql installed in the c dir :
: > ...mine is inside the phpdev folder in side the c dir.
: > Is it OK to delete it from there?
:
: You shouldn't just delete it, but uninstall it through Control Panel.

It does not show anywhere in the CP
:
:
: > How do I delete it as a windows service? I have looked at services in
the
: > control panel ( administrative tools) and canot find it listed.
:
: You must remove the service *before* uninstalling MySQL. Open a Windows
: Command Prompt, and type:
:
: net stop mysql
:
: When it has stopped, you need to change directory to the mysql\bin
: folder. Then type:

: mysqld --remove

the bin folder is in the c drive phpdev/mysql/bin....what would the correct
syntax be to change to that in the command line?

thanks for the support :)
lawrie

[David Powers]

lawrie wrote:

> I have been on the site and it starts to look flaky.

Sorry to hear that. The last time I took a look was to see what they
were doing about PHP 5 (quite a few months ago). I wasn't impressed. The
real problem with such packages is that they're often made by
individuals or small groups, so continued support for what may
originally have been something very useful cannot be guaranteed.

> There installation instructions are reasonably clear but also involve
> removing the apache monitor.

Remove everything if you can. Installing Apache and PHP are very
straightforward. These revised instructions I wrote for readers of
Foundation Dreamweaver MX 2004 are complete, except for the very last stage:

[url]http://www.friendsofed.com/books/1590593081/errata2.html[/url]

The final stage (which refers back to the book) simply involves changing
the location of the Apache DocumentRoot. In httpd.conf, you search for

DocumentRoot "C:/Program Files/Apache Group/Apache/htdocs"

Change it to wherever you want Apache to keep all your web pages and
sites. I normally recommend a folder called htdocs at the top level of
your C drive. So, the previous line becomes:

DocumentRoot "C:/htdocs"

About 25 lines further down, you should find

<Directory "C:/Program Files/Apache Group/Apache/htdocs">

Change this to point to the same folder as before. My normal
recommendation is:

<Directory "C:/htdocs">

Note that the slashes must be *forward*, not the Windows default
backslashes.

> : You shouldn't just delete it, but uninstall it through Control Panel.
>
> It does not show anywhere in the CP

I presume, then, that it's all linked in with phpdev.

> the bin folder is in the c drive phpdev/mysql/bin....what would the correct
> syntax be to change to that in the command line?

Yes.

--
David Powers
Author, "Foundation PHP 5 for Flash" (friends of ED)
Co-author "PHP Web Development with DW MX 2004" (Apress)
[url]http://computerbookshelf.com[/url]

[lawrie]

David

great help & very clear :)

thanks

lawrie


"David Powers" <dp@example.com> wrote in message
news:d2k13v$aat$1@forums.macromedia.com...
: lawrie wrote:
: > I have been on the site and it starts to look flaky.
:
: Sorry to hear that. The last time I took a look was to see what they
: were doing about PHP 5 (quite a few months ago). I wasn't impressed. The
: real problem with such packages is that they're often made by
: individuals or small groups, so continued support for what may
: originally have been something very useful cannot be guaranteed.
:
: > There installation instructions are reasonably clear but also involve
: > removing the apache monitor.
:
: Remove everything if you can. Installing Apache and PHP are very
: straightforward. These revised instructions I wrote for readers of
: Foundation Dreamweaver MX 2004 are complete, except for the very last
stage:
:
: [url]http://www.friendsofed.com/books/1590593081/errata2.html[/url]
:
: The final stage (which refers back to the book) simply involves changing
: the location of the Apache DocumentRoot. In httpd.conf, you search for
:
: DocumentRoot "C:/Program Files/Apache Group/Apache/htdocs"
:
: Change it to wherever you want Apache to keep all your web pages and
: sites. I normally recommend a folder called htdocs at the top level of
: your C drive. So, the previous line becomes:
:
: DocumentRoot "C:/htdocs"
:
: About 25 lines further down, you should find
:
: <Directory "C:/Program Files/Apache Group/Apache/htdocs">
:
: Change this to point to the same folder as before. My normal
: recommendation is:
:
: <Directory "C:/htdocs">
:
: Note that the slashes must be *forward*, not the Windows default
: backslashes.
:
: > : You shouldn't just delete it, but uninstall it through Control Panel.
: >
: > It does not show anywhere in the CP
:
: I presume, then, that it's all linked in with phpdev.
:
: > the bin folder is in the c drive phpdev/mysql/bin....what would the
correct
: > syntax be to change to that in the command line?
:
: Yes.
:
: --
: David Powers
: Author, "Foundation PHP 5 for Flash" (friends of ED)
: Co-author "PHP Web Development with DW MX 2004" (Apress)
: [url]http://computerbookshelf.com[/url]

[David Powers]

lawrie wrote:

> David
>
> great help & very clear :)

Hope that solves your problem, Lawrie.

--
David Powers
Author, "Foundation PHP 5 for Flash" (friends of ED)
Co-author "PHP Web Development with DW MX 2004" (Apress)
[url]http://computerbookshelf.com[/url]

[gareth]

See the following MM Tech Note:

[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=c45f8a29[/url]


--
Gareth - TMM Dreamweaver
[url]http://www.dreamweavermxsupport.com/[/url]
[url]http://www.garethdp.com/[/url]

PHP Login Suite V2 - 34 Server Behaviors to build a complete Login system.
[url]http://www.phploginsuite.co.uk/[/url]

Co-Author: Dreamweaver MX: Instant Troubleshooter - Apress
Co-Author: Practical Intranet Development - Apress
Co-Author: Dreamweaver MX: Advanced PHP Web Development - Apress
Co-Author: Dreamweaver MX: PHP Web Development - Wrox

[lawrie]

Thanks,
My host had a look and accepted that it was his & not dreamweaver problem.
It was fixed & when I asked what the problem had been it was:
"permissions on the box." :0
The truth was they had upgraded to 4.1 & I was the first client to actually
use it!

"gareth" <gareth@buzzinet.co.uk> wrote in message
news:d2mse2$2gd$1@forums.macromedia.com...
: See the following MM Tech Note:
:
: [url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=c45f8a29[/url]
:
:
: --
: Gareth - TMM Dreamweaver
: [url]http://www.dreamweavermxsupport.com/[/url]
: [url]http://www.garethdp.com/[/url]
:
: PHP Login Suite V2 - 34 Server Behaviors to build a complete Login system.
: [url]http://www.phploginsuite.co.uk/[/url]
:
: Co-Author: Dreamweaver MX: Instant Troubleshooter - Apress
: Co-Author: Practical Intranet Development - Apress
: Co-Author: Dreamweaver MX: Advanced PHP Web Development - Apress
: Co-Author: Dreamweaver MX: PHP Web Development - Wrox
:
: