NateTut has asked for the wisdom of the Perl Monks concerning the following question:

My previous Perl code that accessed Teradata won't connect to a V2R5.1 system. I get the following message back from the DB: Deprecated logons are not allowed by administrator. Upgrade client software to latest version. Any ideas?

Replies are listed 'Best First'.
Re: DBD::Teradata and Teradata V2R5.1
by jarich (Curate) on May 13, 2004 at 04:26 UTC
    I'm afraid that you're not giving us a lot to go on NateTut. Teradata is a database well outside of my experience. What version of Teradata were you using when your Perl code used to work?

    Are you sure it's a Perl issue? Could the upgrade have deprecated a bunch of username/passwords including the one(s) that your script is using?

    Can you connect to the database using the same username and password that the script is using?

    A simple google search for: 

    teradata V2R5.1 "deprecated logon"

    [download]
    has given me the following information.

    Teradata Database Utilities - Gateway Control

    Release V2R5.1 introduces the Encryption feature.

    The following table provides information about the option used to control encrypted logons in the Gateway Control utility

    Option:

    bAllowDeprecatedLogons

    [download]
    Note: Deprecated logon is a clear text.

    Description:
    Enables deprecated logons.

    To enable deprecated logons, use the -b option as follows: 

     
       gtwcontrol -b yes

    [download]
    allows the gateway to accept deprecated and encrypted logons. 
           gtwcontrol -b no

    [download]
    ensures that the gateway accepts only encrypted logons.

    The default is NO.

    Comments:
    In Release V2R5.1, the Teradata Gateway always supports encrypted logons. However, if you have not upgraded to Teradata Tools and Utilities 7.1, you can enable the gateway to accept both encrypted and unencrypted, also referred to as deprecated logons.

    You can read more about all of this kind of thing at http://www.teradataforum.com/teradata_pdf/b035-1098-083a.pdf

    It doesn't look like a Perl issue at all. Perhaps it's advice to Upgrade client software to latest version is the way to go... Of course, for some bizarre reason the writer of DBD::Teradata has chosen only to sell the later versions and you may not be able to afford the US$2695.00 ... but I can't help you with that. Check that the newest version of DBD::Teradata handles encryption before you spend your money on it though.

    Hope this helps.

    jarich

[reply]
[d/l]
[select]
      The writer of "DBD::Teradata" is Dean Arnold of "Prescient". - I've been using his commercial driver for many years - it is WELL worth the cost if you go that route. It has a ton of features that you didn't get with the open version. That said, its been a while since I've checked but I vaguely recall that he re-released his commercial version to fully open (ie free). In any case, its a great driver! --Dan
[reply]
        An update:

        Since I just ran into the same issue of "logons deprecated", I went back to the installation prerequites and found the answer:

        If you get "Logons Deprecated" when attempting to connect to Teradata, do not attempt to set gtwcontrol -b to yes.

        Try this instead:

        use "perl -MCPAN -e shell" to get into cpan.

        then install these 3 modules:

        This should automagically encrypt the login/pw over the connection without changing any code.

        --Dan

[reply]
Re: DBD::Teradata and Teradata V2R5.1
by jZed (Prior) on May 13, 2004 at 02:11 UTC
    I suggest you try the dbi-users@perl.org mailing list or a Teradata-specific source of info.
[reply]

Back to Seekers of Perl Wisdom