This is a migrated thread and some comments may be shown as answers.

OpenAccess got rejected, when create table for hosted mySQL.

1 Answer 132 Views
Integration with other products
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Stanley
Top achievements
Rank 1
Stanley asked on 20 Dec 2009, 06:42 AM
I created a simple Model (forward mapping) and deployed and everything works (from UI tier) - only if the MySQL is local. But if I point it to MySQL hosted on GoDaddy.com, it errored me out. In later error case, what puzzled me is that everything looks fine:
  1. Inside OpenAccess: "test database connection" works fine, and
  2. "Check setting", all checking results are green. and
  3. The same login credential, I can use it to login to GoDaddy to do everything on my MySQL. (It must admin.)

My question is that, is there special steps I might missed on OpenAccess side? Thanks for your help!!!

Here is the full compiling log (my IP and name are modified):

------ Rebuild All started: Project: Model, Configuration: Debug Any CPU ------

C:\Windows\Microsoft.NET\Framework\v3.5\Csc.exe /noconfig /nowarn:1701,1702 /errorreport:prompt /warn:4 /define:DEBUG;TRACE /reference:"c:\Program Files (x86)\Reference Assemblies\Microsoft\Framework\v3.5\System.Core.dll" /reference:"c:\Program Files (x86)\Reference Assemblies\Microsoft\Framework\v3.5\System.Data.DataSetExtensions.dll" /reference:C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.Data.dll /reference:C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.dll /reference:C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.Xml.dll /reference:"c:\Program Files (x86)\Reference Assemblies\Microsoft\Framework\v3.5\System.Xml.Linq.dll" /reference:"C:\Program Files (x86)\Telerik\OpenAccess ORM\bin\Telerik.OpenAccess.dll" /reference:"C:\Program Files (x86)\Telerik\OpenAccess ORM\bin\Telerik.OpenAccess.Query.dll" /debug+ /debug:full /filealign:512 /optimize- /out:obj\Debug\Model.dll /resource:App.config,Model.App.config /target:library myModel.cs Properties\AssemblyInfo.cs

Compile complete -- 0 errors, 0 warnings

Model -> C:\Proj\Model\Model\bin\Debug\Model.dll

c:\program files (x86)\telerik\openaccess orm\sdk\VEnhance.exe -assembly:C:\Proj\Model\Model\obj\Debug\Model.dll -config:C:\Proj\Model\Model\App.config -debug+ -verbose+

Enhancement complete -- 0 errors, 0 warnings

Model -> C:\Proj\Model\Model\bin\Debug\Model.dll

c:\program files (x86)\telerik\openaccess orm\bin\VSchema.exe -assembly:C:\Proj\Model\Model\bin\Debug\Model.dll -migrate

SELECT command denied to user 'user1'@'75.149.111.11' for table 'proc'

at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)

at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()

at MySql.Data.MySqlClient.MySqlDataReader.NextResult()

at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)

at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()

at MySql.Data.MySqlClient.SchemaProvider.GetProcedures(String[] restrictions)

at MySql.Data.MySqlClient.ISSchemaProvider.GetProcedures(String[] restrictions)

at MySql.Data.MySqlClient.ISSchemaProvider.GetSchemaInternal(String collection, String[] restrictions)

at MySql.Data.MySqlClient.SchemaProvider.GetSchema(String collection, String[] restrictions)

at MySql.Data.MySqlClient.MySqlConnection.GetSchema(String collectionName, String[] restrictionValues)

at MySql.Data.MySqlClient.MySqlConnection.GetSchema(String collectionName)

at Telerik.OpenAccess.RT.Adonet2Generic.Impl.Ado2Relational.GetProcedures(ConnectionImp conImp, String catalog, String schemaPattern, String procedureNamePattern)

at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DatabaseMetaDataImp.getProcedures(String catalog, String schemaPattern, String procedureNamePattern)

at OpenAccessRuntime.Relational.sql.MySqlSqlDriver.getProcedures(Connection con, ControlParams param, List`1 result)

at OpenAccessRuntime.Relational.sql.SqlDriver.checkDDL(ICollection`1[] tables, Connection con, StreamWriter errors, StreamWriter fix, ControlParams controlParams, StreamWriter messages)

at OpenAccessRuntime.Relational.sql.MySqlSqlDriver.checkDDL(ICollection`1[] tables, Connection con, StreamWriter errors, StreamWriter fix, ControlParams controlParams, StreamWriter messages)

at OpenAccessRuntime.DataObjects.tools.ant.SchemaMigrationTask.migrateDatabase()

OpenAccess Error: Telerik.OpenAccess: Updating SQL schema failed. MySql.Data.MySqlClient.MySqlException: SELECT command denied to user 'user1'@'75.149.111.11' for table 'proc'

OpenAccess Error: SELECT command denied to user 'user1'@'75.149.111.11'  for table 'proc'

Update DatabaseSchema complete -- 2 errors, 0 warnings

========== OpenAccess All: 0 succeeded, 1 failed, 0 skipped ==========

OpenAccess : Build Cancelled due to enhancement error(s).

1 Answer, 1 is accepted

Sort by
0
Ady
Telerik team
answered on 21 Dec 2009, 03:53 PM
Hi Stanley He,

 This seems to be more of a rights issue. OpenAccess uses the ADO.NET API to obtain schema information from the server. In this case, stored procedure information. Can you try and use the following code in a sample application and see if it works?

static void Main(string[] args)
        {
            using (MySqlConnection con =
                new MySqlConnection("Server=xxxxx;Database=xxxx;Uid=xxx;Pwd=xxx;"))
            {
                con.Open();
                DataTable dt = con.GetSchema("Procedures");
            }
        }

Please provide the appropriate values for the connection string so that they point to your MySql instance hosted on GoDaddy.com. Also keep in mind that you need to reference the MySql.Data.dll assembly.


Regards,
Ady
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
Tags
Integration with other products
Asked by
Stanley
Top achievements
Rank 1
Answers by
Ady
Telerik team
Share this question
or