Invalid Credentials error
Good morning, I have used Monetdb for a few weeks now and this evening I cannot login after a full system restart (windows+monetdb). Environment : Windows 10 (well, it's my work computer, I don't have a lot of choice) Monetdb 5 server v11.31.11 I start monetdb by using C:\Program Files\MonetDB\MonetDB5\bin\mserver5.exe Then mclient on C:\Program Files\MonetDB\MonetDB5\mclient.bat (and usually it work just fine) I also tried with mclient.exe using the -x command to debug. Error message : C:\Program Files\MonetDB\MonetDB5\bin>mclient -X -d demo user(win32):monetdb password: MAPI = monetdb@localhost:50000 ACTION= mapi_reconnect ERROR = !InvalidCredentialsException:checkCredentials:invalid credentials for user 'monetdb' Of course, I use the default monetdb/monetdb credentials. I have no idea of what happens and moreover I have lost an entire schema (I see that if I connect through Tableau Desktop...). I have done an upgrade on the last version (11.31.13) and same result, impossible to connect. And same result. I spend the entire evening on that a Thank in advance. Simon AUBERT [cid:691B9F4089B9F34B8E0C22B39B7117EC@eurprd07.prod.outlook.com] Bourse Maritime - 1, place Lainé - 33 000 Bordeaux Mob : +33(0)6 66 28 52 04
Hi Simon, The MonetDB server on windows is normally started with script M5server.bat (or MSQLserver.bat which calls M5server.bat). Try if you can restart the MonetDB server that way. Wait till the server startup is ready for accepting application/mclient connection. The console should show the # MonetDB/SQL module loaded
prompt. Next start mclient.bat Note that the demo database is stored in the user profile area, in my case in: C:\Users\martin\AppData\Roaming\MonetDB5\dbfarm\demo It could be that when you restarted Windows OS you logged in with a different user. In that case the original demo database is located in a different location. martin On 15-01-2019 11:41, AUBERT Simon wrote:
Good morning,
I have used Monetdb for a few weeks now and this evening I cannot login after a full system restart (windows+monetdb).
Environment : Windows 10 (well, it’s my work computer, I don’t have a lot of choice) Monetdb 5 server v11.31.11
I start monetdb by using C:\Program Files\MonetDB\MonetDB5\bin\mserver5.exe
Then mclient on C:\Program Files\MonetDB\MonetDB5\mclient.bat
(and usually it work just fine)
I also tried with mclient.exe using the -x command to debug. Error message : C:\Program Files\MonetDB\MonetDB5\bin>mclient -X -d demo
user(win32):monetdb
password:
MAPI = monetdb@localhost:50000
ACTION= mapi_reconnect
ERROR = !InvalidCredentialsException:checkCredentials:invalid credentials for user 'monetdb'
Of course, I use the default monetdb/monetdb credentials.
I have no idea of what happens and moreover I have lost an entire schema (I see that if I connect through Tableau Desktop…). I have done an upgrade on the last version (11.31.13) and same result, impossible to connect.
And same result.
I spend the entire evening on that a
Thank in advance.
*Simon AUBERT*
cid:691B9F4089B9F34B8E0C22B39B7117EC@eurprd07.prod.outlook.com
Bourse Maritime – 1, place Lainé – 33 000 Bordeaux
Mob : +33(0)6 66 28 52 04
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Good evening, Thanks for your help, Martin, but sadly, it didn't work either. I reboot my computer, load Monetdb through the bat M5server.bat, idem for mclient (mclient.bat) and still the same message. My database is stored on C:\Users\saubert\AppData\Roaming\MonetDB5\dbfarm\demo and that's the windows user I'm currently using. Best regards, Simon De : users-list [mailto:users-list-bounces+simon.aubert=businessdecision.com@monetdb.org] De la part de dinther Envoyé : mardi 15 janvier 2019 16:39 À : users-list@monetdb.org Objet : Re: Invalid Credentials error Hi Simon, The MonetDB server on windows is normally started with script M5server.bat (or MSQLserver.bat which calls M5server.bat). Try if you can restart the MonetDB server that way. Wait till the server startup is ready for accepting application/mclient connection. The console should show the # MonetDB/SQL module loaded
prompt. Next start mclient.bat Note that the demo database is stored in the user profile area, in my case in: C:\Users\martin\AppData\Roaming\MonetDB5\dbfarm\demo It could be that when you restarted Windows OS you logged in with a different user. In that case the original demo database is located in a different location. martin On 15-01-2019 11:41, AUBERT Simon wrote: Good morning, I have used Monetdb for a few weeks now and this evening I cannot login after a full system restart (windows+monetdb). Environment : Windows 10 (well, it's my work computer, I don't have a lot of choice) Monetdb 5 server v11.31.11 I start monetdb by using C:\Program Files\MonetDB\MonetDB5\bin\mserver5.exe Then mclient on C:\Program Files\MonetDB\MonetDB5\mclient.bat (and usually it work just fine) I also tried with mclient.exe using the -x command to debug. Error message : C:\Program Files\MonetDB\MonetDB5\bin>mclient -X -d demo user(win32):monetdb password: MAPI = monetdb@localhost:50000 ACTION= mapi_reconnect ERROR = !InvalidCredentialsException:checkCredentials:invalid credentials for user 'monetdb' Of course, I use the default monetdb/monetdb credentials. I have no idea of what happens and moreover I have lost an entire schema (I see that if I connect through Tableau Desktop...). I have done an upgrade on the last version (11.31.13) and same result, impossible to connect. And same result. I spend the entire evening on that a Thank in advance. Simon AUBERT [cid:691B9F4089B9F34B8E0C22B39B7117EC@eurprd07.prod.outlook.com] Bourse Maritime - 1, place Lainé - 33 000 Bordeaux Mob : +33(0)6 66 28 52 04 _______________________________________________ users-list mailing list users-list@monetdb.orgmailto:users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Good evening, After another windows update (and other corporate update), it works again. For the same reason it was also impossible to install the Microsoft .net3.5 framework. However I lost a full schema. ☹ Will launch another discussion about an optimization in a few days. Best regards, Simon De : AUBERT Simon Envoyé : mardi 15 janvier 2019 22:31 À : users-list@monetdb.org Objet : RE: Invalid Credentials error Good evening, Thanks for your help, Martin, but sadly, it didn’t work either. I reboot my computer, load Monetdb through the bat M5server.bat, idem for mclient (mclient.bat) and still the same message. My database is stored on C:\Users\saubert\AppData\Roaming\MonetDB5\dbfarm\demo and that’s the windows user I’m currently using. Best regards, Simon De : users-list [mailto:users-list-bounces+simon.aubert=businessdecision.com@monetdb.org] De la part de dinther Envoyé : mardi 15 janvier 2019 16:39 À : users-list@monetdb.orgmailto:users-list@monetdb.org Objet : Re: Invalid Credentials error Hi Simon, The MonetDB server on windows is normally started with script M5server.bat (or MSQLserver.bat which calls M5server.bat). Try if you can restart the MonetDB server that way. Wait till the server startup is ready for accepting application/mclient connection. The console should show the # MonetDB/SQL module loaded
prompt. Next start mclient.bat Note that the demo database is stored in the user profile area, in my case in: C:\Users\martin\AppData\Roaming\MonetDB5\dbfarm\demo It could be that when you restarted Windows OS you logged in with a different user. In that case the original demo database is located in a different location. martin On 15-01-2019 11:41, AUBERT Simon wrote: Good morning, I have used Monetdb for a few weeks now and this evening I cannot login after a full system restart (windows+monetdb). Environment : Windows 10 (well, it’s my work computer, I don’t have a lot of choice) Monetdb 5 server v11.31.11 I start monetdb by using C:\Program Files\MonetDB\MonetDB5\bin\mserver5.exe Then mclient on C:\Program Files\MonetDB\MonetDB5\mclient.bat (and usually it work just fine) I also tried with mclient.exe using the -x command to debug. Error message : C:\Program Files\MonetDB\MonetDB5\bin>mclient -X -d demo user(win32):monetdb password: MAPI = monetdb@localhost:50000 ACTION= mapi_reconnect ERROR = !InvalidCredentialsException:checkCredentials:invalid credentials for user 'monetdb' Of course, I use the default monetdb/monetdb credentials. I have no idea of what happens and moreover I have lost an entire schema (I see that if I connect through Tableau Desktop…). I have done an upgrade on the last version (11.31.13) and same result, impossible to connect. And same result. I spend the entire evening on that a Thank in advance. Simon AUBERT [cid:691B9F4089B9F34B8E0C22B39B7117EC@eurprd07.prod.outlook.com] Bourse Maritime – 1, place Lainé – 33 000 Bordeaux Mob : +33(0)6 66 28 52 04 _______________________________________________ users-list mailing list users-list@monetdb.orgmailto:users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (2)
-
AUBERT Simon -
dinther