On 28 Nov 2006, at 18:27, Dale Graham wrote:
If you possibly do it, move to JDBC rather than ODBC. You'll be
much happier, the drivers are free, etc etc.
When you download the JDBC (thin) clients
Download from where? I have found some at http://
mmmysql.sourceforge.net/ - are these recommended? If not, which would
you recommend?
, just place them here
/Library/Java/Extensions
You're done.
The next hard part is figuring out how to "address" different
drivers. They all have different methods (so much for
standardization).
Apple has a great web page on these addresses (even if it IS
directed towards Web Objects)
http://docs.info.apple.com/article.html?artnum=107856
The only other tricky thing to remember is that you have to be sure
to set up the SAME JDBC connections for BOTH editor and server.
Easiest thing to do is to set everything up in the Editor, then
COPY the resulting jdbc.ini file from the ~/Library/Preferences/
Witango directory TO the /Applications/WitangoServer/5.5/
configuration directory
A "typical" mysql entry would look like this (from the jdbc.ini
file). Things you need to change in bold
<DataSource ID="how-you-refer-to-this-database (doesn't HAVE to
be the same as the DSN, but it's easier)">
<DSN>database-name</DSN>
What's a DSN? Wikipedia: "Database Source Names, more commonly seen
as the abbreviation, DSN, are data structures used to describe a
connection to a database. This DSN will take the form of protocol:
subprotocol: host: port: database so as to completely specify all
parameters of the connection. The exact format of the DSN will vary
depending on your programming language"
Does DSN have to comply to a strict convention?
<DriverClass>com.mysql.jdbc.Driver</DriverClass>
<URL>jdbc:mysql:/localhost:3306/database-name</URL>
<--- change to server DNS or IP if
different from localhost
<---- change port number if you're not
using the mysql default
What's the MySQL default? 3306
And for Filemaker?
<Properties>
<Property ID="server">
<Name>server</Name>
<Value>127.0.0.1</Value> <--- where you are on the same
server, e.g., localhost, else change
</Property>
<Property ID="port">
<Name>port</Name>
<Value>3306</Value> <--- change only if not standard mysql
default
</Property>
</Properties>
</DataSource>
To help in Witango and general connection troubleshooting...
Strongly advise your getting a good sql editor (I like Aqua
DataStudio from www.aquafold.com) and testing with that. If you
cannot connect with that, no way Witango's going to work... Most
sql editors these days use JDBC for connecting, too.
OK. Got that and CocoaMySQL. When trying to connect to the database
server "test" database from a remote machine I get: "Unable to
connect to host. Be sure the address is correct and that you have the
necessary privileges"
I believe there's a standard "test" database created and I saw it
yesterday in CocoaMySQL running on the same machine as the server. In
the tables it had one user "admin" with password "admin" . Today I
can't connect to the MySQL server using CocoaMySQL locally or remotely
I assume I have to set privileges to connect to the MySQL server. How
do I do this? I need to create a user - how do I do this? Are
privileges set for the server or per database?
Once connected, how do I create a new database and edit the field
definitions?
Right now I can't get past setting up MySQL. Once I can do that I'll
move on to JDBC drivers and then Filemaker
I've set a root password in MySQL Manager on the server. MySQL is
running using msql \s:
mysql Ver 14.7 Distrib 4.1.13a, for apple-darwin8.0 (powerpc) using
EditLine wrapper
Connection id: 7
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 4.1.13a-log
Protocol version: 10
Connection: Localhost via UNIX socket
Client characterset: latin1
Server characterset: latin1
UNIX socket: /var/mysql/mysql.sock
I've downloaded and worked a bit with phpMyAdmin and got as far as
setting up a server & security. But when I move the config file to
the phpMyAdmin and try to login into the MySQL server I can't connect
to the server
Thanks for the help so far. I'm coming across too many "unknown
unknowns" to get anywhere at the moment
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
