LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 03-25-2003, 09:46 AM   #1
bentman78
Member
 
Registered: Mar 2003
Location: Washington DC, USA
Distribution: Redhat
Posts: 212

Rep: Reputation: 30
Dreamweaver, PHP, MySQL, and Apache Web server


Has anyone ever used Dreamweaver along with PHP on an apache web server? I am having problems setting up a site and wondered if anyone encountered any problems.
I get an "unidentified error has occurred" when trying to connect to a MySQL database using PHP. I would greatly appreciate any help.
 
Old 03-25-2003, 01:14 PM   #2
Evilone
Member
 
Registered: Oct 2002
Location: UK
Distribution: Slack 9.1 (2.6.5)
Posts: 307

Rep: Reputation: 30
Yes i've done it.

Redhat 8
Apache 1.3
Php 4
Mysql 3.23.55

And using samba so i can map a windows drive DW will connect to !!!!!!

Yell if you have any more problems, don't know how far you've got.
 
Old 03-25-2003, 01:24 PM   #3
bentman78
Member
 
Registered: Mar 2003
Location: Washington DC, USA
Distribution: Redhat
Posts: 212

Original Poster
Rep: Reputation: 30
Question

I've gotten that far. I have mysql, apache, and PHP running. I did the <phpinfo?> tag to verify it's working and it does. It's when I try to connect to the database with DWMX that I get the unidentified error. I have searched Macromedias site and found a lot of complaints about the issue but no resolution. Please help me get this up. I am about ready to bash my machine into tiny little bits. Thanks for your time.
 
Old 03-26-2003, 02:35 AM   #4
Evilone
Member
 
Registered: Oct 2002
Location: UK
Distribution: Slack 9.1 (2.6.5)
Posts: 307

Rep: Reputation: 30
I'll look at my site settings when i get home, i'm at work at the moment, i work as tech support at a Uni.

Will post a reply tonight !!!

Edit :

UK Time !! lol
 
Old 03-26-2003, 06:02 AM   #5
bentman78
Member
 
Registered: Mar 2003
Location: Washington DC, USA
Distribution: Redhat
Posts: 212

Original Poster
Rep: Reputation: 30
Great, thanks for the help.
 
Old 03-26-2003, 06:21 AM   #6
Crashed_Again
Senior Member
 
Registered: Dec 2002
Location: Atlantic City, NJ
Distribution: Ubuntu & Arch
Posts: 3,503

Rep: Reputation: 57
After creating the page in Dreamweaver what does the php code that deals with connecting to the database look like? Unidentified errors are not much to go on but if you say it can not connect to the database then their is probably something wrong with that section of your php code.
 
Old 03-26-2003, 10:11 AM   #7
bentman78
Member
 
Registered: Mar 2003
Location: Washington DC, USA
Distribution: Redhat
Posts: 212

Original Poster
Rep: Reputation: 30
I know unidentified error isn't much to go on, that's why people are really complaining on the Macromedia site. I can't get to the scripts right now, but I will get them to you tonight (US, EST). In any case, the macomedia article is http://www.macromedia.com/support/dreamweaver/ts/documents/unidentified_error_mysql.htm . I tried everything there and it doesn't work. I hope this gives you some background. I am about ready to throw my machine through the wall this is so fusterating. I have literally spent hours on this. I really appreiciate your help.
 
Old 03-27-2003, 09:38 AM   #8
bdbourn
LQ Newbie
 
Registered: Mar 2003
Distribution: RH 8.x
Posts: 3

Rep: Reputation: 0
If you are accessing a mysql server from offsite, make sure you have granted access permissions in mysql to allow that. Most installs of mysql by default limit access to localhost.
 
Old 03-31-2003, 04:07 AM   #9
Evilone
Member
 
Registered: Oct 2002
Location: UK
Distribution: Slack 9.1 (2.6.5)
Posts: 307

Rep: Reputation: 30
PHP connection code

<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_adebook = "merlin";
$database_adebook = "adebook";
$username_adebook = "adeweb";
$password_adebook = "******";
$adebook = mysql_pconnect($hostname_adebook, $username_adebook, $password_adebook) or die(mysql_error());
?>

Thats the include file i used to connect, password hashed out for security reasons
 
Old 03-31-2003, 06:50 AM   #10
bentman78
Member
 
Registered: Mar 2003
Location: Washington DC, USA
Distribution: Redhat
Posts: 212

