Common Redmine Installation & Update troubles
Since both Redmine and Easy Redmine are Open Source and are more or less platform independent, some installation & upgrade problems may occur due to various server configurations, software versions or plugins installed. We work hard to track those most common in order to help you with troubleshooting.
You have an error in your SQL syntax
During application update an error message containing "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ..." appears in the log.
Cause
It means your database is outdated and it can't work with the request our application sends to it. It just doesn't understand it.
Solution
You need to update your database.
How to update the database?
Detailed description in the Knowledge base.
Internal error containing "Permission denied"
You have installed or updated Easy Redmine under user with insufficient permissions, not following our strong recommendation in the instructions (at least once in the past).
- Correct permissions by commands chgrp and chown according to server settings (eg. chgrp -R www-data public_html)
- Run installation again bundle exec rake easyproject:install RAILS_ENV=production which will clear cache (if you run it by root, it will not be succesful)
- Restart server
If you are using virtual machine provided by Easy Software, run under user easy:
sudo chown -R easy /home/easy/current
(in older machines - sudo chown -R easy /srv/easyredmine/public_html)
sudo chgrp -R easy /home/easy/current
(in older machines - sudo chgrp -R easy /srv/easyredmine/public_html)
cd /home/easy/current
(in older machines - cd /srv/easyredmine/public_html)
bundle exec rake easyproject:install RAILS_ENV=production
sudo service unicorn restart
Remember to set the permissions for all necessary folders.
I run into 500 error (internal error). What should I do?
Here are some hints what you can do if you run into 500 error.
- run Easy server requirements check and try to repair failed validations
- back-up your database
- download the latest package from the Client Zone
- make sure that webserver has Full access public, files, log, tmp folders
- run bundle install --without development test
- run bundle exec rake easyproject:install RAILS_ENV=production
- restart application server
- delete any 3rd parties' Redmine plugins (also from database)
- write us on This email address is being protected from spambots. You need JavaScript enabled to view it. and attach log/production.log
My Easy Redmine shows 502 Bad Gateway
There are many possible causes of this error. Here are a few tips:
- browser cache problem - try deleting cache from the browser
- dns problem
- server setting problem
First check your connection and network (verify that server is reachable by using a ping command or traceroute command). Firewall server side.
If all above seems fine, try to get some information from nginx error.logs. Check nginx error.log at the server side - /var/log/nginx/error.log
Double check that your nginx configuration matches the standard. Standard nginx configuration can be found here:
https://www.redmine.org/projects/redmine/wiki/HowTo_configure_Nginx_to_run_Redmine
Example of an nginx configuration (as is used by Easy Software). It's quite similar to official one only few variables are optimized:
user www-data;
worker_processes 8;
worker_rlimit_nofile 60000;
error_log /var/log/nginx/error.log;
pid /var/run/nginx.pid;
events {
worker_connections 10240;
# multi_accept on;
}
http {
ssl_protocols TLSv1 TLSv1.1 TLSv1.2; # dont use SSLv3 ref: POODLE
include /etc/nginx/mime.types;
default_type application/octet-stream;
server_names_hash_bucket_size 2048;
access_log /var/log/nginx/access.log;
sendfile on;
#tcp_nopush on;
#keepalive_timeout 0;
keepalive_timeout 65;
tcp_nodelay on;
send_timeout 1800;
client_body_timeout 1800;
client_header_timeout 1800;
proxy_read_timeout 1800;
client_max_body_size 220m;
fastcgi_buffer_size 64K;
fastcgi_buffers 128 16k;
proxy_max_temp_file_size 0;
types_hash_max_size 4096;
types_hash_bucket_size 128;
proxy_busy_buffers_size 256k;
proxy_buffers 8 256k;
proxy_buffer_size 256k;
gzip on;
gzip_disable "MSIE [1-6]\.(?!.*SV1)";
include /etc/nginx/conf.d/*.conf;
include /etc/nginx/sites-enabled/*;
include /etc/nginx/sites-auto/*;
}
Other possible causes of 502 error include...
Unicorn is not running at all, due to
- Insufficient permissions
- Wrong version of passenger
- Wrong Ruby version
- Missing gems
- Broken filesystem
To find out the exact problem, you need to check error logs in unicorn or apache + application log from Easy Redmine (log/production.log)
Timeout
If low timeout is configured, this error will appear on:
- large exports
- overload of server
- rake tasks run from the GUI
Limit of MySQL connections
Make sure you have a sufficient number of connections allowed to MySQL. It depends on the number of users, but you should have at least a 100 allowed.
[!] There was an error parsing `Gemfile`:
This error occurs from version 2018 1.2 (platform 04.00 and higher)
Error during upgrade installation containg some of the following.
[!] There was an error parsing `Gemfile`:
[!] There was an error parsing `Gemfile`: cannot load such file --
# plugin 'rys-bundler', github: 'easysoftware/rys-bundler', branch: 'master' > Plugin.hook('rys-gemfile', self)
Bundler cannot continue.
It is caused by outdated version of redmine installer.
Solution:
Before installing the upgrade
$ gem install redmine-installer
Icons are missing throughout the system
This problems occurs when you use a suffix on your Easy Redmine URL, for example: https://company.com/easyredmine/
In this case, you need to make sure that you have the variable RAILS_RELATIVE_URL_ROOT configured to your correct suffix /easyredmine
Bitnami:
- Create an additional configuration file config/additional_environment.rb
- config.action_controller.relative_url_root = "/easyredmine"
- then precompile assets (rake easyproject:install RAILS_ENV=production) and restart the server
Printing templates do not work
Make sure wkhtmltopdf is installed and running ( wkhtmltopdf needs X server or other emulation)
Test it using: "wkhtmltopdf google.com google.pdf"
Application uses SSL, but some content uses insecure URLs
Add to your proxy configuration:
proxy_set_header X-Forwarded-Proto https
Cron not working - Helpdesk emails, Alerts, repeating tasks, etc. are not automatically processed
Check cron configuration. It is very important that rake tasks are NOT run by root. It will cause failure due to insufficient permissions.
Let's say you are running Easy Redmine under user easy. The commands are:
View active crons crontab -u easy -l
Editing crontab -u easy -e
Apply changes sudo service cron reload
Example for running cron every 5 minutes:
*/5 * * * * /home/easy/scripts/easy_scheduler.sh &> /dev/null
#!/bin/bash -l
LOG_FILE="/home/easy/current/log/easy_scheduler_rake.log"
echo "$(date '+%Y-%m-%d %H:%M:%S') start rake" >> ${LOG_FILE}
cd /home/easy/current && bundle exec rake easyproject:scheduler:run_tasks RAILS_ENV=production >> ${LOG_FILE}
echo "$(date '+%Y-%m-%d %H:%M:%S') end rake" >> ${LOG_FILE}
/home/easy/scripts/easy_scheduler.sh has to be an executable:
sudo chmod +x /home/easy/scripts/easy_scheduler.sh
Don't hesitate to search the internet for a more precise manual to set up cron on your server. It is not an exclusively Easy Redmine required function.
ExecJS::RuntimeError - Updating Easy Redmine on Windows
When you are updating Easy Redmine on Windows platform and hit on error message ExecJs ::RuntimeError
All you have to do is install NODEJS on your system for the proper update.
Easy Redmine 10 upgrade
Top plugins & features
New & mobile design
Server upgrades
Global cloud