hi all you noble men, i just try to read in some data from a config file with following code and try to connect to a mysql database, but i always get the error, script could not connect to database. 
#!/usr/bin/perl


use strict;
use CGI;
use CGI::Carp qw(fatalsToBrowser);
use DBI;
use HTML::Entities;


my $db_config_file = "db.cfg";
my %db_config = ();
open CONFIG, ("< $db_config_file") or die "Konnte Datenbank Konfigurat
+ions Datei nicht &ouml;ffnen! $!";
my @config_pairs = <CONFIG>;
close CONFIG;
foreach (@config_pairs) {
    chomp $_;
    my ($key, $value) = split/:/, $_;
    $db_config{$key} = $value;
}
my $database = $db_config{'database'};
my $db_server = $db_config{'db_server'};
my $db_user = $db_config{'db_user'};
my $db_pass = $db_config{'db_pass'};

my $dbh = DBI->connect("dbi:mysql:$database:$db_server", "$db_user", "
+$db_pass") or die "Konnte Datenbankverbindung nicht herstellen: $!";

[download]
if i read in the config file with the following code 
#!/usr/bin/perl


use strict;
use CGI;
use CGI::Carp qw(fatalsToBrowser);
use DBI;
use HTML::Entities;



my $db_config_file = "db.cfg";
my %db_config = ();
open CONFIG, ("< $db_config_file") or die "Konnte Datenbank Konfigurat
+ions Datei nicht &ouml;ffnen! $!";
my @config_pairs = <CONFIG>;
close CONFIG;
foreach (@config_pairs) {
    chomp $_;
    my ($key, $value) = split/:/, $_;
    $db_config{$key} = $value;
}
my $database = $db_config{'database'};
my $db_server = $db_config{'db_server'};
my $db_user = $db_config{'db_user'};
my $db_pass = $db_config{'db_pass'};

my $query = new CGI;

print $query->header();
print $query->start_html();
print $database . "<br>";
print $db_server . "<br>";
print $db_user . "<br>";
print $db_pass . "<br>";

print $query->end_html();

[download]
it prints out the correct values-> 
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE html
    PUBLIC "-//W3C//DTD XHTML Basic 1.0//EN"
    "http://www.w3.org/TR/xhtml-basic/xhtml-basic10.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en-US"><head><title>U
+ntitled Document</title>
</head><body>db29970540
<br>db07.puretec.de
<br>p7397271
<br>8vskBBPH<br></body></html>

[download]
what is the error i do? update-> the config file looks like this: 
database:xxxxxx
db_server:yyy.yyyyy.yy
db_user:xxxxxx
db_pass:yyyyyy

[download]

In reply to problems with reading data from cfg file by pitbull3000

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.