Can't get MySQL Connection part of tutorial to work?

[gregurke385889]

Hi there

(MacBook Dual 2GHz 10.5.6 Dreamweaver CS4)

So after solving the mySQL login issue and enabling MAMP successfully, I now have another frustrating stumbling block.

I have not been able to get the "connWA" MySQL conncetion to work and I have followed the tutorial to the letter. (god you must hear that phrase a lot ;^))

IT gives me the following warning (see attachment 1) when I get to the final step and hit the "select" button to choose the digital_goods file.

NOTE: If I manually type the name in it allows the database to appear but it would appear it doesn't actually work, as when I click on "test" it gives the warning (attachment 1)

HELP!? I can't go any further and so desperately want to finish this bluesky thing!

thanks in advance
DG

[Jason Byrnes]

The errors you post point to a problem in the Testing Server Section of your site definition.

Specifically the URL Prefix.

From the error, you have set the URL prefix to "http://127.0.0.1", it sounds like this is not a valid URL to serve pages using MAMP.

Try using http://localhost instead

this assumes that your site files are in the root of the MAMP htdocs directory, if the are in a sub folder of the MAMAP htdocs folder, you will need to include that sub folder name in the URL prefix as well. For example, if you site files are at htdocs/mySite the URL prefix needs to be http://localhost/mySite

[gregurke385889]

Hey thanks for the reply.

I don't know how to set the "127.0.1" etc etc.

But I followed your directions and have attached snapshots 3, 4, 5, showing how the directories are set up in MAMP as well as the Dreamweaver site setup.

Unfortunately I still get the identical error message again.

Perhaps the attachments will show up something obvious to you. Sadly I am only a lowly designer who doesn't know squat about programming or terminal setups so this stuff seems a lot harder than the tutorial lets on?

look forward to your thoughts
cheers
DG

[Jason Byrnes]

looking at the MAMP documentation, it appears the default port is 8888, so the URL should be:
http://localhost:8888

try that address for the URL prefix.

[gregurke385889]

Thanks for that, the :8888 did fix it. The WA tutorial says that is selected automaticaly which it did but clearly wasn't right.

OK now tutorial says hit select and now it works hooray!

BUT another hurdle can you believe it?

When I hit select it shows me (attachment 6) which gives me only 2 selection options, yet in the WA tutorial it has 6 options showing and asks to select "physical_goods" (attachment 7).

Because my list is not the same I cannot go any further... aaaaaaaaaaaahhh.

Before you ask I went back to the start of the WA tutorial and there is no reference to placement of these files/options?

(Forgive me for these seemingly basic questions, I wouldn't ask if the tutorial was clearer on troubleshooting these issues)

cheers
DG

[Jason Byrnes]

The Schema Tour section of the DB Starter kit walks through using the MySQL Query browser to crate the Schemas using the .sql files included. Please see that section of the DB Starter kit.

[madelectrical386948]

Hi Gregurke,

I found a nice link to help with the setup. It comes from Adobe and by doing it, I believe it will shed you some light. It does support the Windows and Mac. It helped me a lot.

http://www.adobe.com/devnet/dreamweaver/articles/setting_up_php_02.html

Mike

[gregurke385889]

Hey Jason

I mustn't have been clear about that as I have already done that part of the tutotial. I have followed the WA tutorial and created the schemas in MySQL without a hitch.

The attachments I sent last thread show however that I am not "seeing" the respective db files as per what the tutorial tells me to expect and select from (physical_goods).

What I didn't attach was a snapshot of how my MySQL shows those dbs are in existence which may help from your end?! (attachment 8)

So I think this is the best way to phrase my query:
Why can't I see the schemas that are showing up in MySQL but not in Dreamweaver?

I can easily go to the site root and see that the MAMP db folder has s chemas in it? (attachment 9)

Hope that is clearer for you to direct me to where exactly these files should be found for dreamweaver to allow me to select them and continue the tutorial...

cheers DG

[gregurke385889]

Cheers Mike

appreciate the link I just breezed thru it and sawa couple of things I may be able to tweak, the good thing is I had already done all the MAMP stuff, but as you know it could just be one teeny freakin' thing and the whole circus gets rabies if you know what i mean.

will post a report if I get any good solutions out of it ;^)

