Testing MySQL connection *UNIDENTIFIED ERROR*

[sarienya]

Hi All,

I know other people have had this same problem as me, even after reading
[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_16515[/url]
I am still no closer to the solution!

I have re-installed php and mysql and reconfigured everything. I have checked
the includes path thing and it is what is suggested in the tech notes, i have
tried using my machine name, IP, localhost and anyother thing i could think of
in the MySQL Connections window.

I cant even get to the window of avaible databases to connect to without the
evil *unidentified error* apeearing. You would hope it would be a little more
specific and say something like "theres an error, its to do with..." but no...

Can anyone please provide me with complete instructions on how this hould be
set up (in plain english)?

My system is:
-Windows NT NIVYHA 5.1 build 2600 - PHP
-PHP Version 5.0.4
-MySQL 4.0.15

I have also tried a newer version of MySQL, but same error...

Thankyou for reading....

Regards,
Sally...

[David Powers]

sarienya wrote:

> Can anyone please provide me with complete instructions on how this hould be
> set up (in plain english)?

What have you used as the URL prefix in Testing Server in the Site
Definition? It *must* have a trailing slash on the end, like this:

[url]http://localhost/mysite/[/url]

--
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]

[Alexandro Colorado]

On Fri, 06 May 2005 04:56:45 +0300, sarienya
<webforumsuser@macromedia.com> wrote:

> Hi All,
>
> I know other people have had this same problem as me, even after reading
> [url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_16515[/url]
> I am still no closer to the solution!
>
> I have re-installed php and mysql and reconfigured everything. I have
> checked
> the includes path thing and it is what is suggested in the tech notes, i
> have
> tried using my machine name, IP, localhost and anyother thing i could
> think of
> in the MySQL Connections window.

Was this a bundle install or you download from the respective websites and
installed them seperatly.

> I cant even get to the window of avaible databases to connect to
> without the
> evil *unidentified error* apeearing. You would hope it would be a little
> more
> specific and say something like "theres an error, its to do with..." but
> no...

Make sure you point to the right testing server URL prefix. This should be
something like [url]http://localhost/yoursitefolder/[/url]

> Can anyone please provide me with complete instructions on how this
> hould be
> set up (in plain english)?
>
> My system is:
> -Windows NT NIVYHA 5.1 build 2600 - PHP
> -PHP Version 5.0.4
> -MySQL 4.0.15
>
> I have also tried a newer version of MySQL, but same error...
>
> Thankyou for reading....
>
> Regards,
> Sally...
>

Is your database currently working? Access a phpMyAdmin for example.

Have you errase the _mmServerScript/ folder and re-try to connect?


--
Alexandro Colorado
------------------------------
Support Engineer
InterAKT Online
[url]http://www.interaktonline.com[/url]
Tel: 40(21) 312.5312

[pespsyco]

I've done all that, reconfigured my php.ini, rewritten my connection files, and
I'm still having this problem as well.

for some reason I am unable to download the 6.1 upgrade that is supposed to
fix all this. (Do subscriptions run out?)

any suggestions? I can program code, and test it on the server. but the
whole Idea behind spending all the money for DW was to be able to see what was
going on as I worked.

p

[sarienya]

Thanks Everyone for replying so quick,

However... still no closer to the solution...

I have checked that my stites testing server URL is correct
([url]http://localhost/phptest/[/url])
I have deleted the folder _mmServerScripts and tried to reconnect (Still an
unidentified error)
Im mySQLadmin I can see my database and it seems fine and working?

I have also checked out the ODBC bit of the php info page ( <? phpinfo(); ?>
) And noticed:

odbc.default_db no value no value
odbc.default_pw no value no value
odbc.default_user no value no value

Doesnt seem right? I honestly didnt think setting this up would be this
confussing and complicated.
Any ideas on what else could be the problem?
Thanks once again....


Sally..

[David Powers]

pespsyco wrote:

> for some reason I am unable to download the 6.1 upgrade that is supposed to
> fix all this. (Do subscriptions run out?)

The 6.1 upgrade is only required for Dreamweaver MX, not MX 2004. If
using MX 2004, check that it says version 7.0.1 (on the screen that
appears when the program is loading, or by choosing Help > About
Dreamweaver).

> any suggestions?

Are your site files inside the server DocumentRoot?
Have you set up a user account on MySQL?
Have you upgraded from one version of MySQL to another? If so, have you
run the scripts that update the grants table?

[url]http://dev.mysql.com/doc/mysql/en/upgrading-grant-tables.html[/url]

--
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]

sarienya wrote:

> I have also checked out the ODBC bit of the php info page ( <? phpinfo(); ?>
> ) And noticed:
>
> odbc.default_db no value no value
> odbc.default_pw no value no value
> odbc.default_user no value no value
>
> Doesnt seem right?

It's perfectly all right. Dreamweaver and PHP don't use ODBC to connect
to MySQL. Look a little further up your configuration information page,
and check whether you have any entries for mysql and mysqli. They should
be immediately above ODBC.

MySQL is not enabled by default in PHP 5. I have put comprehensive
installation instructions for PHP, Apache and MySQL on Windows online
for readers of one of my books. You may find them helpful:

[url]http://computerbookshelf.com/phpdw/install1.php[/url]

--
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]

