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: www.oakbridge.ca
Certified DayLite Master Partner
Certified DayLite Trainer
Billings Consultant
FileMaker Business Alliance Member
MoneyWorks Consultant
LightSpeed Authorized Reseller
----------------------------------------
To unsubscribe from this list, please send an email to [email protected]
with "unsubscribe witango-talk" in the body.
