If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Problem: configure DB2 to work in a LAN

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-10-09, 19:43
stefanogiansante stefanogiansante is offline
Registered User
 
Join Date: Jul 2009
Posts: 2
Smile Problem: configure DB2 to work in a LAN

Hi, I'm an italian user, so I'm sorry for my basic english.
I'll describe my problem:
I must make a simulation of the working on a LAN with DB2.
I have installed an istance on a Server (Windows Xp) and so the administrator of this machine became the DBADM of my DB (Sample, default after installing DB2) and have all authorities at instance and db level.
After I have installed a copy of DB2 on a client machine, connected with server on a LAN with a Wifi router (the comunication between two pc is ok), catalog the node and the database on server.
I have set on server (and on client) the dbm cfg parameter authentication on client because i don't want to add on my server S.O. all the LAN user. My problem is: if i create a user with the same username of server administrator (withouth PASSWORD) on the client machine, and try to connect with the command connect to demodb (demodb is the alias on client of Sample on server) so without password, the connection is OK. I wont this. How i set the two parameters TRUST_ALLCLNTS and TRUST_CLNTAUTH to eliminate my problem?
Thanks a lot.
Bye
Stefano
(I have the DB2 Express Edition 9.5)
Reply With Quote
  #2 (permalink)  
Old 07-11-09, 03:07
przytula_guy przytula_guy is offline
Registered User
 
Join Date: Apr 2006
Location: Belgium
Posts: 1,159
this is a db cfg parameter
so at server :
db2 update db cfg for sample using TRUST_CLNTAUTH client
see
trust_clntauth - Trusted clients authentication configuration parameter
__________________
Best Regards, Guy Przytula
Database Software Consultant
DB2 UDB LUW Certified V7-V8-V9-V9.7 DB Admin - Dprop..
Information Server Datastage Certified
http://www.infocura.be
Reply With Quote
  #3 (permalink)  
Old 07-11-09, 06:58
stefanogiansante stefanogiansante is offline
Registered User
 
Join Date: Jul 2009
Posts: 2
if i change the parameter TRUST_CLNTAUTH on dbm cfg I have the same problem. If I logon with a user with the same username of the DBADM (the administrator user of Server PC) my access in granted. Everyone can create a new user with the same name of DBADM on their own client and access the DB!!
I try many combinations of the two parameter, but I have everytime the same problem.
Reply With Quote
  #4 (permalink)  
Old 07-11-09, 09:53
n_i n_i is offline
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
That's the idea of trusted clients though. If you don't trust your clients, authenticate at the server, but then you need to define user IDs on the server itself. Your choice.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On