You are viewing a plain text version of this content. The canonical link for it is here.
Posted to stonehenge-dev@incubator.apache.org by Vineet ghatge <vg...@gmail.com> on 2009/08/11 08:37:20 UTC
HELP-metro contribution
Hello all,
I was successful in doing the till "verify the deployment".The next step
according to the manual is " Metro StockTrader Configuration".
The document refers to .NET script which sets up the database.I was not able
to make out as which code its talking about.Could someone send me the link?
I have been using a old version of setup_utilites(downloaded on 30/3/09)
.Will this be of any use?
With Regards,
Vineet Ghatge H
Fwd: HELP-metro contribution
Posted by Vineet ghatge <vg...@gmail.com>.
---------- Forwarded message ----------
From: Vineet ghatge <vg...@gmail.com>
Date: Tue, Aug 11, 2009 at 7:55 PM
Subject: Re: HELP-metro contribution
To: stonehenge-dev@incubator.apache.org
Hi Ben,
I am comfortable with SQL management.When I say "setupaction.exe"the output
in the command line is:-
-Setting up database
-Config.Appsettings:
-dbserver is .\MSSQLExpress
-installPath is C:\StockTraderDemo\
dbadmin is sa
authType is SQL
.....
system.expection:unable to login with newly created trade user
account,Error:login failed for the user 'trade'
at setupactions.setupaction.createdatabase(string databasename,string
userid,string password) in
C:\stocktraderdemo\setup_utilities\SetupActions\setupactions.cs
What do you mean by the database was populated for a couple of seconds?
-I checked for database->stocktraderDB using SQL management,the database is
present however the tables are not there.
If you already have the DB setup from a .NET installation all you would need
to do is add the endpoints to the Services table.
-when i had initially taken the code from stonhenge a couples month back,I
was successful in populating the database .The previous database did not
have a "Service Table".So I am doing it again.Moreover,there has been lot of
changes in the code since then
Now can you pls tell me the right approach to fix the bug?
with Regards,
Vineet Ghatge H
Re: HELP-metro contribution
Posted by Vineet ghatge <vg...@gmail.com>.
On Tue, Aug 11, 2009 at 9:26 PM, Vineet ghatge <vg...@gmail.com> wrote:
>
>
> Hi Ben,
>
> I feel something is missing in the instructions in the wiki
>
> With Regards,
> Vineet Ghatge H
>
>
Re: HELP-metro contribution
Posted by Ranjitha V <ra...@gmail.com>.
Hi all,
I finished running through the test scenarios as well. I used "uid:0"
and "xxx".
I observed the following:
-> Choosing METRO_BS, I am able to successfully login with all the other OPS
(DOTNET,PHP,
JAVA - both secured and non secure)
-> However, actual transactions of "buy" and "sell" are not happening in any
of the combination
of services.
-> If I choose a different BS i.e,apart from METRO, I am unable to log in.
Should we make some changes in the order processor? Because I think a
combination
of METRO_BS and METRO_OPS should result in a successful transaction. Right?
-Ranjitha
On Wed, Aug 12, 2009 at 3:32 PM, Ranjitha V <ra...@gmail.com> wrote:
> Hello Ben,
>
> I was trying to get the Metro version running. I have completed it i.e, I
> was able to set
> the corresponding BS and OPS after clicking on the tab 'Config'.
>
> For the test cases, is it mandatory to create an account? Because I did
> not see any link called "buy" under Quotes/Trade.
>
> Thanks!
>
> -Ranjitha
>
>
> On Wed, Aug 12, 2009 at 2:13 PM, Vineet ghatge <vg...@gmail.com>wrote:
>
>> Hi Ben,
>>
>> I got the database populated.My authentication was set to 'SQL' I had to
>> change it to 'Integrated'
>>
>> Thank You!
>>
>> With Regards,
>> Vineet Ghatge H
>>
>
>
Re: HELP-metro contribution
Posted by Ranjitha V <ra...@gmail.com>.
Hello Ben,
I was trying to get the Metro version running. I have completed it i.e, I
was able to set
the corresponding BS and OPS after clicking on the tab 'Config'.
For the test cases, is it mandatory to create an account? Because I did
not see any link called "buy" under Quotes/Trade.
Thanks!
-Ranjitha
On Wed, Aug 12, 2009 at 2:13 PM, Vineet ghatge <vg...@gmail.com> wrote:
> Hi Ben,
>
> I got the database populated.My authentication was set to 'SQL' I had to
> change it to 'Integrated'
>
> Thank You!
>
> With Regards,
> Vineet Ghatge H
>
Re: HELP-metro contribution
Posted by Vineet ghatge <vg...@gmail.com>.
Hi Ben,
I got the database populated.My authentication was set to 'SQL' I had to
change it to 'Integrated'
Thank You!
With Regards,
Vineet Ghatge H
RE: HELP-metro contribution
Posted by Ben Dewey <Be...@26ny.com>.
Try using Windows Authentication. Set your SetupAction/App.config to authType setting to 'Integrated'
Just guessing, I'm not sure what's happening in your environment. The thought is that your account doesn't have access to create a login.
-Ben
-----Original Message-----
From: Vineet ghatge [mailto:vgh4uster@gmail.com]
Sent: Tuesday, August 11, 2009 11:57 AM
To: stonehenge-dev@incubator.apache.org
Subject: Re: HELP-metro contribution
Hi Ben,
I deleted it manually,despite which I am getting that error.
With Regards,
Vineet Ghatge H
Re: HELP-metro contribution
Posted by Vineet ghatge <vg...@gmail.com>.
Hi Ben,
I deleted it manually,despite which I am getting that error.
With Regards,
Vineet Ghatge H
RE: HELP-metro contribution
Posted by Ben Dewey <Be...@26ny.com>.
Vineet,
I think the old trade account may remain from the previous installation. Can you try to manually delete the old trade account from SQL Server?
-Ben
________________________________________
From: Vineet ghatge [vgh4uster@gmail.com]
Sent: Tuesday, August 11, 2009 10:25 AM
To: stonehenge-dev@incubator.apache.org
Subject: Re: HELP-metro contribution
Hi Ben,
I am comfortable with SQL management.When I say "setupaction.exe"the output
in the command line is:-
-Setting up database
-Config.Appsettings:
-dbserver is .\MSSQLExpress
-installPath is C:\StockTraderDemo\
dbadmin is sa
authType is SQL
.....
system.expection:unable to login with newly created trade user
account,Error:login failed for the user 'trade'
at setupactions.setupaction.createdatabase(string databasename,string
userid,string password) in
C:\stocktraderdemo\setup_utilities\SetupActions\setupactions.cs
What do you mean by the database was populated for a couple of seconds?
-I checked for database->stocktraderDB using SQL management,the database is
present however the tables are not there.
If you already have the DB setup from a .NET installation all you would need
to do is add the endpoints to the Services table.
-when i had initially taken the code from stonhenge a couples month back,I
was successful in populating the database .The previous database did not
have a "Service Table".So I am doing it again.Moreover,there has been lot of
changes in the code since then
Now can you pls tell me the right approach to fix the bug?
with Regards,
Vineet Ghatge H
Re: HELP-metro contribution
Posted by Vineet ghatge <vg...@gmail.com>.
Hi Ben,
I am comfortable with SQL management.When I say "setupaction.exe"the output
in the command line is:-
-Setting up database
-Config.Appsettings:
-dbserver is .\MSSQLExpress
-installPath is C:\StockTraderDemo\
dbadmin is sa
authType is SQL
.....
system.expection:unable to login with newly created trade user
account,Error:login failed for the user 'trade'
at setupactions.setupaction.createdatabase(string databasename,string
userid,string password) in
C:\stocktraderdemo\setup_utilities\SetupActions\setupactions.cs
What do you mean by the database was populated for a couple of seconds?
-I checked for database->stocktraderDB using SQL management,the database is
present however the tables are not there.
If you already have the DB setup from a .NET installation all you would need
to do is add the endpoints to the Services table.
-when i had initially taken the code from stonhenge a couples month back,I
was successful in populating the database .The previous database did not
have a "Service Table".So I am doing it again.Moreover,there has been lot of
changes in the code since then
Now can you pls tell me the right approach to fix the bug?
with Regards,
Vineet Ghatge H
RE: HELP-metro contribution
Posted by Ben Dewey <Be...@26ny.com>.
What do you mean by the database was populated for a couple of seconds?
Are you comfortable with SQL Management Studio? Can you manually see if the Database or User were created?
-Ben
________________________________________
From: Vineet ghatge [vgh4uster@gmail.com]
Sent: Tuesday, August 11, 2009 8:28 AM
To: stonehenge-dev@incubator.apache.org
Subject: Re: HELP-metro contribution
Hello all,
I tried running the scripts as per ming's intsructions,when I ran the setup
actions.exe file I got the following errors:-
system.expection:unable to login with newly created trade user
account,Error:login failed for the user 'trade'
at setupactions.setupaction.createdatabase(string databasename,string
userid,string password) in
C:\stocktraderdemo\setup_utilities\SetupActions\setupactions.cs
This error was generated after the database was populated for couple of
seconds
I was not able to fix the Bug,can some one suggest where the problem is?
With Regards,
Vineet Ghatge H
Re: HELP-metro contribution
Posted by Vineet ghatge <vg...@gmail.com>.
Hi prajwal,
No there is no attachment at all
I suppose the mailing list does not support attachment,last time ranjitha
tried sending a file,,it did not work though
With Regards,
Vineet Ghatge H
Re: HELP-metro contribution
Posted by Prajwal Muralidhara <Pr...@Sun.COM>.
Hi Vineet,
Check your browser settings. You may have to click button like "show
images from....". Generally happens if image type is not jpeg/jpg. I'm
sending the same mail once again for clarity.
Prajwal
Vineet ghatge wrote:
> Hi Prajwal,
>
> Your snapshot is missing
>
>
Re: HELP-metro contribution
Posted by Vineet ghatge <vg...@gmail.com>.
Hi Prajwal,
Your snapshot is missing
Re: HELP-metro contribution
Posted by Prajwal Muralidhara <Pr...@Sun.COM>.
hi Ben,
I'm stuck in changing the config part. I have followed the steps as u
have said. I was able to successfully populate the database by running
SetupActions.exe. But when i click the config tab in
http://localhost:8090/trader_client, I get this error message
"javax.faces.FacesException: Cant instantiate class:
org.apache.stonehenge.stocktrader.bean.ConfigServiceBean.. Network error
IOException: Connection refused: connect".
I am attaching the snapshot. Kindly suggest me how to deal with this
problem.
Regards
Prajwal
Ben Dewey wrote:
> Ranjitha,
>
> Are you just trying to get metro running? Or are you trying to get metro and .net interoperating? Do you have .NET already running?
>
> SetupActions.exe under dotnet performs the following steps:
> 1. drops stocktraderdb (if exists)
> 2. create stocktraderdb
> 3. add trade/yyy user
> 4. add trade user as db_owner of stocktraderdb
> 5. create xml helper stored procs
> 6. inserts records from xml files
>
>
> So, basically if you running a clean SQL Server with no db or login created you would follow these steps to get Metro running:
>
> 1. get/build/deploy metro
> 2. verify endpoints
> 3. create database using SetupActions (this creates and populates the db)
> 4. updated DB with metro endpoints under SERVICE table.
> 5. run metro/trader_client
> 6. select config tab
> 7. Change config to use JAVA_BS/JAVA_OPS
> 8. try to login to metro/trader_client using uid:0/xxx
> 9. test placing an order
>
> -Ben Dewey
>
> -----Original Message-----
> From: Ranjitha V [mailto:ranjitha123@gmail.com]
> Sent: Wednesday, August 12, 2009 12:09 AM
> To: stonehenge-dev@incubator.apache.org
> Subject: Re: HELP-metro contribution
>
> Hi Ben,
>
> I am a little confused as to how to go about these last few steps.
> I am summarizing it here. Correct me if I am wrong. Add some details if any
> missing.
>
> To establish the endpoints for Metro Stock Trader Configuration, we have to
>
> -> Download the dotnet version from stonehenge site.
> -> Populate the tables(if not already done) using SQL server.
> -> Connect to the SQL server.
> -> Run SetupActions.exe present in /setup_utilities/setupActions/bin/Release
>
> After this, should we check for endpoints by visiting the appropriate URLs
> mentioned in
> manual.doc?
> If not,how exactly do we do it?
>
> -Ranjitha
>
> On Wed, Aug 12, 2009 at 7:55 AM, Ben Dewey <Be...@26ny.com> wrote:
>
>
>> Vineet,
>>
>> Are you still having the same problem?
>>
>>
>>
>> -----Original Message-----
>> From: Vineet ghatge [mailto:vgh4uster@gmail.com]
>> Sent: Tuesday, August 11, 2009 9:34 PM
>> To: stonehenge-dev@incubator.apache.org
>> Subject: Fwd: HELP-metro contribution
>>
>> ---------- Forwarded message ----------
>> From: Vineet ghatge <vg...@gmail.com>
>> Date: Tue, Aug 11, 2009 at 5:58 PM
>> Subject: Re: HELP-metro contribution
>> To: stonehenge-dev@incubator.apache.org
>>
>>
>>
>>
>> Hello all,
>>
>> I tried running the scripts as per ming's intsructions,when I ran the setup
>> actions.exe file I got the following errors:-
>> system.expection:unable to login with newly created trade user
>> account,Error:login failed for the user 'trade'
>> at setupactions.setupaction.createdatabase(string databasename,string
>> userid,string password) in
>> C:\stocktraderdemo\setup_utilities\SetupActions\setupactions.cs
>>
>> This error was generated after the database was populated for couple of
>> seconds
>>
>> I was not able to fix the Bug,can some one suggest where the problem is?
>>
>> With Regards,
>> Vineet Ghatge H
>>
>>
RE: HELP-metro contribution
Posted by Ben Dewey <Be...@26ny.com>.
Ranjitha,
Are you just trying to get metro running? Or are you trying to get metro and .net interoperating? Do you have .NET already running?
SetupActions.exe under dotnet performs the following steps:
1. drops stocktraderdb (if exists)
2. create stocktraderdb
3. add trade/yyy user
4. add trade user as db_owner of stocktraderdb
5. create xml helper stored procs
6. inserts records from xml files
So, basically if you running a clean SQL Server with no db or login created you would follow these steps to get Metro running:
1. get/build/deploy metro
2. verify endpoints
3. create database using SetupActions (this creates and populates the db)
4. updated DB with metro endpoints under SERVICE table.
5. run metro/trader_client
6. select config tab
7. Change config to use JAVA_BS/JAVA_OPS
8. try to login to metro/trader_client using uid:0/xxx
9. test placing an order
-Ben Dewey
-----Original Message-----
From: Ranjitha V [mailto:ranjitha123@gmail.com]
Sent: Wednesday, August 12, 2009 12:09 AM
To: stonehenge-dev@incubator.apache.org
Subject: Re: HELP-metro contribution
Hi Ben,
I am a little confused as to how to go about these last few steps.
I am summarizing it here. Correct me if I am wrong. Add some details if any
missing.
To establish the endpoints for Metro Stock Trader Configuration, we have to
-> Download the dotnet version from stonehenge site.
-> Populate the tables(if not already done) using SQL server.
-> Connect to the SQL server.
-> Run SetupActions.exe present in /setup_utilities/setupActions/bin/Release
After this, should we check for endpoints by visiting the appropriate URLs
mentioned in
manual.doc?
If not,how exactly do we do it?
-Ranjitha
On Wed, Aug 12, 2009 at 7:55 AM, Ben Dewey <Be...@26ny.com> wrote:
> Vineet,
>
> Are you still having the same problem?
>
>
>
> -----Original Message-----
> From: Vineet ghatge [mailto:vgh4uster@gmail.com]
> Sent: Tuesday, August 11, 2009 9:34 PM
> To: stonehenge-dev@incubator.apache.org
> Subject: Fwd: HELP-metro contribution
>
> ---------- Forwarded message ----------
> From: Vineet ghatge <vg...@gmail.com>
> Date: Tue, Aug 11, 2009 at 5:58 PM
> Subject: Re: HELP-metro contribution
> To: stonehenge-dev@incubator.apache.org
>
>
>
>
> Hello all,
>
> I tried running the scripts as per ming's intsructions,when I ran the setup
> actions.exe file I got the following errors:-
> system.expection:unable to login with newly created trade user
> account,Error:login failed for the user 'trade'
> at setupactions.setupaction.createdatabase(string databasename,string
> userid,string password) in
> C:\stocktraderdemo\setup_utilities\SetupActions\setupactions.cs
>
> This error was generated after the database was populated for couple of
> seconds
>
> I was not able to fix the Bug,can some one suggest where the problem is?
>
> With Regards,
> Vineet Ghatge H
>
Re: HELP-metro contribution
Posted by Ranjitha V <ra...@gmail.com>.
Hi Ben,
I am a little confused as to how to go about these last few steps.
I am summarizing it here. Correct me if I am wrong. Add some details if any
missing.
To establish the endpoints for Metro Stock Trader Configuration, we have to
-> Download the dotnet version from stonehenge site.
-> Populate the tables(if not already done) using SQL server.
-> Connect to the SQL server.
-> Run SetupActions.exe present in /setup_utilities/setupActions/bin/Release
After this, should we check for endpoints by visiting the appropriate URLs
mentioned in
manual.doc?
If not,how exactly do we do it?
-Ranjitha
On Wed, Aug 12, 2009 at 7:55 AM, Ben Dewey <Be...@26ny.com> wrote:
> Vineet,
>
> Are you still having the same problem?
>
>
>
> -----Original Message-----
> From: Vineet ghatge [mailto:vgh4uster@gmail.com]
> Sent: Tuesday, August 11, 2009 9:34 PM
> To: stonehenge-dev@incubator.apache.org
> Subject: Fwd: HELP-metro contribution
>
> ---------- Forwarded message ----------
> From: Vineet ghatge <vg...@gmail.com>
> Date: Tue, Aug 11, 2009 at 5:58 PM
> Subject: Re: HELP-metro contribution
> To: stonehenge-dev@incubator.apache.org
>
>
>
>
> Hello all,
>
> I tried running the scripts as per ming's intsructions,when I ran the setup
> actions.exe file I got the following errors:-
> system.expection:unable to login with newly created trade user
> account,Error:login failed for the user 'trade'
> at setupactions.setupaction.createdatabase(string databasename,string
> userid,string password) in
> C:\stocktraderdemo\setup_utilities\SetupActions\setupactions.cs
>
> This error was generated after the database was populated for couple of
> seconds
>
> I was not able to fix the Bug,can some one suggest where the problem is?
>
> With Regards,
> Vineet Ghatge H
>
RE: HELP-metro contribution
Posted by Ben Dewey <Be...@26ny.com>.
Vineet,
Are you still having the same problem?
-----Original Message-----
From: Vineet ghatge [mailto:vgh4uster@gmail.com]
Sent: Tuesday, August 11, 2009 9:34 PM
To: stonehenge-dev@incubator.apache.org
Subject: Fwd: HELP-metro contribution
---------- Forwarded message ----------
From: Vineet ghatge <vg...@gmail.com>
Date: Tue, Aug 11, 2009 at 5:58 PM
Subject: Re: HELP-metro contribution
To: stonehenge-dev@incubator.apache.org
Hello all,
I tried running the scripts as per ming's intsructions,when I ran the setup
actions.exe file I got the following errors:-
system.expection:unable to login with newly created trade user
account,Error:login failed for the user 'trade'
at setupactions.setupaction.createdatabase(string databasename,string
userid,string password) in
C:\stocktraderdemo\setup_utilities\SetupActions\setupactions.cs
This error was generated after the database was populated for couple of
seconds
I was not able to fix the Bug,can some one suggest where the problem is?
With Regards,
Vineet Ghatge H
Fwd: HELP-metro contribution
Posted by Vineet ghatge <vg...@gmail.com>.
---------- Forwarded message ----------
From: Vineet ghatge <vg...@gmail.com>
Date: Tue, Aug 11, 2009 at 5:58 PM
Subject: Re: HELP-metro contribution
To: stonehenge-dev@incubator.apache.org
Hello all,
I tried running the scripts as per ming's intsructions,when I ran the setup
actions.exe file I got the following errors:-
system.expection:unable to login with newly created trade user
account,Error:login failed for the user 'trade'
at setupactions.setupaction.createdatabase(string databasename,string
userid,string password) in
C:\stocktraderdemo\setup_utilities\SetupActions\setupactions.cs
This error was generated after the database was populated for couple of
seconds
I was not able to fix the Bug,can some one suggest where the problem is?
With Regards,
Vineet Ghatge H
Re: HELP-metro contribution
Posted by Vineet ghatge <vg...@gmail.com>.
Hello all,
I tried running the scripts as per ming's intsructions,when I ran the setup
actions.exe file I got the following errors:-
system.expection:unable to login with newly created trade user
account,Error:login failed for the user 'trade'
at setupactions.setupaction.createdatabase(string databasename,string
userid,string password) in
C:\stocktraderdemo\setup_utilities\SetupActions\setupactions.cs
This error was generated after the database was populated for couple of
seconds
I was not able to fix the Bug,can some one suggest where the problem is?
With Regards,
Vineet Ghatge H
Re: HELP-metro contribution
Posted by Ming Jin <sk...@gmail.com>.
Hi, Vineet
You can find those db files under /setup_utilities/DataLoad.
Otherwise, you can first set up .NET version of StockTrader to initialize
the basis environment.
On Tue, Aug 11, 2009 at 4:37 PM, Vineet ghatge <vg...@gmail.com> wrote:
> Hello all,
>
> I was successful in doing the till "verify the deployment".The next step
> according to the manual is " Metro StockTrader Configuration".
>
> The document refers to .NET script which sets up the database.I was not
> able
> to make out as which code its talking about.Could someone send me the link?
>
> I have been using a old version of setup_utilites(downloaded on 30/3/09)
> .Will this be of any use?
>
> With Regards,
> Vineet Ghatge H
>
--
Ming Jin
Consultant
Thoughtworks, Inc
Mobile: +86 135-2125-6300
Email: skyairmj@gmail.com
MSN: skyairmj@hotmail.com
Blog: http://blogjava.net/mingj
Twitter: https://twitter.com/mingjin
RE: HELP-metro contribution
Posted by Ben Dewey <Be...@26ny.com>.
If you already have the DB setup from a .NET installation all you would need to do is add the endpoints to the Services table.
See my walk-thru doc from last night for a screenshot.
-Ben
________________________________________
From: Vineet ghatge [vgh4uster@gmail.com]
Sent: Tuesday, August 11, 2009 4:37 AM
To: stonehenge-dev@incubator.apache.org
Subject: HELP-metro contribution
Hello all,
I was successful in doing the till "verify the deployment".The next step
according to the manual is " Metro StockTrader Configuration".
The document refers to .NET script which sets up the database.I was not able
to make out as which code its talking about.Could someone send me the link?
I have been using a old version of setup_utilites(downloaded on 30/3/09)
.Will this be of any use?
With Regards,
Vineet Ghatge H