profield external data sources connection issue

Hi, i have tried to connect to external db mysql on other host. this is the log message:

Sep 6, 2013 4:03:01 PM com.sun.jersey.spi.container.servlet.WebComponent filterFormParameters

WARNING: A servlet POST request, to the URI https://xxxx.com/rest/profields/1.0/queryselect/getconnection?0.1814490999095142, contains form parameters in the request body but the request body has been consumed by the servlet or a servlet filter accessing the request parameters. Only resource methods using @FormParam will work as expected. Resource methods consuming the request body by other means will not work as expected.

i think the issue is around the number of parameters supported in the connection string. User and Pwd are not supported.....

Could you help me ?

6 answers

Hello Stefano;

Thank you for your feedback and sorry for the incovenience. Of course wwe can help you. We will try to forward your question to the product team. Would you mind to create an issue in our supporting service at http://www.madeira20.com - It will let you keep the track of any news or updatea bout the evolution of the problem fixing.

Kind Regards

Hello Stephano,

Can you finally create the connection?

It seems an Atlassian Rest plugin issue. You can see more details here:

https://jira.atlassian.com/browse/JRA-29661

https://ecosystem.atlassian.net/browse/REST-200

Probably if you upgrade to Jira 6+, the warning won't show again.

Anyway we will try to reproduce the warning in our environment and try to solve it without the Jira upgrade

Regards.

Do you have a news ?

Hi Carlos,

no, the connection failed. The message is like you have not inserted the password, but the password is good. I can't update now to 6, because some plugins are not yet compliant.

Waiting good news from your side...

Thank you

Hello, sorry for the delay on the answer

We couldn't reproduce the error. Could you please send us more information about your environment? Like database server, Profields version...

Regards.

jira version: 5.2.1

db version mysql 5.5

profields version: 3.0.5


Hello Stefano,

We have tried in an environment like yours with a standard jdbc connection string:

jdbc:mysql://server_ip/database?user=????&password=????

And we haven't had any errors.

Could you send us an example of your connection string?

Regards.

jdbc:mysql://my_ip:3306/my_db?user=my_user&password=my_pwd

We don't know what is happened with your "Test connection" resource, because we have tested with the same environment and it worked.

Maybe a system or external configuration is causing the Atlassian Rest plugin warning.

Anyway, can you try to save the connection even if the Test fails and using it in a field?

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Tuesday in Marketplace Apps

If you’re an Atlassian app developer, you’ll want to know about Atlas Camp!

This September 6-7, hundreds of Atlassian App developers will flock to Barcelona Spain to build skills, discover product roadmaps, meet face-to-face with the Atlassian team, and learn how to extend t...

118 views 0 4
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you