Как установить DB2 ODBC?

Question 1

Я пытался, без каких-либо успехов, установить драйвер IBM ODBC, чтобы мой PHP-сервер мог подключиться к базе данных. Я попытался установить db2_connect и получить всевозможные проблемы, я попробовал установить I Access для Linux, и RPM не установил права и не использовал чужой породы какие-либо полезные результаты. Я также пробовал DB2 Runtime v8.1, не добился успеха.

Если я пытаюсь запустить rpm, он утверждает, что мне нужны зависимости, которые я не могу найти в apt-get. Yum также не очень полезен, так как кажется, что у меня нет каких-либо репозиториев, установленных или списков ...

Запуск простого RPM дает мне этот результат в терминале:

# rpm -ivh iSeriesAccess-7.1.0-1.0.x86_64.rpm
rpm: RPM should not be used directly install RPM packages, use Alien instead!
rpm: However assuming you know what you are doing...
error: Failed dependencies:
    /bin/ln is needed by iSeriesAccess-7.1.0-1.0.x86_64
    /sbin/ldconfig is needed by iSeriesAccess-7.1.0-1.0.x86_64
    /bin/rm is needed by iSeriesAccess-7.1.0-1.0.x86_64
    /bin/sh is needed by iSeriesAccess-7.1.0-1.0.x86_64
    libc.so.6()(64bit) is needed by iSeriesAccess-7.1.0-1.0.x86_64
    libc.so.6(GLIBC_2.2.5)(64bit) is needed by iSeriesAccess-7.1.0-1.0.x86_64
    libc.so.6(GLIBC_2.3)(64bit) is needed by iSeriesAccess-7.1.0-1.0.x86_64
    libdl.so.2()(64bit) is needed by iSeriesAccess-7.1.0-1.0.x86_64
    libdl.so.2(GLIBC_2.2.5)(64bit) is needed by iSeriesAccess-7.1.0-1.0.x86_64
    libgcc_s.so.1()(64bit) is needed by iSeriesAccess-7.1.0-1.0.x86_64
    libm.so.6()(64bit) is needed by iSeriesAccess-7.1.0-1.0.x86_64
    libm.so.6(GLIBC_2.2.5)(64bit) is needed by iSeriesAccess-7.1.0-1.0.x86_64
    libodbcinst.so.1()(64bit) is needed by iSeriesAccess-7.1.0-1.0.x86_64
    libodbc.so.1()(64bit) is needed by iSeriesAccess-7.1.0-1.0.x86_64
    libpthread.so.0()(64bit) is needed by iSeriesAccess-7.1.0-1.0.x86_64
    libpthread.so.0(GLIBC_2.2.5)(64bit) is needed by iSeriesAccess-7.1.0-1.0.x86_64
    libpthread.so.0(GLIBC_2.3.2)(64bit) is needed by iSeriesAccess-7.1.0-1.0.x86_64
    librt.so.1()(64bit) is needed by iSeriesAccess-7.1.0-1.0.x86_64
    librt.so.1(GLIBC_2.2.5)(64bit) is needed by iSeriesAccess-7.1.0-1.0.x86_64
    libstdc++.so.6()(64bit) is needed by iSeriesAccess-7.1.0-1.0.x86_64
    libstdc++.so.6(CXXABI_1.3)(64bit) is needed by iSeriesAccess-7.1.0-1.0.x86_64
    libstdc++.so.6(GLIBCXX_3.4)(64bit) is needed by iSeriesAccess-7.1.0-1.0.x86_64

Использование чужой и запуск dkpg дает мне хэдлайт:

