Vertica.log file is not rotating 2

helpmepro1

/home/dbadmin/DBbursa/v_DB_node0001_catalog/vertica.log
the log is not rotating because log rotate expects username owner to be root root

of file

/opt/vertica/config/logrotate/total/DB
and it is dbadmin verticadba 

Daniel_Leybovic

Hi Shimon!

Can you post your installation flags? You can extract it from /opt/vertica/config/admintools.conf

helpmepro1

Welcome to Ubuntu 14.04 LTS (GNU/Linux 3.11.0-12-generic x86_64) ~# cat /opt/vertica/config/admintools.conf [Configuration] last_port = 5433 default_base = /home/dbadmin format = 3 install_opts = --hosts '123.123.123.123' '--failure-threshold=FAIL' -S default spreadlog = False controlsubnet = default controlmode = broadcast [Cluster] hosts = 123.123.123.123 [Nodes] node0001 = 123.123.123.123,/home/dbadmin,/home/dbadminv_mydb_node0001 = 123.123.123.123,/home/dbadmin,/home/dbadmin v_mydb_node0002 = 123.123.123.123,/home/dbadmin,/home/dbadmin v_mydb_node0003 = 123.123.123.123,/home/dbadmin,/home/dbadmin v_frienddb_node0001 = 123.123.123.123,/home/dbadmin,/home/dbadmin v_default_node0001 = 123.123.123.123,/home/dbadmin,/home/dbadmin v_default_node0002 = 123.123.123.123,/home/dbadmin,/home/dbadmin v_test_node0001 = 123.123.123.123,/home/dbadmin,/home/dbadmin v_mydb_node0004 = 123.123.123.123,/home/dbadmin,/home/dbadmin v_myappdb_node0001 = 123.123.123.123,/home/dbadmin,/home/dbadmin [Database:frienddb] restartpolicy = ksafe port = 5433 path = /home/dbadmin/frienddb nodes = v_frienddb_node0001 [Database:myappdb] restartpolicy = ksafe port = 5433 path = /home/dbadmin/myappdb/v_myappdb_node0001_catalog nodes = v_myappdb_node0001

Daniel_Leybovic

Hi!

It do not match, to config.

/home/dbadmin/DBbursa/v_DB_node0001_catalog/vertica.log

means that name of database is DB, while you posted config for frienddb and myappdb

helpmepro1

no i changed names if you can remove that DBbursa from all comments and thus comment

helpmepro1

after changing the owner it works for me , i just report a bug to you

Daniel_Leybovic

Hi!

Thanks, but looks like you are an enterprise user (4 nodes ), so a best way its to open a ticket or send an e-mail to Vertica support.

About your "bug":
1. I did a lot of installations and no problems with log rotation. There are problems sometimes(while its not clear in docs) with user permissions when you defines a db super user and/or os user already exists. But you modified your output so I can't be sure that you didn't modified your install options too and so can say where is a problem.
An example of permissions problem:
https://community.vertica.com/vertica/topics/tz


2. Ubuntu 14.04 isn't supported, so be careful, you actually have no support.
https://my.vertica.com/docs/7.0.x/HTML/index.htm#Authoring/SupportedPlatforms/MCandServer.htm%3FTocP...

PS
I asked only install options - to verify a problem with permissions and I don't care about ips, and so on, only db super user, group, password, etc.

Ubuntu 14.04 require threshold HALT

daniel@xps:~$ lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 14.04 LTS
Release: 14.04
Codename: trusty

daniel@xps:~$ grep install  /opt/vertica/config/admintools.conf
install_opts = --hosts '127.0.0.1' --dba-user daniel --dba-group daniel --data-dir /vertica --clean --license CE --accept-eula --failure-threshold HALT