MySQL Bugs: #39072: Web provider does not work

Bug #39072	Web provider does not work
Submitted:	27 Aug 2008 12:30	Modified:	8 Sep 2008 10:47
Reporter:	oren tet	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / NET	Severity:	S2 (Serious)
Version:	5.2.3	OS:	Windows
Assigned to:		CPU Architecture:	Any
Tags:	Web Provider

Description:
web provider simply does not work on remote host, and does not create database using autogenerateschema="true"

How to repeat:
create database locally and try autogenerateschema="true"

Hi Oren and thanks for your report. Can you please check what I said in Bug#33522 and inform me of result.

no thats not it.
i looked at the source code of the mysql.web, and i saw that if it doens't find the schema version table, it just throws and ignore this whole situation, instead of creating the schema

no thats not it.
i looked at the source code of the mysql.web, and i saw that if it doens't find the schema version table, it just throws and ignore this whole situation, instead of creating the schema

This is verified.  We made some significant changes in our provider schema for the 5.2 release and this bug was missed.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/52926

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/52927

fixed in 5.2.4 and 5.3

An entry was added to the 5.2.4 and 5.3.0 changelogs:

The Web Provider did not work at all on a remote host, and did not create a database when using autogenerateschema="true".