Bug #39072 Web provider does not work
Submitted: 27 Aug 2008 14:30 Modified: 8 Sep 2008 12:47
Reporter: oren tet
Status: Closed
Category:Connector/Net Severity:S2 (Serious)
Version:5.2.3 OS:Microsoft Windows
Assigned to: Target Version:
Tags: Web Provider

[27 Aug 2008 14:30] oren tet
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"
[28 Aug 2008 22:25] Tonci Grgin
Hi Oren and thanks for your report. Can you please check what I said in Bug#33522 and
inform me of result.
[29 Aug 2008 18:36] oren tet
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
[29 Aug 2008 18:39] oren tet
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
[29 Aug 2008 18:56] Reggie Burnett
This is verified.  We made some significant changes in our provider schema for the 5.2
release and this bug was missed.
[29 Aug 2008 19:06] Bugs System
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
[29 Aug 2008 19:10] Bugs System
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
[29 Aug 2008 19:11] Reggie Burnett
fixed in 5.2.4 and 5.3
[8 Sep 2008 12:47] Tony Bedford
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".