Skip to Content (Press Enter)
UserImage.jpg
João Martinho
15Views
13Comments
Re : Setting up a development server with Agile Platform 6 on Amazon EC2
Question
Hi all,

I'm trying to setup a development server with the Agile Platform 6.0. I'm using the standard Windows 64-bit AMI

AMI:Windows_Server-2008-R2_SP1-Language_Packs-64Bit-SQL_2008_R2_SP1_Express-2012.08.15 (ami-51959225)

I've followed the checklist and after I finished installing the Platform Server I can't connect to the database when creating the users and granting permissions.
I can grant permissions, but when I test the connection I always get "Failed to connect to database: Login failed for user OS_ADMIN".

I've checked on Microsoft SQL Server Management Studio that the database is created, which it is, and that the users are created, which they are. I'm stuck in the installation process and can't proceed.

Any lights on this?

Thank you
0
0
16 Oct 2012
Copy Link
2012-03-16 12-21-09
João Rosado
Staff
Hi João,

If the users are created, then SQL server is configured to only accept Windows Authentication logins.
(It is on the checklist install procedures for SQL Server if the Role combo-box has an option selected that includes "Database")

Do this to fix:
  • Connect with Microsoft SQL Server Management Studio
  • Right click the server
  • Click "Properties"
  • On the Security tab choose "SQL Server and Windows Authentication mode"
Also, when doing this make sure the "sa" user is disabled or change his password.

Regards,
João Rosado
1
0
16 Oct 2012
Copy Link
UserImage.jpg
João Martinho
 Hi João, 

That worked great! 

But now after creating the DB Schema and Session I get the following error in trying to save and exit. Do you know what this is?

Thanks


0
0
16 Oct 2012
Copy Link
2012-03-16 12-21-09
João Rosado
Staff
Hi João,

Copy pasting from the checklist:

Make sure that you have installed the role Web Server (IIS). If you don't, install it by doing the following:
  1. In the right pane, click Add Roles
  2. Choose Web Server (IIS)
  3. In Role Services, make sure to select:
    • Under Web Server:
      • Under Application Development:
        • Choose ASP.NET
      • Under Security:
        • Choose Windows Authentication
      • Under Performance:
        • Choose Static Content Compression
        • Choose Dynamic Content Compression
      • Under Management Tools:
        • Choose IIS Management Console
        • Under IIS 6 Management Compatibility:
          • Choose IIS 6 Metabase Compatibility
    • Make sure to accept all dependencies of the items mentioned above. For all the items not mentioned above, leave the default value.


You are missing at least the "IIS 6 Metabase Compatibility".


Regards,
João rosado
0
0
16 Oct 2012
Copy Link
UserImage.jpg
João Martinho
Hi João, 

I have all of those installed for the Web Server role. Any other ideas?

Thanks for the help.
0
0
16 Oct 2012
Copy Link
2012-03-16 12-21-09
João Rosado
Staff
Hi joão,

Well ...
There are some steps that require you to edit the applicationhost.config ...maybe you caused a parsing error on the xml.
(Or edited it with an editor that messed up the encoding of the file)

Try to access on https://localhost/
It should at least show the default IIS page.


Regards,
João Rosado
0
0
16 Oct 2012
Copy Link
UserImage.jpg
João Martinho
Hi again,

Does anyone have a clue about this issue when installing the Service Center?


PS C:\Program Files\OutSystems\Platform Server> .\SCInstall.bat
Service Center Installer v6.0.1.22
 
Start installing Service Center v6.0.1.22...
 
Publishing Extension(s)...
Publishing Extension 'OMLProcessor'...
Publishing Extension 'IntegrationStudio'...
Reading ServiceCenter.oml oml file information...
Adding ServiceCenter eSpace to database...
Compiling ServiceCenter eSpace...
Message 1
  [Error] Internal Error
Invalid compiler output.\r\nSystem.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to co
mpletion of the operation or the server is not responding.
   at OutSystems.HubEdition.RuntimePlatform.DBHelper.#B6(DbException e, IDbTransaction trans)
   at OutSystems.HubEdition.RuntimePlatform.DBHelper.ExecuteReader(IDbCommand cmd, String description, Boolean isApplica
tion, Boolean transformParameters, Boolean skipLog)
   at OutSystems.HubEdition.RuntimePlatform.DBHelper.ExecuteReader(IDbCommand cmd)
   at OutSystems.HubEdition.Compiler.Database.DBCompiler.GetDbSchemaFieldDataSqlServer_MainColumnData(IDbTransaction tra
n, String tableName, String catalogName)
   at #35b.#6Mc.#0Kc(String tableName, IList`1& fieldDefs, IList`1& indexes)
   at #35b.#yLc.#1Kc(IEnumerable`1 tableNames, Dictionary`2& fieldDefsForTable, Dictionary`2& indexesForTable)
   at OutSystems.HubEdition.Compiler.Database.EntitySchema.EntitySchemaUpdater.#FAb(TextWriter writer, String& sqlStatFK
