Connecting SQL GUI to Tethys

[Jacob Fullerton]

To my Tethys friends who are SQL savvy:

I am attempting to hook up MySQL workbench to view my databases in tethys. I'm using Ubuntu 16.04 LTS on the dev branch of tethys. I created a persistent database store just like the tutorial does for the stream gages. Now, when I link using the local host address and the port for the database (host: 127.0.0.1 port:5435) I can't access the database. I am using the user: tethys_super. Any suggestions about what I need to do differently?

The error code I get is the following:

Lost connection to MySQL server at 'reading initial communication packet', system error: 0

The credentials are entered as shown in the figure below:

 

I appreciate any help on the subject! Thanks!

[Shawn Crawley]

Is the MySQL Workbench software installed on your Ubuntu virtual machine, or is it on your host machine?

--
You received this message because you are subscribed to the Google Groups "Tethys Platform" group.
To unsubscribe from this group and stop receiving emails from it, send an email to tethysplatfor...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/tethysplatform/e642b5e8-6650-4895-ba04-619f918f4def%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Shawn Crawley]

Also, I'm not sure if you are able to browse your tethys (or any) postgresql database using MySQL Workbench... I'd recommend installing pgadmin (https://www.pgadmin.org/) to connect to your tethys persistent store databases. If you specifically want to use MySQL for some reason, I don't know that I'll be of much help.

[Jacob Fullerton]

I don't have a specific reason for mysql, I'm just used to its interface and thought I'd try to get that setup if possible. I'll try pgadmin and see if I can figure that out. Is there a GUI interface that works well with it? I know that I have pgadmin, but it is run from the terminal and I was hoping to shave off some of the learning curve for using that software.

[Shawn Crawley]

Pgadmin has a GUI. I have never needed to run anything from the terminal. It's super straight forward, too. You could likely be up to speed in minutes.

To view this discussion on the web visit https://groups.google.com/d/msgid/tethysplatform/ef557bbc-9fe4-42cc-8a25-a23188bdeaef%40googlegroups.com.

[Jacob Fullerton]

Kay, got pgadmin 3 working on my computer, thanks Shawn! My database is up and working, hopefully it does what I need it to do.

[swainn]

Just to be explicitly clear, MySQL workbench only works with MySQL databases. The recommended database for use with Tethys is the PostgreSQL database. PGAdmin is the equivalent of MySQL Workbench for PostgreSQL databases, so use that to connect to the Tethys databases with a GUI. There is a tutorial for working with PGAdmin in the Tethys docs: http://docs.tethysplatform.org/en/latest/supplementary/pgadmin.html