SSL Connect Error Using MMEx

[Bonifacio]

Hello@MMEx Forum

I have just started using MMEx and I cannot get it to work. I am using Win 10 fully updated with 64 bit version of MMEx.

As a test I have created a Portfolio an Investment Account and a Share Account. there is one UK Investment trust in it JMG.L, JP Morgan Emerging Markets Investment Trust plc. with a number of shares and an initial purchase price.

When I click refresh to update the price I get an error - SSL connect error.

It is the first time I have come across this on my pc. I have no idea how to solve it. I have turned off my firewall and Windows Defender, but no joy.

Can anyone assist me please.

Thankyou

Terry

[MartinArmstrong]

Are you based in the UK?

Yahoo, from whom MMEX gets the share prices has changed the way that UK/European countries need to access its service (a GDPR issue).

The problem is fixed now, so depending on how important this is to you right now, you may be content to wait for the next MMEX release, or you could install a beta version of that forthcoming release (although this is a work in progress in some areas).

The problem is discussed in detail here: https://github.com/moneymanagerex/money ... ssues/6040

A Windows beta with the fix can be obtained here: https://ci.appveyor.com/project/whalley ... /artifacts

Note that if you run that version, your .mmb database will be updated to a later standard and you won't be able to open it using MMEX 1.6.4, so make a backup first.

[Bonifacio]

Hi Martin

Many thanks for your reply.

1) Yes I am based in the UK

2) I read the Github thread although a bit beyond me.

3) I did everything you suggested, but I am still getting the "SSL connect error" I also note that if you click on Help Check For Updates in MMEx I still get the "SSL connect error" message. This was with Defender and my Firewall disabled.

Since I am new to MMEx I am wondering if I have not put together the portfolio, and share accounts correctly with the Investment Trust (JMG.L).

Do you know if there is a sample database that I could obtain to check my installation against?

Thanks

Terry

[MartinArmstrong]

I also note that if you click on Help Check For Updates in MMEx I still get the "SSL connect error" message.

Noted.

Led by the initial issue being related to updating share prices I jumped to the wrong conclusion that you were experiencing the Yahoo problem.

The Yahoo issue will still be there with MMEX 1.6.4 but given that you are also seeing the error when you do Check For Updates, then it's clear that there is a wider problem. This won't have anything to do with how you have created the share accounts.

I can't find any past reference to this problem, so have raised an issue here https://github.com/moneymanagerex/money ... ssues/6132, which hopefully someone can investigate for you soon.

[Wirmike]

@Martin
In addition to the report about the SSL item, you may find it useful to know that I am also having a Stock Price update issue.
I am finding that w/- ALL attempts I am greeted w/- a small MMEX window message as follows:

“Error
URL using bad/illegal format to missing URL”

You may find it useful to know that I successfully updated prices in MAY23 and have not touched the URL in “Options” for some considerable time before that.
(The most recent attempt to update was today, 22JLY2023)

Running:
————-
MMEX:1.16.4;
MacOS: 10.13.6;

Regards.

Ps. I am assuming that nothing untoward has happened to the URL in Options.
Can you confirm what the current URL should be?

[Bonifacio]

Hi MartinArmstrong

The report of my problem with the "SSL connect error" that you placed on Github has been responded to as below, moreover the thread has been closed

"n-stein commented 10 hours ago •
Same as #5870. Seems it is likely a transient error on the server side."

Well I still have the problem of not being able to connect to yahoo through mmex either prices or online help. My PC and other finance programs do not have any problems with "SSL connect"

I cannot see how something can be call transient when it is permanent (in my case)

What else can we do?

Thanks very much

Terry

[Renato]

I would try to delete the certificate under Windows:

Press the [Windows] and [R] keys simultaneously so that the "Run" command opens.
Enter "certmgr.msc" here and confirm with "OK". The Certificate Manager will then start.
Select the desired category on the left side and the appropriate certificate on the right side.
Click the certificate with the right mouse button and select the "Delete" option.
If you confirm the operation, the certificate will be deleted and declared invalid on your computer.

[MartinArmstrong]

I am also having a Stock Price update issue.

That's because you are running MMEX 1.6.4. That version is unable to update stock prices due to the changes that Yahoo made.

The fix to work around the changes will be included in the next release of MMEX.

[Bonifacio]

Hi Renato

Many thanks for your help and suggestion. I am into unknown territory here so a couple or more of questions.

1) "Select the desired category on the left side and the appropriate certificate on the right side." This certificate - Does it it relate to MMEx?

2) "Category" - What should I be looking for?

3) What happens when the certificate is deleted?

Thank you for you help.

Terry

[Renato]

Hi Bonifacio

Without knowing the exact error message and where it occurred, it is difficult to help further.
Certificates from "Trusted Issuers" and "Third Party Root Certification Authorities" are automatically renewed when they are deleted.

Another possibility would be to try to use a DNS server from outside GB.
https://www.windowscentral.com/how-chan ... windows-10

Which MMEX version are you currently using.

Have you tried using the latest portable MMEX version.
Please make a copy of your database ....mmb before and use it for this test.
https://ci.appveyor.com/api/buildjobs/j ... rtable.zip

Please let us know if it works, that way we could narrow down and solve the problem.