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 257626 time(s), 27 post(s) 6/1/2012 3:45:05 PMby clipflair-rpx

Related topics

khorvat

khorvat

6/13/2012 3:44:45 PM
Hi, 

we have fixed the issue with the SQL 2012 so you can download attached scripts (but you will need to create a database called MonoX2), or you can download a new MonoX package that I have sent to your InMail.

Let me know if installation is working now, thanks.

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

clipflair-rpx

6/1/2012 3:45:05 PM
1) the installer advanced options say: "Show HTML document editor in Portal designe mode only" (designe is a typo, not sure if it should be design or designer)
2) the initial screen of the installer shows links to get various .NET frameworks, but not of .NET4. Also not sure why it should show these when it could check what build it is (for which .NET version) from assembly metadata of some main class used by MonoX (or try to dynamically load it and see if it fails) and show only the URL for the needed framework
3) it seems that one needs to select "Windows Authentiction and SQL autentication" mode of SQL Server 2012 Express by right clicking the database node and editing security properties and not just set "SQL authentication" for the MonoX-related database they create. Just in case they should go to Logins too in that case and edit the "sa" password in case it has some default value that might pose a security risk
This content has not been rated yet. 
63 Reputation 10 Total posts
clipflair-rpx

clipflair-rpx

6/1/2012 3:48:16 PM
also at advanced options, not sure at what URL the TellAFriend service is to register for it (googling on it finds SocialTwist and SmartAddOn sites speaking about it - maybe the 2nd one is the new tellafriend?)
This content has not been rated yet. 
63 Reputation 10 Total posts
clipflair-rpx

clipflair-rpx

6/1/2012 3:52:34 PM
also at Advanced Options, I see:
Convert video to Flash video
which is preselected, but after that
Video converter exe file location
which is empty?
This content has not been rated yet. 
63 Reputation 10 Total posts
clipflair-rpx

clipflair-rpx

