- From: <xavier.torne@barcelonamedia.org>
- Date: Wed, 19 Jul 2006 17:48:22 +0200
- To: www-lib@w3.org
Hi,
i'm trying to work with webbot with mysql, but don't work.
I compiled with the correct options: ./configure --with-mysql=/usr/lib (i'm
using ubuntu with mysql 5.0.22).
I put in source modifications to see what happens, and when i execute robot
with:
{ROBOT} -q -ss -n -depth 99 -prefix ${ROOT} -img -imgprefix ${IMGROOT}
-sqlserver localhost -sqluser webbot -sqldb webbot -sqlpassword libwww ${ROOT}
i find : Error: Can't connect to MySQL server on 'localhost' (111)
i modificated :
PUBLIC BOOL HTSQL_connect (HTSQL * me)
{
if (me && me->host) {
HTTRACE(SQL_TRACE, "SQL connect. Open a link to server `%s\'\n" _ me->host);
// me->psvr = mysql_connect(&(me->server), me->host,me->user, me->password);
// me->user ? me->user : "",
//me->password ? me->password : "");
if(!mysql_real_connect(&(me->server), me->host,me->user,
me->password,NULL,0,NULL,0)){
fprintf(stderr, "Failed to connect to database: Error: %s\n",
mysql_error(&(me->server)));
}
the vars are ok, and the mysql runs, and the user for the mysql is created (with
grant and all privileges), but doesn't connect to this, i don't know because.
I hope somebody know this! Please! Thanks!
PD:Sorry for my english
Received on Thursday, 20 July 2006 14:26:19 UTC