Re: DBD-mysql-4.005 instalation error!

HI Peter,

Thanks a lot your idea.I placed "my.cnf" file as(re name) "mysql_config" file in /usr/bin derectory.But it gives same error for me.

Error
/usr/bin/mysql_config: 32: [mysqld]: not found
/usr/bin/mysql_config: 36: user: not found
/usr/bin/mysql_config: 37: pid-file: not found
/usr/bin/mysql_config: 38: socket: not found
/usr/bin/mysql_config: 39: port: not found
/usr/bin/mysql_config: 40: basedir: not found
/usr/bin/mysql_config: 41: datadir: not found
/usr/bin/mysql_config: 42: tmpdir: not found
/usr/bin/mysql_config: 43: language: not found
/usr/bin/mysql_config: 49: old_passwords: not found
/usr/bin/mysql_config: 57: key_buffer: not found
/usr/bin/mysql_config: 58: max_allowed_packet: not found
/usr/bin/mysql_config: 59: thread_stack: not found
/usr/bin/mysql_config: 60: thread_cache_size: not found
/usr/bin/mysql_config: 64: query_cache_limit: not found
/usr/bin/mysql_config: 65: query_cache_size: not found
/usr/bin/mysql_config: 66: query_cache_type: not found
/usr/bin/mysql_config: 81: log_bin: not found
/usr/bin/mysql_config: 83: expire_logs_days: not found
/usr/bin/mysql_config: 84: max_binlog_size: not found
/usr/bin/mysql_config: 92: skip-bdb: not found
/usr/bin/mysql_config: 114: [mysqldump]: not found
/usr/bin/mysql_config: 115: quick: not found
/usr/bin/mysql_config: 116: quote-names: not found
/usr/bin/mysql_config: 117: max_allowed_packet: not found
/usr/bin/mysql_config: 119: [mysql]: not found
/usr/bin/mysql_config: 122: [isamchk]: not found
/usr/bin/mysql_config: 123: key_buffer: not found

Reg,

Chaminda S





----- Original Message ----
From: Peter Pentchev <[email protected]>
To: chaminda siyasingha <[email protected]>
Cc: [email protected]
Sent: Monday, September 10, 2007 4:21:25 PM
Subject: Re: DBD-mysql-4.005 instalation error!


On Mon, Sep 10, 2007 at 05:18:55AM -0700, chaminda siyasingha wrote:
> Hi All,
> 
> I have already istalled DBI-mysql-1.59 but when I am instaling  DBD-mysql-4.005 on Linux it gives following error.I have using follwing command to install DBD-mysql-4.005 ,Could you help me to solve this isuue please,
> 

> >> sudo perl Makefile.PL  --testdb=test --testuser=root
> >> --testpassword=osloadmin --testhost=localhost
> >> --cflags="-I/usr/share/mysql/mysql-test/include"
> >> --libs="-L/var/lib/mysql/mysql -lmysqlclient -lz -lm"
> >> --mysql_config="/etc/mysql/my.cnf"

The --mysql_config option should NOT specify your MySQL configuration
file; rather, if you want to use it at all, you should point it at
a file named "mysql_config", which is most likely in your /usr/bin
directory.  The mysql_config file is a helper program that displays
the flags and paths for the compiler and linker, so that you don't
really need to specify --cflags, --libs, and stuff.  In short, your
configuration line should be something more like:

sudo perl Makefile.PL  --testdb=test --testuser=root
--testpassword=osloadmin --testhost=localhost
--mysql_config="/usr/bin/mysql_config"

Of course, that's assuming your mysql_config helper is really installed
in /usr/bin.


In your case, most of the error messages you're seeing are there because
DBD-mysql's Makefile.PL has tried to run your config file as a shell
script :)

> 
> ERROR
> 
> /etc/mysql/my.cnf: 20: t: not found
> /etc/mysql/my.cnf: 21: port: not found
> /etc/mysql/my.cnf: 22: socket: not found
> /etc/mysql/my.cnf: 28: [mysqld_safe]: not found
[snip]
> Argument "6.30_01" isn't numeric in numeric ge (>=) at Makefile.PL line 355.

This one, however, might be more fun than it looks like, but there's no
way to be certain whether it's a real one or it's there simply because
Makefile.PL has not managed to configure itself properly.

Can you try running Makefile.PL with the proper value for --mysql-config
and see if it helps?

G'luck,
Peter

-- 
Peter Pentchev    [email protected]    [email protected]    [email protected]
PGP key:    http://people.FreeBSD.org/~roam/roam.key.asc
Key fingerprint    FDBA FD79 C26F 3C51 C95E  DF9E ED18 B68D 1619 4553
The rest of this sentence is written in Thailand, on


       
____________________________________________________________________________________
Building a website is a piece of cake. Yahoo! Small Business gives you all the tools to get online.
http://smallbusiness.yahoo.com/webhosting