On Fri, Oct 7, 2011 at 3:39 AM, Zachary1234 <stargate7thsym...@live.co.uk> wrote: > I am assuming that some basic drizzle support is offered from here, to > the public, at no $. > I believe the place to ask is here, so...
Actually, I'm not sure but I think drizzle-operations is intended for project internal IT discussions. In any case it is a very quiet list. I will switch this over to the drizzle-discuss list, please join that and continue discussion there. > -Is drizzle syntax virtually identical to mySQL syntax? SQL syntax yes. Some "enterprise" SQL features have been removed (stored procedures, triggers). But for the most part it's the same, yes. > -Is it true that drizzle only has one, completely open source license, > allowing for use of drizzle in a commercial use context with paying and > $ > to drizzle? Drizzle has more than one license but all of them are open source, so I believe the answer is still yes :-) In particular, the Drizzle server is predominantly GPL and it is not possible for anyone to dual-license it in a non-GPL fashion since copyright is owned by multiple authors and their employers, like with the Linux kernel. > -I need a java odbc and jdbc connector program, which is also entirely > no $ > and open source. Has this been programmed yet, and where may I find > it? > If not, are there some odbc connection instructions I can use, and > where? There is a new C client library called libdrizzle which is written from scratch and BSD licensed. There is also Drizzle JDBC library which again is written from scratch and BSD licensed: http://wiki.drizzle.org/JDBC Note however that Oracle and legal GPL authorities have said that it is also ok to just use the MySQL GPL licensed client libraries in cases where you use a standard API like JDBC, ODBC, ADO.NET, PDO, DBI etc... http://openlife.cc/blogs/2011/january/reposting-mark-schonewilles-blog-how-gpl-applies-mysql-use-cases Drizzle does not offer legal advice on this question so if you want to explore this option, please find your own lawyer. The MySQL ND library in the newest versions of PHP are under the BSDish PHP license. >From a technical point of view, any client written for MySQL can connect to Drizzle. > -I attempt a drizzle login on my drizzle-client && drizzle-server > pc, and I only get the following: > > [root@localhost zachary]# drizzle > ERROR: > drizzle_state_connect:could not connect > > -What do I need to do to fix this? Is it possible my firewall rules > are in the way? Is there a script I can use to quickly fix the > problem? It is possible. Have you used MySQL on this server and did that work? One way to troubleshoot this would be to: - if MySQL is running and installed, verify you can connect to it. Use mysql -h127.0.0.1 to make sure it connects via network and not unix socket. - shutdown MySQL - start Drizzle with ./sbin/drizzled --mysql-protocol.port=3306 - now use either "drizzle" or "mysql" commands to connect to drizzled henrik -- henrik.i...@avoinelama.fi +358-40-8211286 skype: henrik.ingo irc: hingo www.openlife.cc My LinkedIn profile: http://www.linkedin.com/profile/view?id=9522559 _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : drizzle-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