[Jason Byrnes]

Two things that may help me see what the problem are:

1) can you post a screen shot sowing the testing server tab of your Dreamweaver site definition.

2) Also a screen shot showing the database connection widow before you click the select button.

[gregurke385889]

Hey Jason

here is the 2 snapshots requested

attachment 10 is the testing server preview, the full directory that is cut off for both ends in "Database-eLearning Folder/"

attachment 11 is the whe I click on the "databases" palette and click on "+" to add a MySQL connection as per the tutorials instructions with "root" the password you can't see.

Incidentally I took Mikes link last night and went thru it all. It suggested I switch off web sharing and reset the MAMP ports to 3306 (MySQL) and 80 (Apache), so I then reset the DW testing server to go to localhost:80, but it didn't get me any further.

Sorry this is proving to be so difficult I appreciate your help but I think we are getting there... DG

[Jason Byrnes]

What happens if you copy and paste the address from your testing server URL Prefix:
http://localhost:80/Database-eLearning

into your web browsers address bar?


shouldn't the URL prefix be:
http://localhost:8888/Database-eLearning


try going to /Application/mamp/htdocs/Database-eLearning using your Macintosh finder and delete the _MMServerScripts folder.

[madelectrical386948]

Hi Gregurke,

I am speaking about windows, xampp apache automatically takes port 80. You don't have to put in :80. I go with http://localhost/what the root is.

Mine is http://localhost/phptesting/

Also, make the testing server folder a solid name. I think I see a - in yours.

My phptesting folder is in c:/xampp/xamplite/htdocs/phptesting.

The other thing I saw was your admin as a name and root as the password. Once you have your MyphpAdmin working, follow that doc. link I sent you. If you don't have admin as a name, you are wasting your time. You can add users and set different parameters for each one.

That is the info you put for your connection. Make sure you bring that database in the php area. You have to import it.

Hope that helps.

thx

Mike

[gregurke385889]

First of all thanks to Jason for trying to help and to Mike his helpful comments thru the posts (dude you were spot on about the wasting time on admin thing that was the whole problem) and for sharing the tutorial from Adobe. I went thru it in full and think I have worked this out from that.

While admin/root is supposedly able to access all databases, it was only after I created my own restricted user and allowed that user access to the schemas that I was able to click "select" and finally I could see the schemas I needed to complete the tutorial. Thank christ

Jason please pass on my frustration to whomever takes on feedback, that the WA tutorial didn't give this info at all, I have even gone back just now to it again and all it asks to use the default admin access.

Look I just hope this is the last part of the WA tutorial that is a hurdle, because I bought this software based on it's key selling point you didn't need to be a code freak to use it. The WA tutorial should be more thorough if it has taken this long to diagnose it, as I have spent hours longer diagnosing this problem than the tutorial actually runs for which is beyond disappointing.

Sorry for the gripe I just hope that being honest will help improve it for other users if those issues get fixed. I look forward to finalising it and starting my own php site soon.

regards DG

PS. For what it's worth there were a few questions to answer from Jason and Mike so bare with me:

The port is set to :80 because I reset it according to the Adobe tutorial (which seems to cover this stuff way clearer than WA http://www.adobe.com/devnet/dreamweaver/articles/)

The reason I have called the site folder "Database-eLearning Folder" is because that is what the tutorial instructions tell me to do (unzip amd drag and drop the folder etc). Also the WA tutorial says the testing server in DW auto selects the correct URL prefix which is not even right, as I soon found out. I have now called my site "bluesky" all lowercase as per the many helpful hints in the adobe tutorial.

[madelectrical386948]

Nice,

I am glad you got it to work. I put in about 12 hours in 1 week to figure this out. To do database stuff, you will have to do some work like this.
After you do it, it becomes easier. Just think, now you know more about your PHPmy Admin.

Good Luck and keep me in the loop about your web site. I will like to see it.

thx

Mike

[online.order393818]

If any one has advice I'd certainly appreciate it very much. This issue has been holding me up for the pas two days...

The problem I'm having with MySQL Database is that it didn't download with the MySQL Administrator version that was mention in the instructions. (this is the one I installed ]mysql-essential-5.0.87-win32],). The password that I created when I install the database doesn't work! On the MySQL Administrator Login, it ask for a User Name & Password. I didn't provide a "Users Name" during the setup. The password is the same password I use to login to my account on my PC's. Therefore, I have no idea of what user name to enter! The only user name associated with my PC is 'Admin' on my desktop w/WinXP Prof., and having the same problem with my laptop, VISTA HP x64. Both with the same user name & password. And neither will allow me to login to the database.

[Office Guy-172461]

See if this article helps:
Logging into a MySQL database
http://www.ipvac.com/kb/entry/149/

[online.order393818]

Office Guy,

That took every bit of 20 seconds to reslove my problem. Thanks a bunch. I'll send you a Starbucks in the mail. ^5{high five}

Take care,
Jw

[online.order393818]

Can anyone explain this error msg. It accures after I run the php.pnp test file from the localhost server?

PHP Warning: PHP Startup: Unable to load dynamic library 'c:\php\ext\php_ifx.dll' - The specified module could not be found. in Unknown on line 0 PHP Warning.

The line up above is just one of many error msgs. at the bottom of the 'Phpinfo.php' page. From what I can tell it appears to be listing 'all' of the files in my c:\windows\php.ini, file. I did remover all of the (;) in front of all the extensions. And I'm running the same file on VISTA without any return errors.

Jw

[Jason Byrnes]

the error is fairly strait forward.


in the php.ini file, you commented the following line:
;extension=php_ifx.dll


to load the Informix module. However the php_ifx.dll file does not exist in the extesnion directory "c:\php\ext\"


You really should not load every extesnion, you should only load the ones that you will use.

[online.order393818]

JB,

Thanks for your response to my PHP error problem, and sorry for wasting your time. It was a classic case of missed assumption!

According to the setup 'Configuring PHP on XP' instructions I received they state:

6. Enable MySQL and (other extensions by removing the ; before the extension name in the list). The extension for MySQL should look like this: extension=php_mysql.dll.

I had assumed that meant ALL...

Thanks again
Jw

[online.order393818]

Jb,

I when I enter 'localhost' no my browser address bar it will not display the page. The error msg I get state: "The website cannot display the page" The reasons: 1. The website is under maintenance, 2. The website has a programming error.

But if I enter this line in the address: localhost/phpinfo.php it load the respected page without a problem!

Can you assist me with this problem?

Thanks,
Jw

[Jason Byrnes]

this would indicate to me that there is no index.htm file at the root of the site.

Crate an index.htm file in the same location as the phpinfo.php file.

[online.order393818]

Thanks for your prompt response. In relation to the 'index.htm' file not being in the root directory. No there is not. Nor is there a index.htm file loacated in the root directory on my pc running VISTA,(other pc with problem WinXP Prof.) but it's working just fine. And they each havethe same identical files in the root directory...

Your opinion please?

Thanks

[Jason Byrnes]

since it will display the page if you enter a page name, but show an error if there is no page name, there is a problem in the default document settings.

The Default documents that IIS is aware of are:
index.htm
index.html
index.asp
default.htm
default.html
default.asp


if no document is specified in the URL it will try to load one of those files.

The error you get suggests that either one of the default files doesnt exist or there is an error in one of them.



In reality, this is not a problem with WebAssist software. There really isnt really problem at all since you can load files in the browser by specifying a file name.

[mathorejohn397508]

Hi Gregurke,

I found a nice link to help with the setup. It comes from Adobe and by doing it, I believe it will shed you some light. It does support the Windows and Mac. It helped me a lot.

http://www.adobe.com/devnet/dreamweaver/articles/setting_up_php_02.html

Mike

Hey...
Thanks for the link. Nice tutorial. great stuff...