1 Topic by dhr

  • dhr
  • New member
  • Offline
  • Registered: 23-05-2013
  • Posts: 4

Topic: pg_connect errors in Instant Indicia

Hi,

I'm new to Indicia and Drupal, though by no means new to web development.

I'm setting up a warehouse & Indicia/Drupal install for a client. Whilst I had some fun and games in doing so, I (believe I) got there in the end; I can log in, edit things etc.

When I view the Drupal Indicia install, I see a lot of this, where I suppose I should be seeing items (or nothing, since I have not added any records):

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

Now, I assume this is being spat out by the warehouse. However I can log in to the warehouse, create people/users/lists etc.

Has anyone ever seen this and successfully solved it?

Thanks,
David

2 Reply by Jim Bacon

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

Re: pg_connect errors in Instant Indicia

Hi David

Sounds like your warehouse is tolerably happy. It is not clear to me how far you have got with your Drupal install though. Are you following some instructions and can you tell us how far you have got? The Drupal/Indicia client will make no effort to communicate with the warehouse until you start configuring it and telling it to do so.

An idle thought. What database are you using as the backend for Drupal? You could have chosen PostgreSQL although everyone I know uses MySQL.

Jim Bacon.

3 Reply by dhr (edited by dhr 23-05-2013 15:57:40)

  • dhr
  • New member
  • Offline
  • Registered: 23-05-2013
  • Posts: 4

Re: pg_connect errors in Instant Indicia

Hi Jim,

Thanks for your fast reply.

Drupal is all installed and configured (to a basic level, to have a 'running site' at least). I have added the Website ID and password as defined in the Warehouse admin, and Indicia tells me the Warehouse is responding to POST requests ok.

I updated Drupal to 2.68 as advised when I logged in (though I haven't updated the various modules yet). Drupal is using MySQL.

I've attached a screenshot if it helps. As I say, this error message is displayed wherever I'd expect some output from the warehouse

Post's attachments

pg_connect.jpg 90.41 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.

4 Reply by dhr

  • dhr
  • New member
  • Offline
  • Registered: 23-05-2013
  • Posts: 4

Re: pg_connect errors in Instant Indicia

Is there an easy or quick way I can test a warehouse query from a PHP script? Just to see if it is indeed the warehouse that's having the issue.

5 Reply by Jim Bacon

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

Re: pg_connect errors in Instant Indicia

Hi David,

If you go to the warehouse home page it probably says something like "You can see Indicia in action on the website demonstration pages."  I'm wondering if that might do what you need by way of a test. Or there is a tutorial for building a simple PHP recording form without all the Drupal clutter. Not super quick but it would be instructive.

If I were to start looking somewhere I would take a peek in the warehouse application/config/database.php file. It defines the credentials used by the application for connecting to postgres. We use two postgresql accounts, both of which need to exist in the database, one for writing data and the other, with lower permissions, for reporting. However, the installation instructions only mention creating one user. I guess unless you manually add the second user then the one user satisfies both needs.

I found a related thread in the forum.

Jim Bacon.

6 Reply by dhr

  • dhr
  • New member
  • Offline
  • Registered: 23-05-2013
  • Posts: 4

Re: pg_connect errors in Instant Indicia

Hi Jim,

Thanks for the tip about the second user. No, it wasn't mentioned in the install - there was a blank entry (hence 'user name not defined').

I've created a user and added its details and we're all good.

Thanks for your help!

David