- discuss - lists.mariadb.org

[Maria-discuss] mariasql client question (zappajs, coffeescript, nodejs)
by klrumpf 05 Feb '13

05 Feb '13

Hi, I have switched from mysql to mariadb using it with the node-mysql client and this has been runing in prod. for some time. I now want to switch to the mariasql client... inspect = require('util').inspect mdbClient = require('mariasql') ... To do the many queries and simplify the source I wanted to write a principal function for queries that simply returns an object (or array) with the query result and then I could just re-use the existing functionality for the render. So I copied this from the examples doSql = (sqlstring) -> c = new mdbClient() c.connect host: 'localhost' db: 'xyz' # NOT database user: 'abc' password: 'defghi' c.on("connect", -> console.log "Client connected" ).on("error", (err) -> console.log "Client error: " + err ).on "close", (hadError) -> console.log "Client closed" c.query(sqlstring).on("result", (res) -> res.on("row", (row) -> console.log "Result row: " + inspect(row) ).on("error", (err) -> console.log "Result error: " + inspect(err) ).on "end", (info) -> console.log "Result finished successfully, number of rows: " + info.numRows ).on "end", -> console.log "Done with all results" c.end() .... and then @get '/': (req,res) -> # LANDING PAGE) result = doSql("select pakz from pkt where pktnr=10001") console.log "919, result = ",result .... @view.... Console log in the doSql functions shows the results correctly but I have been playing around for a while and I can't get the function to return the result for further processing to the @get routine. Seems like I have not understood the scope issues here and probably a few more things, I am still green with this. My questions - what is the correct approach to do pass the query object from the function to the calling program if this is possible at all? - how do I access the individual rows the way I do it with node-mysql like so row[1].myfield ...? - should I create the instance of the mdbClient in the function or rather once at the very beginning of the program, my principal worry being stability even if the db disconnects here and there for some reason? Thanks, hope this is the right list for this, Karl -- Karl-L. Rumpf klrumpf(a)gmail.com Málaga, Spain

2 2

[Maria-discuss] Files under /etc/my.cnf.d/ read by default
by Honza Horak 05 Feb '13

05 Feb '13

