[Solved] Suspended Account?

[Krydos]

Well, let's start with php. Try something like this:

<?php

$dbconn = pg_connect("dbname=username_test user=username password=abc123");
$result = pg_query($dbconn, "select * from test_table");
$row = pg_fetch_all($result);
echo $row['0']['data'];

 

Here is the result http://krydos2.heliohost.org/psql.php

[petervaien]

The problem is not that. I need host and port to connect to Tommy pgsql . Thx

[wolstech]

Localhost on 5432 should work for your scripts on the server. If it doesn't, it may be misconfigured. Remote access doesn't work at all that I can find (Krydos may need to enable it...)

 

Stevie and (old) Johnny both took server.heliohost.org:5432 for remote connections.

[petervaien]

Ok .

On old Stevie, remote access to pgsql db worked perfectly, I sincerely expect to work even on tommy.

Please enable it.

Really thanks for your help.

Best,

P.

[Krydos]

Which IP needs access to which database(s)?

[petervaien]

DB is betnbit_p inside tommy server.

Unfortunately I've not a static IP; but on Stevie server I accessed with any IP...

Thanx

[petervaien]

Any news please?

[wolstech]

Krydos must've been busy yesterday. None of the escalated stuff got look at either. We're all volunteers after all, so we do this as time allows, and its a holiday week in the USA too.

I'll move this to escalated so he'll remember to check it

 

EDIT: Just an update: Krydos said he's travelling yesterday and today, so it may take an extra day or so for him to respond.

[petervaien]

Ok thank you

[Krydos]

Can you access it now?

[petervaien]

unfortunately it says

 

 

org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "<my_temporary_IP>", user "betnbit_betnbit", database "betnbit_p", SSL off

[Krydos]

Oh, it was set up to use the username 'betnbit' not 'betnbit_betnbit' since you didn't specify. Does it work now?

[petervaien]

Great, I got it!

Now I'm gonna try to restore previous database.

Thank you!

[petervaien]

I'm finding very slow the entire process of db restore after Stevie crash. Backup is dated last august, but better than nothing.

I guess that's due to transmission time .

Do you think that sending you the backup directory you'll be able to restore in a shorter time, or it's not up to you?

Thank you.

[Krydos]

To import your postgres .sql file go to https://tommy.heliohost.org:2083/3rdparty/phpPgAdmin/index.php select your database, click the sql tab, and click the choose file button.