MonoX support board

Start the conversation, ask questions and share tips and solutions with fellow developers.

Non-registered users can only browse through our support boards. Please register now if you want to post your questions. It takes a second and it is completely free. Alternatively, you can log in without registration using your credentials at major sites such as Google, Microsoft Live, OpenId, Facebook, LinkedIn or Yahoo.

MonoX installer (Closed) (Mono Support )

Viewed 321774 time(s), 27 post(s) 6/1/2012 3:45:05 PMby clipflair-rpx

Related topics

clipflair

clipflair

6/2/2012 11:34:59 AM
regarding RPX, if you can edit the profile to make it show name ClipFlair instead of the e-mail address it would be nice, thanks (posting this via RPX from Google account to see if it does the same)

update: RPX seems to not show the google e-mail here, so it may be related only to RPX and Windows Live that it shows the e-mail used (registered at Microsoft's passport.net site [MS doesn't require @hotmail etc. for windows live id, most people don't know that]) for the Windows Live account
This content has not been rated yet. 
190 Reputation 31 Total posts
clipflair

clipflair

6/2/2012 11:50:30 AM
btw, regarding the Flash converter (FFMPEG etc.), I'd love to see IIS Transform Manager (1.0 just gone out of beta, can install it via Web Platform Installer)

http://www.iis.net/download/TransformManager
http://technet.microsoft.com/library/ff730186(WS.10).aspx
http://learn.iis.net/page.aspx/1271/transforming-media-files-to-on-demand-smooth-streams/

---

also interesting in this area is:
http://blogs.southworks.net/ejadib/2011/06/29/mmp-video-editor-transform-manager-task-updated-to-iis-transform-manager-1-0-beta/

this is a custom transform manager task that takes as input .CSM (Composite Stream Manifest) files (specifying how to merge virtual video clip segments) generated by MMPVE (Microsoft Media Platform Video Editor - formerly called Rouch Cut Editor [RCE])

one can try MMPVE live at http://videoeditor.cloudapp.net
Source code is at http://archive.msdn.microsoft.com/VideoEditor

MMPVE is under the same umbrella (http://www.microsoft.com/en-us/mediaplatform/) as MMPPF (Microsoft Media Platform Player Framework)
Silverlight: http://smf.codeplex.com/
HTML5: http://playerframework.codeplex.com/


I'm definitely looking into integrating these in the context of ClipFlair (http://clipflair.net)
This content has not been rated yet. 
190 Reputation 31 Total posts
George-Birbilis

George Birbilis

6/3/2012 12:21:12 PM
btw, there's also a thumbnailing tool that can generate thumbs (even from various timepoints in the video for timeline scrubbing) using Expression Encoder API (note that the free version of Expression Encoder is also available via WebPI).

Guess one could also wrap it up in a Transform Manager job (even without code probably, think its custom jobs can call executables to work onto files that are added to the monitored icnoming folder)

see my post at the thread: http://smf.codeplex.com/discussions/266251
(note that the links I posted there to archive.msdn.microsoft.com are broken today cause of some issue with their server, last night they worked fine and you could download the generatethumbnails command like tool)

(there are other ways to for one to get video thumbnails by asking the windows shell for a file's thumbnail, assuming they have s/w installed on Windows that enables thumbs for those file formats in windows explorer - however not sure how robust is such a process to call often on a server)
This content has not been rated yet. 
0 Reputation 2 Total posts
khorvat

khorvat

6/6/2012 12:12:10 PM
Hi,

we have adjusted the installer script can you please try to switch the default scripts with the attached ones. MonoX installer scripts can be located at the "/MonoX/Installer/SQL/*".

Note: Please backup your database before you proceed with these changes as attached scripts are not fully tested.

Let us know the installation result.

Regards

UPDATE: Attachment was removed please use the valid attachment in this topic.
This content has not been rated yet. 
15993 Reputation 2214 Total posts
clipflair

clipflair

6/5/2012 10:46:42 AM
1) comparing to the existing contents of that folder
at "/MonoX/Installer/SQL/import" subfolder, "CalendarEventEntry.sql" is missing
at "/MonoX/Installer/SQL/" the "UpdateScripts" subfolder is missing (guess that's normal)
at "/MonoX/Installer/SQL" the files "DatabaseExists.sql", "DropDatabase.sql" and "TableExists.sql" are missing
Should I merge the two folders, replacing the common files with the new ones? Or did you forget to include some of those .sql files I listed above?

2) speaking of database, are there any plans to support other databases (especially free ones [I know SQL Express is free, but think at multiple incoming requests it introduces throtling to cut-down performance]) like MySQL (the MySQL connector for .NET from WebPI seems to be quite stable now). MySQL support could help in more MonoX adoption probably (but of course means more burden to support/test). Maybe should refactor to allow for pluggable database scripts there, like .../MSSQL, .../MySQL etc. Not sure if there's a database abstraction layer now in MonoX for one to plug-in more databases implementing a low-level db layer or something
This content has not been rated yet. 
190 Reputation 31 Total posts
clipflair

clipflair

6/5/2012 11:40:53 AM
A) there's an issue with the default button at the installer, it's Cancel instead of Next - suppose you give SQL authentication login and pwd and press ENTER at the pwd field, you get back to 1st screen (as if cancel button was pressed). Could also set no button to be the default and ignore ENTER key, although since you do have validation at Next to proceed only when all needed form fields have been filled, I guess setting Next as the default button (ASP.net button should have such a property to make it default [or is at the form level, don't remember]) is the best thing to do

B) tried with copy and replace of the new scripts into the old folder (see comments at [1] in previous post)

then I got:
2012-06-05 14:07:43Z: Installation starting ...
2012-06-05 14:07:43Z: Creating database ...
2012-06-05 14:07:45Z: Column already has a DEFAULT bound to it. Could not create constraint. See previous errors.

so I deleted the MonoX db and created a new one (assuming it had garbage leftovers from previous fail [maybe it should ask user to clear the db if not empty, but not clean automatically to be safe from deleting other db])

then I got:
2012-06-05 14:09:10Z: Installation starting ...
2012-06-05 14:09:10Z: Creating database ...
2012-06-05 14:09:23Z: Database created.
2012-06-05 14:09:23Z: Importing data ...
2012-06-05 14:09:23Z: Importing "aspnet_Applications" ...
2012-06-05 14:09:23Z: User does not have permission to alter database 'MonoX2', the database does not exist, or the database is not in a state that allows access checks. ALTER DATABASE statement failed.

wonder where it got MonoX2 from, is it hardcoded or does it append 2 to my db name?
This content has not been rated yet. 
190 Reputation 31 Total posts
clipflair

clipflair

6/5/2012 11:46:58 AM
so I made a new empty db, named MonoX2 (seems somebody hardcoded that name in the scripts or something) and tried again:

2012-06-05 14:46:03Z: Installation starting ...
2012-06-05 14:46:03Z: Creating database ...
2012-06-05 14:46:16Z: Database created.
2012-06-05 14:46:16Z: Importing data ...
2012-06-05 14:46:16Z: Importing "aspnet_Applications" ...
2012-06-05 14:46:16Z: Must declare the scalar variable "@RecoveryModel". Must declare the scalar variable "@RecoveryModel". Must declare the scalar variable "@RecoveryModel".

so I'm stuck at this one
This content has not been rated yet. 
190 Reputation 31 Total posts
khorvat

khorvat

6/6/2012 12:11:12 PM
Hi,

please find the fixed scripts attached. Let me address other questions you had ...
1) comparing to the existing contents of that folder
at "/MonoX/Installer/SQL/import" subfolder, "CalendarEventEntry.sql" is missing
at "/MonoX/Installer/SQL/" the "UpdateScripts" subfolder is missing (guess that's normal)
at "/MonoX/Installer/SQL" the files "DatabaseExists.sql", "DropDatabase.sql" and "TableExists.sql" are missing
CalendarEventEntry should be in the attached scripts, UpdateScripts are not deployed with this script package, DatabaseExists.sql, DropDatabase.sql and TableExists.sql have not been changed.

2) speaking of database, are there any plans to support other databases
Yes we plan to support other databases but not in the 4.7 (Bug fix version) nor in 5.0 (HTML5 support with a lot of new social modules) but in 6.0 that will be something totally new.

A) there's an issue with the default button at the installer, it's Cancel instead of Next
I have logged in the issue and it will be addressed in next release

