HI all,

I've done a few sites with UD4 on a Windows PC, using ASP and connecting to a MySql db on our Red Hat server.

The thing that I really wanted to do though was to be able to use my Mac as the development server, then transfer to the Red Hat server for production. Why? Well firstly 'cos I prefer Macs and secondly 'cos I wanted to be able to work from home on my iBook, where I don't have a permanent net connection.

OK so here's my solution (many thanks to Christopher Owens excellent walk through at homepage.mac.com/owensc/):
On my work Mac (OS X), install UD4 in classic, install PHAkt via UD4 extension manager, install MySql in OS X, install PHP in OS X. So now I go to my UD4 site, create a new connection via PHAkt's connection interface - and it works! Cool.

So I go home, repeat the installation on my iBook, and start getting connection errors from the PHAkt connection interface.

The thing is, I think I know why - but I don't know what to do about it!

Here's why:
Because UD4 is running in classic Mac OS, the Mac needs to be on a network in order to see the OSX MySQL server. As I said, what I want to do is develop at home *off line*

So my question really is:
Please somebody tell me there's a work around for this situation!!! I've tried obvious stuff like using 'localhost' in the PHAkt connection interface instead of an IPaddress. I've tried using '127.0.0.1' as well. The damn thing won't see my MySQL server!

Failing a solution, does anyone know how far off we are from UD4 being OSX native? This would solve the problem I reckon.

TAI for any thoughts.

ollie

When you say "The damn thing won't see my MySQL server", exactly what error message are you getting (if any)?


Tim Green

Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>

I'm getting this:


Cannot conect to MySQL server on 127.0.0.1:3306. Is there a MySQL server running on the machine/port you are trying to connect to? (java.net.ConnectException)

This tells me that the MySQL service is in fact not running/not installed.

In Linux you can check if MySQL is running my typing 'service mysqld status' while in a console. It might be the same for OSX, but I really couldn't say.

Either way, this all points to you checking that MySQL is actually installed correctly. Sorry, I can't be of more help.

Tim Green

Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>

rawveg,

thanks for your thoughts. Yes the MySQL server is running fine - like I said in my original post, if my mac is on a network I can connect through PHAkt no problem.

I am convinced therfore that it is a problem between classic Mac OS and OS X. Not sure if you're a mac user. but if you're not familiar with OS X, it runs a kind of emulation of OS 9 (classic) which allows you to use your non-OS X native apps (ie. UD4). The 2 OSes are running in thier respective own little worlds. It makes sense to me then, that classic cannot talk to OS X when both are running on the same computer UNLESS classic routes to OS X via a network.

That's why I can't wait for an OS X native version of UD!! I think when this happens I'll be able to develop offline by connecting to 'localhost' a la Windows users.

ollie

I completely understand the principle here. It is exactly the same as running Windows under Linux as a virtual machine (using VMWare or something similar).

Normally in these instances though some form of Loopback network connection is created to allow access to the local filesystem (or something similar). Surely this is what you should be using for your IP (it isn't necessarily 127.0.0.1 or localhost as these would refer solely to your Classic OS Virtual Machine).

More likely you will have to check your Classic's network settings, or create an AppleTalk connection to the OSX box. This might all sound confusing, but essentially what you have is two different machines. Though they are in fact the same machine, neither OS really knows that, so I suspect that this is where the problem/confusion lies.

I know for a fact that there are other OSX users successfully using PHP/UD/PHAkT with this OSX/Classic combination as some of them have posted to this group previously.

Anyway, I hope all of this makes sense to you.

Good Luck.

Tim Green

Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>

As a thought, at the page homepage.mac.com/owensc/page6.html I see that a variant of the localhost IP address 192.168.1.5

I have seen this used on virtual machine setups before (or at least this address range). As it is mentioned twice is it possible that this is indeed the loopback connection between Classic and OSX ?

Also I see that this page says:-
""Cannot find database. Is it running?"
The MySQL daemon may not be running. Make sure that you start MySQL and have the startup scripts installed. Refer to Marc's Web site for more information on that.

There is also a possibility that your Mac's network settings may be the culprit. MacOS X has settings for PPPoE, Point-to-Point Protocol over Ethernet, a method that some Internet service providers use to provide access to their network over high-speed Internet connections such as cable modem or DSL. Sometime this appears to interfere with UltraDev's ability to connect to the MySQL server. It is best that your Mac has a static IP address and that PPPoE is disabled. If you must run PPPoE, setting the "Connect automatically when starting TCP/IP applications" option in the PPPoE Options dialogue in the Network control panel may alleviate this problem."

Just a thought...

Tim Green

Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>

Edited by - rawveg on 14 Dec 2001 12:22:34

rawveg,

thanks a lot for that. Yes I did see the troubleshhoting info at homepage.mac.com/owensc/page6.html , but I didn't think to try the IP you suggest.

I'll do some investigation and get back to you!

ollie

I was have this same problem. I thought it was some problems with JDBC driver but, it turns out rawveg is correct. OSX thinks Classic is another machine when it comes to connecting MySQL databases.

What I had to do was give my database User access from all machines '%' and in the Ultradev connection setup specify the host as my machine's actual IP address (not localhost or 127.0.0.1 but, the IP address listed in your Network Preferences).

After I did all of that is worked perfectly for me.

Excellent follow-up specbebop. Thanks for the info.

Would you do me a favour please, and post that snippet of information as an FAQ ? I'm sure that this is an issue that more and more OSX users will come across, and it would be great if the answer was clearly available.

Cheers!

Tim Green

Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>

well guys, thanks for all the input, but I still cannot get UD4 to connect to MySQL via PHAkt when NOT connected to the network via ethernet.

Thanks specbebop, I can get it to work with your instructions, but my problem is that I want to be able to connect to MySQL when I'm not on a network, i.e. when I'm at home on my iBook. Can you do me a favour? - get it all working as you describe, then pull out your ethernet cable and tell me if it still works?

cheers.

one question in the homepage.mac.com/owensc/ultradev/page4.html site , i read " go to usr/local " , but i dont see the folder mysql-3.23.47,
but mysql is ready and functionally

im very tired of try this, help me please !!
sorry for this english
mau*