[Vtigercrm-developers] vtiger 5.4 and MySQL user Privileges

[polanskiman]

Hello,

I have 2 questions:

1 - I have installed 2 instances of vtiger 5.4 and 1 instance of vtiger 6.
Each instance works with its own database. Access to each database goes
through 3 different DB users (see below). So, for the sake of god, can
someone explain me why each time I log into one instance of vtiger 5.4 it
logs me out of the other vtiger 5.4 instance and vice-versa. Same thing goes
with vtiger 6 except that it only logs me out one time from the other
instance of vtiger 5.4, then it does happen anymore. Below the
*config.inc.php* code of each instance:

Vitger 5.4 instance 1

> $dbconfig['db_server'] = 'localhost';
> $dbconfig['db_port'] = ':3306';
> $dbconfig['db_username'] = 'adminA';
> $dbconfig['db_password'] = '12345';
> $dbconfig['db_name'] = 'DB1';
> $dbconfig['db_type'] = 'mysql';
> $dbconfig['db_status'] = 'true';

vtiger 5.4 instance 2

> $dbconfig['db_server'] = 'localhost';
> $dbconfig['db_port'] = ':3306';
> $dbconfig['db_username'] = 'adminB';
> $dbconfig['db_password'] = '12345';
> $dbconfig['db_name'] = 'DB2';
> $dbconfig['db_type'] = 'mysql';
> $dbconfig['db_status'] = 'true';

vtiger 6

> $dbconfig['db_server'] = 'localhost';
> $dbconfig['db_port'] = ':3306';
> $dbconfig['db_username'] = 'adminC';
> $dbconfig['db_password'] = '12345';
> $dbconfig['db_name'] = 'DB3';
> $dbconfig['db_type'] = 'mysql';
> $dbconfig['db_status'] = 'true';


2 - Since I am a security freak, I have already changed access to the DBs
from /root/ to some other. However, I would like to know what are the
minimum permissions required for vtiger to work properly? Is it safe to deny
all Administration permissions to the DB user while leaving all Data and
Structure permissions?

Thank you.

(note: username/passwords/database names provided above are not the actual
ones).



--
View this message in context: http://vtiger-crm.2324883.n4.nabble.com/vtiger-5-4-and-MySQL-user-Privileges-tp10492.html
Sent from the vtigercrm-developers mailing list archive at Nabble.com.