Opened 9 years ago

Closed 9 years ago

Last modified 9 years ago

#2813 closed defect (worksforme)

Problems connecting to localhost pgsql in nomatim

Reported by: James Michael DuPont Owned by: openstreetmap@…
Priority: trivial Milestone:
Component: nominatim Version:
Keywords: php Cc:

Description

I have problems connecting to the database using DB This works :

psql -h localhost gisdb gis

I installed pear install MDB2_Driver_pgsql.

Now I am reworking the code for using the PDO.

Attachments (2)

test.php (226 bytes) - added by James Michael DuPont 9 years ago.
failing test connect
patch.txt (7.5 KB) - added by James Michael DuPont 9 years ago.
New patch with website

Download all attachments as: .zip

Change History (5)

Changed 9 years ago by James Michael DuPont

Attachment: test.php added

failing test connect

comment:1 Changed 9 years ago by James Michael DuPont

It works now! patch for website so far.

New test results with new patch: php ./util.update.php --index Rank: 0, total to do: 0 Rank: 1, total to do: 0 Rank: 2, total to do: 0 Rank: 3, total to do: 0 Rank: 4, total to do: 2 480458: 1, 2 remaining (17:35:28) 480459: 1, 1 remaining (17:35:28) Finished Rank: 4 in 1 @ 2 per second Rank: 5, total to do: 0 Rank: 6, total to do: 0 Rank: 7, total to do: 0 Rank: 8, total to do: 3 480458: 3, 3 remaining (17:35:29) Rank: 9, total to do: 0 Rank: 10, total to do: 45 480458: 36, 45 remaining (17:35:29) 479458: 3, 9 remaining (17:35:29) 481458: 6, 6 remaining (17:35:29) Rank: 11, total to do: 0 Rank: 12, total to do: 18 480458: 17, 18 remaining (17:35:29) 481458: 1, 1 remaining (17:35:29) Rank: 13, total to do: 0 Rank: 14, total to do: 0 Rank: 15, total to do: 0 Rank: 16, total to do: 8 480459: 3, 8 remaining (17:35:29) 481460: 1, 5 remaining (17:35:29) 481458: 1, 4 remaining (17:35:29) 481459: 1, 3 remaining (17:35:30) 480458: 2, 2 remaining (17:35:30) Finished Rank: 16 in 1 @ 8 per second Rank: 17, total to do: 30 480459: 9, 30 remaining (17:35:30) 480460: 5, 21 remaining (17:35:30) 479458: 1, 16 remaining (17:35:30) 479459: 2, 15 remaining (17:35:30) 480457: 1, 13 remaining (17:35:30) 480458: 10, 12 remaining (17:35:30) 481458: 2, 2 remaining (17:35:31) Finished Rank: 17 in 1 @ 30 per second Rank: 18, total to do: 1006 481458: 113, 1006 remaining (17:35:31) 481459: 1, 893 remaining (17:35:32) 479458: 96, 892 remaining (17:35:32) 480460: 44, 796 remaining (17:35:34) 480458: 649, 752 remaining (17:35:35) 480457: 86, 103 remaining (17:35:45) 479459: 9, 17 remaining (17:35:47) 479460: 8, 8 remaining (17:35:47) Finished Rank: 18 in 16 @ 62.875 per second Rank: 19, total to do: 0 Rank: 20, total to do: 98 479458: 5, 98 remaining (17:35:47) 481458: 24, 93 remaining (17:35:47) 479459: 2, 69 remaining (17:35:48) 480457: 39, 67 remaining (17:35:48) 480458: 28, 28 remaining (17:35:49) Finished Rank: 20 in 2 @ 49 per second Rank: 21, total to do: 15 479458: 10, 15 remaining (17:35:49) 480459: 3, 5 remaining (17:35:49) 480460: 1, 2 remaining (17:35:49) 481460: 1, 1 remaining (17:35:49) Rank: 22, total to do: 42 480459: 3, 42 remaining (17:35:49) 481458: 16, 39 remaining (17:35:50) 479459: 1, 23 remaining (17:35:50) 480458: 22, 22 remaining (17:35:50) Finished Rank: 22 in 1 @ 42 per second Rank: 23, total to do: 0 Rank: 24, total to do: 0 Rank: 25, total to do: 1 480458: 1, 1 remaining (17:35:50) Rank: 26, total to do: 377 479458: 4, 377 remaining (17:35:50) 479459: 6, 373 remaining (17:35:50) 479460: 2, 367 remaining (17:35:51) 480457: 2, 365 remaining (17:35:51) 480458: 49, 363 remaining (17:35:51) 480459: 159, 314 remaining (17:35:52) 480460: 25, 155 remaining (17:35:55) 481458: 121, 130 remaining (17:35:56) 481459: 8, 9 remaining (17:35:58) 481460: 1, 1 remaining (17:35:59) Finished Rank: 26 in 9 @ 41.8888888889 per second Rank: 27, total to do: 6 481458: 6, 6 remaining (17:35:59) Rank: 28, total to do: 0 Rank: 29, total to do: 0 Rank: 30, total to do: 1010 481457: 7, 1010 remaining (17:35:59) 479459: 53, 1003 remaining (17:36:00) 481460: 3, 950 remaining (17:36:01) 479460: 32, 947 remaining (17:36:01) 481458: 119, 915 remaining (17:36:02) 480459: 108, 796 remaining (17:36:04) 481459: 42, 688 remaining (17:36:07) 479458: 75, 646 remaining (17:36:08) 480460: 99, 571 remaining (17:36:10) 480458: 366, 472 remaining (17:36:12) 480457: 106, 106 remaining (17:36:19) Finished Rank: 30 in 22 @ 45.9090909091 per second

Changed 9 years ago by James Michael DuPont

Attachment: patch.txt added

New patch with website

comment:2 Changed 9 years ago by twain

Priority: majortrivial
Resolution: worksforme
Status: newclosed

$oDB =& DB::connect('pgsql://gis@/localhost/gisdb', false);

should have been

$oDB =& DB::connect('pgsql://gis@localhost/gisdb', false);

comment:3 Changed 9 years ago by James Michael DuPont

Thanks, thats great.

Note: See TracTickets for help on using tickets.