Next up: Getting the Twitter addon to work
Bugger! I must have set the cron job wrong?
Well, apart from the fact that:
Enabling SSL kills the site.
It moans "table_open_cache too low (400)" when it's actually set to 2000
#Friendica is back
Enabling SSL kills the site.
It moans "table_open_cache too low (400)" when it's actually set to 2000
#Friendica is back
utzer [Friendica]
in reply to Shredni Vashtar • • •Shredni Vashtar
in reply to utzer [Friendica] • •utzer [Friendica]
in reply to Shredni Vashtar • • •Shredni Vashtar likes this.
Shredni Vashtar
in reply to utzer [Friendica] • •utzer [Friendica]
in reply to Shredni Vashtar • • •Nanook
in reply to Shredni Vashtar • • •Shredni Vashtar
Unknown parent • •It does.
Your table_definition_cache is too low (400).
Shredni Vashtar
in reply to Shredni Vashtar • •MySQL / MariaDB
max_allowed_packet 16777216
utzer [Friendica]
in reply to Shredni Vashtar • • •Shredni Vashtar
in reply to utzer [Friendica] • •You'll be please to know I fixed the table_definition_cache is too low error by doing:
sudo vim /etc/mysql/mariadb.cnf
[mysqld]table_definition_cache = 1500
sudo systemctl restart mysqld
What figure do you suggest for max_allowed_packet?
utzer [Friendica]
in reply to Shredni Vashtar • • •@Peter Cannon for max_allowed_packet is is hard to say, I just checked, for some reason I had it set to 256M, but that is too much. It is, as far as I understand, the maximum size that can sent/written to the database, so based on that, 32M or 64M should be plenty. Just my guess.
I think Steffen know better than I.
Nanook
in reply to utzer [Friendica] • • •utzer [Friendica]
in reply to Nanook • • •Nanook
in reply to utzer [Friendica] • • •utzer [Friendica]
in reply to Nanook • • •Nanook
in reply to utzer [Friendica] • • •utzer [Friendica]
in reply to Nanook • • •Nanook
in reply to utzer [Friendica] • • •Shredni Vashtar
in reply to Shredni Vashtar • •Hows that?
MySQL / MariaDB
max_allowed_packet 67108864
utzer [Friendica]
in reply to Shredni Vashtar • • •Shredni Vashtar likes this.