Replies Back to Article
Using PHAkT v1.0: Connecting to a MySQL Database using JDBC
Did you just move the files ? Or did you move the entire folder ? The entire folder should be moved to that location.
Also, are you running a local or remote MySQL server ? The communication link error could point to an incorrect configuration rather than a problem with the driver. For example, if you are using a remote MySQL server, are you sure that Remote Access is enabled ? If it isn't then it is going to cause problems.
Unfortunately, I can't test or reproduce any of this as I don't have access to a MAC. If you continue to get problems try posting your problem to the PHP Forum in the TalkZones where other MAC users could possibly help you out.
I'm sorry German, I don't understand what you mean.
If you are looking to use the advanced section of recordset creation then you really should read through the UD manual as (though this is aimed at ASP,JSP and CFML) the procedure is exactly the same.
If it is anything else, then I'm afraid that you will need to make it clearer what information you require.
"Server configuration denies access to data source"
Is your MySQL a remote server or a local one ? I ask because this error usually means that remote access has been turned off. It's even more likely this is the case if you are trying to connect to a remote server, and if that's the case you will need to speak to your host provider.
If it is a local server then it is still quite possible that permissions is the problem, though you will be able to sort this out yourself. To point you on your way, there is a Tutorial (or is it an FAQ) on exactly how to do that. I can't remember offhand the link, but it's on this site.
Hope this helps.
No, I'm sorry that isn't the case. Whilst I don't profess to be an OSX expert, I have been around Linux and 'niX based operating systems a long time.
The MySQL Daemon doesn't need to be carbonized as it is running as a service. Services run just above kernel level, and then the next level above that is your window manager (in your case OSX). So the fact that UD doesn't 'see' your MySQL server isn't anything at all to do with that.
An interesting, and very common mistake that alot of people make is specifying http:// when adding info to the URL for a JDBC connection. But I doubt very much it is that, as you must have read this tutorial.
In a Console type the following :-
service mysqld status
If you get no output to this, or an error telling you that the server isn't running, or that this service doesn't exist, then that could well be the problem.
Also, ensure that the port that mysqld is correct. The default is 3306, but it is quite possible that it is running on a different port in your setup.
If mysql is running perfectly (you could always install PHPMyAdmin to fully verify that), then it is likely that it is an UltraDev configuration issue. Have you installed the JDBC driver for MySQL ? I know on Classic Macs the files have to be manually copied to a different location. Is this the case with OSX ?
As it is a JDBC driver, do you have installed the latest Java Runtimes ?
Finally, once you have verified all of the above, ensure that you have correctly configured a user with a valid password for MySQL on your local machine. Many people try to run MySQL in its default installation mode, which is using the root user for general access without a password. This can produce undesireable results when using MySQL, and it is EXTREMELY insecure.
If none of this is the case, then it might be worthwhile posting the same question to some of the OSX forums knocking around. Someone will have encountered this problem somewhere (it might also be adviseable to duplicate this post in the PHP forum).
I hope some of this is of some help to you. I'm sorry I couldn't help more, but as I said initially, I'm not a MAC expert. ;-)
Good Luck!
I installed the MX trial version and had problems using my already established PHP projects using PHAKT's extension. So, I uninstalled MX and it totally destroyed UD 4 on my machine. Tons of errors. I reinstalled UD 4, with the udpate to 4.01. I also installed the latest PHAKT extension 1.3.
Now, everytime I launch UD with a PHP profile it gives me an error message looking for this file: connection_php_mysql.htm
I drilled down to where it should be and it isn't there (obviously). I've reinstalled and installed UD, PHAKT several times and can't resolve this.
Has anybody else experienced this? Am I looking in the wrong place? Is this an issue with UD or PHAKT? HELP!!!!
This problem occurs because when you tried to use Dreamweaver MX, you obviously created a new database connection.
Simply delete this new connection from your site, and you will no longer receive the error.
Please remember that the Public Preview of Dreamweaver MX, is BETA software, and appropriate backups should be taken. Moreover, it is HIGHLY recommended that you do not use this software on a production machine.
I hope this helps
Regards
Tim
I've installed PHAkT and the JDBC extension on this site and am trying to connect to a mySQL server on my Raq4. I can create a connection and see the tables and column values in the recored set test window. However when I try to test a simple page I get the following error
Fatal error: Failed opening required './adodb/adodb.inc.php' (include_path='') in /home/sites/site1/web/phpTest/TMP1j3bhwi7dw.php on line 7
Any Ideas?
