Jeff, that's exactly what the problem was!
On Tue, Dec 22, 2015 at 8:41 PM, Jeffrey Seger <jse...@gmail.com> wrote:
> Just a guess, but try chomping $myline before splitting it. I'm guessing
> you have a newline hanging on.
> On Dec 22, 2015 9:35 PM, "Donna Cote" <d-c...@tamu.edu> wrote:
>
>> Thanks, John, for your time.
>>
>> Here is the successful connect on the command line:
>>
>>> $ /usr/bin/mysql -u ldmdbuser2 -pb7cb452be401724b9a1b ldmsurvey
>>
>> Reading table information for completion of table and column names
>>
>> You can turn off this feature to get a quicker startup with -A
>>
>>
>>> Welcome to the MySQL monitor. Commands end with ; or \g.
>>
>> Your MySQL connection id is 5698
>>
>> Server version: 5.1.73 Source distribution
>>
>>
>>> Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights
>>> reserved.
>>
>>
>>> Oracle is a registered trademark of Oracle Corporation and/or its
>>
>> affiliates. Other names may be trademarks of their respective
>>
>> owners.
>>
>>
>>> Type 'help;' or '\h' for help. Type '\c' to clear the current input
>>> statement.
>>
>>
>>> mysql>
>>
>>
>> My perl script reads a .config file which contains:
>>
>>> $
>>> cat /opt/ldmsurvey/scripts/.config
>>
>> ldmsurvey,ldmdbuser2,b7cb452be401724b9a1b
>>
>>
>>
>>
>> The script's output is:
>>
>>> $ ./gather-details-n-do-db-inserts.pl ldm1-log-sample.log
>>
>> debug 51 pre gather db config routine
>>
>> debug 58: post gather-db-config-routine, database=ldmsurvey,
>>> userid=ldmdbuser2
>>
>> debug 65 pre attempt db connection with dbi:mysql:ldmsurvey ldmdbuser2
>>> b7cb452be401724b9a1b
>>
>>
>>
>> DBI connect('ldmsurvey','ldmdbuser2',...) failed: Access denied for user
>>> 'ldmdbuser2'@'localhost' (using password: YES) at ./
>>> gather-details-n-do-db-inserts.pl line 65
>>
>> Access denied for user 'ldmdbuser2'@'localhost' (using password: YES) at
>>> ./gather-details-n-do-db-inserts.pl line 65.
>>
>> $
>>
>>
>> Just don't understand.
>>
>>
>>
>> On Tue, Dec 22, 2015 at 7:49 PM, John R Pierce <pie...@hogranch.com>
>> wrote:
>>
>>> On 12/22/2015 5:36 PM, Donna Cote wrote:
>>>
>>>> I have perl-DBD-MySQL-4.013-release-3.el6 and Perl 5.10.1 and while I
>>>> have a user account which can connect to the database at the command
>>>> prompt, I cannot get the same user (or any user) to connect from within my
>>>> Perl script. Actually, I succeeded with one connection one time (from
>>>> within Perl script) on 20-Dec-2015 (Sun Dec 20 22:35:53 CST 2015).
>>>>
>>>
>>>
>>> I see your perl program has a bunch of debug print's, but you don't show
>>> the actual output from them, nor the contents of your .config file which
>>> apparently contains the database connection parameters.
>>>
>>> it would also be useful to see the command line you use to successfully
>>> connect to this database at the command prompt.
>>>
>>>
>>>
>>> --
>>> john r pierce, recycling bits in santa cruz
>>>
>>>
>>
