• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

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

G

gtsupport

Guest
After upgrading to Plesk 10.3 we can not access the Application Vault.

Code: 
Fehler
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 	7476
Type 	Exception


We've attached a screenshot.


OS: centos 5.6 x64 (with latest updates)
 

Attachments

  • screenshot.jpg
    screenshot.jpg
    70.7 KB · Views: 15
Hello. This can only be assisted if we have access to the server. Please see a private message from me.
 
Same problem here -- but with the latest version 10.3.1 ... updating from 10.2.
Can't change passwords, can't create domains, can't access parts of control panel.

How can I fix this?

Frank
 
Version Parallels Plesk Panel v10.3.1_build1013110726.09 os_Ubuntu 10.04

We also have connect error after upgrading from 10.2.0 to 10.3.1

Error text: 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 7476
Type Exception


-------------------
From update log:
Trying to set up APS controller database... Attempting to check APS db connection via ODBC, using /usr/bin/isql (empty output is good)
[ISQL]ERROR: Could not SQLConnect
Failed, rc = 1.
Attempting to check APS db connection via ODBC, using /usr/bin/iusql (empty output is good)
[ISQL]ERROR: Could not SQLDriverConnect
Failed, rc = 1.
Failed to establish test connection. Cleaning up.

ERROR while trying to establish test connection to APS database via ODBC

-------------------

my.cnf: skip-name-resolve and skip-networking is not activated

repair using bootstrapper.sh do not solve the problem.


How can we get the ODBC connection working?
 
Last edited:
The problem can be fixed by removing skip-name-resolve configuration parameter from MySQL server configuration and re-running bootstrapper.sh repair.
 
Same as the poster before me, I disabled 'skip-name-resolve' in /etc/my.cnf and then run
/usr/local/psa/bootstrapper/pp10.11.0-bootstrapper/bootstrapper.sh repair

It did not fix it -- instead I see this now:

-----
Trying to find psa database... version is 010120
DATABASE ERROR!!!
Previous product version is 10.11.0, but previous database
version is 010120. In most of cases it is result of
previous upgrade try failure.
-----

Frank
 
kriogen said:
The problem can be fixed by removing skip-name-resolve configuration parameter from MySQL server configuration and re-running bootstrapper.sh repair.
Click to expand...

Ok, now I get this error from the bootstapper repair:

------------------------------------
2011-08-09T10:00:15+02:00 ERR (3): Can not import package ID '1' into APS controller: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2011-08-09T10:00:15+02:00 ERR (3): Can not import package ID '2' into APS controller: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2011-08-09T10:00:15+02:00 ERR (3): Can not import package ID '5' into APS controller: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2011-08-09T10:00:15+02:00 ERR (3): Can not import package ID '6' into APS controller: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2011-08-09T10:00:15+02:00 ERR (3): Can not import package ID '7' into APS controller: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2011-08-09T10:00:15+02:00 ERR (3): Can not import package ID '9' into APS controller: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2011-08-09T10:00:15+02:00 ERR (3): Can not import package ID '11' into APS controller: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2011-08-09T10:00:15+02:00 ERR (3): Can not import package ID '12' into APS controller: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2011-08-09T10:00:15+02:00 ERR (3): Can not import package ID '13' into APS controller: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2011-08-09T10:00:15+02:00 ERR (3): Can not import package ID '17' into APS controller: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2011-08-09T10:00:15+02:00 ERR (3): Can not import package ID '18' into APS controller: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2011-08-09T10:00:16+02:00 ERR (3): Can not import package ID '20' into APS controller: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2011-08-09T10:00:16+02:00 ERR (3): Can not import package ID '21' into APS controller: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2011-08-09T10:00:16+02:00 ERR (3): Can not import package ID '22' into APS controller: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2011-08-09T10:00:16+02:00 ERR (3): Can not import package ID '26' into APS controller: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2011-08-09T10:00:16+02:00 ERR (3): Can not import package ID '27' into APS controller: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2011-08-09T10:00:16+02:00 ERR (3): Can not import package ID '29' into APS controller: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2011-08-09T10:00:16+02:00 ERR (3): Can not import package ID '30' into APS controller: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2011-08-09T10:00:16+02:00 ERR (3): Can not import package ID '31' into APS controller: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2011-08-09T10:00:16+02:00 ERR (3): Can not import package ID '32' into APS controller: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2011-08-09T10:00:16+02:00 ERR (3): Can not import package ID '33' into APS controller: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2011-08-09T10:00:16+02:00 ERR (3): Can not import package ID '34' into APS controller: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2011-08-09T10:00:16+02:00 ERR (3): Can not import package ID '35' into APS controller: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2011-08-09T10:00:16+02:00 ERR (3): Can not import package ID '36' into APS controller: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2011-08-09T10:00:16+02:00 ERR (3): Can not import package ID '38' into APS controller: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2011-08-09T10:00:16+02:00 ERR (3): Can not import package ID '41' into APS controller: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2011-08-09T10:00:16+02:00 ERR (3): Can not import package ID '42' into APS controller: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2011-08-09T10:00:16+02:00 ERR (3): Can not import package ID '43' into APS controller: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2011-08-09T10:00:16+02:00 ERR (3): Can not import package ID '44' into APS controller: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2011-08-09T10:00:16+02:00 ERR (3): Can not import package ID '45' into APS controller: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2011-08-09T10:00:16+02:00 ERR (3): Can not import package ID '46' into APS controller: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2011-08-09T10:00:16+02:00 ERR (3): Can not import package ID '48' into APS controller: [unixODBC][Driver Manager]Data source name not found, and no default driver specified


