Please provide some tool/program that I can execute to change the default password. We are planning to load confidential data on a hosted server and can't afford to keep the default password. Thanks, On Dec 4, 2007 3:19 AM, Fabian Groffen wrote:

On 03-12-2007 16:34:40 -0500, Venks wrote:

...

How can I change the default MonetDB password? ALTER USER on "monetdb" gives me the following error:

!InvalidCredentialsException:setPassword:The administrator cannot set its own password, use changePassword instead

This is an interesting one. In order to change your password using changePassword, one needs to have the old password. The kernel doesn't allow root to unconditionally change the administrator password (what it does for other users when the administrator uses setPassword).

You can change the administrator/monetdb password using changePassword in the MAL interface. Maybe we should make a little tool/howto for this. I cannot find the wrapper function that used to be there to call for these functions from MAL.

Romulo Goncalves wrote:
> Venks wrote:
>> Please provide some tool/program that I can execute to change the 
>> default password. We are planning to load confidential data on a hosted 
>> server and can't afford to keep the default password.
> The process to change a password for any user in MonetDB is not worky 
> properly (a bug will follow this email, in the bug tracker list) and it 
> will be fixed as soon as possible. We will also try to provide a way to 
> change the admin password.
To change the admin password just do like this:
- start mserver5 without the the sql module
- in mserver5 prompt execute the command:
changePassword("monetdb","newpasword");
The command syntax is:
changePassword(,);

It will change the old password by the new one for the actual user who 
by default is monetdb (the admin user) ;)

Restart your mserver5 (now you can load the sql module) and then connect 
a client.

Note: By default the mclient will use as login
user = monetdb and password= monetdb.

After your change you will need to give the new login information:
mclient -lsql -u monetdb
password: new_password
sql>


Regards,
Romulo
> 
> Regards,
> Romulo
> 
> -------------------------------------------------------------------------
> SF.Net email is sponsored by: The Future of Linux Business White Paper
> from Novell.  From the desktop to the data center, Linux is going
> mainstream.  Let it simplify your IT future.
> http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
> _______________________________________________
> MonetDB-users mailing list
> MonetDB-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-users

On 04-12-2007 08:56:18 -0500, Venks wrote:

I started mserver5 by just executing ./mserver5. I am getting the following error when I execute changePassword.

!TypeException:user.main[1]:'user.changePassword' undefined in: _1:any := user.changePassword(_2:str, _3:str)

Please let me know if I am missing something.

There was a "little" bug floating around. I fixed it in both stable and current branches. You should be able to use client.changePassword("old", "new"); from any MAL connection now.

I downloaded the latest current release from CVS and installed it successfully. I ran the command ./mserver5 at the UNIX prompt and executed the following command:

clients.changePassword("monetdb","monetdb1") ;

I didn't get any error so I assumed it worked. But when I tried to connect using the new password from "mclient" it didn't work, but worked with the default password. So I tried to change the password again using the above command and now I am getting the following error: !InvalidCredentialsException:changePassword:Access denied #function user.main():void; # clients.changePassword("monetdb","csdb"); #end main; -Venks On Dec 4, 2007 9:45 AM, Romulo Goncalves wrote:

Venks wrote:

...

I started mserver5 by just executing ./mserver5. I am getting the following error when I execute changePassword.

!TypeException:user.main[1]:'user.changePassword' undefined in: _1:any := user.changePassword(_2:str, _3:str)

Please let me know if I am missing something. Update your sources and then the command (to run in the mserver5) should be: clients.changePassword(, );

restart mserver and then start your SQL adventure...

I forgot to tell you that you need also to use the module name (in this case clients) to call the function ;)

I just tested it in the current and stable and it works.

Regards, Romulo

------------------------------------------------------------------------- SF.Net email is sponsored by: The Future of Linux Business White Paper from Novell. From the desktop to the data center, Linux is going mainstream. Let it simplify your IT future. http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

Hi, I believe I have a developer access to CVS. I used my credentials (dreambubble) to download the latest code. If you still think I didn't have the latest version, let me know and I will download and install again. Thanks, On Dec 5, 2007 3:07 AM, Fabian Groffen wrote:

On 04-12-2007 19:10:53 -0500, Venks wrote:

...

I downloaded the latest current release from CVS and installed it successfully. I ran the command ./mserver5 at the UNIX prompt and executed the following command:

...

clients.changePassword("monetdb","monetdb1") ;

I didn't get any error so I assumed it worked. But when I tried to connect using the new password from "mclient" it didn't work, but worked with the default password. So I tried to change the password again using the above command and now I am getting the following error:

!InvalidCredentialsException:changePassword:Access denied #function user.main():void; # clients.changePassword("monetdb","csdb"); #end main; -Venks

SourceForge's anonymous CVS has a delay. It should have synced it now, I hope. Otherwise, the current nightlies should include the fix.

By the way, please note that you can also change the monetdb username into something else.

