Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Not able to connect to the server from python. #8

Open
joseajunior opened this issue Aug 11, 2023 · 0 comments
Open

Not able to connect to the server from python. #8

joseajunior opened this issue Aug 11, 2023 · 0 comments

Comments

@joseajunior
Copy link

I create a server using a Docker Compose like this:

    image: icr.io/informix/informix-developer-database
    tty: true
    ports:
      - "9088:9088"
    environment:
      DBA_USER: wexrobotlib_user
      DBA_PASSWORD: Passw0rd
      LICENSE: accept
      INIT_FILE: informix_setup.sql
    privileged: true
    volumes:
      - ./INFORMIX_setup.sql:/opt/ibm/config/informix_setup.sql
    healthcheck:
      test: ["CMD", "bash", "-c", "echo \"select count(*) from systables\" | dbaccess sysmaster"]
      interval: 1m30s
      timeout: 30s
      retries: 5
      start_period: 30s

After the creation, I try connecting from the DBeaver with these credentials and it works:

User: wexrobotlib_user
Password: Passw0rd

But If I try to connect using python from the library sqlalchemy and sqlalchemy-informix using this url:
informix://wexrobotlib_user:Passw0rd@localhost:9088/test
or with the authentication value:
informix://wexrobotlib_user:Passw0rd@localhost:9088/test;AUTHENTICATION=SERVER
I get hanged with this error:
[email protected]:1556: err = -408: oserr = 0: errstr = from _gateway to server informix : Invalid message type received from the sqlexec process.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant