Hi Matt & others :)
With the MySQL /mariaDB < 5.6 i don't have this problem also (only getting
crashes in Percona XtraDB under MariaDB.).
I have googled al little bit more and it seems like MySQL has changed the
behaviour of the join i have tried; as far as i understand, a join is
interpreted as inner join by mysql, and i found the following webpage on
stackoverflow, with a simular problem:
http://stackoverflow.com/questions/17548097/mysql-5-6-12-group-concat-with-inner-join-issue
Maybe this will have an influence on the development...
Hans Scheffers
AIX / Linux Systeembeheer
> From: matt.jo...@monster.com
> To: icinga-users@lists.sourceforge.net
> Date: Thu, 14 Nov 2013 15:48:56 +0000
> Subject: Re: [icinga-users] icinga-web woes
>
> For what it is worth I am running the same versions of Icinga/IDO/Icinga-Web
> with a remote MariaDB(5.5.3) and I had no issues with the transition.
>
> -----Original Message-----
> From: Michael Friedrich [mailto:michael.friedr...@gmail.com]
> Sent: Thursday, November 14, 2013 10:40 AM
> To: icinga-users@lists.sourceforge.net
> Subject: Re: [icinga-users] icinga-web woes
>
> On 14.11.2013 16:20, Hans Scheffers wrote:
> > Both statements are executed as root user in mysql (so all grants
> > should be OK) and are on the same database.
> > The only difference I see is the mysql / mariadb version, it looks
> > like the syntax in the newer mysql has been changed.
> >
> > Anyone can shed a light on this ;)
>
> i would ask on the mysql/mariadb/etc mailinglists. not related to icinga as
> application - likely happens with any other tool writing data to the database.
>
> --
> DI (FH) Michael Friedrich
>
> mail: michael.friedr...@gmail.com
> twitter: https://twitter.com/dnsmichi
> jabber: dnsmi...@jabber.ccc.de
> irc: irc.freenode.net/icinga dnsmichi
>
> icinga open source monitoring
> position: lead core developer
> url: https://www.icinga.org
>
> ------------------------------------------------------------------------------
> DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
> OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access Free
> app hosting. Or install the open source package on any LAMP server.
> Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
> http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
> _______________________________________________
> icinga-users mailing list
> icinga-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/icinga-users
> NOTICE:
>
> This message, and any attachments, contain(s) information that may be
> confidential or protected by privilege from disclosure and is intended only
> for the individual or entity named above. No one else may disclose, copy,
> distribute or use the contents of this message for any purpose. Its
> unauthorized use, dissemination or duplication is strictly prohibited and may
> be unlawful. If you receive this message in error or you otherwise are not an
> authorized recipient, please immediately delete the message and any
> attachments and notify the sender.
>
> ------------------------------------------------------------------------------
> DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
> OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
> Free app hosting. Or install the open source package on any LAMP server.
> Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
> http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
> _______________________________________________
> icinga-users mailing list
> icinga-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/icinga-users
------------------------------------------------------------------------------
DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
Free app hosting. Or install the open source package on any LAMP server.
Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
_______________________________________________
icinga-users mailing list
icinga-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/icinga-users