DB connection is not consistent

[jashanka]

I've noticed that report tab doesn't work consistently while connecting to DB.

Say I've a DB user 'auto' as below ( using mysql )

create user 'auto'@'%' identified by 'twister'; create user 'auto'@'localhost' identified by 'twister';

grant all privileges on . to 'auto'@'localhost' with grant option; grant all privileges on . to 'auto'@'%' with grant option;

and say twister server running at x.x.x.51 ip and I've configured the database section with following details, Database: some_db Server: x.x.x.52 #where my DB server is running User: auto Password: twister

So when I click on report tab it works sometimes and sometimes I get error as below,

faultCode 1 faultString (1045, "Access denied for user 'auto'@'x.x.x.51' (using password: YES)")

Manually I'm always able to connect to DB server without any problem, please let me know anything I'm missing. Any help greatly appreciated.

Thanks, Jai Shankar

[bogdanpopescu]

@jashanka ould you please let us know what is the GUI version and server ( /opt/twister/server/version.txt ) versions ?

[jashanka]

Gui version 2.0.40 Server 2.045

On Wednesday, 9 April 2014 11:58 AM, Bogdan Popescu notifications@github.com wrote:

@jashanka ould you please let us know what is the GUI version and server ( /opt/twister/server/version.txt ) versions ? — Reply to this email directly or view it on GitHub.

[jashanka]

Well, I also upgraded to latest twister server(3.021) and client and tested for the DB connectivity, but got the same error.

"(1045, "Access denied for user 'auto'@'x.x.x.51' (using password: YES)")"

[bogdanpopescu]

@jashanka Hi, If it works intermitently, please upgrade to version uploaded on 11th April and retest.

[jashanka]

Thanks for the quick fix.

But while I found new build is fixed the DB problem, seems I'm facing one more. i.e. Say user 'A' starts his client and logs into Twister and does his testing and logs out, then user 'B' starts his client and logs into Twister and finishes his testing and logs out.

But after that subsequent login of user 'A' gets him all the paths and settings of user 'B', (this is applicable to all users who had logged in earlier as well ).

Could you please check on this.

Thanks, Jai

[bogdanpopescu]

@jashanka Please close this one and open a new issue. Just FYI, I didn't reproduce the new one.

[jashanka]

Sure, Thanks.