sScript)
   at OutSystems.HubEdition.Compiler.Database.EntitySchema.EntitySchemaUpdater.Dump()
   at OutSystems.HubEdition.Compiler.ESpace.UpdateScript()
   at OutSystems.HubEdition.Compiler.ESpace.UpdateScriptThread()
 
PS C:\Program Files\OutSystems\Platform Server> .\SCInstall.bat
Service Center Installer v6.0.1.22
 
Start installing Service Center v6.0.1.22...
 
Publishing Extension(s)...
Publishing Extension 'OMLProcessor'...
Publishing Extension 'IntegrationStudio'...
Reading ServiceCenter.oml oml file information...
Adding ServiceCenter eSpace to database...
Compiling ServiceCenter eSpace...
Message 1
  [Error] Compilation Error
A timeout has occured. OutSystems compiler appears to be blocked.
0
0
30 Oct 2012
Copy Link
2019-06-17 07-29-54
Hermínio Mira
Hi João,

I have one installed in the most basic AMI possible:
Windows_Server-2008-SP2-English-64Bit-Base-2012.10.10 (ami-32b9065b)

I used the full 6.0 platform setup (Outsystems suite + SQL 2005 Express) and it gave several times error, the dreaded 106 which can basically mean 1000 things. Each time I rebooted the machine and ran setup again... in the end it installed everything and is working fine, slow, but fine. (using free tier I can't ask for more really :) )

Hope you can solve your issue (probably using a different AMI),
Hermínio Mira
0
0
31 Oct 2012
Copy Link
UserImage.jpg
Carlos Aguiar
Hi, don´t know if this is going to help but I will ask anyway. How much memory is being allocated to your EC Windows 2008 Server VM?  You need at least 2Gigabytes
I had similar problems when I tried to setup a community version on the Portugal Telecom SmartCloud. Everything was solved we I upgraded from a standard Windows 2008 Server with 1Gbyte RAM to a VM with 2Gbyte RAM.

Carlos Aguiar
0
0
01 Nov 2012
Copy Link
UserImage.jpg
João Martinho
Thank you for your replies.

We are trying to setup a free tier Amazon EC2 development server so the AMI is a micro instance, meaning 614MB of RAM...I do get the warnings when installing the platform that we need at least 1GB of RAM, but I thought that we could at least run the server, maybe only the performance would be penalized, but seeing as it's intended to be just a development server it would not be very critical at this point.

If this is not a possibility we'll have to think of an alternative for a development server.

Thanks!
0
0
01 Nov 2012
Copy Link
UserImage.jpg
Carlos Aguiar
With 1GByte you will constantly be running into trouble, take it from me. My experience is that with a 2GByte server, Setup is just next, next, next and Voilà, it´s installed and running.
0
0
01 Nov 2012
Copy Link
2019-06-17 07-29-54
Hermínio Mira
Again, I'm running it on a 614MB machine, free tier without issues for the last 20 days!
Publishing is a real pain (6-7mins) but thats the price of "free"...
0
0
02 Nov 2012
Copy Link
2024-01-22 15-21-29
Pedro Cardoso
Hermínio Mira wrote:
Again, I'm running it on a 614MB machine, free tier without issues for the last 20 days!
Publishing is a real pain (6-7mins) but thats the price of "free"...
 
 Hi Hermínio, 

check this post to see if you can increase the performance of your environment. Hope it help.

Cheers
0
0
17 Jan 2013
Copy Link
2011-06-15 10-50-19
Miguel Ventura
Staff
Hermínio Mira wrote:
Again, I'm running it on a 614MB machine, free tier without issues for the last 20 days!
Publishing is a real pain (6-7mins) but thats the price of "free"...
 
That's actually very nice!
If you're running on the free tier it means you're using a micro instance. Unlike the other instance types, the micro instance doesn't have assured CPU throughput. You can read it on the instance types page: all instances have their CPU capacity described in ECUs, while the micro instance has "up to 2 ECUs (for short periodic bursts)". It also means that if other guest VMs are running in the same host hardware, you'll get the capacity that's left from the others.

All in all this makes the compilation stages suffer in their times, but that's really due to the limits of the micro instance. You'd notice the same penalties on any software over any OS.
0
0
18 Jan 2013
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.