[Tile-serving] [openstreetmap/osm2pgsql] ssl error while loading data with osm2pgsql (#1429)

[Rémy Léone]

I've tried loading data in a posgresql database serving requests over TLS.

I get the following errors:

```
$ osm2pgsql --password --host 51.159.113.252 --username admin --port 37888 -d gis --create --slim -G --hstore --tag-transform-script ~/workspace/openstreetmap-carto/openstreetmap-carto.lua -C 2500 --number-processes 1 -S ~/workspace/openstreetmap-carto/openstreetmap-carto.style azerbaijan-latest.osm.pbf
2021-03-15 22:18:21  osm2pgsql version 1.4.1
Password:
2021-03-15 22:18:22  Database version: 12.5 (Debian 12.5-1.pgdg100+1)
2021-03-15 22:18:22  PostGIS version: 3.1
2021-03-15 22:18:22  Node-cache: cache=2500MB, maxblocks=40000*65536, allocation method=11
2021-03-15 22:18:23  Setting up table 'planet_osm_point'
2021-03-15 22:18:23  Setting up table 'planet_osm_line'
2021-03-15 22:18:23  Setting up table 'planet_osm_polygon'
2021-03-15 22:18:23  Setting up table 'planet_osm_roads'
Processing: Node(1300k 1300.0k/s) Way(0k 0.00k/s) Relation(0 0.0/s)2021-03-15 22:18:27  ERROR: planet_osm_nodes - error on COPY: SSL error: sslv3 alert bad record mac

2021-03-15 22:18:27  ERROR: Data: 2894006076	403023702	470259297
2894006077	403027227	470277413
2894006078	403031362	470297009
2894006079	403036814	470322766
2894006080	403037424	470326217
2894006081	403037612	470331147
2894006082	403039022	470362573
2894006083	403040526	470394432
2894006084	403040902	470405585
2894006085	403041842	470414766
2894006086	403043111	470430418
2894006087	403044802	470452971
2894006088	403046165	470468192
2894006089	403047199	470482611
2894006090	403047810	470491731
2894006091	403047951	470494812
2894
...
829
3177650410	385949713	488327353
3177650411	385950406	488304036
3177650412	385950725	488347604
3177650413	385951456	488301349
3177650414	385952076	488325942
3177650415	385952247	488342633
3177650416	385952297	488315547
3177650417	385952979	488293758
3177650418	385953245	488340081
3177650419	385954701	488316921
3177650420	385954715	488337797
3177650421	385955131	488279181
3177650422	385955489	488304897
3177650423	385956276	488307114
3177650424	385956486	488321576
3177650425	385956657	488335714

2021-03-15 22:18:27  ERROR: DB copy thread failed: COPYing data to Postgresql.
```

I've installed osm2pgsql using homebrew. Here are the dynamic libraries used:

```
$ otool -L /usr/local/bin/osm2pgsql
/usr/local/bin/osm2pgsql:
	/usr/local/opt/boost/lib/libboost_system-mt.dylib (compatibility version 0.0.0, current version 0.0.0)
	/usr/local/opt/boost/lib/libboost_filesystem-mt.dylib (compatibility version 0.0.0, current version 0.0.0)
	/usr/local/opt/postgresql/lib/libpq.5.dylib (compatibility version 5.0.0, current version 5.13.0)
	/usr/lib/libz.1.dylib (compatibility version 1.0.0, current version 1.2.11)
	/usr/lib/libexpat.1.dylib (compatibility version 7.0.0, current version 8.0.0)
	/usr/lib/libbz2.1.0.dylib (compatibility version 1.0.0, current version 1.0.5)
	/usr/local/opt/proj/lib/libproj.19.dylib (compatibility version 22.0.0, current version 22.1.0)
	/usr/local/opt/luajit-openresty/lib/libluajit-5.1.2.dylib (compatibility version 2.1.0, current version 2.1.0)
	/usr/lib/libc++.1.dylib (compatibility version 1.0.0, current version 904.4.0)
	/usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 1292.60.1)
```

-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/1429
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20210315/174a1f60/attachment.htm>