Steve,
The JDBC driver is the JAR file (probably the only one), usually the readme or a quick Google search will tell you what it is. For MySQL it’s mysql-connector-java-5.1.14-bin.jar For MS SQL it’s sqljdbc4.jar For Oracle it’s ojdbc6.jar These files can be simply placed that the path given (/Library/Java/Extensions) and they become available to the JVM on OSX. In jdbc.ini the property values can be left empty – the TAF has the username/password in it. You do, however, need to have the same value that’s in DataSource ID=”” between the <DSN></DSN> - in your case “witangotest”. Otherwise everything else looks correct. Robert From: Steve Smith [mailto:[email protected]] Sent: Friday, January 28, 2011 1:46 PM To: [email protected] Subject: Witango-Talk: MySQL on OS X Server Two part problem, first part is not directly Witango related but I'm hoping someone on the list might have some experience with setting up MySQL Server on a OS X Server box (Snow Leopard Server running on Mac mini). I've been attempting to install MySQL on a new OS X Server and I'm running into a lack of knowledge problem. My own. I keep getting the following in the MySQL Logs: 110128 13:29:21 [Warning] Setting lower_case_table_names=2 because file system for /Volumes/OakbridgeServerVolume/ServiceData/MySQL/ is case insensitive /usr/libexec/mysqld: File './mysql-bin.index' not found (Errcode: 13) 110128 13:29:21 [ERROR] Aborting 110128 13:29:21 [Note] /usr/libexec/mysqld: Shutdown complete That's problem number one. Problem number 2 is the lack of instructions for the mysql-connector-java-5.1.14 download that I've got. My understanding is that these are the jdbc drivers. But where are they supposed to go? And once I've got them installed in the right location, what are the next steps? There is information in the new Witango Installer Guide but it says: "The Witango Server can only use a JDBC driver once the driver files have been downloaded to the /Library/Java/Extensions directory." but what exactly are the driver files? There are a number of files in the mysql-connector-java-5.1.14 folder. Once I've got the MySQL Server working, and I've found the correct place for the driver files, would a datasource called witangotest in my jdbc.ini file look like this (assuming MySQL running on the same machine and a test database called testdb: <?xml version="1.0" encoding="ISO-8859-1" ?> <!DOCTYPE JDBCINI SYSTEM "jdbcini.dtd" > <JDBCINI Version="0x00010000"> <DataSources> <DataSource ID="witangotest"> <DSN></DSN> <DriverClass>com.mysql.jdbc.Driver</DriverClass> <URL>jdbc:mysql://127.0.0.1:3306/Testdb</URL> <Properties> <Property ID=""> <Name></Name> <Value></Value> </Property> </Properties> </DataSource> </DataSources> </JDBCINI> What goes into the Property ID, Name, and Value sections? Is there where username and password would go in and what are those the correct formats for those values? Please let me know. Thanks, Steve Smith Oakbridge Information Solutions Oakville Office: (416) 628-0793 Cambridge Office: (519) 489-0142 Email: [email protected] Web: <http://www.oakbridge.ca/> www.oakbridge.ca Certified <http://www.oakbridge.ca/daylite.tml> DayLite Master Partner Certified <http://www.oakbridge.ca/daylite.tml> DayLite Trainer Billings <http://www.billingsapp.com/> Consultant FileMaker Business Alliance <http://www.filemaker.com/> Member MoneyWorks <http://www.moneyworks.ca/> Consultant LightSpeed <http://www.xsilva.com/> Authorized Reseller _____ To unsubscribe from this list, please send an email to [email protected] with "unsubscribe witango-talk" in the body. ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe witango-talk" in the body.