Original Poster
Rep: Reputation: 30
Hey, thanks man, I'll give it a try. I had to upgrade due to a problem on my Linux server. Apparently there is a bug in Redhat. I will try your code though and see if it works. I apreciate it!
 
Old 03-31-2003, 06:52 AM   #11
Evilone
Member
 
Registered: Oct 2002
Location: UK
Distribution: Slack 9.1 (2.6.5)
Posts: 307

Rep: Reputation: 30
Dunno bout that m8, im on redhat 8 here as well, and it all works.

PS, you did give your machine access to mysql did'nt you??
 
Old 03-31-2003, 09:25 AM   #12
bentman78
Member
 
Registered: Mar 2003
Location: Washington DC, USA
Distribution: Redhat
Posts: 212

Original Poster
Rep: Reputation: 30
yes I did. It seems to be Macromedia. I used Namo Web Editor and it connects. Namo is only a trial I downloaded to see what the problem was, I need to use Macromedia.
Once again thanks for your help. If you find out anything else let me know.
 
Old 04-04-2003, 03:47 AM   #13
Evilone
Member
 
Registered: Oct 2002
Location: UK
Distribution: Slack 9.1 (2.6.5)
Posts: 307

Rep: Reputation: 30
Ok sorry bout the delay, have had flu over here and it kicked me in the ass for a while.


I looked at my setup and assuming your mysql and php are working, and that your machine has access (have you used a graphical client like mysqlfront and checked????). I'm assuming you have but being thourough. I next went into dreamweaver and did the following to connect :

1) Define a site, this comprises the following :

Name it

Choose php and mysql as a server technology

Next set up your paths, mine point to w: which is a mapped drive to the redhat box with the html and apache on.

Next it asks how to connect, i do local lan and then point to w: again (w: for web lmao).

For the url i give it http://redhatserver/

I dont enable check in / out, but thats preference.

2) In DW XP (Important, allthough i've used 4 these instructions were for my XP setup) get the application tab up on the right, and then go to bindings, click the + button !!!

Choose recordset, and then follow these settings :

Name : Anything you want

Connection : Hot define and then fill in your details as follows :

name : name of your connection (anything)
mysqlserver : name of your server ie fred, or redhat
username : user with % access in mysql
password : obvious !!! see above user details
database : name of previously setup db

click ok

where it now said connection you should set it to the one you just setup above.

you should now be able to select a table from a dropdown list

this is now your connection working !!! or should be.


Your db, db user and tables MUST be presetup, DW-XP will not do this for you as far as i know..


Hope this helps more, let me know how you go on, this is turning into a vendetta now lol, i remember how i started, frustrated the hell outta me for ages hehhehe


Ade
 
Old 04-04-2003, 12:27 PM   #14
bentman78
Member
 
Registered: Mar 2003
Location: Washington DC, USA
Distribution: Redhat
Posts: 212

Original Poster
Rep: Reputation: 30
Hey thanks for getting back.

I am using MySQLCC and can connect just fine. I have hard coded several PHP pages and haven't had any issues. I have recently downloaded Mambo Portal Server and I am running that with no problems. It seems to be Dreamweaver. I didyour setup as well. few changes :

I am using the I.P address for the MySQl server

I have used the %, localhost and I.P for the login ID (i.e. user@%, user@localhost, user@162.24.1.12 'my I.P')

My setup is pretty simple. I have a drived mapped to the server from my widws client. My remote site and test server are the same thing. My local site is on my HD.

Once again thanks for the help.
 
Old 04-04-2003, 12:28 PM   #15
bentman78
Member
 
Registered: Mar 2003
Location: Washington DC, USA
Distribution: Redhat
Posts: 212

Original Poster
Rep: Reputation: 30
what do you mean by presetup?
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
what is the best distro for web developers...mysql, php, and apache required sketchydave Linux - Distributions 4 11-24-2005 03:24 PM
Dreamweaver MX, MySql, apache and PHP ...? shahg_shahg Linux - Software 1 07-23-2005 04:50 AM
Dreamweaver MX, MySql, apache and PHP ...? shahg_shahg Linux - Software 1 07-23-2005 04:49 AM
Dreamweaver and Apache, PHP and MySQL WiWa Linux - Newbie 3 09-16-2003 12:05 PM
Installing PHP and MySQL w/ Apache web server dcrealm47 Linux - Newbie 5 02-26-2003 11:21 AM


All times are GMT -5. The time now is 11:35 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration