mysql backend setup

[epeleg]

can someone please tell me what are the exact permissions needed for the plastic user on the mysql server ?

(a GRANT statement would be nice).

Is it possible to create the databases it needs and give it rights only on those databases?

if so, what databases should I create for it? and what permissions should I give on them (Actually when limiting it to those databases I don't care giving it ALL permissions).

[epeleg]

I now think that this is not a permissions issue at all...

I have given the plastic user all the possible permissions on the mysql server and still

It does not seem as if the plastic server is even trying to create the required databases / tables.

This is what mysql logs when I am starting the plastic server service.

111117 7:36:37 9 Connect plastic@localhost on

9 Query SHOW VARIABLES

9 Query SHOW COLLATION

9 Query SET character_set_results=NULL

9 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ

9 Query BEGIN

9 Query SELECT sdata FROM databaseinfo WHERE iobjid = 1

9 Query ROLLBACK

9 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ

9 Query BEGIN

9 Query SELECT * FROM seid WHERE sactive != 'T' AND sgroup = 'F'

9 Query ROLLBACK

9 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ

9 Query BEGIN

9 Query SELECT * FROM seid

9 Query ROLLBACK

9 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ

9 Query BEGIN

9 Query SELECT ta.iobjid as iobjid, ta.iposition as iposition, ta.sname as sname, ta.itype as itype, ta.isubtype as isubtype, ta.spath as spath, ta.sfilter as sfilter, ta.fidowner as fidowner, ta.fidacl as fidacl FROM triggeraction ta

9 Query COMMIT

How can I force it to create the databases/tables it needs ?

[epeleg]

more info:

I have tried creating a repository via the command line and this is what I got:

C:\Program Files\PlasticSCM\client>cm addrepository rep_1 myrep localhost:8084

Error: Unable to find assembly 'MySql.Data, Version=6.2.3.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d'.: localhost:8084 ---> System.Runtime.Serialization.SerializationException: Unable to find assembly 'MySql.Data, Version=6.2.3.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d'.

however MySql.Data.dll (version 6.2.3.0) is sitting nicely at C:\Program Files\PlasticSCM\server.

trying to run the same cm from ...\server yields the same results.

[cidico]

What does the plastic writes in the log file?

[epeleg]

it was complaining that if could not find some tables.

anyway I decided to remove it all and wait a few more hours to the launch of V4

hopefully it will work better then the v3 I was trying to install...

[hampsterx]

probably it failed the first time (due to permissions) then thought it had created the tables. remove config files and rerun the server setup and see if it recreates them properly.

[epeleg]

so now I have the v4 and it also does not seem to play nice with mysql. or maybe I am doing something wrong...

and not loader.log.txt at all this time...

[epeleg]

hampsterx, care to be more specific as to what files I should remove ?

[hampsterx]

users\xxx\appData\local\plastic (win7 path. winxp path is bit different but u can find. not sure if this is client config only or contains server also)

c:\program files\plastic\server\*.conf

Do that then rerun the server setup again.

Don't quote me on any of this, I am not a plastic employee..

[epeleg]

I doubt that it would be a good idea to delete all those conf files. (for once db.conf defines what backend should be used...).

and the only conf file at appdata also does not seem related.

have you got it up and running with mysql as the backend ?

[hampsterx]

as i said dont trust my advice, you must be in asia pacific as you seem online when I am, plastic admin are in Europe I guess so you might have to wait till tmrw for a reply. Yes I am using Mysql backend. Just trying to upgrade v3 to v4 at the moment using local server for mysql and then I can move those databases to the main server and restrict plastic access to just those ones

[psantosl]

Hi guys

Plastic creates the databases you don't need to create them.

IF, setting up (careful, don't do it with real data), it can't create a database sometimes (not usual) it can end up with half created tables (ok, created, of course, but not filled in correctly). You can go and drop the mysql databases and restart.

Check the server's log (plastic's) for more info... and let me know.

[epeleg]

Hi psantosl,

What triggers the creation of the databases? Is there a command I can give it to try again?

I have another post where I provide all the logs.

your help would be very much appriciated.

hampsterx - can you show what you have in your db.conf ?

did you set up the databases yourself?

what permissions did you give the db user for plastic ?

[epeleg]

Just an update to anyone reading this:

This seems to have been my error as I replaced the {0} in the <ConnectionString>

as it appears in http://www.plasticscm.com/infocenter/technical-articles/kb-how-to-configure-plastic-scm-with-mysql.aspx

with an database name.

I fixed that and it is now working o.k.