December 11, 20232 yr It'd be nice to have the image updated, esp now that docs supports dark mode, assuming you've the time available 👍
January 8, 20242 yr Hi all, I need some help. 1. Installing the onlyoffice-mysql-server I successfull installed the onlyoffice-mysql-server Docker without a static IP. Also changed the Passwords. Here are my logs. 2024-01-08T09:23:48.833342Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2024-01-08T09:23:48.833375Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set. 2024-01-08T09:23:49.013707Z 0 [Warning] InnoDB: New log files created, LSN=45790 2024-01-08T09:23:49.056672Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. 2024-01-08T09:23:49.120006Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: a16acf3c-ae07-11ee-9ada-0242ac130002. 2024-01-08T09:23:49.124798Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2024-01-08T09:23:49.515176Z 0 [Warning] CA certificate ca.pem is self signed. 2024-01-08T09:23:49.617879Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. 2024-01-08T09:23:53.144788Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2024-01-08T09:23:53.144836Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set. 2024-01-08T09:23:53.145938Z 0 [Note] mysqld (mysqld 5.7.28) starting as process 83 ... 2024-01-08T09:23:53.149085Z 0 [Note] InnoDB: PUNCH HOLE support available 2024-01-08T09:23:53.149164Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2024-01-08T09:23:53.149189Z 0 [Note] InnoDB: Uses event mutexes 2024-01-08T09:23:53.149251Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2024-01-08T09:23:53.149276Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2024-01-08T09:23:53.149341Z 0 [Note] InnoDB: Using Linux native AIO 2024-01-08T09:23:53.149830Z 0 [Note] InnoDB: Number of pools: 1 2024-01-08T09:23:53.149941Z 0 [Note] InnoDB: Using CPU crc32 instructions 2024-01-08T09:23:53.151152Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2024-01-08T09:23:53.156991Z 0 [Note] InnoDB: Completed initialization of buffer pool 2024-01-08T09:23:53.158653Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2024-01-08T09:23:53.172924Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2024-01-08T09:23:53.194793Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2024-01-08T09:23:53.194969Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2024-01-08T09:23:53.210747Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2024-01-08T09:23:53.212602Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2024-01-08T09:23:53.212676Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2024-01-08T09:23:53.213014Z 0 [Note] InnoDB: 5.7.28 started; log sequence number 2628227 2024-01-08T09:23:53.213268Z 0 [Note] Plugin 'FEDERATED' is disabled. 2024-01-08T09:23:53.213490Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2024-01-08T09:23:53.217152Z 0 [Note] InnoDB: Buffer pool(s) load completed at 240108 10:23:53 2024-01-08T09:23:53.219509Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2024-01-08T09:23:53.219541Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2024-01-08T09:23:53.220343Z 0 [Warning] CA certificate ca.pem is self signed. 2024-01-08T09:23:53.220439Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2024-01-08T09:23:53.226174Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory. 2024-01-08T09:23:53.266981Z 0 [Note] Event Scheduler: Loaded 0 events 2024-01-08T09:23:53.267218Z 0 [Note] mysqld: ready for connections. Version: '5.7.28' socket: '/var/run/mysqld/mysqld.sock' port: 0 MySQL Community Server (GPL) 2024-01-08T09:23:55.183821Z 0 [Note] Giving 0 client threads a chance to die gracefully 2024-01-08T09:23:55.183888Z 0 [Note] Shutting down slave threads 2024-01-08T09:23:55.183921Z 0 [Note] Forcefully disconnecting 0 remaining clients 2024-01-08T09:23:55.183954Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2024-01-08T09:23:55.184013Z 0 [Note] Binlog end 2024-01-08T09:23:55.184803Z 0 [Note] Shutting down plugin 'ngram' 2024-01-08T09:23:55.184838Z 0 [Note] Shutting down plugin 'partition' 2024-01-08T09:23:55.184873Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2024-01-08T09:23:55.184906Z 0 [Note] Shutting down plugin 'ARCHIVE' 2024-01-08T09:23:55.184940Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2024-01-08T09:23:55.184988Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2024-01-08T09:23:55.185017Z 0 [Note] Shutting down plugin 'MyISAM' 2024-01-08T09:23:55.185047Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2024-01-08T09:23:55.185075Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2024-01-08T09:23:55.185106Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2024-01-08T09:23:55.185132Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2024-01-08T09:23:55.185160Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2024-01-08T09:23:55.185184Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2024-01-08T09:23:55.185211Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2024-01-08T09:23:55.185241Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2024-01-08T09:23:55.185265Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2024-01-08T09:23:55.185293Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2024-01-08T09:23:55.185316Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2024-01-08T09:23:55.185344Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2024-01-08T09:23:55.185376Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2024-01-08T09:23:55.185402Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2024-01-08T09:23:55.185430Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2024-01-08T09:23:55.185454Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2024-01-08T09:23:55.185480Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2024-01-08T09:23:55.185509Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2024-01-08T09:23:55.185534Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2024-01-08T09:23:55.185562Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2024-01-08T09:23:55.185586Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2024-01-08T09:23:55.185613Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2024-01-08T09:23:55.185643Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2024-01-08T09:23:55.185669Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2024-01-08T09:23:55.185698Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2024-01-08T09:23:55.185721Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2024-01-08T09:23:55.185747Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2024-01-08T09:23:55.185777Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2024-01-08T09:23:55.185803Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2024-01-08T09:23:55.185830Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2024-01-08T09:23:55.185854Z 0 [Note] Shutting down plugin 'InnoDB' 2024-01-08T09:23:55.185917Z 0 [Note] InnoDB: FTS optimize thread exiting. 2024-01-08T09:23:55.185994Z 0 [Note] InnoDB: Starting shutdown... 2024-01-08T09:23:55.286608Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2024-01-08T09:23:55.287511Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 240108 10:23:55 2024-01-08T09:23:57.018045Z 0 [Note] InnoDB: Shutdown completed; log sequence number 12440250 2024-01-08T09:23:57.020621Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2024-01-08T09:23:57.020721Z 0 [Note] Shutting down plugin 'MEMORY' 2024-01-08T09:23:57.020846Z 0 [Note] Shutting down plugin 'CSV' 2024-01-08T09:23:57.021081Z 0 [Note] Shutting down plugin 'sha256_password' 2024-01-08T09:23:57.021362Z 0 [Note] Shutting down plugin 'mysql_native_password' 2024-01-08T09:23:57.021610Z 0 [Note] Shutting down plugin 'binlog' 2024-01-08T09:23:57.022236Z 0 [Note] mysqld: Shutdown complete 2024-01-08T09:23:57.334998Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2024-01-08T09:23:57.335045Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set. 2024-01-08T09:23:57.336429Z 0 [Note] mysqld (mysqld 5.7.28) starting as process 1 ... 2024-01-08T09:23:57.340331Z 0 [Note] InnoDB: PUNCH HOLE support available 2024-01-08T09:23:57.340424Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2024-01-08T09:23:57.340532Z 0 [Note] InnoDB: Uses event mutexes 2024-01-08T09:23:57.340574Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2024-01-08T09:23:57.340684Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2024-01-08T09:23:57.340755Z 0 [Note] InnoDB: Using Linux native AIO 2024-01-08T09:23:57.341263Z 0 [Note] InnoDB: Number of pools: 1 2024-01-08T09:23:57.341455Z 0 [Note] InnoDB: Using CPU crc32 instructions 2024-01-08T09:23:57.342707Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2024-01-08T09:23:57.347793Z 0 [Note] InnoDB: Completed initialization of buffer pool 2024-01-08T09:23:57.349406Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2024-01-08T09:23:57.367959Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2024-01-08T09:23:57.397850Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2024-01-08T09:23:57.398070Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2024-01-08T09:23:57.412688Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2024-01-08T09:23:57.414420Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2024-01-08T09:23:57.414504Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2024-01-08T09:23:57.414916Z 0 [Note] InnoDB: 5.7.28 started; log sequence number 12440250 2024-01-08T09:23:57.415187Z 0 [Note] Plugin 'FEDERATED' is disabled. 2024-01-08T09:23:57.415468Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2024-01-08T09:23:57.422019Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2024-01-08T09:23:57.422054Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2024-01-08T09:23:57.422917Z 0 [Warning] CA certificate ca.pem is self signed. 2024-01-08T09:23:57.423014Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2024-01-08T09:23:57.423504Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2024-01-08T09:23:57.423545Z 0 [Note] InnoDB: Buffer pool(s) load completed at 240108 10:23:57 2024-01-08T09:23:57.423547Z 0 [Note] IPv6 is available. 2024-01-08T09:23:57.423617Z 0 [Note] - '::' resolves to '::'; 2024-01-08T09:23:57.423653Z 0 [Note] Server socket created on IP: '::'. 2024-01-08T09:23:57.429274Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory. 2024-01-08T09:23:57.470997Z 0 [Note] Event Scheduler: Loaded 0 events 2024-01-08T09:23:57.471235Z 0 [Note] mysqld: ready for connections. Version: '5.7.28' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL) 2024-01-08T09:24:24.369648Z 2 [Warning] IP address '172.19.0.1' could not be resolved: Name or service not known There are some Warnings, but the DB is there and also all Users are created. Looks good for me. Login via PHPMyAdmin with the root user is also possible. 2. onlyoffice-mail-server I used the Docker with the Default settings. Just changed the Root Password for mail_admin and under advanced Settings "Extra Parameters" -> -h mail.example.de -p 25:25 -p 465:465 -p 143:143 -p 993:993 -p 110:110 -p 995:995 -p 587:587 -p 8081:8081 -p 4190:4190 The SQL DB Log got this extra line -> 2024-01-08T09:40:03.911887Z 32 [Note] Access denied for user 'mail_admin'@'onlyoffice-mail-server.onlyoffice' (using password: NO) But the DB onlyoffice_mailserver is created and has a lot of tables. I am also able to Login via PHPMyAdmin with the User mail_admin. These are the onlyoffice-mail-server.log (right click on the Docker) ******************************************************************** * Start iRedMail Configurations ******************************************************************** [ INFO ] Create required system accounts: vmail, iredapd. [ INFO ] Configure Apache web server and PHP. [ INFO ] Configure PHP. [ INFO ] Configure MySQL database server. [ INFO ] Configure Postfix (Message Transfer Agent). [ INFO ] Configure Cluebringer (postfix policy server). [ INFO ] Configure Dovecot (pop3/imap/managesieve server). [ INFO ] Configure ClamAV (anti-virus toolkit). [ INFO ] Configure Amavisd-new (interface between MTA and content checkers). [ INFO ] Configure SpamAssassin (content-based spam filter). [ INFO ] Configure OpenDkim. [ INFO ] Configure Fail2ban (authentication failure monitor). [ INFO ] Configure Server API. rake aborted! Psych::SyntaxError: (<unknown>): did not find expected key while parsing a block mapping at line 2 column 2 /var/www/html/mailserver_api-2.0.1/config/application.rb:11:in `<top (required)>' /var/www/html/mailserver_api-2.0.1/config/environment.rb:3:in `<top (required)>' /var/www/html/mailserver_api-2.0.1/Rakefile:2:in `block in <top (required)>' Tasks: TOP => api_key:generate => environment (See full trace by running task with --trace) [ INFO ] Configure SpamTrainer. [ INFO ] Configure Awstats (logfile analyzer for mail and web server). [ INFO ] Create self-signed SSL certification files (2048 bits). [ INFO ] Generate a strong, unique Diffie Hellman Group with openssl, please wait. ************************************************************************* * iRedMail-0.9.2 installation and configuration complete. ************************************************************************* [ INFO ] Disable SELinux in /etc/selinux/config. [ INFO ] Removing package(s): sendmail Loaded plugins: fastestmirror, ovl Setting up Remove Process Resolving Dependencies --> Running transaction check ---> Package sendmail.x86_64 0:8.14.4-9.el6_8.1 will be erased --> Processing Dependency: sendmail = 8.14.4-9.el6_8.1 for package: sendmail-devel-8.14.4-9.el6_8.1.x86_64 --> Running transaction check ---> Package sendmail-devel.x86_64 0:8.14.4-9.el6_8.1 will be erased --> Finished Dependency Resolution Dependencies Resolved ================================================================================ Package Arch Version Repository Size ================================================================================ Removing: sendmail x86_64 8.14.4-9.el6_8.1 @base 1.5 M Removing for dependencies: sendmail-devel x86_64 8.14.4-9.el6_8.1 @base 254 k Transaction Summary ================================================================================ Remove 2 Package(s) Installed size: 1.8 M Downloading Packages: Running rpm_check_debug Running Transaction Test Transaction Test Succeeded Running Transaction Warning: RPMDB altered outside of yum. Erasing : sendmail-devel-8.14.4-9.el6_8.1.x86_64 1/2 Erasing : sendmail-8.14.4-9.el6_8.1.x86_64 2/2 warning: erase unlink of /var/log/mail/statistics failed: No such file or directory warning: erase unlink of /var/log/mail failed: No such file or directory Verifying : sendmail-devel-8.14.4-9.el6_8.1.x86_64 1/2 Verifying : sendmail-8.14.4-9.el6_8.1.x86_64 2/2 Removed: sendmail.x86_64 0:8.14.4-9.el6_8.1 Dependency Removed: sendmail-devel.x86_64 0:8.14.4-9.el6_8.1 Complete! [ INFO ] Copy firewall sample rules: /etc/sysconfig/iptables. [ INFO ] Restarting firewall ... [ INFO ] Copy MySQL sample file: /etc/my.cnf. [ INFO ] Enable SSL support for MySQL server. ******************************************************************** * First mail account credential: * * o Username: [email protected] * o Password: ZmMyZGM1ZTgz * * ******************************************************************** * Congratulations, mail server setup completed successfully. Please * read below file for more information: * * - /usr/src/iRedMail/iRedMail.tips * * And it's sent to your mail account [email protected]. * ********************* WARNING ************************************** dig: couldn't get address for 'resolver1.opendns.com': failure dig: couldn't get address for 'resolver1.opendns.com': failure Waiting for external MySql response I have closed the log and reopened it. Those two "dig: couldn't get address for 'resolver1.opendns.com': failure" are gone. I also tried to verify the correctness of the settings for the records. dig -t A mail.example.de dig -t CNAME mail.example.de First I tried with the A Record: Type: A Name: mail.example.de Value: MyPublicIP TTL: 86400 After that I also tried it with a CNAME (A Record to example.de exists) Type: CNAME Name: mail Value: example.de. TTL: 86400 I also have a MX Record for both tests Type: MX Name: @ Value: mail.example.de TTL: 86400 Piority: 0 But nothing is working. I also opened all TCP Ports in my Fritz.Box. Did I missed a Port? 80 HTTP-Server 443 HTTPS-Server 25 SMTP 143 IMAP STARTTLS 465 SMTPS 587 SMTP STARTTLS 993 IMAPS 995 POP3S 110 POP3 sh-4.1# dig -t CNAME mail.example.de ; <<>> DiG 9.8.2rc1-RedHat-9.8.2-0.68.rc1.el6_10.3 <<>> -t CNAME mail.example.de ;; global options: +cmd ;; connection timed out; no servers could be reached sh-4.1# dig -t A mail.example.de ; <<>> DiG 9.8.2rc1-RedHat-9.8.2-0.68.rc1.el6_10.3 <<>> -t A mail.example.de ;; global options: +cmd ;; connection timed out; no servers could be reached sh-4.1# Interesting is also -> I restarted the onlyoffice-mail-server and it will just stopp after some seconds. ********************* WARNING ************************************** Waiting for external MySql response [ INFO ] Checking configuration file: /usr/src/iRedMail/config ... [FOUND] [ INFO ] Import installation process status from file: /usr/src/iRedMail/runtime/install.status. Waiting for external MySql response < SKIP > Function: install_all. ******************************************************************** * Start iRedMail Configurations ******************************************************************** < SKIP > Function: add_required_users. < SKIP > Function: web_server_config. [ INFO ] Configure MySQL database server. < SKIP > Function: mysql_import_vmail_users. < SKIP > Function: postfix_config_basic. < SKIP > Function: postfix_config_virtual_host. < SKIP > Function: postfix_config_sasl. < SKIP > Function: postfix_config_tls. < SKIP > Function: policy_server_config. < SKIP > Function: enable_dovecot. < SKIP > Function: clamav_config. < SKIP > Function: amavisd_config_rhel. < SKIP > Function: amavisd_config_general. < SKIP > Function: amavisd_import_sql. < SKIP > Function: sa_config. < SKIP > Function: opendkim_config. < SKIP > Function: fail2ban_config. < SKIP > Function: server_api_config. < SKIP > Function: spam_trainer_config. < SKIP > Function: awstats_config_basic. < SKIP > Function: awstats_config_weblog. < SKIP > Function: awstats_config_maillog. < SKIP > Function: awstats_config_crontab. < SKIP > Function: cleanup. Waiting for external MySql response [ INFO ] Configure MySQL database server. Starting crond: [ OK ] Starting Dovecot Imap: [ OK ] Starting system logger: [ OK ] Starting amavisd: [ OK ] Starting postfix: [ OK ] Starting cbpolicyd: [ OK ] Starting Clam AntiVirus Daemon: [ OK ] Starting clamd.amavisd: [ OK ] Starting httpd: [ OK ] Starting OpenDKIM Milter: [ OK ] Starting spamd: [ OK ] Starting fail2ban: [ OK ] Starting server ** Press ANY KEY to close this window ** Looks like the Docker is waiting for the SQL response from external? I did not installed onlyoffice-document-server and onlyoffice-community-server, yet. Does anyone have any ideas? Thanks!
May 15, 20242 yr how do i get the onlyoffice secret? i read the instructions, did i just overlook it?
July 13, 20241 yr Hi all, I am trying to install additional fonts in my onlyoffice / nextcloud. However I can't see how to do this. Openoffice has a directory /appdata/onlyofficeds/fonts/ but I can't write to it. Thank you.
July 22, 20241 yr I keep trying to get this to work, I've followed the steps multiple times and I always get stuck at the same place. This is the log I get on the document server. * Reloading nginx configuration nginx ...done. ==> /var/log/onlyoffice/documentserver/converter/err.log <== ==> /var/log/onlyoffice/documentserver/converter/out.log <== [2024-07-22T21:59:27.103] [WARN] nodeJS - update cluster with 1 workers [2024-07-22T22:00:17.695] [WARN] nodeJS - update cluster with 1 workers [2024-07-22T22:00:17.705] [WARN] nodeJS - worker 1038 started. [2024-07-22T22:00:17.708] [WARN] nodeJS - update cluster with 1 workers [2024-07-22T22:07:26.859] [WARN] nodeJS - update cluster with 1 workers [2024-07-22T22:07:26.870] [WARN] nodeJS - worker 932 started. [2024-07-22T22:07:26.873] [WARN] nodeJS - update cluster with 1 workers [2024-07-22T22:09:12.219] [WARN] nodeJS - update cluster with 1 workers [2024-07-22T22:09:12.231] [WARN] nodeJS - worker 1118 started. [2024-07-22T22:09:12.235] [WARN] nodeJS - update cluster with 1 workers ==> /var/log/onlyoffice/documentserver/docservice/err.log <== ==> /var/log/onlyoffice/documentserver/docservice/out.log <== [2024-07-22T21:59:31.042] [WARN] nodeJS - Express server listening on port 8000 in production-linux mode. Version: 6.4.2. Build: 6 [2024-07-22T22:00:16.265] [WARN] nodeJS - Express server starting... [2024-07-22T22:00:16.268] [WARN] nodeJS - Failed to subscribe to plugin folder updates. When changing the list of plugins, you must restart the server. https://nodejs.org/docs/latest/api/fs.html#fs_availability [2024-07-22T22:00:16.384] [WARN] nodeJS - Express server listening on port 8000 in production-linux mode. Version: 6.4.2. Build: 6 [2024-07-22T22:07:27.442] [WARN] nodeJS - Express server starting... [2024-07-22T22:07:27.445] [WARN] nodeJS - Failed to subscribe to plugin folder updates. When changing the list of plugins, you must restart the server. https://nodejs.org/docs/latest/api/fs.html#fs_availability [2024-07-22T22:07:27.559] [WARN] nodeJS - Express server listening on port 8000 in production-linux mode. Version: 6.4.2. Build: 6 [2024-07-22T22:09:11.623] [WARN] nodeJS - Express server starting... [2024-07-22T22:09:11.626] [WARN] nodeJS - Failed to subscribe to plugin folder updates. When changing the list of plugins, you must restart the server. https://nodejs.org/docs/latest/api/fs.html#fs_availability [2024-07-22T22:09:11.742] [WARN] nodeJS - Express server listening on port 8000 in production-linux mode. Version: 6.4.2. Build: 6 ==> /var/log/onlyoffice/documentserver/metrics/err.log <== ==> /var/log/onlyoffice/documentserver/metrics/out.log <== sets: {}, pctThreshold: [ 90 ] } 22 Jul 21:46:59 - [894] reading config file: ./config/config.js 22 Jul 21:46:59 - server is up INFO 22 Jul 21:53:42 - [888] reading config file: ./config/config.js 22 Jul 21:53:42 - server is up INFO 22 Jul 21:59:26 - [862] reading config file: ./config/config.js 22 Jul 21:59:26 - server is up INFO 22 Jul 22:07:26 - [894] reading config file: ./config/config.js 22 Jul 22:07:26 - server is up INFO ==> /var/log/onlyoffice/documentserver/nginx.error.log <== 2024/07/22 20:06:30 [error] 6346#6346: *2 connect() failed (111: Connection refused) while connecting to upstream, client: 192.168.0.70, server: , request: "GET /example/ HTTP/1.1", upstream: "http://127.0.0.1:3000/", host: "192.168.0.110:8082", referrer: "http://192.168.0.110:8082/welcome/" 2024/07/22 20:06:30 [error] 6346#6346: *2 connect() failed (111: Connection refused) while connecting to upstream, client: 192.168.0.70, server: , request: "GET /example/ HTTP/1.1", upstream: "http://127.0.0.1:3000/", host: "192.168.0.110:8082", referrer: "http://192.168.0.110:8082/welcome/" And this is what I get on the community server + sleep 1 + mysqladmin ping -h onlyoffice-mysql-server:3306 -P 3306 -u onlyoffice_user --password=my_password --silent mysqladmin: [Warning] Using a password on the command line interface can be insecure. and finally, here's the log from the mysql. 2024-07-23 00:05:20+02:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.28-1debian9 started. 2024-07-23 00:05:21+02:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql' 2024-07-23 00:05:21+02:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.28-1debian9 started. mysqld: [Warning] World-writable config file '/etc/mysql/conf.d/onlyoffice.cnf' is ignored. 2024-07-22T22:05:21.494387Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2024-07-22T22:05:21.496506Z 0 [Note] mysqld (mysqld 5.7.28) starting as process 1 ... 2024-07-22T22:05:21.501246Z 0 [Note] InnoDB: PUNCH HOLE support available 2024-07-22T22:05:21.501266Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2024-07-22T22:05:21.501271Z 0 [Note] InnoDB: Uses event mutexes 2024-07-22T22:05:21.501276Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2024-07-22T22:05:21.501302Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2024-07-22T22:05:21.501311Z 0 [Note] InnoDB: Using Linux native AIO 2024-07-22T22:05:21.501656Z 0 [Note] InnoDB: Number of pools: 1 2024-07-22T22:05:21.501788Z 0 [Note] InnoDB: Using CPU crc32 instructions 2024-07-22T22:05:21.503679Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2024-07-22T22:05:21.513669Z 0 [Note] InnoDB: Completed initialization of buffer pool 2024-07-22T22:05:21.516334Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2024-07-22T22:05:21.561898Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2024-07-22T22:05:21.805528Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2024-07-22T22:05:21.806019Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2024-07-22T22:05:21.959368Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2024-07-22T22:05:21.963244Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2024-07-22T22:05:21.963254Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2024-07-22T22:05:21.963818Z 0 [Note] InnoDB: 5.7.28 started; log sequence number 143895124 2024-07-22T22:05:21.964111Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2024-07-22T22:05:21.964162Z 0 [Note] Plugin 'FEDERATED' is disabled. 2024-07-22T22:05:21.974556Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2024-07-22T22:05:21.974571Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2024-07-22T22:05:21.975796Z 0 [Warning] CA certificate ca.pem is self signed. 2024-07-22T22:05:21.975928Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2024-07-22T22:05:22.021384Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2024-07-22T22:05:22.021427Z 0 [Note] IPv6 is available. 2024-07-22T22:05:22.021445Z 0 [Note] - '::' resolves to '::'; 2024-07-22T22:05:22.021467Z 0 [Note] Server socket created on IP: '::'. 2024-07-22T22:05:22.091772Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory. 2024-07-22T22:05:22.223834Z 0 [Note] InnoDB: Buffer pool(s) load completed at 240723 0:05:22 2024-07-22T22:05:22.419605Z 0 [Note] Event Scheduler: Loaded 0 events 2024-07-22T22:05:22.420070Z 0 [Note] mysqld: ready for connections. Version: '5.7.28' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL)
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.