Is it possible to not send a password in connection string?

[rossj-cargotel]

We have an unusual problem with 11.10 on CentOS 7. If we send a password with a connection string, informix panics. Doesn't matter if we are connecting through perl's DBD::Informix or through the informix_fdw connector.

I've tried just taking the password out of the create user mapping statement but that doesn't seem to work--I get a -951 informix error.

Can the informix_fdw connect without a password supplied?

[psoo]

Hi,

Looks strange. Have you tried dbaccess?

Unfortunately, you cannot just omit the password from the IFX login, since the ESQL/C CONNECT TO statement requires a password when using the USER authentication clause:

https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.sqls.doc/ids_sqs_0090.htm

That's why it's mandatory in the IFX connection string. Are all users affected or just one? If all user logins show the problem, there may be something fishy with your Informix install.

[rossj-cargotel]

Yes, but dbaccess will allow us to connect without username and password because we have put servers and usernames in /etc/hosts.equiv on the informix server.

sqlcmd is the same way--but if I use a username and password in the sqlcmd command it, too, causes informix to panic.

Since both of those can connect to informix without username and password I had hopes that informix_fdw could also skip the check.

Thank you for your answer and all the work you put into informix_fdw.
We've been using it in limited cases while we work on getting moved over to postgres but now cannot. You can close this ticket.

Jeff

Jeff Ross rossj@cargotel.com

On 4/10/17 4:03 AM, Bernd Helmle wrote:

Hi,

Looks strange. Have you tried dbaccess?

Unfortunately, you cannot just omit the password from the IFX login, since the ESQL/C CONNECT TO statement requires a password when using the USER authentication clause:

https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.sqls.doc/ids_sqs_0090.htm

That's why it's mandatory in the IFX connection string. Are all users affected or just one? If all user logins show the problem, there may be something fishy with your Informix install.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/credativ/informix_fdw/issues/18#issuecomment-292905459, or mute the thread https://github.com/notifications/unsubscribe-auth/AL7JjVoYV3jUdiS1IMiBGeEVGOGiKy-Tks5ruf5ugaJpZM4M35B-.

--

The contents of this e-mail and any attachments are intended solely for the use of the named addressee(s) and may contain confidential and/or privileged information. Any unauthorized use, copying, disclosure, or distribution of the contents of this e-mail is strictly prohibited by the sender and may be unlawful. If you are not the intended recipient, please notify the sender immediately and delete this e-mail.

[psoo]

Uh, does that mean this issue blocks your migration efforts?

[rossj-cargotel]

No, not at all. I use a different method completely to import a database from informix to postgres. I was using the informix foreign data wrapper for adhoc queries of informix from postgres.

Jeff

Jeff Ross rossj@cargotel.com SENDPM

On 4/18/17 2:59 AM, Bernd Helmle wrote:

Uh, does that mean this issue blocks your migration efforts?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/credativ/informix_fdw/issues/18#issuecomment-294736936, or mute the thread https://github.com/notifications/unsubscribe-auth/AL7JjYWC1l8yIuq7o4w84f9nJKVLl6A0ks5rxHtvgaJpZM4M35B-.

--

The contents of this e-mail and any attachments are intended solely for the use of the named addressee(s) and may contain confidential and/or privileged information. Any unauthorized use, copying, disclosure, or distribution of the contents of this e-mail is strictly prohibited by the sender and may be unlawful. If you are not the intended recipient, please notify the sender immediately and delete this e-mail.