topic Re: Db Connection passwords don't seem to save. in Talend Studio

Db Connection passwords don't seem to save.

_AnonymousUser — Thu, 01 Aug 2013 02:22:40 GMT

After creating a connection and verifying that everything is correct using the check button, I try and retrieve the schema for the database only to be greeted with an error message.
Using a MySql connection I get:
Connection failure, check the database settings or contact your database administrator.
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
Using MSSql:
Connection failure, check the database settings or contact your database administrator.
Impossible to initialize the connection !
Naturally I go back and check the database settings using edit connection, without changing anything I hit check and also receive the above error messages. This is resolved when I re-enter the passwords, I click finish and try retrieving the schema again but I receive the same errors and the problem just starts again.
Any insight would be appreciated.

Re: Db Connection passwords don't seem to save.

Anonymous — Thu, 01 Aug 2013 02:55:47 GMT

Hi,
What talend production build version are you using?
Best regards
Sabrina

Re: Db Connection passwords don't seem to save.

_AnonymousUser — Thu, 01 Aug 2013 03:19:54 GMT

I have tried with both v5.3.1 and v5.1.1.

Re: Db Connection passwords don't seem to save.

Anonymous — Thu, 01 Aug 2013 04:48:32 GMT

Hi,
I have tested it on talend open studio for Data Integration using MySql and MSSQL, everything is fine.
Are your DB in localhost or server? Did you follow the document TalendHelpCenteretting up a DB connection to set up DB connection?
Best regards
Sabrina

Re: Db Connection passwords don't seem to save.

_AnonymousUser — Thu, 01 Aug 2013 05:00:25 GMT

Both databases are local, and I have also tried using both the 64bit and 32bit executables for both versions.
I have been using the zipped versions of talend. Currently I am downloading the executable installer to see if I get different results.

Re: Db Connection passwords don't seem to save.

Anonymous — Thu, 01 Aug 2013 05:21:31 GMT

Hi,
What's your unzipper? like WinRAR or 7zip?
1) Use the manual install zip file 'TalendOpenStudioProduct.zip' instead of 'TalendOpenStudioProduct-windows-installer.exe'
2) Unzip it with 7-Zip/WinRAR, not with Windows Explorer
3) Unzip it to a root drive, e.g. 'C:\Talend-Open-Studio-DI-5.3.1\studio\', (without spaces in path names).
Best regards
Sabrina

Re: Db Connection passwords don't seem to save.

_AnonymousUser — Thu, 01 Aug 2013 05:27:59 GMT

Looks like I have found the problem, thank you for your support.
Both my database passwords contained a period (.), on a hunch I changed them to just use alphanumeric characters and lo and behold it worked.

Re: Db Connection passwords don't seem to save.

Anonymous — Thu, 01 Aug 2013 05:29:54 GMT

Hi,
It is great! Thanks for your feedback. Feel free post your issue on forum.
Best regards
Sabrina

Re: Db Connection passwords don't seem to save.

Anonymous — Thu, 02 Apr 2015 07:42:14 GMT

Hi all,
I'm also facing same problem to connect mysql Database.
User: raja.reddy
Error: "Connection failure. You must change the Database Settings.
java.lang.RuntimeException: java.sql.SQLException: Access denied for user 'raja.reddy'@'50.60.70.80' (using password:Yes)"
Thanks in Advance.
Regards,
kumar.talend

Re: Db Connection passwords don't seem to save.

Anonymous — Thu, 02 Apr 2015 09:26:58 GMT

Hi kumar.talend,

On which official version did you get that?

Best regards
Sabrina

Re: Db Connection passwords don't seem to save.

Anonymous — Mon, 06 Apr 2015 09:35:11 GMT

Thank you Sabrina,
I have installed Talend Open Studio Big Data v5.6.1.
Regards,
kumar.talend

Re: Db Connection passwords don't seem to save.

Anonymous — Tue, 07 Apr 2015 04:26:30 GMT

Hi kumar.talend,
The DB connection is Ok with you?
Is there any backslashes or period in your password?
Best regards
Sabrina

Re: Db Connection passwords don't seem to save.

Anonymous — Tue, 07 Apr 2015 08:07:15 GMT

Hi Sabrina,
Password doesn't have any backslashes or period But User name have period(.).This will causes the issues?
I'm unable to establishing connection b/w Talend and Mysql.
Thanks,
Kumar

Re: Db Connection passwords don't seem to save.

Anonymous — Tue, 07 Apr 2015 11:09:11 GMT

Hi kumar.talend,
Does this issue repro on other studios(5.5.1...)? Have you tried to connect your MySql DB successfully without using Talend tool?
Best regards
Sabrina

Re: Db Connection passwords don't seem to save.

Anonymous — Wed, 08 Apr 2015 11:51:38 GMT

Hi Sabrina,
Previous we are used PostgreSql DB,I didn't get any DB connect issues with Pg DB, we are using MySql for new project.
I'm able to access MySql DB using MySQL Community Server.
Thanks,
Kumar

Re: Db Connection passwords don't seem to save.

Anonymous — Wed, 08 Apr 2015 11:59:57 GMT

Hi kumar,
We will take a testing on Talend Open Studio Big Data v5.6.1 to see if this issue repro then come back to you asap.
Best regards
Sabrina

Re: Db Connection passwords don't seem to save.

Anonymous — Wed, 08 Apr 2015 12:09:13 GMT

Thank you Sabrina,
Regards,
kumar