Using pgAdmin III, getting "access denied"

175 views
Skip to first unread message

Grant Woodward

unread,
May 8, 2014, 8:37:35 PM5/8/14
to schem...@googlegroups.com
I just registered for The Schemaverse (which is an awesome concept, by the way), and I'd like to use pgAdmin to connect, as the tutorial suggests. (Also, I use pgAdmin for troubleshooting things at work, so I'm already a bit familiar with it.) Unfortunately, I'm getting the following when I attempt to connect:

FATAL: no pg_hba.conf entry for host "<my_ip_address>", user "<my_username>", database "schemaverse", SSL on FATAL: no pg_hba.conf entry for host "<my_ip_address>", user "<my_username>", database "schemaverse", SSL off 

Obviously, I've anonymized certain parts of this. Is there something I need to on my end to connect? Or do I need to wait for my username to be added to an access list?

Abstrct

unread,
May 9, 2014, 5:01:44 PM5/9/14
to schem...@googlegroups.com
If you login to the website (either in the training wheels page or tutorial), does that work? 

Once an account is created it is automatically added to the players group, which then authorizes it for remote connections. There shouldn't be a delay. 

The main thing I can think of is that the maintenance database may be set to something other than schemaverse. Make sure it's not blank or set to something else other than schemaverse. 

Let me know if none of that works out. We will get it all figured out :) 

-Abstrct

Grant Woodward

unread,
May 9, 2014, 5:29:28 PM5/9/14
to schem...@googlegroups.com
Logging in to the website does work. I did have the maintenance db set to 'schemaverse' (no quotes)—I double-checked that a couple of times. I left all SSL settings blank.

I'll try it again when I get home tonight.


--
You received this message because you are subscribed to a topic in the Google Groups "Schemaverse" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/schemaverse/5DreC3P313w/unsubscribe.
To unsubscribe from this group and all its topics, send an email to schemaverse...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



--
Grant

Abstrct

unread,
May 10, 2014, 6:19:25 PM5/10/14
to schem...@googlegroups.com
Did you end up having any luck? 

I assume the host you are using is db.schemaverse.com too right?

Another thing that might be slightly misleading is that even once it does connect properly, pgAdmin will alert you to a bunch of permission issues (just due to the nature of the game). Clearly by the error message you provided, you are having connection problems, but I just wanted to point that out so you don't accidentally think it still isn't working when it is.

-Abstrct 


On Friday, May 9, 2014 5:29:28 PM UTC-4, Grant Woodward wrote:
Logging in to the website does work. I did have the maintenance db set to 'schemaverse' (no quotes)—I double-checked that a couple of times. I left all SSL settings blank.

I'll try it again when I get home tonight.
On Fri, May 9, 2014 at 5:01 PM, Abstrct wrote:
If you login to the website (either in the training wheels page or tutorial), does that work? 

Once an account is created it is automatically added to the players group, which then authorizes it for remote connections. There shouldn't be a delay. 

The main thing I can think of is that the maintenance database may be set to something other than schemaverse. Make sure it's not blank or set to something else other than schemaverse. 

Let me know if none of that works out. We will get it all figured out :) 

-Abstrct



On Thursday, May 8, 2014 8:37:35 PM UTC-4, Grant Woodward wrote:
I just registered for The Schemaverse (which is an awesome concept, by the way), and I'd like to use pgAdmin to connect, as the tutorial suggests. (Also, I use pgAdmin for troubleshooting things at work, so I'm already a bit familiar with it.) Unfortunately, I'm getting the following when I attempt to connect:

FATAL: no pg_hba.conf entry for host "<my_ip_address>", user "<my_username>", database "schemaverse", SSL on FATAL: no pg_hba.conf entry for host "<my_ip_address>", user "<my_username>", database "schemaverse", SSL off 

Obviously, I've anonymized certain parts of this. Is there something I need to on my end to connect? Or do I need to wait for my username to be added to an access list?

--
You received this message because you are subscribed to a topic in the Google Groups "Schemaverse" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/schemaverse/5DreC3P313w/unsubscribe.
To unsubscribe from this group and all its topics, send an email to schemaverse+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.



--
Grant

Grant Woodward

unread,
May 10, 2014, 8:35:49 PM5/10/14
to schem...@googlegroups.com
Found the problem: Case sensitivity. I registered through the website as "STGGrant", but only a lowercased login -- "stggrant" -- was accepted through pgAdmin. I'm now logged in. Might be worth mentioning in the documentation. Thanks for your prompt help!


To unsubscribe from this group and all its topics, send an email to schemaverse...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.



--
Grant
Reply all
Reply to author
Forward
Message has been deleted
0 new messages