[unixODBC][Driver Manager]Can’t open lib ‘SQL Server’
I get that error, the library is installed and I can’t get it to work, please help
It’s hard to help without being able to reproduce it, but it must be a common issue not directly related with Manticore, e.g. this SO thread may be helpful Linux python3 - Can't open lib 'SQL Server' - Stack Overflow
If you still can’t solve it, please provide more details:
- the source in the configuration file
- info about the installed library
- Manticore version
this my manticore.conf
searchd {
listen = 127.0.0.1:9312
listen = 127.0.0.1:9306:mysql
listen = 127.0.0.1:9308:http
log = /var/log/manticore/searchd.log
query_log = /var/log/manticore/query.log
pid_file = /run/manticore/searchd.pid
query_log_format = sphinxql
binlog_path = /var/lib/manticore/binlog
collation_server = utf8_general_ci
}
#CONFIGURACION SQL SERVER
source mybase {
type = mssql
sql_host = 10.1.27.11/Superlo
sql_user = admin
sql_pass = miadmin
sql_db = mybase
sql_query = SELECT * FROM Resultado WHERE IdResultado BETWEEN 1 AND 100
sql_attr_uint= IdResultado
sql_field_string=IdJuicio
sql_field_string=Materia
sql_field_string=TipoAccin
sql_field_string=Delito
sql_field_string=Nombres
sql_field_string=Identificacion
sql_field_string=IdJudicatura
sql_attr_uint=IdIncidenteJudicatura
sql_attr_uint=IdMovimientoJuicioIncidente
sql_field_string=TablaReferencia
sql_field_string=IdTablaReferencia
sql_field_string=NombreProvidencia
sql_field_string=FechaActividad
sql_attr_uint=idTipoDocumento
sql_field_string=Texto
sql_field_string=GeneradoOCR
sql_field_string=UUID
sql_field_string=Alias
sql_field_string=Visible
sql_field_string=NombreArchivo
sql_attr_uint=Size
sql_field_string=estado
sql_field_string=FechaCrea
sql_field_string=FechaModifica
}
index consultar {
type=plain
source = mybase
path =/opt/manticore/data/consultar
stopwords= es, la
}
#FIN CONFIGURACION SQL SERVER
this error
ERROR: table ‘consultar’: sql_connect: [unixODBC][Driver Manager]Can’t open lib ‘SQL Server’ : file not found (DSN=odbc://miadmin:***@10.1.27.11/Superlo:0/mybase).
please help me