Monday, October 10, 2016

mysql default current_timestamp error

The DEFAULT CURRENT_TIMESTAMP support for a DATETIME (datatype) was added in MySQL 5.6.

It is now possible to achieve this with DATETIME fields since MySQL 5.6.5

Previous versions can't do that with DATETIME.But you can do it with TIMESTAMP.


Upgrade your mysql with this version and you will not get this error again.

Ubuntu : apt-get upgrade : ubuntu The following packages have been kept back

Solution :

To solve this issue, Run command :

sudo apt-get dist-upgrade

Ubuntu 16.04 - Enable ssh root login

Steps :

a) Edit file /etc/ssh/sshd_config
sudo nano /etc/ssh/sshd_config

b) Change following attribute.
FROM:
PermitRootLogin prohibit-password
TO:
PermitRootLogin yes


c) sudo service ssh restart

gitlab large size files push issue

error: RPC failed; result=22, HTTP code = 413
fatal: The remote end hung up unexpectedly, gitlab large file size push issue

Steps :

1) Upgrade gitlab with latest version. Right now current version is 8.12.4

2) Increase file size in /etc/gitlab/gitlab.rb under nginx section.
  nginx['enable'] = true
  nginx['client_max_body_size'] = '250m'


3) Increase max attachment size in http://gitlab.domain/admin/application_settings


4) Reconfigure gitlab and restart system.