W3C home > Mailing lists > Public > www-lib@w3.org > July to September 2006

webbot with mysql

From: <xavier.torne@barcelonamedia.org>
Date: Wed, 19 Jul 2006 17:48:22 +0200
Message-ID: <20060719174822.bfdthmngqsc8wg4s@webmail.barcelonamedia.org>
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 GMT

This archive was generated by hypermail 2.2.0+W3C-0.50 : Monday, 23 April 2007 18:18:45 GMT