mhardcastle / lotss-query Goto Github PK

except KeyError:
    bad_pointings = ['']

except AttributeError:
    bad_pointings = ['']

In [1]: from surveys_db import SurveysDB

In [2]: sdb=SurveysDB()
2022-02-07 15:48:00,769| ERROR   | Password is required for key /home/cyril.tasse/.ssh/id_rsa

<theCommonSLotssPWD>
tasse
id_rsa.survey

ForwardAgent yes
ForwardX11 yes

 sshtunnel.SSHTunnelForwarder(
    ssh_address_or_host=None,
    ssh_config_file='~/.ssh/config',
    ssh_host_key=None,
    ssh_password=None,
    ssh_pkey=None,
    ssh_private_key_password=None,
    ssh_proxy=None,
    ssh_proxy_enabled=True,
    ssh_username=None,
    local_bind_address=None,
    local_bind_addresses=None)

cyril.tasse@nancep6:~$ ssh -i ~/.ssh/id_rsa.survey [email protected]
Last login: Mon Feb  7 15:42:32 2022 from nancep6.obs-nancay.fr
tasse@lofar-server:~$ logout
Connection to lofar.herts.ac.uk closed.
cyril.tasse@nancep6:~$ ssh -i ~/.ssh/id_rsa [email protected]
Last login: Mon Feb  7 16:02:14 2022 from nancep6.obs-nancay.fr

<thepwd>
tasse
id_rsa.survey

In [2]: from surveys_db import SurveysDB

In [3]: with SurveysDB() as sdb:
   ...:     sdb.cur.execute('select * from transients')
   ...:     result=sdb.cur.fetchall()
   ...:
2021-05-26 07:38:16,444| ERROR   | Password is required for key /home/cyril.tasse/.ssh/id_rsa
---------------------------------------------------------------------------
TypeError                                 Traceback (most recent call last)
<ipython-input-3-a36669045cb0> in <module>
----> 1 with SurveysDB() as sdb:
      2     sdb.cur.execute('select * from transients')
      3     result=sdb.cur.fetchall()
      4     

/data/cyril.tasse/VE_Py3_nancep6/sources/lotss-query/surveys_db.py in __init__(self, readonly, verbose, survey)
    167                 self.tunnel.start()
    168                 localport=self.tunnel.local_bind_port
--> 169                 self.con = mdb.connect('127.0.0.1', 'survey_user', self.password, self.database, port=localport, cursorclass=mdbcursors.DictCursor)
    170             else:
    171                 connected=False

TypeError: __init__() takes 1 positional argument but 5 positional arguments (and 2 keyword-only arguments) were given
> /data/cyril.tasse/VE_Py3_nancep6/sources/lotss-query/surveys_db.py(169)__init__()
    167                 self.tunnel.start()
    168                 localport=self.tunnel.local_bind_port
--> 169                 self.con = mdb.connect('127.0.0.1', 'survey_user', self.password, self.database, port=localport, cursorclass=mdbcursors.DictCursor)
    170             else:
    171                 connected=False

try:
    import MySQLdb as mdb
    import MySQLdb.cursors as mdbcursors
except ImportError:
    import pymysql as mdb
    import pymysql.cursors as mdbcursors