[sarienya]

Hi David,

Thanks for the URL. After reading everything availbable there, totally
uninstalling everything i had installed and starting again from scratch.
I have:
Double checking that IIS is not running and is not installing.
New install of APACHE, is running and OK
New install of PHP, is running and OK
New install of MySQL, is running, as far as i know, is OK.

Still, unidentified error... *hits her head on the nearest brick wall*

I just dont understand what is going wrong, everything seems to be up and
runnong and "ON"

Any ideas?

Thanks,
Sally...

[David Powers]

sarienya wrote:

> Still, unidentified error... *hits her head on the nearest brick wall*

If you have a clean install, and everything is running and on, make sure
that your site is located in the server root. Also make sure you have a
trailing slash on the URL prefix in the Testing Server section of Site
Definition. Then, as long as you have a properly configured user account
with MySQL, you should be able to make a connection to MySQL.

--
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]

[florenced]

I am having the same problem connecting to a remote mysql server using PHP and
Dreamweaver. However I can connect using an asp/ODBC connection in
Dreamweaver. The issue seems to be with the localhost, mySQL connection only.
The problem appears to be on my side and does not seem to be with the server
or mySQL on the server machine. Anyone have any ideas.

[David Powers]

florenced wrote:

> I am having the same problem connecting to a remote mysql server using PHP and
> Dreamweaver.

If you're connecting to a remote server, this article should be of
assistance:

[url]http://www.dreamweavermxsupport.com/index.php?type=article&id=85&block=1&pid=60&sid=61[/url]

--
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]

[florenced]

I solved the problem at least for my situation. All I had to do was remove the
_mmServerScripts folder on my ftp site and then let dreamweaver resend the
files to the server and I was then able to set up my connection between
Dreamweaver and mySQL. I think what might have happened is that I had some
network changes on my client and Dreamweaver does not update the files on the
remote server it only checks to see if they exist, so they have to be deleted
in order to be resent. Anyway thanks to David Powers for pointing me in the
right direction.

[Topaipai]

Hi yall,

Sarienya, I had the exact same problem but I found the solution after reading
this topic :
Indeed, here is what I did :

-1) very important : delete all the _mmServerScripts folders that Macromedia
had created in the folder of your website.
-2) verify if : the folder for the TEST SERVER is the SAME as the one pointed
by the URL prefix, for example :
-test server path : C:/programfiles/.../www/phptest/
-URL prefix : [url]http://localhost/phptest/[/url]
After that everything worked just fine for me
Hope it will help u
To.


Originally posted by: sarienya
Hi David,

Thanks for the URL. After reading everything availbable there, totally
uninstalling everything i had installed and starting again from scratch.
I have:
Double checking that IIS is not running and is not installing.
New install of APACHE, is running and OK
New install of PHP, is running and OK
New install of MySQL, is running, as far as i know, is OK.

Still, unidentified error... *hits her head on the nearest brick wall*

I just dont understand what is going wrong, everything seems to be up and
runnong and "ON"

Any ideas?

Thanks,
Sally...

[geisellet]

Hello!

It's interesting that I had this same problem yesterday (with a very
similar setup only using Windows 2000 Professional instead of Windows
NT).

I discovered that Dreamweaver does not like site names with normally
valid "special" characters. In my case, I was using a "-" in the site
name, QSS-Newlogo. Since all of the domains I manage have "-" in the
names, I use the "-" every day in all my live web interactions!
However, once I renamed my test site name, left off the "-", QSSNew,
everything connected beautifully, as had other test sites before.

Just another troubleshooting idea to add to the list.

I'm truly appreciating reading through this list, as I continue to
learn and grow as a Dreamweaver web developer!

Thanks, Geiselle

Topaipai wrote:

> Hi yall,
>
> Sarienya, I had the exact same problem but I found the solution

after reading

> this topic :
> Indeed, here is what I did :
>
> -1) very important : delete all the _mmServerScripts folders that

Macromedia

> had created in the folder of your website.
> -2) verify if : the folder for the TEST SERVER is the SAME as the

one pointed

> by the URL prefix, for example :
> -test server path : C:/programfiles/.../www/phptest/
> -URL prefix : [url]http://localhost/phptest/[/url]
> After that everything worked just fine for me
> Hope it will help u
> To.
>
>
> Originally posted by: sarienya
> Hi David,
>
> Thanks for the URL. After reading everything availbable there,

totally

> uninstalling everything i had installed and starting again from

scratch.

> I have:
> Double checking that IIS is not running and is not installing.
> New install of APACHE, is running and OK
> New install of PHP, is running and OK
> New install of MySQL, is running, as far as i know, is OK.
>
> Still, unidentified error... *hits her head on the nearest brick

