Kopano core for ubuntu 20.04

fbartels

@hodor27 for master we are already building these packages, but they have simply not been uploaded because the release chain is failing. But be aware that these builds do not come with any guarantees.

cbnidk

Hi

I have now tried to install kopano on ubuntu 20.04
with core - webapp from 15-05-2020
https://download.kopano.io/community/core%3A/core-10.0.4.79.5a95f51-Ubuntu_20.04-amd64.tar.gz
https://download.kopano.io/community/webapp%3A/webapp-4.0.2740%2B1614.1.ff6dfb6-Ubuntu_20.04-all.tar.gz
and I only have one problem with kopani.ini file it is not the right place
it is in /etc/php5/mods-available I have moved it to the rigth place and
it worked now mapi is loaded

Claus

cbnidk

@cbnidk said in Kopano core for ubuntu 20.04:

Hi

I have now tried to install kopano on ubuntu 20.04
with core - webapp from 15-05-2020
https://download.kopano.io/community/core%3A/core-10.0.4.79.5a95f51-Ubuntu_20.04-amd64.tar.gz
https://download.kopano.io/community/webapp%3A/webapp-4.0.2740%2B1614.1.ff6dfb6-Ubuntu_20.04-all.tar.gz
and I only have one problem with kopani.ini file it is not the right place
it is in /etc/php5/mods-available I have moved it to the rigth place and
it worked now mapi is loaded
but now my phpmyadmin don’t work I get this error
[Fri May 15 18:28:16.724280 2020] [php7:warn] [pid 2625] [client 192.168.1.2:63294] PHP Warning: require_once(PhpMyAdmin/MoTranslator/autoload.php): failed to open stream: No such file or directory in /usr/share/phpmyadmin/autoload.php on line 2
[Fri May 15 18:28:16.724308 2020] [php7:error] [pid 2625] [client 192.168.1.2:63294] PHP Fatal error: require_once(): Failed opening required ‘PhpMyAdmin/MoTranslator/autoload.php’ (include_path=’:/usr/share/kopano/php’) in /usr/share/phpmyadmin/autoload.php on line 2
if mapi don’t loaded phpmyadmin is working
Claus

cbnidk

This post is deleted!

cbnidk

@cbnidk

hi

I have dpkg-reconfigure php7-mapi and uninstall phpmyadmin from ubuntu 20.04
then install phpmyadmin from here
wget https://files.phpmyadmin.net/phpMyAdmin/5.0.2/phpMyAdmin-5.0.2-all-languages.tar.gz
then everything is working for now, both load of php7-mapi and phpmyadmin

Claus

fbartels

@cbnidk said in Kopano core for ubuntu 20.04:

and I only have one problem with kopani.ini file it is not the right place
it is in /etc/php5/mods-available I have moved it to the rigth place and

Thanks for the report. I have created https://jira.kopano.io/browse/KC-1770 so that the packaging can be adjusted.

cbnidk

Hi

When I use kopano-migration-imap on kopano 10.0.4 and ubuntu 20.04
I get this error in sydlog every 1 sek.

] SQL [00044871] result failed: Deadlock found when trying to get lock; try restarting transaction, Query: “SELECT 1 FROM properties WHERE hierarchyid IN(118958) LOCK IN SHARE MODE”

but the tool is working I can move mail from old kopano to new

Claus

fbartels

@cbnidk yes, it will work since the transaction will be retried. But ultimately this means you need to improve your database tuning.

cbnidk

@fbartels said in Kopano core for ubuntu 20.04:

database tuning

hi

can I do this if I am up runing with kopano server it shut be done
bebefore kopano install I have never done that before and I have
runing kopano for some time now?

cb

fbartels

@cbnidk said in Kopano core for ubuntu 20.04:

can I do this if I am up runing with kopano server it shut be done

Some mysql can be applied with a restart, some others may need a dump and restore of the database.

@cbnidk said in Kopano core for ubuntu 20.04:

I have never done that before

Importing data does put a different load on the database than the usual daily usage.

cbnidk

Hi

I have tuned the database with this

innodb_buffer_pool_size = 3GB
innodb_log_file_size = 750M
innodb_log_buffer_size = 32M
max_allowed_packet = 32M
max_connections = kopano (server.cfg) threads(default 8) + thread_limit(default 40) + 9

but I have to # out the last line
max_connections = kopano (server.cfg) threads(default 8) + thread_limit(default 40) + 9
otherwise the copano server will not start
is this line important?
fornow it is # out,

Claus

cbnidk

hi

But it don’t help I have the same error log in syslog when using kopano-migration-imap

Claus

fbartels

@cbnidk said in Kopano core for ubuntu 20.04:

innodb_log_file_size = 750M

I would not set the log file size that high. rather have multiple smaller files.

@cbnidk said in Kopano core for ubuntu 20.04:

max_connections = kopano (server.cfg) threads(default 8) + thread_limit(default 40) + 9
but I have to # out the last line
max_connections = kopano (server.cfg) threads(default 8) + thread_limit(default 40) + 9
otherwise the copano server will not start

Why doesnt it start? What is the error message?

@cbnidk said in Kopano core for ubuntu 20.04:

But it don’t help

Slow disk maybe? Tuning is more than just configuration.

Edit: there are also way more parameters you can tune in MySQL for customers we have a detailed tuning guide that our support can send out.

cbnidk

Hi

how big will be good my old kopano is 134mb but this is default I thing

the error is
2020-05-20T21:22:56.449172: [error ] mysql_real_connect: Too many connections
2020-05-20T21:22:56.449209: [error ] Can’t update the database: MYSQL not initialized
in server.log

Claus

cbnidk

@cbnidk

hi

in my server log I got this one or two time a day

SQL [00020233] info: MySQL server has gone away. Reconnecting.
is there a way to fix this?
mysql config =
innodb_buffer_pool_size = 1600M
innodb_log_file_size = 400M
innodb_log_buffer_size = 100M
max_allowed_packet = 16M
innodb_file_per_table = ON
key_buffer_size = 400M

kopano 10.0.4
ubuntu 20.04

Claus

fbartels

@cbnidk which version as you using exactly. There was recently an issue with stale mysql connections, but that hs been solved meanwhile.

If its just a mysql connection being closed after reaching the connection timeout I would no worry about it.

cbnidk

hi

my ver. is kopano-server_10.0.4.79.bbc9fa6e6-0+91.1_amd64.deb
for ubuntu 20.04

Claus

fbartels

the latest is 10.0.5.2.9bfb891a3-0+102.1.

But is most probably just a connection timeout.

thctlo

You should verify if mysql/mariadb is fully updated.

My upgrade from 18.04 to 20.04 needed some fixing after the upgrade.
apache2 stopped working, mysql stopped working, thinks like that.
it also changed my interface from 0.0.0.0 to 127.0.0.1, i had to correct it manualy again.
check these things.

Which i never have these things in a same setups on Debian itself.
Always problems with Ubuntu and dist upgrades…

cbnidk

Hi

it was a fresh install on 20.04, is it the ip of mysql
or the kopano server you have 0.0.0.0
my kopano server connect to mysql on 127.0.0.1
Claus