[Maria-discuss] 5.5.x vs 10.x

2014-12-28 Thread Tanstaafl
So, thinking of building a totally new server from scratch on a new vmWare host for playing around, and was curious of the differences. Is 5.5 still being maintained just because it is the last major stable version before 10.x? But then isn't 10.x the way forward? Is 10.x still considered a drop-

Re: [Maria-discuss] Lost connection to MySQL server at, 'reading authorization packet', system error: 104 (or 0)

2014-07-09 Thread Tanstaafl
On 7/9/2014 1:55 PM, Reindl Harald wrote: Am 09.07.2014 19:29, schrieb Tanstaafl: But my point is shouldn't these errors that the server is seeing show in the (mysql) logs somewhere? why should they? if they would and i can access your database server it takes me one minute to DOS

Re: [Maria-discuss] Lost connection to MySQL server at, 'reading authorization packet', system error: 104 (or 0)

2014-07-09 Thread Tanstaafl
On 7/9/2014 1:29 PM, Tanstaafl wrote: On 7/9/2014 12:52 PM, Reindl Harald wrote: Am 09.07.2014 17:45, schrieb Tanstaafl: But a couple of weeks later, my mysql server actually blocked the SOGo server completely: 2014-06-29 19:49:01.986 sogo-tool[7566] ERROR: could not open MySQL4 connection

Re: [Maria-discuss] Lost connection to MySQL server at, 'reading authorization packet', system error: 104 (or 0)

2014-07-09 Thread Tanstaafl
On 7/9/2014 12:24 PM, Federico Razzoli wrote: I know nothing about SOGo (this is a MariaDB list), but I searched the proper mailing list for you, and it seems that someone already had your problem: http://www.mail-archive.com/users%40sogo.nu/msg18460.html That is me from another account - st

Re: [Maria-discuss] Lost connection to MySQL server at, 'reading authorization packet', system error: 104 (or 0)

2014-07-09 Thread Tanstaafl
On 7/9/2014 12:52 PM, Reindl Harald wrote: Am 09.07.2014 17:45, schrieb Tanstaafl: But a couple of weeks later, my mysql server actually blocked the SOGo server completely: 2014-06-29 19:49:01.986 sogo-tool[7566] ERROR: could not open MySQL4 connection to database 'sogo&#

Re: [Maria-discuss] Lost connection to MySQL server at, 'reading authorization packet', system error: 104 (or 0)

2014-07-09 Thread Tanstaafl
On 7/2/2014 8:30 AM, Reindl Harald wrote: you refuse to understand that this message comes from the*client* and not from MySQL/MariaDB - so guess why nobody here gave an answer Yes, the error I posted comes from the client, but apparently the server is seeing errors from the client too... I

[Maria-discuss] max_connections variable

2014-07-08 Thread Tanstaafl
Hello all, How is the max_connections variable used? Apparently it counts the max number of connections for all users combined, but is there a time factor? Ie, is it just simultaneous connections? Or max_connections per day? per hour? Thanks ___

Re: [Maria-discuss] Lost connection to MySQL server at, 'reading authorization packet', system error: 104 (or 0)

2014-07-02 Thread Tanstaafl
On 6/30/2014 3:48 PM, Reindl Harald wrote: solve problems at the root-cause Absolutely agree... if a update of 3rd party software introduces problems it is very clear where the root-cause is Not necessarily. Have you never heard of a case where updating one software reveals a bug in some

Re: [Maria-discuss] Lost connection to MySQL server at, 'reading authorization packet', system error: 104 (or 0)

2014-06-30 Thread Tanstaafl
13:59, schrieb Tanstaafl: Reindl/anyone? comlain at the client developers what else nobody else has such problems you even state before update the client there was no problem if you update software B and things break why seek the problem in software A at all? On 6/22/2014 12:01 PM, Tanstaafl

Re: [Maria-discuss] Lost connection to MySQL server at, 'reading authorization packet', system error: 104 (or 0)

2014-06-30 Thread Tanstaafl
Reindl/anyone? On 6/22/2014 12:01 PM, Tanstaafl wrote: On 6/19/2014 7:34 AM, Reindl Harald wrote: Am 19.06.2014 13:17, schrieb Tanstaafl: On 6/18/2014 7:53 AM, Reindl Harald wrote: the client seems to use the very outdated mysql4 protocol which is not compatible When you say 

Re: [Maria-discuss] Lost connection to MySQL server at, 'reading authorization packet', system error: 104 (or 0)

