Page 1 of 2 12 LastLast
Results 1 to 15 of 24
  1. #1
    Join Date
    May 2010
    Posts
    193
    Points
    8,360
    Level
    39

    Should I buy mysql licence?

    Hello,

    I am working on a service uses mysql database on interworx servers. It is a desktop application which communicates with the server (upload-download files and write entries to database). The desktop software is not open source. For the software I give a homepage under a subdomain which is written in php and also uses mysql.

    What do you think should I buy commercial licence for mysql?

    Best regards,
    Adam

  2. #2
    Join Date
    Apr 2012
    Posts
    2,179
    Points
    24,207
    Level
    68
    Hi dss

    Good luck in your project, I hope it goes well for you and I would not mind knowing a little more about it but I understand you may prefer not too.

    My personal thoughts after a little thinking about your post, but please understand it us my personal thought and not necessary correct, I think if your MySQL been used all the time is on your server, and not included in your app, then you may not need to purchase a licence, however, if you include a MySQL in your download app, then you must purchase a licence.

    If you do need to purchase a licence, I would probably opt for an OEM licence.

    I hope that helps a little and look forward to other user views, but apologise if I'm wrong.

    Many thanks

    John

  3. The Following User Says Thank You to d2d4j For This Useful Post:

    dss

  4. #3
    Join Date
    May 2010
    Posts
    193
    Points
    8,360
    Level
    39
    Hi John,

    Thank you for your answer! I have the same opinion, but the internet is totally full with different opinions I read somewhere that somebody asked 3 lawyers and all of them had different opinion

    Of course I have to use another .NET connector for the VB.net application instead of MySQL's Connector.NET and I found this great tool: http://www.devart.com/dotconnect/mysql/

    So the problem on the client side may be solved. Now I am trying to install and configure PostgreSQL on my dev server but it's not supported by InterWorx and I don't want to change the CP. (This could be a hidden feature request! )

    If somebody has opinion please tell me!
    Last edited by dss; 02-15-2014 at 07:17 PM.

  5. The Following User Says Thank You to dss For This Useful Post:


  6. #4
    Join Date
    May 2010
    Posts
    193
    Points
    8,360
    Level
    39
    Good luck in your project, I hope it goes well for you and I would not mind knowing a little more about it but I understand you may prefer not too.
    It's a small cloud service. Our users can upload files to our server with a client software and download them on a homepage (subdomain). The client software write the file details to the databse wich contains user details too.

    They don't have access directly to the server over SFTP. They are using sql on the homepage, like on a normal shared hosting, printing file names and identify the users.

    In the uploader program we will use Devart's dotConnect for MySQL so we won't redistribute any MySQL library. The customers will pay for the storage space, not for the homepage and software like in general hosting business.

    As John wrote, mysql will be used all the time on our server and the client software will use third party mysql connector.
    dotConnect for MySQL

    dotConnect for MySQL

  7. #5
    Join Date
    Apr 2012
    Posts
    2,179
    Points
    24,207
    Level
    68
    Hi dss

    Sounds good, I wish you all the best

    After reading your posts, I'm fairly confident that it does not require a licence itself, as your not including MySQL in app.

    I think you would not have this dilemma if you did not include the app for the users, ie if you had an upload page on website to upload with no app, but I could be wrong sorry.

    To give you an instance in a smaller site, you can install piwigo, which uses MySQL and install mobile app to directly upload pics, which I don't think they have purchased a commercial licence, albeit it opensource so maybe a example sorry, however, that said, the software is free to download/install but an end user could charge monies for its use, which this makes it a good example, I hope.

    I hope that helps and looking forward to other users opinions

    Many thanks

    John

  8. The Following User Says Thank You to d2d4j For This Useful Post:

    dss

  9. #6
    Join Date
    May 2010
    Posts
    193
    Points
    8,360
    Level
    39
    Hi John,

    Thank you John! As I read your reply I think our opinions are the same (I hope we are right ). How do you think "not including MySQL in app"? Don't use MySQL's (Oracle's) libraries or don't use SQL queries in the application?

    Unfortunately the upload software is required because of the very big files and the real time file encryption during the upload.

    I had a look to MySQL's homepage, and as I understand I only have to buy commercial licence If I'm using libraries from them embedded in my application (for example their mysql connector). Because of this I am using the previously mentioned 3rd party library.

  10. #7
    Join Date
    Apr 2012
    Posts
    2,179
    Points
    24,207
    Level
    68
    Hi Dss

    I know it's confusing, but less so then Microsoft licencing, and MySQL is far cheaper then MsSQL, which they now changed a while ago to per core from per proc.

    I have had a quick further look, and I'm thinking now you may be out of luck, as their licence specs cover connections to MySQL as well, from non GPL or commercial products (unless I am getting confused sorry).

    I myself, may think if possible, to opensource your software (this does not mean your software maybe free, only the source code is made available under GPL) and save yourself monies, other then that, you have to licence the server I'm thinking sorry.

    Also, further reading may suggest you might be able to use the php connector, but I'm not too sure if this more work then it needs and may not work for you.

    I hope that helps a little but I would be interested to know other user opnions

    Many thanks

    John

    However, if you develop and sell a commercial program but do not deliver it together with MySQL and leave the installation of the MySQL server and its licensing to the customer, then you must obtain licenses for the client libraries used in your program.
    Explicit licensing of the client library is seen by the MySQL company as an exception, since as a rule, the server is licensed. Commercial licensing of the client library actually represents nothing other than a protection of the MySQL company's commercial interests. They want to avoid the situation in which commercial developers get around having to obtain a commercial license simply by not providing the MySQL server. The customer then loads the GPL version of the MySQL server from the Internet and believes that all is right with the world. In such a case the MySQL company would receive nothing for the development of a commercial MySQL product.
    Client Licenses for the PHP Project, F(L)OSS Exception
    Since MySQL 4.0, the GPL license for client libraries has led to problems with some other open source projects. For example, the PHP project is not subordinate to GPL, but to another open source license that is considerably more liberal and contains fewer restrictions for commercial applications. If PHP were to provide the MySQL client library under GPL, the GPL would have to hold for the entire PHP project. PHP developers were not agreeable to this. MySQL therefore defined an exception that permitted the PHP project to make the MySQL client library part of PHP.
    For other open source projects that do not use the GPL license, MySQL has defined the FLOSS or FOSS license exception. FLOSS stands for Free/Libre and Open Source Software. (On the MySQL Web site the exception is often abbreviated FOSS.) Open source projects that exist under a license that is part of the FOSS exception are permitted to integrate the MySQL client library into their code without the GPL restrictions coming into play. Further details on these license exceptions can be found here:
    http://www.mysql.com/company/legal/licensing/faq.html
    http://www.mysql.com/company/legal/l...exception.html

    Please see link for full article http://searchitchannel.techtarget.co...ercial-license and https://blogs.oracle.com/MySQL/entry...ng_and_pricing

  11. #8
    Join Date
    Apr 2012
    Posts
    2,179
    Points
    24,207
    Level
    68
    Hi dss

    I hope you don't mind, but again thinking about the upload part, and I apologise as I have no knowledge of your software, but it seems similar to some of our clients sites, but might it be simpler to have a webpage upload function instead.

    As I said, some of our clients have this, and do upload files at around 1gb or larger, using https etc and it uses MySQL db.

    It's just a thought sorry

    Many thanks

    John

  12. The Following User Says Thank You to d2d4j For This Useful Post:

    dss

  13. #9
    Join Date
    May 2010
    Posts
    193
    Points
    8,360
    Level
    39
    Hi John,

    Thank you very much! It not the best news

    I think in the state of my application and website it is easier to migrate everything to postgresql. I don't need professional management for it just possibility to create databases, I can do it with pgAdmin on my desktop computer. I installed pgsql to my dev vps and it is very ease to move data to there. It looks like nothing special needed, I think it will work next to InterWorx. So the domain, emails will be managed with InterWorx but in the background will run pgsql.

  14. The Following User Says Thank You to dss For This Useful Post:


  15. #10
    Join Date
    Feb 2014
    Location
    USA
    Posts
    49
    Points
    1,829
    Level
    17
    Unless I am misunderstanding your project you don't need a license. You are free to develop applications that use MySQL. So unless you are actually distributing MySQL in your application a license isn't necessary. If your application talks to MySQL and is run off your hardware that doesn't mean you need a license either because you aren't sending them MySQL. You are just providing an interface to MySQL.

    For example one can download PHPBB or Wordpress and those entities don't need MySQL licenses as they aren't distributing MySQL. It sounds like it is your database the application is talking to. Now you don't get support from Oracle or the more advanced features without a license. However personally I think Percona is better for that anyway.
    Respectfully,

    Jeremy
    Devops is my life

  16. The Following User Says Thank You to cleverwise For This Useful Post:

    dss

  17. #11
    Join Date
    May 2010
    Posts
    193
    Points
    8,360
    Level
    39
    Dear Jeremy,

    I'm trying to summarize:

    I'm developing a software and a page for sharing files. The application connects to my InterWorx server and uses MySQL databases under a domain to store details about the files and the users. The page is using that database (print the file details, identify the users, store system messages, etc.) written in php.

    What is "distributing MySQL" exactly meaning? For example MySQL databases are requirements to use the software? The desktop application uses a connector to connect to the server.

    Is it allowed to install to our customer's computer for example the mysql.data.dll file (downloaded from mysql.com)? What if I use connector from a third party developer (for example Devart's dotConnector)?

    Our customer's going to buy monthy price so it's not a free service and the source codes couldn't be open!

    Because it's a starting project I don't want to pay a lot for license while it is possible to migrate easily to other database engine. But IW supports only MySQL and I don't want to change it. I'm now testing PostgreSQL next to IW, it looks like everything is fine.

  18. #12
    Join Date
    Apr 2012
    Posts
    2,179
    Points
    24,207
    Level
    68
    Hi Dss and Jeremy

    I hope you don't mind but I am still thinking a licence is required sorry. I understand the points raised by Jeremy, but to be honest, the examples listed use php and not .netconnectors, but I could be wrong, and I still am wary of this sentence:

    In such a case the MySQL company would receive nothing for the development of a commercial MySQL product.

    I suppose the only real answer would be if it ever went to a court, where a judgment could then be made, but I doubt it would ever reach that stage myself.

    I'm sorry if I am confusing it more though

    Many thanks

    John

  19. #13
    Join Date
    Feb 2014
    Location
    USA
    Posts
    49
    Points
    1,829
    Level
    17
    The question of licensing commercially is whether you are sending the MySQL server to your clients.

    If for example I develop an application that uses MySQL in the application. Clients download that application and install it on their machines and during the install MySQL itself is actually installed then that is a case for licensing (usually the embedded license). However if a client downloads an application that connects to a MySQL server but they are NOT installing MySQL itself on their computer that is different.

    In this case licensing MySQL comes down to are you embedding MySQL server into your application? It doesn't sound like it to me. It sounds like you have connectors to MySQL. It would be like having a chat server running off MySQL. Your clients download your chat client that simply connects to MySQL but you are the one with the MySQL server not them.

    The ONLY question is the connector you are using as that might be a commercial issue. From Oracle: "Oracle provides its MySQL database server and MySQL Client Libraries under a dual license model designed to meet the development and distribution needs of both commercial distributors (such as OEMs, ISVs and VARs) and open source projects."

    You aren't distributing the "MySQL database server" as you are running the database server not your clients.

    http://www.mysql.com/about/legal/licensing/oem/
    Respectfully,

    Jeremy
    Devops is my life

  20. The Following User Says Thank You to cleverwise For This Useful Post:

    dss

  21. #14
    Join Date
    Apr 2012
    Posts
    2,179
    Points
    24,207
    Level
    68
    Hi Jeremy

    Many thanks, but to me it's still not clear sorry.

    As dss is not open source, and will be providing a connector other then php, does it need to be licenced.

    As I understand it, if it's not open source, and supplies part of the library, it needs licensing, but this is only my thoughts, and thankfully I've not had to answer this question for myself, and as dss has already posted, 4 different lawyers had different thoughts.

    Once again I'm sorry if I am confusing matters further and I will refrain from posting on this topic, to stop any more confusion been caused, but your answer to me has not fully confirmed if it needs a lincence sorry.

    Many thanks

    Jobn

  22. The Following User Says Thank You to d2d4j For This Useful Post:

    dss

  23. #15
    Join Date
    May 2010
    Posts
    193
    Points
    8,360
    Level
    39
    So what do you recommend? Should I buy connector from a diffenrent vendor instead of this: http://dev.mysql.com/downloads/connector/net/?

    To John:
    You can understand now, why I have asked this question This situation is everywhere where I read.
    Last edited by dss; 02-20-2014 at 02:14 PM.

  24. The Following User Says Thank You to dss For This Useful Post:


Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •