1 Topic by carlo_politi

  • carlo_politi
  • Veteran
  • Offline
  • Registered: 25-01-2013
  • Posts: 147

Topic: pg_connect() error

Hi,
i'm trying to configure Drupal to show verification pages but i get this error:

pg_connect(): Unable to connect to PostgreSQL server: FATAL: no PostgreSQL user name specified in startup packet


The problem is my Drupal  has not PostgreSQL but only MySQL, PostgreSQL is only on Indicia Warehouse. Is there a way to solve this?

Carlo Politi - Software Engineer
QuestIT s.r.l.
Home page: www.quest-it.com
E-Mail: politi@quest-it.com - Skype: carlo.politi.questit

2 Reply by Jim Bacon

  • Jim Bacon
  • Veteran
  • Offline
  • From: BRC
  • Registered: 03-11-2008
  • Posts: 980

Re: pg_connect() error

Hi Carlo

Drupal does not need to connect to the Warehouse database. Drupal communicates with the Warehouse using web services.

Are you using one of the verification forms in the IForm module for Drupal?

Jim Bacon.

3 Reply by carlo_politi

  • carlo_politi
  • Veteran
  • Offline
  • Registered: 25-01-2013
  • Posts: 147

Re: pg_connect() error

Hi Jim,
i have simply created a verification page in Drupal with "Verification" as "Form Category" and "Verification 3" as "Form". I use what it comes with Drupal 0.8.2...

Carlo Politi - Software Engineer
QuestIT s.r.l.
Home page: www.quest-it.com
E-Mail: politi@quest-it.com - Skype: carlo.politi.questit

4 Reply by Jim Bacon

  • Jim Bacon
  • Veteran
  • Offline
  • From: BRC
  • Registered: 03-11-2008
  • Posts: 980

Re: pg_connect() error

Hi Carlo

For me, that form works without needing to make any changes to the form configuration. It does depend upon the Site Configuration >Iform > Settings having a correct Website ID and Password. It also depends upon the "Verification Grid Report 3" being present on the Warehouse.

If you edit your verification page, go to the Report Settings section, what Report Name is selected?

Jim Bacon

5 Reply by carlo_politi (edited by carlo_politi 11-02-2013 14:56:12)

  • carlo_politi
  • Veteran
  • Offline
  • Registered: 25-01-2013
  • Posts: 147

Re: pg_connect() error

Hi Jim,
i have these:

Report Name: Auto-checked verification data 3
Report for map output: Record attributes for verification
Report for record details: Record data for verification
Report for record attributes: Record attributes for verification

these last 3, for "Verification 3"

Carlo Politi - Software Engineer
QuestIT s.r.l.
Home page: www.quest-it.com
E-Mail: politi@quest-it.com - Skype: carlo.politi.questit

6 Reply by Jim Bacon

  • Jim Bacon
  • Veteran
  • Offline
  • From: BRC
  • Registered: 03-11-2008
  • Posts: 980

Re: pg_connect() error

Hi Carlo

I had the following reports by default which worked:

Report Name: Library > Occurrences > Verification grid report 3
Report for map output: Library > Occurrences > Verification map report 3
Report for record details: Reports for Prebuilt Forms > Verification 3 > Record data for verification
Report for record attributes: Reports for Prebuilt Forms > Verification 3 > Record attributes for verification

but it also works for me with the reports that you have selected.

To make the map visible I had to also check the options:
Other Map Settings > show map of the currently selected records
Base Map Layers > Google Physical

However, I see from your other post that you have perhaps fixed this problem and moved on. If so, can you reply with your solution.

Jim Bacon.

7 Reply by carlo_politi

  • carlo_politi
  • Veteran
  • Offline
  • Registered: 25-01-2013
  • Posts: 147

Re: pg_connect() error

Hi Jim, i opened an other thread to separate problems because it's on an other installation, not the production one, where i have the problem i don't see map values for verification records... the pg_connect error is on a test installation...

i tried to check "Other Map Settings" but it was in that case i get error i get in the other post and also, i noticed now i get this message: "The report's configuration does not output any mappable data"...

Carlo Politi - Software Engineer
QuestIT s.r.l.
Home page: www.quest-it.com
E-Mail: politi@quest-it.com - Skype: carlo.politi.questit

8 Reply by Jim Bacon

  • Jim Bacon
  • Veteran
  • Offline
  • From: BRC
  • Registered: 03-11-2008
  • Posts: 980

Re: pg_connect() error

Hi Carlo,

A report queries the Warehouse database and returns information.
The fields returned are defined in the report file.
When you pick a report from a list you are picking a report file from the /reports folder on the Warehouse.
If the report does not contain any geographical information you cannot draw a map.
In this case you receive the message "The report's configuration does not output any mappable data".
You need to choose a different report for map output.

Jim Bacon.