1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

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

Discussion in 'Plesk 10.x for Linux Issues, Fixes, How-To' started by gtsupport, Jul 11, 2011.

  1. gtsupport

    gtsupport Guest

    0
     
    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)
     

    Attached Files:

  2. Sergey L

    Sergey L Golden Pleskian Staff Member

    32
    43%
    Joined:
    Aug 10, 2006
    Messages:
    1,195
    Likes Received:
    30
    Hello. This can only be assisted if we have access to the server. Please see a private message from me.
     
  3. Frank Hoffmann

    Frank Hoffmann Guest

    0
     
    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
     
  4. Christian_S

    Christian_S Basic Pleskian

    17
    35%
    Joined:
    Nov 8, 2010
    Messages:
    35
    Likes Received:
    0
    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: Aug 9, 2011
  5. Kirill K

    Kirill K Regular Pleskian

    24
    53%
    Joined:
    Dec 24, 2007
    Messages:
    144
    Likes Received:
    0
    The problem can be fixed by removing skip-name-resolve configuration parameter from MySQL server configuration and re-running bootstrapper.sh repair.
     
  6. Frank Hoffmann

    Frank Hoffmann Guest

    0
     
    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
     
  7. Christian_S

    Christian_S Basic Pleskian

    17
    35%
    Joined:
    Nov 8, 2010
    Messages:
    35
    Likes Received:
    0
    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
     
  8. Kirill K

    Kirill K Regular Pleskian

    24
    53%
    Joined:
    Dec 24, 2007
    Messages:
    144
    Likes Received:
    0
    Frank, you used old version of bootstrapper. 10.3.1 version should contain /usr/local/psa/bootstrapper/pp10.12.0-bootstrapper dir.
     
  9. Kirill K

    Kirill K Regular Pleskian

    24
    53%
    Joined:
    Dec 24, 2007
    Messages:
    144
    Likes Received:
    0
    Christian, could you provide ssh access to you server?
     
  10. Christian_S

    Christian_S Basic Pleskian

    17
    35%
    Joined:
    Nov 8, 2010
    Messages:
    35
    Likes Received:
    0
    Yes, can you send me a private message with IP?
     
    Last edited: Aug 11, 2011
  11. Kirill K

    Kirill K Regular Pleskian

    24
    53%
    Joined:
    Dec 24, 2007
    Messages:
    144
    Likes Received:
    0
    running of next command should fix the problem:
    sw_engine_pleskrun $PRODUCT_ROOT_D/admin/plib/scripts/aps-controller-data-import.php
     
  12. Christian_S

    Christian_S Basic Pleskian

    17
    35%
    Joined:
    Nov 8, 2010
    Messages:
    35
    Likes Received:
    0
    Thanks, it works now.
     
Loading...