Postgres password error

[dobson]

Hi, I'm really looking forward to trying out MusicCabinet.

I just went through the installation process on my Mac (running 10.. I installed PostgreSQL 9.1.6, went through the installation dialog following directions, (chose a password and created the new postgres user, port 5432, default locale, etc...)

Now, when I go to the Subsonic web interface, and I get to the MusicCabinet configuration page, when I enter my password it says "Wrong password".
I'm certain I'm using the correct password, I even uninstalled PostgreSQL and reinstalled it. Also, I am able to use the pgAdmin III app that is provided with the default Mac installation of PostgreSQL, and it accepts the password that I entered during installation just fine.

obviously, I'm missing something... can anyone help?

[hakko]

No-one has reported that before, so there's probably some unusual circumstances here.

Could you send me the two log files mentioned from the About view (subsonic.log and musiccabinet.log), and I'll see if I can make something out from them?

Does your password contain non-ascii characters, such as ö, ǫ, ç ? Any other odd characters?

Regards

[hakko]

I'm answering here to keep this public for future reference.

It seems like you're have a network setup that is a bit unusual - the Postgresql error message is:

Code: Select all

[2012-10-13 12:59:03] WARN JdbcDatabaseAdministrationDao - Expected Postgresql server to return R, got E.
[2012-10-13 12:59:03] WARN JdbcDatabaseAdministrationDao - Password validation failed.
org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "192.168.1.110", user "postgres", database "template1", SSL off

By default, Postgresql does only allow incoming connections from localhost (127.0.0.1). If you want it to accept connections from elsewhere, you have to give explicit access.

Try editing your pg_hba.conf file (in postgres install dir / data), adding this at the very last:

Code: Select all

host    all         all         192.168.1.110/32        trust


I think that should be enough, but a Postgres DBA can surely correct me.

[dobson]

thanks... I'm not sure why it thinks I'm trying to access from anywhere other than localhost. I'm only using one computer... postgres and subsonic are installed on the same computer and that is the computer I am using to access subsonic by going to localhost:4040 . . .
192.168.1.110 is indeed the local IP address of the computer I'm working on...

adding that line to my pg_hba.conf file didn't fix it just yet, but I'll keep playing around and let you know if I stumble on to a solution.

thanks!

[hakko]

Weird. 192.168 looks like a home network to me? But I'm not a network technician.

How about

Code: Select all

host    all         all         192.168.1.110/32        md5