What does psql say if yuo trying to connect " on GUEST from HOST"?
2013/6/24 <monosij.for...@gmail.com> > > Hello - > > I am running PostgreSQL 9.1 on an Oracle VirtualBox 4.2. > Host/Guest: Ubuntu 13.04 / 64 > > From HOST port 15432 is forwarded to port GUEST port 5432 to connect into > PG on the GUEST. > > I have PG running on HOST as well on default port 5432. > > So while this connection works on HOST from HOST: > engine = create_engine('postgresql://USER:PASSWORD@localhost > :5432/DATABASE') > > This connection does not works on GUEST from HOST: > engine = create_engine('postgresql://USER:PASSWORD@localhost > :15432/DATABASE') > > Pls note ONLY port number has changed from 5432 to 15432. > > ... > Netstat shows the port 15432 is active as well as 10022 which is used to > pass SSH from HOST to GUEST:22. > > Active Internet connections (only servers) > Proto Recv-Q Send-Q Local Address Foreign Address State > PID/Program name > tcp 0 0 *:10022 *:* LISTEN > 17676/VirtualBox > tcp 0 0 *:15432 *:* LISTEN > 17676/VirtualBox > tcp 0 0 *:rsync *:* LISTEN > 1124/xinetd > > Please let me know if I am missing something very obvious. > > Also - what is the best way to not have the password as part of Python > file? Send the password as a password input? > Just wondering if sqlalchemy has something built in already - else can use > the Python getpass. > > Thanks for your help. > > > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@googlegroups.com. > Visit this group at http://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- Best Regards, Panov Sergey -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/groups/opt_out.