WARNING!
Some problems are found during cannot import data to APS controller database. Please rerun /opt/psa/admin/plib/scripts/aps-controller-data-import.php manually(see log file: /tmp/plesk_10.3.0_installation.log)
------------------------------------

I can not run aps-controller-data-import.php manually as written in the error text outside the Plesk-software.

and apps can now not be installed by customers. Get this error text:

Internal error: Package with UID '' not found.
Message Package with UID '' not found.
File aps_php.php
Line 8015
Type Exception
 
Frank Hoffmann said:
Same as the poster before me, I disabled 'skip-name-resolve' in /etc/my.cnf and then run
/usr/local/psa/bootstrapper/pp10.11.0-bootstrapper/bootstrapper.sh repair

It did not fix it -- instead I see this now:
Frank
Click to expand...

Frank, you used old version of bootstrapper. 10.3.1 version should contain /usr/local/psa/bootstrapper/pp10.12.0-bootstrapper dir.
 
Christian_S said:
Ok, now I get this error from the bootstapper repair:

------------------------------------
2011-08-09T10:00:15+02:00 ERR (3): Can not import package ID '1' into APS controller: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
Click to expand...

Christian, could you provide ssh access to you server?
 
Christian_S said:
2011-08-09T10:00:15+02:00 ERR (3): Can not import package ID '1' into APS controller: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
...
WARNING!
Some problems are found during cannot import data to APS controller database. Please rerun /opt/psa/admin/plib/scripts/aps-controller-data-import.php manually(see log file: /tmp/plesk_10.3.0_installation.log)
------------------------------------
Click to expand...

running of next command should fix the problem:
sw_engine_pleskrun $PRODUCT_ROOT_D/admin/plib/scripts/aps-controller-data-import.php
 
You must log in or register to reply here.

Similar threads

F
Resolved Trying to Install Ghost CMS as a Node.js app isn't working
Replies
4
Views
3K
FifthRateIntellectual
F
Noam Harel
Question mssql connect
Replies
5
Views
1K
Noam Harel
Noam Harel
ScottGoddard
Resolved Migration Tool - Access denied for user 'admin'@'localhost'
Replies
6
Views
3K
ScottGoddard
ScottGoddard
Scottpr
Issue Plesk Onyx Version 17.0.17 Error
Replies
8
Views
2K
Scottpr
Scottpr
V
Internal error: ODBC error #IM002: [unixODBC][Driver Manager]Data source name not found, and no defa
Replies
0
Views
996
Vagan
V
Back
Top