6/1/2012 4:20:29 PM
Also, have to note (the manual and online pages are cryptic on that) the db roles needed to be given to the db user account one will use for MonoX.
db_owner (and public which can't be unchecked) is needed at Security/Logins, right click the user, select Properties, then User Mapping at the dialog that opens up, then select the mono db you created and check the "db_owner" role

must make it clear that selecting all roles there (as a newbe might do) will just fail, since if you give "db_denydatareader" you'll get
"The SELECT permission was denied on the object 'database_principals', database 'mssqlsystemresource', schema 'sys'."
by MonoX installer

anyway, having found my way arround the above, now I'm stuck at:

2012-06-01 19:03:11Z: Installation starting ...
2012-06-01 19:03:11Z: Creating database ...
2012-06-01 19:03:21Z: Database created.
2012-06-01 19:03:21Z: Importing data ...
2012-06-01 19:03:21Z: Importing "aspnet_Applications" ...
2012-06-01 19:03:21Z: Could not find stored procedure 'sp_dboption'.

one thing I found related seems to say that MonoX might not work with SQL Server 2012:

http://msdn.microsoft.com/en-us/library/hh231665.aspx

-------
If you are using SQL Server 2012 features with a SharePoint farm, you must apply SharePoint Server2010 Service Pack 1 (SP1) to the farm before adding SQL Server 2012 features. Pre-SP1 version of SharePoint 2010 uses a deprecated feature that was removed in Microsoft SQL Server 2012 . Applying SP1 adds a new methodology for connecting to SQL Server 2012 features.

Evidence that SP1 is required
This section describes the errors that will occur if SP1 is not installed. Errors are most likely to occur when you create a farm or update information in the configuration database. The following list summarizes the more common ways you will encounter this error.
In ULS logs, you will find the following error: Could not find stored procedure 'sp_dboption'.
In the SharePoint Products Configuration wizard, the wizard fails to create the configuration database.
--------------

is there a workarround for this issue? I see some discussion at:
http://connect.microsoft.com/SQLServer/feedback/details/723806/sql-server-2012-rc0-missing-master-sys-sp-dboption-stored-procedure

the code MonoX uses there should change according to http://msdn.microsoft.com/en-us/library/ms187310(SQL.105).aspx

sp_dboption (Transact-SQL)
SQL Server 2008 R2
Displays or changes database options.
Do not use sp_dboption to modify options on either the master database or the tempdb database.
Important This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible. Use ALTER DATABASE instead. To modify database options that are associated with replication (merge publish, published, subscribed), use sp_replicationdboption.
This content has not been rated yet. 
63 Reputation 10 Total posts
clipflair-rpx

clipflair-rpx

6/1/2012 4:45:17 PM
So a quick workarround might be to implement sp_dboption (the question is is sys.sp_dbopion or dbo.sp_dboption or what other name needed? [and why does the error message not specify the exact name and at what database it tries to find that missing SP?])

The question is what to put in there, could one possibly checkout the code of that stored proc from older SQL Server (not sure if that would work), or try to implement it so that it calls ALTER DATABASE (the one suggested as alternative by MS)?
This content has not been rated yet. 
63 Reputation 10 Total posts
clipflair-rpx

clipflair-rpx

6/1/2012 4:49:54 PM
in case MonoX uses sp_dboption to "Alter a SQL Server Database as Single User Mode and as Multi User Mode", the following
http://sqldbpool.com/2009/03/25/how-to-alter-a-sql-server-database-as-single-user-mode-and-as-multi-user-mode/

says:
you can alter the database access mode by using sql commands like ALTER DATABASE and sp_dboption.
ALTER DATABASE [MyDBName] SET MULTI_USER WITH NO_WAITALTER DATABASE [MyDBName] SET SINGLE_USER WITH NO_WAITorEXEC
sp_dboption ‘MyDBName’, ‘single user’, ‘false’EXEC sp_dboption ‘MyDBName’, ‘single user’, ‘true’

so I wonder if I could avoid MonoX making that call by doing such an action by hand (just a guess) and whether it uses sp_dboption later on too during install or even worse during runtime of MonoX portal
This content has not been rated yet. 
63 Reputation 10 Total posts
khorvat

khorvat

6/2/2012 9:40:22 AM
Hi,

we appreciate all the suggestions you have put in here and I have logged them in our feature / bug tracking system.  

1. Tell a Friend - company behind this feature is http://tellafriend.socialtwist.com/
2. MonoX requires only one of the selected authentication types not both of them, so use the one you prefer 
it seems that one needs to select "Windows Authentiction and SQL autentication" mode of SQL Server 2012 Express by right clicking the database node and editing security properties and not just set "SQL authentication" for the MonoX-related database they create. Just in case they should go to Logins too in that case and edit the "sa" password in case it has some default value that might pose a security risk it seems that one needs to select "Windows Authentiction and SQL autentication" mode of SQL Server 2012 Express by right clicking the database node and editing security properties and not just set "SQL authentication" for the MonoX-related database they create. Just in case they should go to Logins too in that case and edit the "sa" password in case it has some default value that might pose a security risk

3. Video conversion - we will fix the bug with preselected video conversion, but you need to be aware that FFMpeg is used for video conversion and they don't allow us to distribute the converter but you need to download it your self and put in the specified folder.

4. We will investigate the SQL 2012 issues and get back to you shortly

Regards
This content has not been rated yet. 
15993 Reputation 2214 Total posts
geobirbilis

geobirbilis

6/2/2012 9:58:11 AM
thanks for the quick reply, waiting for more info on 4 as soon as possible (btw, some friend told me that stored proc was deprecated since 2005, but seems even Microsoft's own SharePoint devs were bitten by that SP getting removed from SQL Server 2012 latest release)

regarding 2, I'd prefer to use Windows Authentication, but the docs only mention about some change needing to be done at web.config or something for it to work, but there's no step-by-step article on that or any screenshots/samples, or haven't spotted them
This content has not been rated yet. 
155 Reputation 23 Total posts
geobirbilis

geobirbilis

6/2/2012 10:00:08 AM
(btw, for the clipflair profile above I used Windows Live ID to login which resulted in the account's e-mail being shown here instead of some account name - wonder if this is a bug of RPX or something [it results to getting spammed from spam bots that gather e-mails])
This content has not been rated yet. 
155 Reputation 23 Total posts
khorvat

khorvat

6/2/2012 10:33:42 AM
We will get back to you on SQL 2012 work around soon, regarding 2. this isn't strictly related to MonoX so we didn't include detailed instructions in the MonoX manual, you need to change your connection string in web.config you can find more information here.

We will need to check the RPX issue and get back to you, in the meanwhile do you want us to change e-mail address for that account to stop the SPAM etc. ?

Regards
This content has not been rated yet. 
15993 Reputation 2214 Total posts
1 2 3