wall*

>
> I just dont understand what is going wrong, everything seems to be

up and

> runnong and "ON"
>
> Any ideas?
>
> Thanks,
> Sally...

[dmahadocon]

I don't know if this is going to help you, but from the PHP Manual:

In PHP 4.2.0 and later, the default value for the PHP directive
register_globals is off. This is a major change in PHP. Having register_globals
off affects the set of predefined variables available in the global scope. For
example, to get DOCUMENT_ROOT you'll use $_SERVER['DOCUMENT_ROOT'] instead of
$DOCUMENT_ROOT, or $_GET['id'] from the URL
[url]http://www.example.com/test.php?id=3[/url] instead of $id, or $_ENV['HOME'] instead
of $HOME.

For related information on this change, read the configuration entry for
register_globals, the security chapter on Using Register Globals , as well as
the PHP 4.1.0 and 4.2.0 Release Announcements.

Using the available PHP Reserved Predefined Variables, like the superglobal
arrays, is preferred."

What this means is that you can either:

1. Enable 'register_long_arrays' in your php.ini file
2. modify the MMHTTPDB.php file to not rely on HTTP_POST_VARS[]

I used option 1 (reluctantly), but I think that I am going back later on to
modity Macromedia's script files.

[Yvesg]

Hello all,
I just look at this back and forth exchange and I am hitting the very same
wall for the last days and I start to get bruised :) I have tried every single
steps proposed here with the same wall. From all the reading done so far, I
think the big problem is related from the PHP 5.xx that now uses MYSQLI instead
of MYSQL. I have perfectly working PHP 5.0.3, perfectly working MySQL 4.1.10,
perfectly working phpMyAdmin 2.6.1-pl3. From there, I can deduct that there is
no security, setup of bad installation if my phpMyAdmin installation can, by
using the PHP 5.0.3, connect to my MySQL 4.1.10 database. I even have a site
in Dreamweaver connecting to another MySQL database when I hard code my server
/ db / Id / password in the PHP code. But, when I tried from Dreamweaver
Application section, to connect "visually" to the very same database with the
very same parameter, I get the "unindentified error". What bug me is that when
I look at the file "mysql.php" in the directory "_mmServerScripts", I see
everywhere "mysql" and not "mysqli" !! My understanding is that Dreamweaver
uses this file to connect to the database. I did "plug" the "mysql" with
"mysqli" in this file and tried again. At least, I was able to get rid of the
"unindentified error" and get a blank message but no better luck to actually
connect to the database and see the various table.
Any other ideas before I need to get to the ER to get stitches :)
Many thanks in advance.

Yves

[David Powers]

Yvesg wrote:

> From all the reading done so far, I
> think the big problem is related from the PHP 5.xx that now uses MYSQLI instead
> of MYSQL. I have perfectly working PHP 5.0.3, perfectly working MySQL 4.1.10,
> perfectly working phpMyAdmin 2.6.1-pl3.

It makes no difference. As long as you have enabled mysql in your PHP
installation, it will work just fine.

I have been using MX 2004 with every version of PHP 5 since RC3 (5.0.0,
5.0.1, 5.0.2, 5.0.3 and 5.0.4). I have also used every version of MySQL
4.1 since 4.1.5. They all work perfectly with MX 2004.

Run phpinfo(), and check that you have both MySQL and MySQLi enabled.
Also check the Client API version shown for MySQL. If it's 3.23.x,
that's probably where your problem lies. My Client API version for both
MySQL and MySQLi is 4.1.7.

--
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]

[Yvesg]

David,
You're the man !! It work now. I had for client the version 4.1.7 and I also
had run phpinfo() many time without noticing that I had "mysqli" and "msql"
instead of "mysql". I had in PHP.INI the 2 lines on top of each other
uncommented with in mind "mysql" and "mysqli" but with a typo in one of them.
Pitcher error from me.
Many thanks for your valuable help David.

Yves

[David Powers]

Yvesg wrote:

> David,
> You're the man !! It work now. I had for client the version 4.1.7 and I also
> had run phpinfo() many time without noticing that I had "mysqli" and "msql"
> instead of "mysql". I had in PHP.INI the 2 lines on top of each other
> uncommented with in mind "mysql" and "mysqli" but with a typo in one of them.

Glad you're finally there, Yves. It *is* very confusing that mysql,
mssql, msql, and mysqli are all so similar.

--
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]

[Gear6Web]

Originally posted by: Topaipai
Hi yall,

Sarienya, I had the exact same problem but I found the solution after reading
this topic :
Indeed, here is what I did :

-1) very important : delete all the _mmServerScripts folders that Macromedia
had created in the folder of your website.



If you are using Plesk admin for a remote server/database, go into the file
browser in the control panel as the files that need to be removed are not
visible in the files window of dreamweaver. Thanks for all the help. Problem
solved.