Re: Errors installing Template CPAN module

From: knocte (knocte_at_NO-SPAM-PLEASE-hotmail.com)
Date: 03/16/04 

Date: Tue, 16 Mar 2004 18:10:39 +0100

James Willmore wrote:
> UGH!!! Do NOT post ALL the results! Only post what's relevent!.
>
> [ ... ]
>
> Clue #1 is taring you right in the face ...
>

(Yep... but it's not taring, it's *untaring* ;)
Sorry for that.

>>DBI Test Configuration
>>----------------------
>>
>>Please enter the driver name for the test database.
>>The DBD drivers installed on your system are
>>
>> DBM, ExampleP, File, Proxy, Sponge, mysql
>>
>>Enter driver name: [mysql] mysql
>>
>>Now enter the data source (DSN) for the test database.
>>Many DBD drivers require only a database name (e.g. 'test') while
>>others may require an alternate format or additional parameters
>>(e.g. 'dbname=test'). Please consult your DBD documentation for
>>further details.
>>
>>Database name: [test] test
>>Enter user name : []
>>Enter password : []
>
>
> do you have MySQL on your system? Is it running? Username and password
> set properly (you haven't set these values - is this by design or did you
> just blindly hit 'Enter'?)?

I simply hit Enter... BUT, I know that I have MySQL running, and that
there is a database called 'test', with all permissions granted to any
user (I can enter mysql with no user and no password and change the
database with insertions).

> [ ... ]
>
> Clue #2 ... the DBI tests have failed ...
>
>
>>t/date...........ok
>>t/dbi............
>>
>>Use of uninitialized value in join or string at
>>/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/DBI.pm line 1300,
>><DATA> line 1.
>>Use of uninitialized value in join or string at
>>/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/DBI.pm line 1300,
>><DATA> line 1.
>>Use of uninitialized value in join or string at
>>/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/DBI.pm line 1300,
>><DATA> line 1.
>>Use of uninitialized value in join or string at
>>/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/DBI.pm line 1300,
>><DATA> line 1.
>>Template process failed: DBI error - DBI connect failed: Unknown MySQL
>>Server Host 'test' (1)
>
>
> again ... see the comments above related to MySQL. Your connection to a
> datasource failed.
>
>
>>Anyone know what is the problem? Thanks in advance.
>
>
> Yes ... you need to make sure MySQL (or some database software) is running
> on your system. You *may* be able to use DBD::SQLite to run the tests
> againist if you don't have a database server to test againist - but I'm
> not 100% sure about this.
>
> HTH
>

Well, I will have to do some tests (using other usernames/passwords,
using other string instead of 'test'...). I will inform you...

Thanks four your reply. Regards.

Relevant Pages

  • Re: return multiple rows from sql statement
    ... strings from input values is almost certainly a safe path to SQL ... Also, being a MySQL function, it knows what MySQL needs or uses. ... All characters that are entered in the fields make their way into the database unaltered. ... The insert of what surprisinlgly was NOT a syntax error, but a string called "mysql_insert_id" into an integer field resulted in the value zero being put in. ...
    (comp.lang.php)
  • Re: return multiple rows from sql statement
    ... strings from input values is almost certainly a safe path to SQL ... Also, being a MySQL function, it knows what MySQL needs or uses. ... All characters that are entered in the fields make their way into the database unaltered. ... The insert of what surprisinlgly was NOT a syntax error, but a string called "mysql_insert_id" into an integer field resulted in the value zero being put in. ...
    (comp.lang.php)
  • Re: return multiple rows from sql statement
    ... strings from input values is almost certainly a safe path to SQL ... Also, being a MySQL function, it knows what MySQL needs or uses. ... The insert of what surprisinlgly was NOT a syntax error, but a string called "mysql_insert_id" into an integer field resulted in the value zero being put in. ... derived form..now normally I update the database, then read the data from the database back into the form: In this case I was testing 'failed to update, re-enter some data' and the backslashed stuff gave me issues with quotes and backslashes. ...
    (comp.lang.php)
  • Re: Random Access Files in databases
    ... I am not a Database design guru either, but it might be wise to break ... location and read in in the string, and then you want to get an integer, so ... I'm pretty sure the SQL language does have ways to seek around in BLOB ... some SQL purist are quick to point out that MySQL doesn't implement the SQL ...
    (comp.lang.java.programmer)
  • Re: Errors installing Template CPAN module (FIXED!)
    ... >> do you have MySQL on your system? ... >> just blindly hit 'Enter'?)? ... > database with insertions). ... Perhaps it's a bug of the Template module (or a Warning that gives the ...
    (comp.lang.perl.misc)