Raised This Month: $115 Target: $400
 28% 

PostgreSQL Database Interface


Post New Thread Reply   
 
Thread Tools Display Modes
Peace-Maker
SourceMod Plugin Approver
Join Date: Aug 2008
Location: Germany
Old 11-02-2016 , 23:03   Re: PostgreSQL Database Interface
Reply With Quote #11

Looks like another bug. I've updated the package for that. Patches getting added to the PR.
Keep the reports coming
__________________
Peace-Maker is offline
SovRedBit
Member
Join Date: May 2017
Old 06-11-2017 , 15:48   Re: PostgreSQL Database Interface
Reply With Quote #12

Can you please add port to database.cfg, because i want to use my custom port not 5432
SovRedBit is offline
asherkin
SourceMod Developer
Join Date: Aug 2009
Location: OnGameFrame()
Old 06-11-2017 , 16:15   Re: PostgreSQL Database Interface
Reply With Quote #13

Quote:
Originally Posted by SovRedBit View Post
Can you please add port to database.cfg, because i want to use my custom port not 5432
Did you try it? It is already supported.
__________________
asherkin is offline
SovRedBit
Member
Join Date: May 2017
Old 06-11-2017 , 16:24   Re: PostgreSQL Database Interface
Reply With Quote #14

Quote:
Originally Posted by asherkin View Post
Did you try it? It is already supported.
Yep, it tell me about this error, but i changed my port in database.cfg and on database server.
Anyway i made a default port 5432 and it still give me this error, don't know what to do, i have PostgreSQL-9.4 on server and PostgreSQL-9.2 on client and i configured it to connect to the server but the extension still give me this error, don't know why.


L 06/11/2017 - 23:03:21: [SM] Exception reported: OnDBConnect could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
SovRedBit is offline
asherkin
SourceMod Developer
Join Date: Aug 2009
Location: OnGameFrame()
Old 06-11-2017 , 18:16   Re: PostgreSQL Database Interface
Reply With Quote #15

Quote:
Originally Posted by SovRedBit View Post
Yep, it tell me about this error, but i changed my port in database.cfg and on database server.
Anyway i made a default port 5432 and it still give me this error, don't know what to do, i have PostgreSQL-9.4 on server and PostgreSQL-9.2 on client and i configured it to connect to the server but the extension still give me this error, don't know why.


L 06/11/2017 - 23:03:21: [SM] Exception reported: OnDBConnect could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
It is trying to connect using a unix domain socket so the port is completely ignored anyway...

That error message is straight from the Postgres client library, if you search for "Is the server running locally and accepting connections on Unix domain socket" you'll see many people discussing it and hopefully be able to solve it.
__________________
asherkin is offline
SovRedBit
Member
Join Date: May 2017
Old 06-12-2017 , 15:50   Re: PostgreSQL Database Interface
Reply With Quote #16

Quote:
Originally Posted by asherkin View Post
It is trying to connect using a unix domain socket so the port is completely ignored anyway...

That error message is straight from the Postgres client library, if you search for "Is the server running locally and accepting connections on Unix domain socket" you'll see many people discussing it and hopefully be able to solve it.
I know what this Error mean, i tried to use psql client from this Linux server to connect to the main psql server but i had this error, so i fixed it by enable the if of this client, but on csgo server it's not working, and i don't know why, i have enabled everything, but it still not want to work.
SovRedBit is offline
Peace-Maker
SourceMod Plugin Approver
Join Date: Aug 2008
Location: Germany
Old 06-12-2017 , 18:13   Re: PostgreSQL Database Interface
Reply With Quote #17

Paste your databases.cfg section which is causing trouble please (without credentials).
__________________
Peace-Maker is offline
SovRedBit
Member
Join Date: May 2017
Old 06-12-2017 , 21:27   Re: PostgreSQL Database Interface
Reply With Quote #18

Quote:
Originally Posted by Peace-Maker View Post
Paste your databases.cfg section which is causing trouble please (without credentials).
"vip"
{
"driver" "pgsql"
"host" "178.170....."
"database" "testvip"
"user" "postgres"
"pass" "password"
"port" "5432"
"timeout" "40
}
SovRedBit is offline
DJ Tsunami
DJ Post Spammer
Join Date: Feb 2008
Old 06-13-2017 , 04:05   Re: PostgreSQL Database Interface
Reply With Quote #19

Your "timeout" line is missing a quote at the end.
__________________
DJ Tsunami is offline
SovRedBit
Member
Join Date: May 2017
Old 06-13-2017 , 06:06   Re: PostgreSQL Database Interface
Reply With Quote #20

It's not the problem, this error exists even if i delete the port and timeout
SovRedBit is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 22:08.


Powered by vBulletin®
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Theme made by Freecode