span8
span4
我很高兴地通知您,开发已经解决了这个问题。PostgreSQL现在应该在FME 2018.0版本18195+的Linux上支持SSL。2018测试版可从以下网站获得https://www.亚搏在线safe.com/downloads/beta,而2018.0将于今年3月发布。
请让我知道你是否有任何问题,并为任何不便道歉。
您确定这不是您的FME主机没有访问Postgres数据库权限的问题吗?
从你的日志:
'致命:没有pg_hba.conf条目为主机“10.42.32.75”,用户“titta”,数据库“地理数据”,SSL关闭
这部分日志指向您的FME来自10.42.32.75,它没有在pg_hba.conf中列出,因此被拒绝。
所以你可能想要改变这种测试方式
主机all all::1/128 md5
:
宿主所有所有的0.0.0.0/0 md5
主机所有的所有::/0 md5
这是我的日志:
PostGIS模块的FME API版本匹配当前内部版本(3.8 20170315)PostGIS Trying to find a DYNAMIC plugin for reader named `POSTGIS' FME API version of module 'POSTGIS' matches current internal version (3.8 20170315) Opening POSTGIS reader for dataset 'geodata' Error connecting to PostgreSQL database(host='10.3.1.147', port='15432', dbname='geodata', user='titta', password='***'): 'FATAL: no pg_hba.conf entry for host "10.42.32.75", user "titta", database "geodata", SSL off ' Successfully closed POSTGIS database reader Reader failed in open() call Failed to obtain any schemas from reader 'POSTGIS' from 1 datasets.这可能是由于无效的数据集或由于许可、依赖项或模块加载而导致的格式可访问性问题。有关详细信息,请参阅UniversalReader日志文件 - readSchema结果为0的模式特征被返回读卡器参数(0)=>地理数据<阅读器参数(1)=> READ_SCHEMA_MODE <阅读器参数(2)=> SCHEMALIST <阅读器参数(3)=>HOST <阅读器参数(4)=> 10.3.1.147 <阅读器参数(5)=> PORT <阅读器参数(6)=> 15432 <阅读器参数(7)=> USER_NAME <阅读器参数(8)=> titta <阅读器 Parameter(9) = >PASSWORD< Reader Parameter(10) = >********< Reader Parameter(11) = >_MERGE_SCHEMAS< Reader Parameter(12) = >YES< Reader Parameter(13) = >RETRIEVE_ALL_TABLE_NAMES< Reader Parameter(14) = >YES< Reader Directive(0) = >RUNTIME_MACROS< Reader Directive(1) = >READ_SCHEMA_MODE,SCHEMALIST,HOST,10.3.1.147,PORT,15432,USER_NAME,titta,PASSWORD,********,_MERGE_SCHEMAS,YES,RETRIEVE_ALL_TABLE_NAMES,YES< Configuration object contents: FME Temporary Folder: /tmp mapping file Line 0: `APPLICATION' `FME_WORKBENCH' mapping file Line 1: `AUTOREG' `YES' mapping file Line 2: `LOG_ENCODING' `UTF-8' mapping file Line 3: `LOG_MAX_FEATURES' `-1' mapping file Line 4: `LOG_APPEND' `NO' mapping file Line 5: `FME_HOME' `/opt/fme-desktop-2017/' mapping file Line 6: `FME_SESSION_USED' `TRUE' mapping file Line 7: `R_4_METAFILE' `POSTGIS' mapping file Line 8: `R_4_DATASET' `geodata' mapping file Line 9: `R_4_READ_SCHEMA_MODE' `SCHEMALIST' mapping file Line 10: `R_4_HOST' `10.3.1.147' mapping file Line 11: `R_4_PORT' `15432' mapping file Line 12: `R_4_USER_NAME' `titta' mapping file Line 13: `R_4__MERGE_SCHEMAS' `YES' mapping file Line 14: `R_4_RETRIEVE_ALL_TABLE_NAMES' `YES' mapping file Line 15: `R_4_READ_SCHEMA_MODE' `SCHEMALIST' mapping file Line 16: `R_4_HOST' `10.3.1.147' mapping file Line 17: `R_4_PORT' `15432' mapping file Line 18: `R_4_USER_NAME' `titta' mapping file Line 19: `R_4__MERGE_SCHEMAS' `YES' mapping file Line 20: `R_4_MERGE_SCHEMAS' `YES' mapping file Line 21: `R_4_RETRIEVE_ALL_TABLE_NAMES' `YES' mapping file Line 22: `SCHEMA_TIME' `YES' mapping file Keyword: `SCHEMA_TIME' occurs 1 time(s) mapping file Keyword: `R_4_HOST' occurs 2 time(s) mapping file Keyword: `R_4_PORT' occurs 2 time(s) mapping file Keyword: `R_4_PASSWORD' occurs 2 time(s) mapping file Keyword: `R_4_USER_NAME' occurs 2 time(s) mapping file Keyword: `FME_SESSION_USED' occurs 1 time(s) mapping file Keyword: `AUTOREG' occurs 1 time(s) mapping file Keyword: `LOG_MAX_FEATURES' occurs 1 time(s) mapping file Keyword: `R_4_METAFILE' occurs 1 time(s) mapping file Keyword: `LOG_APPEND' occurs 1 time(s) mapping file Keyword: `APPLICATION' occurs 1 time(s) mapping file Keyword: `FME_HOME' occurs 1 time(s) mapping file Keyword: `R_4_READ_SCHEMA_MODE' occurs 2 time(s) mapping file Keyword: `R_4_RETRIEVE_ALL_TABLE_NAMES' occurs 2 time(s) mapping file Keyword: `R_4__MERGE_SCHEMAS' occurs 2 time(s) mapping file Keyword: `R_4_MERGE_SCHEMAS' occurs 1 time(s) mapping file Keyword: `R_4_DATASET' occurs 1 time(s) mapping file Keyword: `LOG_ENCODING' occurs 1 time(s) UniversalReader -- readSchema resulted in 0 schema features being returned Failed to obtain any schemas from reader 'POSTGIS' from 1 datasets.这可能是由于无效的数据集或由于许可、依赖项或模块加载而导致的格式可访问性问题。请参阅日志文件以获取更多信息成功关闭POSTGIS数据库读卡器
嗨@henrikuggla。FME 2015+支持SSL在Postgres / PostGIS的但有没有配置它的参数。如果您需要的功能配置,还有一个增强请求PR 52876,我可以将你加入?
嗨@NatalieAt亚搏在线Safe。我不明白你说的“FME 2015+通过Postgres / PostGIS支持SSL”是什么意思。如果我将Postgresql设置为需要ssl,那么读取器和写入器都将失败。FME日志上清楚地写着“ssl关闭”。我该怎么做才能成功?
©2020安全亚搏在线软件公司|法律