B) tried with copy and replace of the new scripts into the old folder (see comments at [1] in previous post)
Yes, you need to do the whole procedure from scratch to apply the attached script

Must declare the scalar variable "@RecoveryModel". Must declare the scalar variable "@RecoveryModel". Must declare the scalar variable "@RecoveryModel".
This should be fixed now.

Please try to use newly attached script package and get back to us, thanks.

Regards
This content has not been rated yet. 
15993 Reputation 2214 Total posts
clipflair-rpx

clipflair-rpx

6/6/2012 4:09:24 PM
tried it again with an empty MonoX db and got:

2012-06-06 18:56:08Z: Installation starting ...
2012-06-06 18:56:08Z: Creating database ...
2012-06-06 18:56:19Z: Database created.
2012-06-06 18:56:19Z: Importing data ...
2012-06-06 18:56:19Z: Importing "aspnet_Applications" ...
2012-06-06 18:56:19Z: User does not have permission to alter database 'MonoX2', the database does not exist, or the database is not in a state that allows access checks. ALTER DATABASE statement failed.

am I supposed to only use a db named "MonoX2"?

Creating a blank db named MonoX2 (and not MonoX or other name) seems to proceed in the installation beyond the point above (fingers crossed)
This content has not been rated yet. 
63 Reputation 10 Total posts
clipflair-rpx

clipflair-rpx

6/6/2012 4:08:14 PM
btw, a thing that tricked me a lot is that if one doesn't set at Server Logins the "Default database" for the mono user they created to the mono db they created (need the "db_owner" role on the mono db btw at server logins / User Mapping for that login apart from "public" role), then the installer can't connect to the sql server (tried with sql authentication) to list the DBs available to choose
This content has not been rated yet. 
63 Reputation 10 Total posts
1 2 3