A
A
Alexander Semenenko2016-11-24 17:17:47
PostgreSQL
Alexander Semenenko, 2016-11-24 17:17:47

External data sources 1c on linux server not working on Centos, why?

We have a 1c server on Centos x64. And the 1c server itself has a bit depth of i386.
Installed postgresql-odbc.x86_64 to connect external data sources.
Next, I configured the /etc/odbcinst.ini file

[PostgreSQL-U]
Description     = PostgreSQL ODBC driver (Unicode version)
Driver          = /usr/lib64/psqlodbcw.so
Setup           = /usr/lib64/libodbcpsqlS.so
Debug           = 0
CommLog         = 1
UsageCount	= 1

I checked that the libraries exist:
ls -l /usr/lib64/psqlodbcw.so
-rwxr-xr-x 1 root root 519496 Авг 23  2010 /usr/lib64/psqlodbcw.so

And when I connect external data sources from 1s, I get an error:
ODBC error SQLSTATE: 010000
Error number: 0
Description: [unixODBC][Driver Manager]Can't open lib '/usr/lib64/psqlodbcw.so' : file not found
String data connections:
DRIVER={PostgreSQL-U};Database=имя_базы;Server=имя_сервера_баз_данных;

Why 1C does not see this library, because it is on the specified path, I tried to give everyone the rights to this library, but it did not help. Or how can you see how 1C is looking for this library? Can you tell me, can I connect from the Centos console, and not from 1C?
Thanks in advance!

Answer the question

In order to leave comments, you need to log in

2 answer(s)
S
SofroN, 2016-11-25
@semenenko88

1C i386 server cannot use x86_64 libraries.
Bit depth should be the same.
1C i386 server on linux x86_64 system is still a hemorrhoid.

V
Vladimir Kuzin, 2016-11-25
@Bobson8

As already mentioned here - it's about the bitness of the OS and 1C. Find libraries for the 32-bit version, drop them into the /usr/lib/ folder, overwrite the path in the config. Should work.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question