Re: Mckoi:Restricting IP user access
Justin Cobb <[email protected]>
| Newsgroups | gmane.comp.db.mckoi |
|---|---|
| Message-ID | <[email protected]> |
Toby, Here is basically what I have in my SYS_INFO.sUSRUserConnectPriv table. There isn't to much to it. UserName | Protocol | Host | Access ___________________________________________ admin TCP % ALLOW admin Local % ALLOW user1 TCP 192.168.1.20 ALLOW On Thu, 2005-01-20 at 17:00 -0800, Tobias Downer wrote: > Justin, > > This feature hasn't gone through extensive testing so there may be > problems with it. Would it be possible to show me all the entries in > the sUSRUserConnectPriv table? > > Toby. > > Justin Cobb wrote: > > > I am running into a problem restricting a remote users IP address. I am > > updating the SYS_INFO.sUSRUserConnectPriv table with the correct IP > > address. If I do a 192.168.1.% it works just fine but if I specify the > > full IP address such as 192.168.1.20 then the database fails on > > authentication. I check the database debug file and this is what is says > > when I try to login. > > > > java.io.EOFException > > at > > com.mckoi.util.LengthMarkedBufferedInputStream.blockForCommand(LengthMarkedBufferedInputStream.java:273) > > at > > com.mckoi.database.jdbcserver.StreamJDBCServerConnection.blockForRequest(StreamJDBCServerConnection.java:164) > > at > > com.mckoi.database.jdbcserver.MultiThreadedConnectionPoolServer > > $ClientThread.checkCurrentConnection(MultiThreadedConnectionPoolServer.java:162) > > at > > com.mckoi.database.jdbcserver.MultiThreadedConnectionPoolServer > > $ClientThread.run(MultiThreadedConnectionPoolServer.java:236) > > > > Is this a bug in the database?? > > > > > > --------------------------------------------------------------- > Mckoi SQL Database mailing list http://www.mckoi.com/database/ > To unsubscribe, send a message to [email protected] > -- --------------------------------------------------------------- Mckoi SQL Database mailing list http://www.mckoi.com/database/ To unsubscribe, send a message to [email protected]