[Vtigercrm-developers] vtiger 5.4 and MySQL user Privileges

Pabiszczak, Błażej b.pabiszczak at opensaas.pl
Fri May 9 07:22:53 GMT 2014


Because info is saved in sessions, you have (for all vtiger's) this same
folder for sessions.


Z poważaniem / Regards
Błażej Pabiszczak
M: +48.884999123
E: b.pabiszczak at opensaas.pl


2014-05-09 9:18 GMT+02:00 polanskiman <lefevre_paul at yahoo.fr>:

> 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.
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20140509/f52eb7af/attachment.html>


More information about the vtigercrm-developers mailing list