2014-06-22 Thread Tanstaafl
On 6/19/2014 7:34 AM, Reindl Harald wrote: Am 19.06.2014 13:17, schrieb Tanstaafl: On 6/18/2014 7:53 AM, Reindl Harald wrote: the client seems to use the very outdated mysql4 protocol which is not compatible When you say 'not compatible' - do you mean that mariadb simply will (

Re: [Maria-discuss] Lost connection to MySQL server at, 'reading authorization packet', system error: 104 (or 0)

2014-06-22 Thread Tanstaafl
On 6/18/2014 7:30 AM, Tanstaafl wrote: Googling reveals a lot of reports about this error over the years, some seemingly to be bugs, others DB tuning issues. Should I be looking at tuning: max_connections max_user_connections ? If not, does anyone know where I should start looking? Is there

Re: [Maria-discuss] Lost connection to MySQL server at, 'reading authorization packet', system error: 104 (or 0)

2014-06-19 Thread Tanstaafl
On 6/18/2014 7:53 AM, Reindl Harald wrote: the client seems to use the very outdated mysql4 protocol which is not compatible When you say 'not compatible' - do you mean that mariadb simply will (would) not work with that protocol if the software attempts to use it? - no idea why it does th

[Maria-discuss] Lost connection to MySQL server at, 'reading authorization packet', system error: 104 (or 0)

2014-06-18 Thread Tanstaafl
Hi all, I'm very inexperienced mariadb/mysql/sql user/admin, but not totally clueless, been maintaining a tiny mysql DB for postfixadmin for years, then converted it to mariadb. We recently started using SOGo (groupware). I hired the SOGo guys to help with the install/config, and have been u

Re: [Maria-discuss] Easy way to see different users@hosts connected to all databases?

2014-06-18 Thread Tanstaafl
://blog.webyog.com/2011/12/19/how-to-add-a-simple-custom-object-in-monyog/ (you can of course use the query used as an example in the blog in whatever client interface you want) On Sun, Jun 15, 2014 at 4:08 PM, Tanstaafl mailto:tansta...@libertytrek.org>> wrote: Is there a simple command I can is

Re: [Maria-discuss] Easy way to see different users@hosts connected to all databases?

2014-06-15 Thread Tanstaafl
Thanks for the replies, some useful info there, but I found a much simpler way (that gave me just what I needed): Log into mysql as root and do: show processlist; perfect! Thanks again, Charles On 6/15/2014 10:08 AM, Tanstaafl wrote: Is there a simple command I can issue to see a list of

[Maria-discuss] Easy way to see different users@hosts connected to all databases?

2014-06-15 Thread Tanstaafl
Is there a simple command I can issue to see a list of the current users@hosts connected to all of the databases of a running mariadb server? I'm trying to troubleshoot a problem where an update from 5.5.30 to 5.5.37 recently caused all of the connections from my groupware host to start coming

Re: [Maria-discuss] postfixadmin and mariadb, want to add support for user 'groups'

2014-03-12 Thread Tanstaafl
On 3/9/2014 12:10 PM, Tanstaafl wrote: The problem is, SOGo does not have support for using 'Groups' for ACLs when using SQL for the AUTH backend. It also does not (yet) have support for different AUTH and USER DB backends. So, as things stand now, I'm going to have to man

Re: [Maria-discuss] postfixadmin and mariadb, want to add support for user 'groups'

2014-03-10 Thread Tanstaafl
On 3/10/2014 10:38 AM, Reindl Harald wrote: So, I need an SQL schema that allows for the creation of 'Groups', that the email 'accounts' can be made members of, that can then be queried to test if any given email user is a member of any given group. Hopefully that was a little clearer that

Re: [Maria-discuss] postfixadmin and mariadb, want to add support for user 'groups'

2014-03-10 Thread Tanstaafl
On 3/10/2014 9:42 AM, Sergei Golubchik wrote: Hi, Tanstaafl! On Mar 09, Tanstaafl wrote: So, as things stand now, I'm going to have to manually add every single individual userid to every single resource they will need to have access too, rather than just doing this with groups. Th

[Maria-discuss] postfixadmin and mariadb, want to add support for user 'groups'

2014-03-09 Thread Tanstaafl
Hello all, We have a postfixadmin+mariadb sql database we have been using for many, many years (well, only recently migrated from mysql to mariadb, and it was totally transparent, so thanks for that!). This system is rock solid, and we have no desire to change it. We are in the process of se

Re: [Maria-discuss] New server, switch to MariaDB, different versions

2013-04-27 Thread Tanstaafl
On 2013-04-27 4:25 PM, Elena Stepanova wrote: Hi, On 4/27/2013 10:54 PM, Tanstaafl wrote: Hello, My current (8 yr old bare metal) server is currently running mysql 5.1.62, with just a couple of very small databases: postfixadmin and roundcube I am setting up a shiny new virtualized (ESXi

[Maria-discuss] New server, switch to MariaDB, different versions

2013-04-27 Thread Tanstaafl
Hello, My current (8 yr old bare metal) server is currently running mysql 5.1.62, with just a couple of very small databases: postfixadmin and roundcube I am setting up a shiny new virtualized (ESXi host) server, that now has MariaDB 5.5.30 on it... My question is, can I do a dump from my