Team Repository :  Process Modeler Forum
Any issues concerning the Process Modeler Team Repository 
User unknown to the MySql repository
Posted by: randysiegel (IP Logged)
Date: April 19, 2011 04:09PM

When I try to use the repository feature in PM5 I get an error that says:

"The user <user name> is unknown to the repository".

I am using MySql 5.1. I have created a schema for the my process diagrams and created a user that can connect and has full DBA access.

PM5 keeps telling me that the user is unknown. Further more, I can not change the user name in PM5. Regardless of what I put in the Authentication section.

It seems to only be using the user name stated in the "Repository login for..." at the bottom of the connection configuration window. This is my windows login.

This does not work for any user I try to create. I can connect with other applications, just not PM5.

Any ideas?

From the PM log:

19 Apr 2011 12:40:53,904 ERROR - NHibernate.ADOException Message-Exception:could not execute query
[ select trepositor0_.version as x0_0_ from test.repository_info trepositor0_ ]
[SQL: select trepositor0_.version as x0_0_ from test.repository_info trepositor0_]
19 Apr 2011 12:40:53,904 ERROR - DBAccess.ExecuteSessionedHql Inner-Exception:MySql.Data.MySqlClient.MySqlException: Table 'test.repository_info' doesn't exist
at MySql.Data.MySqlClient.MySqlStream.OpenPacket()
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.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd)
at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session)
at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
19 Apr 2011 12:40:53,904 ERROR - Schema Name not valid
19 Apr 2011 12:40:53,904 ERROR - could not execute query
[ select trepositor0_.version as x0_0_ from test.repository_info trepositor0_ ]
[SQL: select trepositor0_.version as x0_0_ from test.repository_info trepositor0_]
19 Apr 2011 12:40:53,904 ERROR - Table 'test.repository_info' doesn't exist
19 Apr 2011 12:40:53,904 ERROR - could not execute query
[ select tpmuser0_.ID_pmuser as ID1_1118_, tpmuser0_.login as login1118_, tpmuser0_.password as password1118_, tpmuser0_.description as descript4_1118_, tpmuser0_.privilege as privilege1118_, tpmuser0_.modified_on as modified6_1118_, tpmuser0_.modified_by as modified7_1118_ from test.pmuser tpmuser0_ ]
[SQL: select tpmuser0_.ID_pmuser as ID1_1118_, tpmuser0_.login as login1118_, tpmuser0_.password as password1118_, tpmuser0_.description as descript4_1118_, tpmuser0_.privilege as privilege1118_, tpmuser0_.modified_on as modified6_1118_, tpmuser0_.modified_by as modified7_1118_ from test.pmuser tpmuser0_]
19 Apr 2011 12:40:53,904 ERROR - Table 'test.pmuser' doesn't exist



Edited 1 time(s). Last edit at 04/19/2011 06:43PM by randysiegel.



Subject Views Written By Posted
  User unknown to the MySql repository 378 randysiegel 04/19/2011 04:09PM
  Re: User unknown to the MySql repository 148 martijnburger 09/13/2011 10:39AM
  Re: User unknown to the MySql repository 146 Support/Info 09/13/2011 02:45PM
  Re: User unknown to the MySql repository 147 martijnburger 09/13/2011 03:13PM
  Re: User unknown to the MySql repository 174 Support/Info 09/13/2011 05:35PM
  Re: User unknown to the MySql repository 180 martijnburger 09/14/2011 12:43PM
  Re: User unknown to the MySql repository 146 Support/Info 09/13/2011 02:39PM


Sorry, only registered users may post in this forum.
This forum powered by Phorum.