In all cases, I am always testing with the latest drivers available from each vendor.
In the case of MySQL, this means the 5.1 suite of drivers (Connector/ODBC and Connector/J) In general older drivers will work, but are not necessarily supported. Robert From: STEPHEN SU [mailto:[email protected]] Sent: Wednesday, January 26, 2011 3:20 PM To: [email protected] Subject: Re: Witango-Talk: MySQL, OSX, JDBC and ODBC Robert, which JDBC driver set works the best? - s On Jan 26, 2011, at 2:55 PM, Robert Shubert wrote: Steve, I have tested Witango 6 on OS X against MySQL with both JDBC and ODBC. JDBC works fine and I would recommend it slightly above ODBC on OS X. For ODBC, you need to download and install the MySQL ODBC 5.1 driver for OS X 10.6 32-bit (not the 64-bit one since iODBC on OS X runs in 32-bit mode) You may also need an ODBC administrative tool. The MySQL installer may install one, I can’t be sure, because I already had 2 others. Apple has one, but I couldn’t get that one to work properly. Ultimately, I used the OpenLink ODBC Administrator to setup the DSN and Witango 6 was happy with that. Incidentally I have tested Witango 6 against the current open link drivers (for MS SQL) and that worked well. By default Witango Server 6 is setup to access both JDBC and ODBC. Robert PS. I have not done any testing with PostgreSQL yet, and we don’t support that DBMS in the Studio. I will get to this as soon as I can. From: Steve Smith [mailto:[email protected]] Sent: Wednesday, January 26, 2011 12:01 PM To: [email protected] Subject: Re: Witango-Talk: I Screwed Up Found the problem. As good as Apple's user interface for OS X Server is, sometimes you see a slightly different picture when you open up terminal and run ls -la. Once I remembered what the letters meant, I was able to figure out what needed to be fixed. Now it is on to setting up a data source on this box. My experience was always with ODBC, but my sense is that JDBC is the way to go in today's world. Planning on continuing to use MySQL, or possibly look at PostgreSQL. For now I'll be porting over my existing system which runs under MySQL. Is JDBC the way to go? 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 On 2011-01-25, at 8:37 PM, Robert Shubert wrote: Steve, Simply put, the permissions on the folder where you site files reside doesn’t have read permissions. It should have Everyone “Read only” on it (and possibly folders leading up to it). Just Get Info on each and set them accordingly. Creating the share may have automatically set tighter permissions, or perhaps changed the group permission that was originally allowing Apache to access the files. Robert From: Steve Smith [mailto:[email protected]] Sent: Tuesday, January 25, 2011 7:25 PM To: [email protected] Subject: Witango-Talk: I Screwed Up With Robert's help, I was able to get Witango v6 up and running on my Mac mini OS X Server... for a few minutes. Then I started to tinker and tried a couple of things in an attempt to create a Share Point that I could access from the machine that is running Witango Studio. And I screwed things up. Now whenever I attempt to access any document on the webserver I get this: Access forbidden! You don't have permission to access the requested directory. There is either no index document or the directory is read-protected. If you think this is a server error, please contact the webmaster. Error 403 10.0.1.10 Tue Jan 25 19:13:10 2011 Apache/2.2.15 (Unix) And while I thought that I had Time Machine turned on, I must have turned it off so I can't even restore. In System Admin's logs for the webserver, I see this: Tue Jan 25 19:13:10 2011 error http://client <http://client/> 10.0.1.16 (13)Permission denied: access to / denied Is this an easy fix and if so can someone help me out? 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. _____ 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. _____ 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.
