[teiid-issues] [JBoss JIRA] Commented: (TEIID-1460) Have teiid emulate a native postgresql database connection
[
https://issues.jboss.org/browse/TEIID-1460?page=com.atlassian.jira.plugin...
]
Steven Lawrance commented on TEIID-1460:
----------------------------------------
For python, here are a few things I tried:
# Using PyGreSQL DBAPI to connect directly:
import pgdb
conn = pgdb.connect(host="teiidserver:35432", user="test",
password="123")
That results in 'pg.InternalError: received invalid response to SSL negotiation:
'
Using stunnel to handle the SSL, listening locally on 5432 and forwarding to
server:35432.. we need to set the environment variable PGSSLMODE=disable (or we could
change the connect params). It seems to get further but we get an exception from teiid:
>> import pgdb
>> conn = pgdb.connect(host="localhost", user="test",
password="123")
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/usr/lib64/python2.7/site-packages/pgdb.py", line 381, in connect
dbtty, dbuser, dbpasswd)
pg.InternalError: ERROR: org.teiid.core.TeiidException
DETAIL: org.teiid.jdbc.TeiidSQLException: org.teiid.core.TeiidException
No luck with the pg8000 module either:
# pg8000, connecting via stunnel as above
from pg8000 import DBAPI
conn = DBAPI.connect(host="localhost", user="test",
password="123")
That complains about the authentication method not being supported. It hangs if I try to
connect directly using SSL:
from pg8000 import DBAPI
conn = DBAPI.connect(host="teeidserver", port=35432, user="test",
password="123")
Have teiid emulate a native postgresql database connection
----------------------------------------------------------
Key: TEIID-1460
URL: https://issues.jboss.org/browse/TEIID-1460
Project: Teiid
Issue Type: Feature Request
Components: Server
Affects Versions: 7.3
Environment: All environments
Reporter: Graeme Gillies
Assignee: Steven Hawkins
Priority: Minor
Currently we are using postgresql-odbc, and unixODBC to connect to teiid via the emulated
postgresql ODBC connection on port 35432. Unfortunately, this is cumbersome to use,
requires fiddling with setting up ODBC, and is difficult for integration into non-java
languages (that have to use the ODBC connection).
What we would like is for teiid to emulate a postgresql database such that we can point
typical postgresql tools (such as psql) to port 35432 (or some other port) and they will
"work". That would also allow us to use each languages native/preferred method
of connecting to a postgresql database to connect to teiid. E.g. DBD::Postgres for perl,
ruby-pg for ruby, pg/pgdb in python, etc.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira