[rt-users] Enabling full text index, getting "MySQL server has gone away"

2016-11-14 Thread Alex Hall
Hi all, As the subject says, I'm trying to enable full text indexing. I've updated MySQL to 5.7 (on Debian 8) and ran /opt/rt4/sbin/rt-setup-fulltext-index --dba root --dba-password pwd However, I get a bunch of warnings about executing the SQL statements and, after that, that attachments can't b

Re: [rt-users] Enabling full text index, getting "MySQL server has gone away"

2016-11-14 Thread Alex Hall
I should also say that I've already tried setting my MySQL max_packet_size. 500M didn't do it, so I upped it to 5000M, restarting the service both times. That hasn't changed the warnings I'm getting, and I really don't think any attachments are over 5GB. Plus, the first few warnings are that "st ex

Re: [rt-users] Enabling full text index, getting "MySQL server has gone away"

2016-11-14 Thread Martin Wheldon
Hi Alex, I think the mysql configuration be "max_allowed_packet" rather than "max_packet_size". Best Regards Martin On 2016-11-14 13:54, Alex Hall wrote: I should also say that I've already tried setting my MySQL max_packet_size. 500M didn't do it, so I upped it to 5000M, restarting the ser

Re: [rt-users] Enabling full text index, getting "MySQL server has gone away"

2016-11-14 Thread Alex Hall
Thanks for the correction. I hate to say it, but this didn't change the results I'm seeing at all. I just updated /etc/mysql/conf.d/mysql.cnf, restarted MySQL, and ran the full-text index command again. I got the exact same errors as before. On Mon, Nov 14, 2016 at 11:50 AM, Martin Wheldon < mart

Re: [rt-users] Enabling full text index, getting "MySQL server has gone away"

2016-11-14 Thread James Zuelow
: martin.whel...@greenhills-it.co.uk Cc: rt-users Subject: Re: [rt-users] Enabling full text index, getting "MySQL server has gone away" Thanks for the correction. I hate to say it, but this didn't change the results I'm seeing at all. I just updated /etc/mysql/conf.d/mysql.cnf, restarted

Re: [rt-users] Enabling full text index, getting "MySQL server has gone away"

2016-11-14 Thread Alex Hall
> James > > > > *From:* rt-users [mailto:rt-users-boun...@lists.bestpractical.com] *On > Behalf Of *Alex Hall > *Sent:* Monday, November 14, 2016 7:57 AM > *To:* martin.whel...@greenhills-it.co.uk > *Cc:* rt-users > *Subject:* Re: [rt-users] Enabling full text index, getting &qu

Re: [rt-users] Enabling full text index, getting "MySQL server has gone away"

2016-11-14 Thread James Zuelow
, November 14, 2016 1:33 PM To: James Zuelow Cc: martin.whel...@greenhills-it.co.uk; rt-users Subject: Re: [rt-users] Enabling full text index, getting "MySQL server has gone away" For future readers, my own solution was--thankfully--much simpler. Nowhere that I found in the docs I was read