These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Market Discussions

 
  • Topic is locked indefinitely.
 

EMMA - Update to work with new style API keys - version 1.6
Author
Previous Topic Next Topic
StubbornMule
Aliastra
Gallente Federation
#61 - 2012-09-19 00:53:42 UTC  |  Edited by: StubbornMule
Kendra Prime wrote:
I am unable to get EMMA to connect to EVE-Central. Any Ideas?
I have allowed access through Windows Firewall, and am running EMMA in Admin mode.

Running Windows 7 x64

=====================================================================================
EXCEPTION REPORT
=====================================================================================
8/4/2012 11:00:50 PM Error - EveMarketMonitorApp.Common.EMMAException - Failed to contact www.eve-central.com
Status - DestinationPortUnreachable



I am also having this same error...I opened up EMMA through the firewall and it reaches everything else just fine as near as I can tell. I am also running Windows 7 x64 Any advice?
Ambo
Rattini Tribe
Minmatar Fleet Alliance
#62 - 2012-09-19 16:37:36 UTC
I shall investigate
Sabotaged
Veritas Vincit
#63 - 2012-10-11 09:06:16 UTC
Running Windows 8 w/ SQL Server 2012.

running 1.6.0.8

Autologin appears to be ignored.

I login, add a group, add my API Key, press ok and it says

Procedure or function RptGroupSetHasChar has too many arguments specified.
Ambo
Rattini Tribe
Minmatar Fleet Alliance
#64 - 2012-10-11 17:28:49 UTC
Afraid that I don't have access to a win 8 system (and absolutely no plans to upgrade) so I don't really have any idea how it'll behave.
Sabotaged
Veritas Vincit
#65 - 2012-10-11 22:19:43 UTC
Ambo wrote:
Afraid that I don't have access to a win 8 system (and absolutely no plans to upgrade) so I don't really have any idea how it'll behave.

So everyone who gets a new computer is SOL?

Your assuming its a windows 8 problem, I'm assuming it's a difference between 2008 express and 2012 express. Can't run 2008 on windows 8, but you can run 2012 on windows 7. Can you atleast upgrade that? Its free?
Ambo
Rattini Tribe
Minmatar Fleet Alliance
#66 - 2012-10-12 16:27:07 UTC
Sabotaged wrote:
Ambo wrote:
Afraid that I don't have access to a win 8 system (and absolutely no plans to upgrade) so I don't really have any idea how it'll behave.

So everyone who gets a new computer is SOL?

Your assuming its a windows 8 problem, I'm assuming it's a difference between 2008 express and 2012 express. Can't run 2008 on windows 8, but you can run 2012 on windows 7. Can you atleast upgrade that? Its free?


It might be to do with SQL 2012. The problem with that is that I'm not going to update EMMA to work with 2012. Last time it was a massive pita for most of my users and some never actually got their SQL installs working again.

The SQL express upgrade process is notoriously terrible.

So I'd have to upgrade my machine to 2012 to look at this one problem then trust that the uninstall back to 2008 will work properly. Frankly I have no faith whatsoever in that working.

So yes, I'm sorry but I can't do anything for you right now.
Ambo
Rattini Tribe
Minmatar Fleet Alliance
#67 - 2012-10-18 18:25:10 UTC
A few people have been having problems since CCP turned off HTTP access. To fix this, you just need to click through the error messages on startup, go to settings -> api settings and edit the base url there to be HTTPS instead of HTTP.

Should just work after that. Smile
Lost Hamster
Hamster Holding Corp
#68 - 2012-10-20 20:57:58 UTC
Ambo wrote:
A few people have been having problems since CCP turned off HTTP access. To fix this, you just need to click through the error messages on startup, go to settings -> api settings and edit the base url there to be HTTPS instead of HTTP.

Should just work after that. Smile


