OpenAccess got rejected, when create table for hosted mySQL.

2 posts, 0 answers
  1. Stanley
    Stanley avatar
    17 posts
    Member since:
    Feb 2008

    Posted 20 Dec 2009 Link to this post

    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).

  2. Ady
    Admin
    Ady avatar
    588 posts

    Posted 21 Dec 2009 Link to this post

    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.
  3. DevCraft banner
Back to Top