Internal error: [unixODBC][Driver Manager]Data source name not found, and no default

[JLChafardet]

Os: CentOS release 5.8 (Final)
Arch: x64
Plesk Version: 11.0.9
Quote:
rpm -qa | grep -i odbc
unixODBC-devel-2.2.11-10.el5
unixODBC-libs-2.2.11-10.el5
mysql-connector-odbc-3.51.26r1127-2.el5
unixODBC-2.2.11-10.el5
error:
Error

Internal error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified

Message [unixODBC][Driver Manager]Data source name not found, and no default driver specified
File aps_php.php
Line 7536
Type Exception

 

[abdi]

http://forum.parallels.com/showthread.php?t=111989

 

[JLChafardet]

Thanks for your insight, but no, that doesn't fix it, already tried it.

I've tried several stuff related to unixDBC from the forums, no luck so far.

 

[IgorG]

Make sure that you have correct /etc/odbcinst.ini file. For instance on my test Plesk server:

# cat /etc/odbcinst.ini
# Example driver definitions

# See /usr/share/doc/unixODBC*/README.64bit for more information


# Use these definitions with the original unixODBC package

# Driver from the postgresql-odbc package
# Setup from the unixODBC-libs package
[PostgreSQL]
Description = ODBC for PostgreSQL
Driver = /usr/lib/psqlodbc.so
Setup = /usr/lib/libodbcpsqlS.so
Driver64 = /usr/lib64/psqlodbc.so
Setup64 = /usr/lib64/libodbcpsqlS.so
FileUsage = 1


# Driver from the mysql-connector-odbc package
# Setup from the unixODBC-libs package
[PostgreSQL64]
Description = ODBC for PostgreSQL (64 bit)
Driver = /usr/lib/psqlodbcw.so
Setup = /usr/lib/libodbcpsqlS64.so
Driver64 = /usr/lib64/psqlodbcw.so
Setup64 = /usr/lib64/libodbcpsqlS64.so
FileUsage = 1


# Driver from the mysql-connector-odbc64 package
# Setup from the unixODBC64-libs package
[MySQL64]
Description = ODBC for MySQL (64 bit)
Driver = /usr/lib/libmyodbc5.so
Setup = /usr/lib/libodbcmyS64.so
Driver64 = /usr/lib64/libmyodbc5.so
Setup64 = /usr/lib64/libodbcmyS64.so
FileUsage = 1
[MySQL]
Description = MySQL driver for Plesk
Driver = /usr/lib/libmyodbc3.so
Setup =
FileUsage = 1
Driver64 =
Setup64 =
UsageCount = 1

 

[JLChafardet]

I'll be checking the ini file, though I think this boxe's ini file looks exactly like yours.

 

[JLChafardet]

Yeah it does look the same, the files exist, the paths are right!

it just doesnt work.

Error

Internal error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified

Message [unixODBC][Driver Manager]Data source name not found, and no default driver specified File aps_php.php Line 7536 Type Exception





I keep getting that message.

cat /etc/odbcinst.ini
# Example driver definitions

# See /usr/share/doc/unixODBC*/README.64bit for more information

# Use these definitions with the original unixODBC package

# Driver from the postgresql-odbc package
# Setup from the unixODBC package
[PostgreSQL]
Description = ODBC for PostgreSQL
Driver = /usr/lib/psqlodbc.so
Setup = /usr/lib/libodbcpsqlS.so
Driver64 = /usr/lib64/psqlodbc.so
Setup64 = /usr/lib64/libodbcpsqlS.so
FileUsage = 1


# Driver from the mysql-connector-odbc package
# Setup from the unixODBC package
[MySQL]
Description = MySQL driver for Plesk
Driver = /usr/lib64/libmyodbc3.so
Setup =
FileUsage = 1
Driver64 =
Setup64 =
UsageCount = 1

 

[IgorG]

But you haven't mysql-connector-odbc section there.

 

[JLChafardet]

IgorG,

I dont seem to be able to find a suitable solution

the content (proven that the files really exist) of /etc/odbcinst.ini

looks lke this

root@tb009 ~]# cat /etc/odbcinst.ini
# cat /etc/odbcinst.ini
# Example driver definitions

# See /usr/share/doc/unixODBC*/README.64bit for more information


# Use these definitions with the original unixODBC package

# Driver from the mysql-connector-odbc64 package
# Setup from the unixODBC64-libs package
[MySQL64]
Description = ODBC for MySQL (64 bit)
Driver = /usr/lib64/libmyodbc5.so
Setup = /usr/lib64/libodbcmyS64.so
Driver64 = /usr/lib64/libmyodbc5.so
Setup64 = /usr/lib64/libodbcmyS64.so
FileUsage = 1
[MySQL]
Description = MySQL driver for Plesk
Driver = /usr/lib64/libmyodbc3.so
Setup =
FileUsage = 1
Driver64 =
Setup64 =
UsageCount = 1

still get the same exact error, i have no clue what to do right now, i cant use the app vault at all.

 

[JLChafardet]

Bumping, really need a reply if anyone can help.

 

[IgorG]

Make sure that SELinux is not in Permissive mode. Check that drivers /usr/lib64/libmyodbc5.so and /usr/lib64/libmyodbc3.so are really exists.