logo-dw

Go Back   Dreamweaver Club Forums > Hand Coders Forum > PHP
Register FAQ Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Display Modes
Old 04-22-2012, 01:23 AM   #1
pimpin
 
Join Date: Apr 2012
Posts: 7
Default PHP MySQL server connection error

Hello all. Fairly new at DW and I have been watching all the tutorials etc i can but I'm having an issue that neither my hosting company nor I can figure out. I am trying to create some dynamic data tables for a login page and when DW goes to connect to the server it comes back with a mapping error but the root file is correct. I have set up the db and table in MySQL admin but nothing shows up in DW. DW connects to my server I have confirmed that, but it is unable to connect to the root folder and I have confirmed the root folder directory with my hosting co just in case i had that wrong. not sure how to attach a screen shot or i would but any help would be greatly appreciated.

Last edited by pimpin; 04-22-2012 at 01:48 AM..
pimpin is offline   Reply With Quote
Old 04-22-2012, 02:29 AM   #2
edbr
edbr's Avatar
 
Join Date: Aug 2005
Location: Bali
Posts: 11,176
Default

so your remote folder is not showing?
as for the connection to the database it maybe your hosting does not permit this
__________________
If you're happy and you know it shake your meds!
different style links examples

Flight / Hotel search
Free script download
Bali Villas
edbr is offline   Reply With Quote
Old 04-22-2012, 02:53 AM   #3
pimpin
 
Join Date: Apr 2012
Posts: 7
Default

contacted the host and they tell me there is no problem on their end, all looked fine to them. the error i get says that the directory ,........./_MM.... does not map to root, check URL prefix... as I say, I have entered the root folder but no joy.
pimpin is offline   Reply With Quote
Old 04-22-2012, 04:37 AM   #4
edbr
edbr's Avatar
 
Join Date: Aug 2005
Location: Bali
Posts: 11,176
Default

can you post the connection details you have used?
__________________
If you're happy and you know it shake your meds!
different style links examples

Flight / Hotel search
Free script download
Bali Villas
edbr is offline   Reply With Quote
Old 04-22-2012, 06:20 AM   #5
pimpin
 
Join Date: Apr 2012
Posts: 7
Default

root directory is

/var/www/***********/data/www/mydomain.com/

followed by root user name and password
pimpin is offline   Reply With Quote
Old 04-22-2012, 09:33 PM   #6
pimpin
 
Join Date: Apr 2012
Posts: 7
Default

K... fixed the connection issue (turned out to work with the IP number rather than URL?). However now I have another issue in that my new login page does not function properly. I set up the database and the table (with three fields). I have entered the users, their ID and password but the page keeps reverting back to the failed login option?
pimpin is offline   Reply With Quote
Old 04-23-2012, 02:37 AM   #7
edbr
edbr's Avatar
 
Join Date: Aug 2005
Location: Bali
Posts: 11,176
Default

need more to go on to try and find the error
__________________
If you're happy and you know it shake your meds!
different style links examples

Flight / Hotel search
Free script download
Bali Villas
edbr is offline   Reply With Quote
Old 04-23-2012, 05:20 PM   #8
pimpin
 
Join Date: Apr 2012
Posts: 7
Default

I have created the db and the table on the server. I created the tables and fields in DW forms and went through the authenticatian/login/password setup step. Saved on both the server side and the local side. The login page comes up when I type in the IP but does not connect to the landing page when i type in the user name and password.
pimpin is offline   Reply With Quote
Old 04-23-2012, 10:37 PM   #9
pimpin
 
Join Date: Apr 2012
Posts: 7
Default

problem solved. turned out be an issue with the connections folder i think? I started over from scratch and the second time through it worked fine with the db etc. Thank-you for taking the time to respond to my newbie questions... it's greatly appreciated!
pimpin is offline   Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 05:11 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Copyright 2006 DreamweaverClub.com