[Vtigercrm-developers] Fwd: Re: vtiger 5.4 and MySQL user Privileges

[Vic Cekvenich]

-------- Original Message --------
Subject: 	Re: [Vtigercrm-developers] vtiger 5.4 and MySQL user Privileges
Date: 	Fri, 9 May 2014 09:22:53 +0200
From: 	Pabiszczak, Błażej <b.pabiszczak at opensaas.pl>
Reply-To: 	vtigercrm-developers at lists.vtigercrm.com
To: 	vtigercrm-developers at lists.vtigercrm.com



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 <mailto:b.pabiszczak at opensaas.pl>


2014-05-09 9:18 GMT+02:00 polanskiman <lefevre_paul at yahoo.fr 
<mailto: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 --------------
_______________________________________________
http://www.vtiger.com/