------------------------------------------------------------------------- SF.Net email is sponsored by: The Future of Linux Business White Paper from Novell. From the desktop to the data center, Linux is going mainstream. Let it simplify your IT future. http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

I did have the latest source. I just followed exactly what you mentioned below and it works. I was using ./mserver5 (without any modules) as suggested before. So I think you have to load the MAL module for this to work. Is that correct? On Dec 5, 2007 7:40 AM, Fabian Groffen wrote:

On 05-12-2007 07:28:47 -0500, Venks wrote:

...

Hi,

I believe I have a developer access to CVS. I used my credentials (dreambubble) to download the latest code. If you still think I didn't have the latest version, let me know and I will download and install again.

(pegasus:monetdb/current/java) fabian% mclient -lmal -dtest mal>clients.changePassword("monetdb", "csdb"); mal>\q (pegasus:monetdb/current/java) fabian% java -jar jars/jdbcclient.jar -u monetdb -d test password: (csdb) Connection warning: Redirect by localhost:50000 to mapi:monetdb://pegasus.ins.cwi.nl:50001/test Welcome to the MonetDB interactive JDBC terminal! Database: MonetDB v5.3.0, 'test' Driver: MonetDB Native Driver v1.7 (Canephora_p1 20071205 based on MCL v1.2) Type \q to quit, \h for a list of available commands auto commit mode: on monetdb->

It works for me, so I really think your sources aren't uptodate (yet).

------------------------------------------------------------------------- SF.Net email is sponsored by: The Future of Linux Business White Paper from Novell. From the desktop to the data center, Linux is going mainstream. Let it simplify your IT future. http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

Interesting. Please try using ./mserver5 and see if you can change the password. On Dec 5, 2007 8:26 AM, Fabian Groffen wrote:

On 05-12-2007 07:56:58 -0500, Venks wrote:

...

I did have the latest source. I just followed exactly what you mentioned below and it works. I was using ./mserver5 (without any modules) as suggested before. So I think you have to load the MAL module for this to work. Is that correct?

You got an access denied, which is not related to which modules are loaded. The least, I think it is strange.

...

On Dec 5, 2007 7:40 AM, Fabian Groffen wrote:

...

On 05-12-2007 07:28:47 -0500, Venks wrote:

...

Hi,

I believe I have a developer access to CVS. I used my credentials (dreambubble) to download the latest code. If you still think I didn't have the latest version, let me know and I will download and install again.

(pegasus:monetdb/current/java) fabian% mclient -lmal -dtest mal>clients.changePassword("monetdb", "csdb"); mal>\q (pegasus:monetdb/current/java) fabian% java -jar jars/jdbcclient.jar -u monetdb -d test password: (csdb) Connection warning: Redirect by localhost:50000 to mapi:monetdb://pegasus.ins.cwi.nl:50001/test Welcome to the MonetDB interactive JDBC terminal! Database: MonetDB v5.3.0, 'test' Driver: MonetDB Native Driver v1.7 (Canephora_p1 20071205 based on MCL v1.2) Type \q to quit, \h for a list of available commands auto commit mode: on monetdb->

It works for me, so I really think your sources aren't uptodate (yet).

------------------------------------------------------------------------- SF.Net email is sponsored by: The Future of Linux Business White Paper from Novell. From the desktop to the data center, Linux is going mainstream. Let it simplify your IT future. http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

------------------------------------------------------------------------- SF.Net email is sponsored by: The Future of Linux Business White Paper from Novell. From the desktop to the data center, Linux is going mainstream. Let it simplify your IT future. http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

------------------------------------------------------------------------- SF.Net email is sponsored by: The Future of Linux Business White Paper from Novell. From the desktop to the data center, Linux is going mainstream. Let it simplify your IT future. http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

Can you please tell me the function or command to change the default user "monetdb" to something else? Thanks, On Dec 5, 2007 3:07 AM, Fabian Groffen wrote:

On 04-12-2007 19:10:53 -0500, Venks wrote:

...

I downloaded the latest current release from CVS and installed it successfully. I ran the command ./mserver5 at the UNIX prompt and executed the following command:

...

clients.changePassword("monetdb","monetdb1") ;

I didn't get any error so I assumed it worked. But when I tried to connect using the new password from "mclient" it didn't work, but worked with the default password. So I tried to change the password again using the above command and now I am getting the following error:

!InvalidCredentialsException:changePassword:Access denied #function user.main():void; # clients.changePassword("monetdb","csdb"); #end main; -Venks

SourceForge's anonymous CVS has a delay. It should have synced it now, I hope. Otherwise, the current nightlies should include the fix.

By the way, please note that you can also change the monetdb username into something else.

------------------------------------------------------------------------- SF.Net email is sponsored by: The Future of Linux Business White Paper from Novell. From the desktop to the data center, Linux is going mainstream. Let it simplify your IT future. http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users