And if you still have a problem, then change from eve-online.com to eveonline.com ( full URL: https://api.eveonline.com)
Sinner Slayer
Crazy Chocobos in Space
#69 - 2012-10-20 21:09:49 UTC  |  Edited by: Sinner Slayer
just installed SQL Server 2012 on Windows 7 x64 and while loading error frame pops up:

"Problem loading EMMA:
Execution of user code in the .NET Framework is disabled. Enable "crl
enable" configuration option".

when i click OK, EMMA closes.
Ambo
Rattini Tribe
Minmatar Fleet Alliance
#70 - 2012-10-21 14:31:13 UTC
Sinner Slayer wrote:
just installed SQL Server 2012 on Windows 7 x64 and while loading error frame pops up:

"Problem loading EMMA:
Execution of user code in the .NET Framework is disabled. Enable "crl
enable" configuration option".

when i click OK, EMMA closes.


The 64 bit version of SQL Express has a bug that will mean EMMA will probably fail to run first time. The error will be somthing like 'CLR integration not enabled'. To fix this, simply restart Windows.
Sinner Slayer
Crazy Chocobos in Space
#71 - 2012-10-21 18:59:45 UTC
Ambo wrote:
Sinner Slayer wrote:
just installed SQL Server 2012 on Windows 7 x64 and while loading error frame pops up:

"Problem loading EMMA:
Execution of user code in the .NET Framework is disabled. Enable "crl
enable" configuration option".

when i click OK, EMMA closes.


The 64 bit version of SQL Express has a bug that will mean EMMA will probably fail to run first time. The error will be somthing like 'CLR integration not enabled'. To fix this, simply restart Windows.


nope. restart didn't changed a thing.
got error message asking for SQL Server 2008 at start, then when i loggin in got the .NET Framework error with the same mesaage in box :(
shags
Marginal Inc.
#72 - 2012-10-26 03:13:08 UTC
Lost Hamster wrote:
Ambo wrote:
A few people have been having problems since CCP turned off HTTP access. To fix this, you just need to click through the error messages on startup, go to settings -> api settings and edit the base url there to be HTTPS instead of HTTP.

Should just work after that. Smile


And if you still have a problem, then change from eve-online.com to eveonline.com ( full URL: https://api.eveonline.com)


This worked for me, thanks guys.
shags
Marginal Inc.
#73 - 2012-10-26 03:15:17 UTC
StubbornMule wrote:
Kendra Prime wrote:
I am unable to get EMMA to connect to EVE-Central. Any Ideas?
I have allowed access through Windows Firewall, and am running EMMA in Admin mode.

Running Windows 7 x64

=====================================================================================
EXCEPTION REPORT
=====================================================================================
8/4/2012 11:00:50 PM Error - EveMarketMonitorApp.Common.EMMAException - Failed to contact www.eve-central.com
Status - DestinationPortUnreachable



I am also having this same error...I opened up EMMA through the firewall and it reaches everything else just fine as near as I can tell. I am also running Windows 7 x64 Any advice?



Same here, this has not worked for me at all since i started playing again a few months back. I thought they had disabled the service or something. does it work for others?

windows 7 x64
Ambo
Rattini Tribe
Minmatar Fleet Alliance
#74 - 2012-10-26 17:22:20 UTC
As far as I'm aware it's still active. Perhaps they've just configured the server not to respond to pings? I'll try and remember to look into it this weekend.
Ambo
Rattini Tribe
Minmatar Fleet Alliance
#75 - 2012-10-26 17:28:49 UTC
Sinner Slayer wrote:
Ambo wrote:
Sinner Slayer wrote:
just installed SQL Server 2012 on Windows 7 x64 and while loading error frame pops up:

"Problem loading EMMA:
Execution of user code in the .NET Framework is disabled. Enable "crl
enable" configuration option".

when i click OK, EMMA closes.


The 64 bit version of SQL Express has a bug that will mean EMMA will probably fail to run first time. The error will be somthing like 'CLR integration not enabled'. To fix this, simply restart Windows.


nope. restart didn't changed a thing.
got error message asking for SQL Server 2008 at start, then when i loggin in got the .NET Framework error with the same mesaage in box :(


I'm afraid I haven't tested with SQL 2012 and it's unlikely I will be any time soon. Perhaps it's just not compatible without changes Sad
Lost Hamster
Hamster Holding Corp
#76 - 2012-11-04 18:42:34 UTC  |  Edited by: Lost Hamster
I have just installed an evaluation SQL 2012, and it is working fine with EMMA, when you are using differently to connect to the SQL DB.
Basically tha basic EMMA is using USER instance to run the SQL DB, with this change you are eliminating the user instance.
It's an "advanced" connection mode.

In SQL management console attach the two SQL database to the server. (EMMADatabase and EveData)

Then you need to edit the EveMarketMonitorApp.exe.config file.

Look for this lines bellow, and change them to look like this:

add name="EveMarketMonitorApp.Properties.Settings.EMMA_DatabaseConnectionString"
connectionString="Data Source=COMPUTERNAME;database=EMMADatabase;Trusted_Connection=yes" providerName="System.Data.SqlClient"

add name="EveMarketMonitorApp.Properties.Settings.ebs_DATADUMPConnectionString"
connectionString="Data Source=COMPUTERNAME;database=EveData;;Integrated Security=True" providerName="System.Data.SqlClient"

When this changes are done, it should work like charm (If you can set it up). Cool

EDIT:

I managed to get it work with the normal way, however to get it to work, you really need some deep hacking.
The problem is that during the database initialization for whatever reason it does not get or accepts the command:
sp_configure 'clr enabled', 1
command, and the program stops working. As a workaround I have connected directly to the user instance, set up the required value, and then run the program normally.

And this is how I got it working. Start SQL management studio.
Start EMMA, wait you get the error.
Then run this query against the database:
select * from sys.dm_os_child_instances

There is a column called: Instance_pipe_name
right click on the value, and copy to clipboard.
Open a new connection /File -> Connect object explorer
there to the server name paste the value, and connect.
New query, and execute the following commands:
sp_configure 'clr enabled', 1
go
reconfigure
go

you can now close EMMA, and start it again, it should work now.
Ambo
Rattini Tribe
Minmatar Fleet Alliance
#77 - 2012-11-05 19:27:04 UTC
Wow LH, good work. Shocked

Thanks for sharing it.
Gabriel Braun
Wrabble Wrousers
#78 - 2012-11-22 12:21:48 UTC  |  Edited by: Gabriel Braun
Fixed
Ambo
Rattini Tribe
Minmatar Fleet Alliance
#79 - 2012-12-05 21:05:42 UTC
Just put version 1.6.1.0 out.

This has a few fixes for little problems (main one being that item filters on various screens had been broken since CCP changed to 32 bit IDs for items)
The static data has also been updated to the latest retribution release (thanks to Lost Hamster for that one)
Finally, I've added a feature to export your data to Eve API format XML. It doesn't export everything yet, it's a work-in-progress. (The intention is that this will be used to export your data from EMMA 1.6 to EMMA 2 when I finally get that finished.)
flakeys
Doomheim
#80 - 2012-12-09 16:54:09 UTC
AMBO IT'S OUT AND YOU DIDNT EVEN MAIL ME

We are all born ignorant, but one must work hard to remain stupid.