Hi guys, while we were packaging MariaDB into Fedora (finally) we used the upstream's cnf files structure, which means /etc/my.cnf, that includes all files from directory /etc/my.cnf.d/* using statement !includedir. That works fine when user installs (not updates) the MariaDB packages without having them installed before. The problem is if user has changed /etc/my.cnf before updating -- then /etc/my.cnf doesn't get updated (!includedir won't be added) and we end with files under /etc/my.cnf.d/* but nothing what includes them. That is quite confusing for users that may change something in /etc/my.cnf.d/client.cnf but nothing happens. Since files under /etc/my.cnf.d/* are empty by default it shouldn't do any harm if all files corresponding with /etc/my.cnf.d/*.cnf template get loaded even without !includedir in /etc/my.cnf. Actually I believe that is what users expect to happen when they see files under /etc/my.cnf.d.. So, that's basically what I'm proposing -- read files under /etc/my.cnf.d/* by default, without a need to use !includedir. What do you think? Regards, Honza

1 1

Re: [Maria-discuss] Reading a field's default value from a trigger
by Bruce Kirkpatrick 04 Feb '13

04 Feb '13

For anyone encountering the "Field 'xxx' doesn't have a default value" when running insert/update/replace statement on MariaDB, I found that this is actually caused by the sql mode STRICT_TRANS_TABLES. This also fixes when a trigger updates the default value of the field. I believe the default options for MariaDB windows installer cause this option to be enabled, whereas I had previous never designed my application for the various modes supported. You can also fix the issue by giving every field in the table an explicit default value of 0 or '' except for text/longtext columns. I choose not to do that since I don't know how many other things change with STRICT_TRANS_TABLES. If you change my.ini / my.cnf to sql-mode="", you won't have this error occur anymore. You can run SELECT @@GLOBAL.sql_mode; on your mysql server and mariadb server to compare what the current settings are. This is my first post to the MariaDB mailing list. Sorry if I did it wrong. I've been using MySQL for over 10 years and decided to migrate to MariaDB now. -- Bruce Kirkpatrick<http://www.skyflare.com/> 386-405-4643

2 1

[Maria-discuss] MariaDB's tracking of MySQL changes
by Christian Convey 04 Feb '13

04 Feb '13

Can someone explain the relationship between MySQL and MariaDB code updates? I've read that MariaDB is a drop-in *replacement* for MySQL. But I've also read that MariaDB treats MySQL as an upstream code base. So what's the deal? Does MariaDB have alternative implementations for just some of MySQL's components, and when a new MySQL release comes out, MariaDB updates just those components for which it doesn't have its own versions? [This is a re-post from the #maria IRC channel, where I got no answer.] Thanks, Christian

2 1

[Maria-discuss] MariaDB 5.5.29, 5.3.12, 5.2.14, 5.1.67 now available
by Daniel Bartholomew 31 Jan '13

31 Jan '13

The MariaDB project is pleased to announce the immediate availability of the following new MariaDB versions: 5.5.29, 5.3.12, 5.2.14, & 5.1.67 Appologies in advance for the length of this email but we'd rather send out just one combined announce email instead of an email for each of these releases. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.29 Stable (GA) - Release Notes: https://kb.askmonty.org/en/mariadb-5529-release-notes - Changelog: https://kb.askmonty.org/en/mariadb-5529-changelog - Downloads: https://downloads.mariadb.org/mariadb/5.5.29 MariaDB 5.3.12 Stable (GA) - Release Notes: https://kb.askmonty.org/en/mariadb-5312-release-notes - Changelog: https://kb.askmonty.org/en/mariadb-5312-changelog - Downloads: https://downloads.mariadb.org/mariadb/5.3.12 MariaDB 5.2.14 Stable (GA) - Release Notes: https://kb.askmonty.org/en/mariadb-5214-release-notes - Changelog: https://kb.askmonty.org/en/mariadb-5214-changelog - Downloads: https://downloads.mariadb.org/mariadb/5.2.14 MariaDB 5.1.67 Stable (GA) - Release Notes: https://kb.askmonty.org/en/mariadb-5167-release-notes - Changelog: https://kb.askmonty.org/en/mariadb-5167-changelog - Downloads: https://downloads.mariadb.org/mariadb/5.1.67 - - Other Links - - - - - - - - - - - - - - - - - - - - - - - - - - - APT and YUM Repository Configuration Generator: https://downloads.mariadb.org/mariadb/repositories/ Overview of MariaDB 5.5: https://kb.askmonty.org/en/what-is-mariadb-55 Overview of MariaDB 5.3: https://kb.askmonty.org/en/what-is-mariadb-53 Overview of MariaDB 5.2: https://kb.askmonty.org/en/what-is-mariadb-52 Overview of MariaDB 5.1: https://kb.askmonty.org/en/what-is-mariadb-51 - - Security Updates - - - - - - - - - - - - - - - - - - - - - - - - - These releases are "bug fix" releases and they include, among other things, fixes for the following security vulnerabilities: - A buffer overflow that can cause a server crash or arbitrary code execution (a variant of CVE-2012-5611) http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-5611 - CVE-2012-5627/MDEV-3915 fast password brute-forcing using the "change user" command http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-5627 https://mariadb.atlassian.net/browse/MDEV-3915 - CVE-2012-5615/MDEV-3909 information leakage about existing user accounts via the protocol handshake http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-5615 https://mariadb.atlassian.net/browse/MDEV-3909 - fixes for DoS attacks - crashes and server lockups https://mariadb.atlassian.net/browse/MDEV-4029 https://mariadb.atlassian.net/browse/MDEV-729 These releases of MariaDB also include all applicable upstream security fixes from MySQL, such as fix for a CVE-2012-5612/MDEV-3908 and other crashes. http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-5612 https://mariadb.atlassian.net/browse/MDEV-3908 - - New Packages - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.29 includes packages for Fedora 18 "Spherical Cow" and Ubuntu 12.10 "Quantal Quetzal". Visit the Repository Configurator to generate the necessary commands to easily install MariaDB on these and many other distributions. We've also extended the repository configuration tool to provide instructions for distributions which include MariaDB. We've started with Mageia and will be adding others soon. https://downloads.mariadb.org/mariadb/repositories/ - - Discontinued Builds - - - - - - - - - - - - - - - - - - - - - - - Along with the news of new package builds is the news that some old distributions will be deprecated. The MariaDB project tries to support as many different operating systems and Linux distributions as possible. However, when a distribution or OS stops receiving upstream security and other updates it becomes difficult to provide packages for that platform. In such cases, our policy is to deprecate that platform and stop building binary packages for it in our build system. As of 1 Feb 2013, we will stop building and testing packages for the following: - Fedora 16 "Verne" - Debian 5 "Lenny" - Ubuntu 10.10 "Maverick" - Ubuntu 11.04 "Natty" Even after your chosen Linux distribution is deprecated, packages and support are still available. Companies such as SkySQL and Monty Program (among others) provide paid support for all versions of MariaDB and back to even very old MySQL versions. This includes packaged binaries. More information on our deprecation policy can be found at: https://kb.askmonty.org/en/mariadb-deprecation-policy/ - - Archived Releases - - - - - - - - - - - - - - - - - - - - - - - - From the beginning of the MariaDB project in 2009 we've kept all of our old releases online via our network of mirrors. Doing this is great for those few who are interested in old releases, but the disk space required to host all of our old releases is over 130 Gigabytes at present and grows by several gigabytes with each new release. This is too much for some of our mirrors to handle. So, starting with this round of releases our primary mirror will only host the most recent few releases in each series (5.5, 10.0, 5.3, and so on). Mirrors are, of course, free to keep archiving every release, but the primary mirror that they pull from will not. Old releases do have value, so for those that are interested in old releases, we are setting up a simple, no frills, archive server which will host them. Once the server is up and running, links to archived releases on https://downloads.mariadb.org will point at the archive server. During the transition period, links to some old releases may disappear for a short time, but don't worry, they haven't been deleted, they're just being moved! If you have hundreds of spare gigabytes on a fast connection and would also like to host the complete MariaDB archive, contact us at mirror at mariadb.org and we'll include a link your mirror from our archive server. (see https://kb.askmonty.org/en/mirroring-mariadb/ for more information about becoming a mirror) - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf (my.ini on Windows) file! See http://kb.askmonty.org/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to MariaDB, please see our "contributing" and "donations" pages. We also have merchandise available in a cafepress store. - https://kb.askmonty.org/en/contributing - https://mariadb.org/en/donate/ - http://www.cafepress.com/mariadb We hope you enjoy MariaDB! -- MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org Monty Program - http://montyprogram.com

1 0

Re: [Maria-discuss] noinstall package for MariaDB
by Vineet Deodhar 25 Jan '13

25 Jan '13

Thank you. I really appreciate the fast & helpful response on this mailing list. --- Vineet --- On Fri, 25/1/13, Vladislav Vaintroub <wlad(a)montyprogram.com> wrote: From: Vladislav Vaintroub <wlad(a)montyprogram.com> Subject: RE: [Maria-discuss] noinstall package for MariaDB To: "'Vineet Deodhar'" <d_vineet(a)yahoo.com> Date: Friday, 25 January, 2013, 15:10 >Thanks Vladislav. >If I get you right, I should copy & paste the directories EXCEPT the data directory. >Is that correct? This is correct, and this is what you also should normally do when updating zips, even if you are not switching MySQL variants. >I am using Windows at present, but going to switch over to Ubuntu 12.04 LTS soon. :-) >Can you pl. share the mariadb download url for linux? Everything is on https://downloads.mariadb.org/mariadb . For example https://downloads.mariadb.org/mariadb/5.5.28a/#os_group=linux_generic would be tar.gz (if you favor non-install packages, like on Windows, those are the right ones)

1 0

[Maria-discuss] noinstall package for MariaDB
by Vineet Deodhar 25 Jan '13

25 Jan '13

Hi ! At present, I am using MySQL noinstall version (which doesn't require ANY installation). Just copy & paste the folder & start. Is there any way to use MariaDB without installing? (Maybe replace MySQL folder containing the binaries with MariaDB folder? If yes, from where to get the noinstall folder for MariaDB?) Thanks, Vineet

2 2

[Maria-discuss] Compatibility problems switching Glassfish application from MySQL to MariaDB
by Guido Winkelmann 24 Jan '13

24 Jan '13

Hi, I'm having some problems switching one of our Java/Glassfish-based web applications over from MySQL to to MariaDB. Since the MariaDB project advertises the software as a fully compatible drop- in replacement for MySQL, the first thing I did was simply stop the MySQL server, uninstall it, and then install and start MariaDB (5.5.28a, from Gentoo portage). We have got several C/C++ based application that access our MySQL databases. Those took a recompile, but afterwards continued to work as if nothing had happened. I didn't have as much luck with our glassfish-based web frontend though. The first problem was that the existing MySQL connector is apparently unable to connect to MariaDB, so I deleted the existing JDBC Connection Pools and replaced them with new ones using the MariaDB Java Client instead. This worked on the surface, however now I'm getting a lot of exceptions whenever I'm accessing parts of the application that make use of BINARY type columns. According to the developer (of the web application on question), this is because either MariaDB itself or the connector are returning binary columns as type string, causing the persistance layer to attempt to convert them to a string object. Since the binary columns in question contain various unprintable characters, including zero-bytes, this fails. Can someone please help me with these problems? Guido

2 2

[Maria-discuss] 10.0.0 msi pack fails first start
by Federico Razzoli 24 Jan '13

24 Jan '13

Hi I tried to install MariaDB 10.0.0 on Windows XP, MSI package. Apparently the installation worked, but the server fails to start. I paste here the log until the first shutdown, just in case you don't know about this problem. Federico 130124 10:49:47 InnoDB: The InnoDB memory heap is disabled 130124 10:49:47 InnoDB: Mutexes and rw_locks use Windows interlocked functions 130124 10:49:47 InnoDB: Compressed tables use zlib 1.2.3 130124 10:49:47 InnoDB: CPU does not support crc32 instructions 130124 10:49:47 InnoDB: Initializing buffer pool, size = 128.0M 130124 10:49:47 InnoDB: Completed initialization of buffer pool InnoDB: The first specified data file .\ibdata1 did not exist: InnoDB: a new database to be created! 130124 10:49:47 InnoDB: Setting file .\ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 130124 10:49:47 InnoDB: Log file .\ib_logfile0 did not exist: new to be created InnoDB: Setting log file .\ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 130124 10:49:48 InnoDB: Log file .\ib_logfile1 did not exist: new to be created InnoDB: Setting log file .\ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... 130124 10:49:48 InnoDB: Doublewrite buffer not found: creating new 130124 10:49:48 InnoDB: Doublewrite buffer created 130124 10:49:49 InnoDB: 128 rollback segment(s) are active. InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 130124 10:49:49 InnoDB: Waiting for the background threads to start 130124 10:49:49 InnoDB: 1.2.0 started; log sequence number 0 130124 10:49:49 [Note] Plugin 'FEEDBACK' is disabled. 130124 10:49:56 InnoDB: FTS optimize thread exiting. 130124 10:49:56 InnoDB: Starting shutdown... 130124 10:49:58 InnoDB: Shutdown completed; log sequence number 1602824 130124 10:50:00 InnoDB: The InnoDB memory heap is disabled 130124 10:50:00 InnoDB: Mutexes and rw_locks use Windows interlocked functions 130124 10:50:00 InnoDB: Compressed tables use zlib 1.2.3 130124 10:50:00 InnoDB: CPU does not support crc32 instructions 130124 10:50:01 InnoDB: Initializing buffer pool, size = 31.0M 130124 10:50:01 InnoDB: Completed initialization of buffer pool 130124 10:50:01 InnoDB: Log file .\ib_logfile0 did not exist: new to be created InnoDB: Setting log file .\ib_logfile0 size to 31 MB InnoDB: Database physically writes the file full: wait... 130124 10:50:02 InnoDB: Log file .\ib_logfile1 did not exist: new to be created InnoDB: Setting log file .\ib_logfile1 size to 31 MB InnoDB: Database physically writes the file full: wait... 130124 10:50:03 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 130124 10:50:03 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 130124 10:50:03 InnoDB: 128 rollback segment(s) are active. 130124 10:50:03 InnoDB: Waiting for the background threads to start 130124 10:50:03 InnoDB: 1.2.0 started; log sequence number 1603084 130124 10:50:03 [Note] Plugin 'FEEDBACK' is disabled. 130124 10:50:03 [Note] Event Scheduler: Loaded 0 events 130124 10:50:03 [Note] C:\Programmi\MariaDB 10.0\bin\mysqld.exe: ready for connections. Version: '10.0.0-MariaDB' socket: '' port: 3306 Source distribution 130124 11:03:13 InnoDB: The InnoDB memory heap is disabled 130124 11:03:13 InnoDB: Mutexes and rw_locks use Windows interlocked functions 130124 11:03:13 InnoDB: Compressed tables use zlib 1.2.3 130124 11:03:13 InnoDB: CPU does not support crc32 instructions 130124 11:03:13 InnoDB: Initializing buffer pool, size = 128.0M 130124 11:03:13 InnoDB: Completed initialization of buffer pool InnoDB: Error: log file .\ib_logfile0 is of different size 32505856 bytes InnoDB: than specified in the .cnf file 5242880 bytes! 130124 11:03:14 [ERROR] Plugin 'InnoDB' init function returned error. 130124 11:03:14 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 130124 11:03:15 [Note] Plugin 'FEEDBACK' is disabled. 130124 11:03:16 [ERROR] Unknown/unsupported storage engine: InnoDB 130124 11:03:16 [ERROR] Aborting 130124 11:03:17 [Note] C:/Programmi/MariaDB 10.0/bin/mysqldd: Shutdown complete

1 1

[Maria-discuss] Trouble installing MariaDB 5.5 on Ubuntu 12.04 (& 12.10)
by Aaron Anderson 23 Jan '13

23 Jan '13

Gang, I've installed MariaDB on several Debian/Ubuntu systems in the past few months, without any issues. ~2 days ago on an Unbuntu 12.10 system did an apt-get update/upgrade/dist-upgrade. I believe that MariaDB was updated in that process. After the updates, mysql was "gone" My apps couldn't find it, it wasn't running, etc. I was in a hurry so I had to fall back to the standard mysql package so not a lot of into there. I built a new Ubuntu 12.04 LTS server, added the Maria repo, did an apt-get update/ugprade/dist-upgrade. Rebooted. Here's some output... I'm stuck in this loop. root@nn01:~# apt-get install mariadb-server Reading package lists... Done Building dependency tree Reading state information... Done Some packages could not be installed. This may mean that you have requested an impossible situation or if you are using the unstable distribution that some required packages have not yet been created or been moved out of Incoming. The following information may help to resolve the situation: The following packages have unmet dependencies: mariadb-server : Depends: mariadb-server-5.5 but it is not going to be installed E: Unable to correct problems, you have held broken packages. root@nn01:~# apt-get install mariadb-server-5.5 Reading package lists... Done Building dependency tree Reading state information... Done Some packages could not be installed. This may mean that you have requested an impossible situation or if you are using the unstable distribution that some required packages have not yet been created or been moved out of Incoming. The following information may help to resolve the situation: The following packages have unmet dependencies: mariadb-server-5.5 : Depends: mariadb-client-5.5 (>= 5.5.28-mariadb-a1~precise) but it is not going to be installed Depends: mariadb-server-core-5.5 (>= 5.5.28-mariadb-a1~precise) but it is not going to be installed E: Unable to correct problems, you have held broken packages. root@nn01:~# apt-get install mariadb-client-5.5 Reading package lists... Done Building dependency tree Reading state information... Done Some packages could not be installed. This may mean that you have requested an impossible situation or if you are using the unstable distribution that some required packages have not yet been created or been moved out of Incoming. The following information may help to resolve the situation: The following packages have unmet dependencies: mariadb-client-5.5 : Depends: libdbd-mysql-perl (>= 1.2202) but it is not going to be installed Depends: mariadb-common but it is not going to be installed Depends: libmariadbclient18 (>= 5.5.28-mariadb-a1~precise) but it is not going to be installed Depends: mariadb-client-core-5.5 (>= 5.5.28-mariadb-a1~precise) but it is not going to be installed E: Unable to correct problems, you have held broken packages. root@nn01:~#

2 2