$ alien iSeriesAccess-7.1.0-1.0.x86_64.rpm --scripts
# dpkg -i iseriesaccess_7.1.0-2_amd64.deb
(Reading database ... 127664 files and directories currently installed.)
Preparing to replace iseriesaccess 7.1.0-2 (using iseriesaccess_7.1.0-2_amd64.deb) ...
Unpacking replacement iseriesaccess ...
post uninstall processing for iSeriesAccess 1.0...upgrade
/var/lib/dpkg/info/iseriesaccess.postrm: line 8: [: upgrade: integer expression expected
Setting up iseriesaccess (7.1.0-2) ...
post install processing for iSeriesAccess 1.0...configure
iSeries Access ODBC Driver has been deleted (if it existed at all) because its usage count became zero
odbcinst: Driver installed. Usage count increased to 1.
Target directory is /etc
odbcinst: Driver installed. Usage count increased to 3.
Target directory is /etc
Processing triggers for libc-bin ...
ldconfig deferred processing now taking place

Итак, кажется, что файлы установлены правильно, ну, как показывает мой драйвер odbc, но db2cli.ini не где найти.

Итак, несколько вопросов. Есть ли лучшая альтернатива для подключения php к db2, скажем, пакет ubuntu, который я могу просто установить? Может ли кто-нибудь направить меня к шагам, которые делают мой сервер ubuntu хорошо работать с RPM, чтобы я мог создать свой экземпляр db2?

Также помните, что я подключаюсь к I-й серии удаленно. Я не использую DB2 Express C, даже если бы я попытался использовать функции phb db2. И у меня нет zend, но я думаю, что у меня есть все остальные пакеты в репозиториях ubuntu. Помогите, спасибо!

Question 2

Я делаю так:

1. sudo apt-get install php5-odbc alien

2. alien –i –c iSeriesAccess-6.1.0-1.2.x86_64.rpm

3. nano /etc/odbc.ini

[DATASOURCE NAME] 
Description = iSeries Access ODBC Driver DSN for iSeries 
Driver = iSeries Access ODBC Driver 
System = IP ADDRESS OF YOUR iSERIES 
UserID = 
Password = 
Naming = 0 
DefaultLibraries = QGPL 
Database = YOUR DATABASE
ConnectionType = 0 
CommitMode = 2 
ExtendedDynamic = 0 
DefaultPkgLibrary = QGPL 
DefaultPackage = A/DEFAULT(IBM),2,0,1,0,512 
AllowDataCompression = 1 
LibraryView = 0 
AllowUnsupportedChar = 0 
ForceTranslation = 0 
Trace = 0 
CCSID = 1208

Question 3

Question 4

Я делаю так:

1. sudo apt-get install php5-odbc alien

2. alien –i –c iSeriesAccess-6.1.0-1.2.x86_64.rpm

3. nano /etc/odbc.ini

[DATASOURCE NAME] 
Description = iSeries Access ODBC Driver DSN for iSeries 
Driver = iSeries Access ODBC Driver 
System = IP ADDRESS OF YOUR iSERIES 
UserID = 
Password = 
Naming = 0 
DefaultLibraries = QGPL 
Database = YOUR DATABASE
ConnectionType = 0 
CommitMode = 2 
ExtendedDynamic = 0 
DefaultPkgLibrary = QGPL 
DefaultPackage = A/DEFAULT(IBM),2,0,1,0,512 
AllowDataCompression = 1 
LibraryView = 0 
AllowUnsupportedChar = 0 
ForceTranslation = 0 
Trace = 0 
CCSID = 1208

Question 5

Я делаю так:

1. sudo apt-get install php5-odbc alien

2. alien –i –c iSeriesAccess-6.1.0-1.2.x86_64.rpm

3. nano /etc/odbc.ini

[DATASOURCE NAME] 
Description = iSeries Access ODBC Driver DSN for iSeries 
Driver = iSeries Access ODBC Driver 
System = IP ADDRESS OF YOUR iSERIES 
UserID = 
Password = 
Naming = 0 
DefaultLibraries = QGPL 
Database = YOUR DATABASE
ConnectionType = 0 
CommitMode = 2 
ExtendedDynamic = 0 
DefaultPkgLibrary = QGPL 
DefaultPackage = A/DEFAULT(IBM),2,0,1,0,512 
AllowDataCompression = 1 
LibraryView = 0 
AllowUnsupportedChar = 0 
ForceTranslation = 0 
Trace = 0 
CCSID = 1208

Question 6

Я делаю так:

1. sudo apt-get install php5-odbc alien

2. alien –i –c iSeriesAccess-6.1.0-1.2.x86_64.rpm

3. nano /etc/odbc.ini

[DATASOURCE NAME] 
Description = iSeries Access ODBC Driver DSN for iSeries 
Driver = iSeries Access ODBC Driver 
System = IP ADDRESS OF YOUR iSERIES 
UserID = 
Password = 
Naming = 0 
DefaultLibraries = QGPL 
Database = YOUR DATABASE
ConnectionType = 0 
CommitMode = 2 
ExtendedDynamic = 0 
DefaultPkgLibrary = QGPL 
DefaultPackage = A/DEFAULT(IBM),2,0,1,0,512 
AllowDataCompression = 1 
LibraryView = 0 
AllowUnsupportedChar = 0 
ForceTranslation = 0 
Trace = 0 
CCSID = 1208

Question 7

Question 8

Я делаю так:

1. sudo apt-get install php5-odbc alien

2. alien –i –c iSeriesAccess-6.1.0-1.2.x86_64.rpm

3. nano /etc/odbc.ini

[DATASOURCE NAME] 
Description = iSeries Access ODBC Driver DSN for iSeries 
Driver = iSeries Access ODBC Driver 
System = IP ADDRESS OF YOUR iSERIES 
UserID = 
Password = 
Naming = 0 
DefaultLibraries = QGPL 
Database = YOUR DATABASE
ConnectionType = 0 
CommitMode = 2 
ExtendedDynamic = 0 
DefaultPkgLibrary = QGPL 
DefaultPackage = A/DEFAULT(IBM),2,0,1,0,512 
AllowDataCompression = 1 
LibraryView = 0 
AllowUnsupportedChar = 0 
ForceTranslation = 0 
Trace = 0 
CCSID = 1208

Question 9

Я делаю так:

1. sudo apt-get install php5-odbc alien

2. alien –i –c iSeriesAccess-6.1.0-1.2.x86_64.rpm

3. nano /etc/odbc.ini

[DATASOURCE NAME] 
Description = iSeries Access ODBC Driver DSN for iSeries 
Driver = iSeries Access ODBC Driver 
System = IP ADDRESS OF YOUR iSERIES 
UserID = 
Password = 
Naming = 0 
DefaultLibraries = QGPL 
Database = YOUR DATABASE
ConnectionType = 0 
CommitMode = 2 
ExtendedDynamic = 0 
DefaultPkgLibrary = QGPL 
DefaultPackage = A/DEFAULT(IBM),2,0,1,0,512 
AllowDataCompression = 1 
LibraryView = 0 
AllowUnsupportedChar = 0 
ForceTranslation = 0 
Trace = 0 
CCSID = 1208

Question 10

Я делаю так:

1. sudo apt-get install php5-odbc alien

2. alien -i -c iSeriesAccess-6.1.0-1.2.x86_64.rpm

3. nano /etc/odbc.ini

  [DATASOURCE NAME] Описание = iSeries Access ODBC Драйвер DSN для iSeries Драйвер = iSeries Access ODBC Driver System = IP АДРЕС ВАШИХ ИГРОКОВ  UserID = Password = Naming = 0 DefaultLibraries = QGPL Database = ВАША БАЗА ДАННЫХ ConnectionType = 0 CommitMode = 2 ExtendedDynamic = 0 DefaultPkgLibrary = QGPL DefaultPackage = A / DEFAULT (IBM), 2,0,1,0,512 AllowDataCompression = 1 LibraryView = 0 AllowUnsupportedChar =  0 ForceTranslation = 0 Trace = 0 CCSID = 1208

Question 11

Я делаю так:

1. sudo apt-get install php5-odbc alien

2. alien -i -c iSeriesAccess-6.1.0-1.2.x86_64.rpm

3. nano /etc/odbc.ini

  [DATASOURCE NAME] Описание = iSeries Access ODBC Драйвер DSN для iSeries Драйвер = iSeries Access ODBC Driver System = IP АДРЕС ВАШИХ ИГРОКОВ  UserID = Password = Naming = 0 DefaultLibraries = QGPL Database = ВАША БАЗА ДАННЫХ ConnectionType = 0 CommitMode = 2 ExtendedDynamic = 0 DefaultPkgLibrary = QGPL DefaultPackage = A / DEFAULT (IBM), 2,0,1,0,512 AllowDataCompression = 1 LibraryView = 0 AllowUnsupportedChar =  0 ForceTranslation = 0 Trace = 0 CCSID = 1208

Rinzwind · Accepted Answer · 25 July 2018 в 21:50

Я делаю так:

1. sudo apt-get install php5-odbc alien

2. alien –i –c iSeriesAccess-6.1.0-1.2.x86_64.rpm

3. nano /etc/odbc.ini

[DATASOURCE NAME] 
Description = iSeries Access ODBC Driver DSN for iSeries 
Driver = iSeries Access ODBC Driver 
System = IP ADDRESS OF YOUR iSERIES 
UserID = 
Password = 
Naming = 0 
DefaultLibraries = QGPL 
Database = YOUR DATABASE
ConnectionType = 0 
CommitMode = 2 
ExtendedDynamic = 0 
DefaultPkgLibrary = QGPL 
DefaultPackage = A/DEFAULT(IBM),2,0,1,0,512 
AllowDataCompression = 1 
LibraryView = 0 
AllowUnsupportedChar = 0 
ForceTranslation = 0 
Trace = 0 
CCSID = 1208

Rinzwind · Accepted Answer · 26 July 2018 в 17:08

Я делаю так:

1. sudo apt-get install php5-odbc alien

2. alien –i –c iSeriesAccess-6.1.0-1.2.x86_64.rpm

3. nano /etc/odbc.ini

[DATASOURCE NAME] 
Description = iSeries Access ODBC Driver DSN for iSeries 
Driver = iSeries Access ODBC Driver 
System = IP ADDRESS OF YOUR iSERIES 
UserID = 
Password = 
Naming = 0 
DefaultLibraries = QGPL 
Database = YOUR DATABASE
ConnectionType = 0 
CommitMode = 2 
ExtendedDynamic = 0 
DefaultPkgLibrary = QGPL 
DefaultPackage = A/DEFAULT(IBM),2,0,1,0,512 
AllowDataCompression = 1 
LibraryView = 0 
AllowUnsupportedChar = 0 
ForceTranslation = 0 
Trace = 0 
CCSID = 1208

Rinzwind · Accepted Answer · 2 August 2018 в 03:26

Я делаю так:

1. sudo apt-get install php5-odbc alien

2. alien –i –c iSeriesAccess-6.1.0-1.2.x86_64.rpm

3. nano /etc/odbc.ini

[DATASOURCE NAME] 
Description = iSeries Access ODBC Driver DSN for iSeries 
Driver = iSeries Access ODBC Driver 
System = IP ADDRESS OF YOUR iSERIES 
UserID = 
Password = 
Naming = 0 
DefaultLibraries = QGPL 
Database = YOUR DATABASE
ConnectionType = 0 
CommitMode = 2 
ExtendedDynamic = 0 
DefaultPkgLibrary = QGPL 
DefaultPackage = A/DEFAULT(IBM),2,0,1,0,512 
AllowDataCompression = 1 
LibraryView = 0 
AllowUnsupportedChar = 0 
ForceTranslation = 0 
Trace = 0 
CCSID = 1208

Rinzwind · Accepted Answer · 4 August 2018 в 19:23

Я делаю так:

1. sudo apt-get install php5-odbc alien

2. alien –i –c iSeriesAccess-6.1.0-1.2.x86_64.rpm

3. nano /etc/odbc.ini

[DATASOURCE NAME] 
Description = iSeries Access ODBC Driver DSN for iSeries 
Driver = iSeries Access ODBC Driver 
System = IP ADDRESS OF YOUR iSERIES 
UserID = 
Password = 
Naming = 0 
DefaultLibraries = QGPL 
Database = YOUR DATABASE
ConnectionType = 0 
CommitMode = 2 
ExtendedDynamic = 0 
DefaultPkgLibrary = QGPL 
DefaultPackage = A/DEFAULT(IBM),2,0,1,0,512 
AllowDataCompression = 1 
LibraryView = 0 
AllowUnsupportedChar = 0 
ForceTranslation = 0 
Trace = 0 
CCSID = 1208

Rinzwind · Accepted Answer · 6 August 2018 в 03:34

Я делаю так:

1. sudo apt-get install php5-odbc alien

2. alien –i –c iSeriesAccess-6.1.0-1.2.x86_64.rpm

3. nano /etc/odbc.ini

[DATASOURCE NAME] 
Description = iSeries Access ODBC Driver DSN for iSeries 
Driver = iSeries Access ODBC Driver 
System = IP ADDRESS OF YOUR iSERIES 
UserID = 
Password = 
Naming = 0 
DefaultLibraries = QGPL 
Database = YOUR DATABASE
ConnectionType = 0 
CommitMode = 2 
ExtendedDynamic = 0 
DefaultPkgLibrary = QGPL 
DefaultPackage = A/DEFAULT(IBM),2,0,1,0,512 
AllowDataCompression = 1 
LibraryView = 0 
AllowUnsupportedChar = 0 
ForceTranslation = 0 
Trace = 0 
CCSID = 1208

Rinzwind · Accepted Answer · 7 August 2018 в 21:23

Я делаю так:

1. sudo apt-get install php5-odbc alien

2. alien –i –c iSeriesAccess-6.1.0-1.2.x86_64.rpm

3. nano /etc/odbc.ini

[DATASOURCE NAME] 
Description = iSeries Access ODBC Driver DSN for iSeries 
Driver = iSeries Access ODBC Driver 
System = IP ADDRESS OF YOUR iSERIES 
UserID = 
Password = 
Naming = 0 
DefaultLibraries = QGPL 
Database = YOUR DATABASE
ConnectionType = 0 
CommitMode = 2 
ExtendedDynamic = 0 
DefaultPkgLibrary = QGPL 
DefaultPackage = A/DEFAULT(IBM),2,0,1,0,512 
AllowDataCompression = 1 
LibraryView = 0 
AllowUnsupportedChar = 0 
ForceTranslation = 0 
Trace = 0 
CCSID = 1208

Rinzwind · Accepted Answer · 10 August 2018 в 09:41

Я делаю так:

1. sudo apt-get install php5-odbc alien

2. alien -i -c iSeriesAccess-6.1.0-1.2.x86_64.rpm

3. nano /etc/odbc.ini

  [DATASOURCE NAME] Описание = iSeries Access ODBC Драйвер DSN для iSeries Драйвер = iSeries Access ODBC Driver System = IP АДРЕС ВАШИХ ИГРОКОВ  UserID = Password = Naming = 0 DefaultLibraries = QGPL Database = ВАША БАЗА ДАННЫХ ConnectionType = 0 CommitMode = 2 ExtendedDynamic = 0 DefaultPkgLibrary = QGPL DefaultPackage = A / DEFAULT (IBM), 2,0,1,0,512 AllowDataCompression = 1 LibraryView = 0 AllowUnsupportedChar =  0 ForceTranslation = 0 Trace = 0 CCSID = 1208

Rinzwind · Accepted Answer · 13 August 2018 в 15:53

Я делаю так:

1. sudo apt-get install php5-odbc alien

2. alien -i -c iSeriesAccess-6.1.0-1.2.x86_64.rpm

3. nano /etc/odbc.ini

  [DATASOURCE NAME] Описание = iSeries Access ODBC Драйвер DSN для iSeries Драйвер = iSeries Access ODBC Driver System = IP АДРЕС ВАШИХ ИГРОКОВ  UserID = Password = Naming = 0 DefaultLibraries = QGPL Database = ВАША БАЗА ДАННЫХ ConnectionType = 0 CommitMode = 2 ExtendedDynamic = 0 DefaultPkgLibrary = QGPL DefaultPackage = A / DEFAULT (IBM), 2,0,1,0,512 AllowDataCompression = 1 LibraryView = 0 AllowUnsupportedChar =  0 ForceTranslation = 0 Trace = 0 CCSID = 1208

Как установить DB2 ODBC?

8 ответов

Другие вопросы по тегам:

Похожие вопросы: