{"comment":{"created_at":"2011-10-23T11:07:44Z","body":"hi, above mentioned krugar here. more details:\r\nDebian Squeeze - Linux 2.6.26-2-xen-amd64 #1 SMP Tue Jan 25 06:13:50 UTC 2011 x86_64 GNU/Linux\r\nPostgres server from package: postgresql_8.4.7-0squeeze2_all.deb\r\nbuddycloud server built from: buddycloud-server-v0.0.1.99.2-x86-64.tar.gz\r\n\r\ndatabase test with psql works out, user/database-name/password in config.js doublechecked etc.\r\n\r\nconsole output from the server (# /opt/buddycloud-server/bin/buddycloud-server ):\r\nquery SELECT DISTINCT listener FROM subscriptions WHERE listener IS NOT NULL undefined\r\nquery SELECT node FROM nodes undefined\r\n\r\npostgres logfile:\r\n2011-10-23 12:49:52 CEST LOG:  unexpected EOF on client connection\r\n2011-10-23 12:49:52 CEST LOG:  unexpected EOF on client connection\r\n2011-10-23 12:49:52 CEST LOG:  unexpected EOF on client connection\r\n2011-10-23 12:49:52 CEST LOG:  unexpected EOF on client connection\r\n2011-10-23 12:49:52 CEST LOG:  unexpected EOF on client connection\r\n\r\n\"tcpdump -ni lo\" output concerning psql port:\r\n12:50:08.477521 IP 127.0.0.1.56352 > 127.0.0.1.5432: Flags [S], seq 930558348, win 32792, options [mss 16396,sackOK,TS val 1036786652 ecr 0,nop,wscale 5], length 0\r\n12:50:08.477521 IP 127.0.0.1.5432 > 127.0.0.1.56352: Flags [S.], seq 928948083, ack 930558349, win 32768, options [mss 16396,sackOK,TS val 1036786652 ecr 1036786652,nop,wscale 5], length 0\r\n12:50:08.477521 IP 127.0.0.1.56352 > 127.0.0.1.5432: Flags [.], ack 1, win 1025, options [nop,nop,TS val 1036786652 ecr 1036786652], length 0\r\n12:50:08.477521 IP 127.0.0.1.56353 > 127.0.0.1.5432: Flags [S], seq 934197877, win 32792, options [mss 16396,sackOK,TS val 1036786652 ecr 0,nop,wscale 5], length 0\r\n12:50:08.477521 IP 127.0.0.1.5432 > 127.0.0.1.56353: Flags [S.], seq 934774092, ack 934197878, win 32768, options [mss 16396,sackOK,TS val 1036786652 ecr 1036786652,nop,wscale 5], length 0\r\n12:50:08.477521 IP 127.0.0.1.56353 > 127.0.0.1.5432: Flags [.], ack 1, win 1025, options [nop,nop,TS val 1036786652 ecr 1036786652], length 0\r\n12:50:08.481521 IP 127.0.0.1.56354 > 127.0.0.1.5432: Flags [S], seq 931023043, win 32792, options [mss 16396,sackOK,TS val 1036786653 ecr 0,nop,wscale 5], length 0\r\n12:50:08.481521 IP 127.0.0.1.5432 > 127.0.0.1.56354: Flags [S.], seq 926131750, ack 931023044, win 32768, options [mss 16396,sackOK,TS val 1036786653 ecr 1036786653,nop,wscale 5], length 0\r\n12:50:08.481521 IP 127.0.0.1.56354 > 127.0.0.1.5432: Flags [.], ack 1, win 1025, options [nop,nop,TS val 1036786653 ecr 1036786653], length 0\r\n12:50:08.481521 IP 127.0.0.1.56355 > 127.0.0.1.5432: Flags [S], seq 941273667, win 32792, options [mss 16396,sackOK,TS val 1036786653 ecr 0,nop,wscale 5], length 0\r\n12:50:08.481521 IP 127.0.0.1.5432 > 127.0.0.1.56355: Flags [S.], seq 930178220, ack 941273668, win 32768, options [mss 16396,sackOK,TS val 1036786653 ecr 1036786653,nop,wscale 5], length 0\r\n12:50:08.481521 IP 127.0.0.1.56355 > 127.0.0.1.5432: Flags [.], ack 1, win 1025, options [nop,nop,TS val 1036786653 ecr 1036786653], length 0\r\n12:50:08.481521 IP 127.0.0.1.56356 > 127.0.0.1.5432: Flags [S], seq 939951285, win 32792, options [mss 16396,sackOK,TS val 1036786653 ecr 0,nop,wscale 5], length 0\r\n12:50:08.481521 IP 127.0.0.1.5432 > 127.0.0.1.56356: Flags [S.], seq 939923173, ack 939951286, win 32768, options [mss 16396,sackOK,TS val 1036786653 ecr 1036786653,nop,wscale 5], length 0\r\n12:50:08.481521 IP 127.0.0.1.56356 > 127.0.0.1.5432: Flags [.], ack 1, win 1025, options [nop,nop,TS val 1036786653 ecr 1036786653], length 0\r\n12:50:08.529521 IP 127.0.0.1.47768 > 127.0.0.1.5347: Flags [S], seq 935873413, win 32792, options [mss 16396,sackOK,TS val 1036786665 ecr 0,nop,wscale 5], length 0\r\n12:50:08.529521 IP 127.0.0.1.5347 > 127.0.0.1.47768: Flags [S.], seq 933972045, ack 935873414, win 32768, options [mss 16396,sackOK,TS val 1036786665 ecr 1036786665,nop,wscale 5], length 0\r\n12:50:08.529521 IP 127.0.0.1.47768 > 127.0.0.1.5347: Flags [.], ack 1, win 1025, options [nop,nop,TS val 1036786665 ecr 1036786665], length 0\r\n12:50:08.553521 IP 127.0.0.1.47768 > 127.0.0.1.5347: Flags [P.], seq 1:123, ack 1, win 1025, options [nop,nop,TS val 1036786671 ecr 1036786665], length 122\r\n12:50:08.553521 IP 127.0.0.1.5347 > 127.0.0.1.47768: Flags [.], ack 123, win 1024, options [nop,nop,TS val 1036786671 ecr 1036786671], length 0\r\n12:50:08.553521 IP 127.0.0.1.56356 > 127.0.0.1.5432: Flags [P.], seq 1:44, ack 1, win 1025, options [nop,nop,TS val 1036786671 ecr 1036786653], length 43\r\n12:50:08.553521 IP 127.0.0.1.5432 > 127.0.0.1.56356: Flags [.], ack 44, win 1024, options [nop,nop,TS val 1036786671 ecr 1036786671], length 0\r\n12:50:08.553521 IP 127.0.0.1.5432 > 127.0.0.1.56356: Flags [P.], seq 1:14, ack 44, win 1024, options [nop,nop,TS val 1036786671 ecr 1036786671], length 13\r\n\r\nnot quite sure where the difference in timestamps comes from, might have been my fault tho.\r\nran the test again with firewall disabled, same result (at least in the buddycloud console).\r\nlet me know if you need more/other data.","updated_at":"2011-10-23T11:07:44Z","url":"https://api.github.com/repos/buddycloud/buddycloud-server/issues/comments/2494898","id":2494898,"user":{"avatar_url":"https://secure.gravatar.com/avatar/5da975a3295407c55968d08aed626a28?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"5da975a3295407c55968d08aed626a28","url":"https://api.github.com/users/krugar","id":109856,"login":"krugar"}},"action":"created","issue":{"number":20,"created_at":"2011-10-22T12:49:09Z","pull_request":{"diff_url":null,"patch_url":null,"html_url":null},"body":"I have configured postgres and it works with the bc schema:\r\n\r\n> psql -h localhost  --username buddycloud-server -d buddycloud-server -c \"select * from nodes;\"\r\n\r\n> Password for user buddycloud-server: \r\n> node \r\n> \r\n> (0 rows)\r\n\r\nbut running the client with the same database config fails:\r\n\r\n> $  bin/buddycloud-server \r\n> Postgres: ECONNREFUSED, Connection refused\r\n> Postgres: ECONNREFUSED, Connection refused\r\n> Postgres: ECONNREFUSED, Connection refused\r\n> Postgres: ECONNREFUSED, Connection refused\r\n\r\nDB config:\r\n\r\n/opt/buddycloudlib/node_modules/buddycloud-server/config.js\r\n\r\n// PostgreSQL backend\r\nexports.modelBackend = 'postgres';\r\nexports.modelConfig = {\r\n    host: 'localhost',\r\n    port: 5432,\r\n    database: 'buddycloud-server',\r\n    user: 'buddycloud-server',\r\n    password: 'xxxx',\r\n    poolSize: 4\r\n};\r\n","comments":3,"title":"server startup problems / postgres","updated_at":"2011-10-23T11:07:44Z","url":"https://api.github.com/repos/buddycloud/buddycloud-server/issues/20","id":2022483,"assignee":{"avatar_url":"https://secure.gravatar.com/avatar/0120a25badc6b1e50f6890527dca7042?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"0120a25badc6b1e50f6890527dca7042","url":"https://api.github.com/users/astro","id":12923,"login":"astro"},"milestone":null,"closed_at":null,"user":{"avatar_url":"https://secure.gravatar.com/avatar/efca683b0387b1440aa68d21c3f51c3b?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"efca683b0387b1440aa68d21c3f51c3b","url":"https://api.github.com/users/imaginator","id":469572,"login":"imaginator"},"html_url":"https://github.com/buddycloud/buddycloud-server/issues/20","labels":[],"state":"open"},"legacy":{"issue_id":2022483,"comment_id":2494898}}