Oninit® Archive
Results for “REMOTE_USERS_CFG”
REMOTE_SERVER_CFG issue/question
All, I tried posting this via the web, but every time I click on the "Post" link, I get a pop-up stating: Access Denied You don't have permission to access "http://community.ibm.com/higherlogic/ui/mvc/contributedcontent/contributedcontent/createQuestion" on this server. Reference…
Who needs a HOME?
Informix-only level trust through REMOTE_SERVER_CFG and/or REMOTE_USERS_CFG, since early 11.70... ------------------------------ Andreas Legner Informix Dev HCL Software ------------------------------…
Changing DBSPACETEMP run-time
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Please, is there a way to change DBSPACETEMP for a session inside 4GL? ------------------------------ Sincerely, Dennis ------------------------------…
using SSL with Informix
Been reading up on what it takes to set up encrypted communications with Informix. As I understand the docs, prior to 14.10.xC4W1, only GSKIT is supported for SSL. We're running 14.10.FC10 on Linux x86-64, so we should be able to use either GSKIT or OpenSSL. However, we have c…
ontape error
Hi, I have looking for information and found on version 14 some differences for ifxclone. We need to add trust between computers EXECUTE FUNCTION TASK("cdr add trustedhost","host1, host2,..) I have done the steps, but now I am facing one permission issue?? ifxclone -S cmsantar01_…
ADO - activex data object
What do I require, to connect "ado activex data object" to Informix ? AIX 7.2 IBM Informix Dynamic Server Version 12.10.FC9W1 Regards Dirk…
Windows User Authentication
Hi all I need help with user authentication with an Informix Server 12.10.FC12 on windows 2016 server. I wonder why I do _not_ need a windows user to connect to a database on that informix server. I have granted the user, let's name him "xxx", connect to the on and only databa…
User authentication /Windows
We are running Informix 11.70 on a Windows Server 2008. Connecting to the server is working from the command line interface (DBACCESS -e dbname), but when trying to connect (for example) from Server Studio (on the same Windows server) using a userid and password we get -951 : i…
onsocssl problem
I have seen my mistake was the name on ONCONFIG. But now when I try to connect over dbaccess I receive this error: 28014: Secure Sockets Layer error: GSK_KEYRING_OPEN_ERROR. No such file or directory Is anything wrong with my settings? Thanks for any help, SP…
listener-thread@soc_be.c:3073: err = -25582:
Adding Version details Informix Version : IBM Informix Dynamic Server Version 12.10.FC6 O/S Version : Red Hat Enterprise Linux Server release 6.9 Thanks & Regards, Karthik Rajan…
Trusted context
You're missing, or better saying, confusing different concepts. Informix has a trusted connection and a trusted context. They are very different things (in spite of the similar names) A trusted connection is a connection to a database server where no password is given and for th…
How to tell that client uses SSL connection?
We are in process of migration from soctcp to socssl connections and I cannot find any onstat command (or anything else) that can tell me what connection is used by client: secured or not. Any ideas ?…
informix on linux or solaris?
Hi, I want to know the advantage and disadvantage for using informix on Linux(RHEL 7) and Solaris (Solaris11). Which is the best combination and why. or any other OS What is the authenticity for closing Solaris Thanks .…
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
Authentication with certificates
Hello everyone, I'm trying to figure out how I can use certificate authentication to connect to IDS 12.10. Does anyone have experience with this challenge or can tell me if it's even possible? Thank you for all Replies. Kind regards. Jochen…
25590: Authentication error.
Hello OS Version : CentOS release 6.9 Informix version : IDS 12.10.FC9TL We are having issues connecting to our Informix database through dbaccess Users created locally on the server can connect successfully to the database. However all 'Active Directory ' users receive error me…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
onpassword utility related to Connection Mnager.
GSKit implements all the security and encryption, by means of providing required shared objects. So in order to use onpasswd, and later to be able to read encrypted file or use encrypted communication, you'll need to have GSKit installed. From: "MUKESH TANUKU" <mukeshbt1328@gma…
Re: RE: HDR replication setup on Windows
Forgot to mention: there needs to be some sort of trust relationship=20 between the two hosts, i.e. Informix must allow passwordless connection=20 between the two Informix servers, for user informix. There's a hosts.equiv file as well on Windows, afaik (in=20 %WINDIR%\\\\system3…
orphaned users
People here may not know nothing about SQL Server. Can you elaborate on what "orphaned" means? Most Informix installations use OS authentication. Although it's possible to authenticate on external sources, that's not the most common scenario. Regards. On Fri, Jan 6, 2017 at 1:2…
User Name from Connection Pool
Hi Fernando, Thank you for pointing us in the direction of Trusted Context. That is precisely what we were looking for. I am confirming that we tested and it works to allow non dba users to run "SET SESSION AUTHORIZATION". In addition to the Informix Documentation, here are 2 li…
Cannot Connect To Newly Installed Informix
> I'm pretty sure that I'm throwing the correct credentials.=20 Where/how - can you elaborate? Impression is you want an authenticated connection rather than a trusted=20 one? Andreas From: "NATYURAL HORACIO" <horacio.natyural@gmail.com> To: ids@iiug.org Date: 16.09.2016 11:57…
IDS and keepalive
Thanks for the responses Fernando ... AIX 7.1, IDS 11.50.FC8 LISTEN_TIMEOUT 10 MAX_INCOMPLETE_CONNECTIONS 1024 The issue: a client connecting via TCP is having long sessions (up to 9 minutes) that eventually timeout. They see the msg at their end and I see it in my message log…
Re: Informix & implicit PAM results in "Server....
On Wed, 2016-07-13 at 08:51 -0400, Adam Tauno Williams wrote: > On Mon, 2016-07-11 at 08:04 -0400, Fernando Nunes wrote: > > Can you add the PAM file configuration? > > And regarding the error.... it looks like the sqlstatus. Can you > > try a remote dbaccess to obtain the native…
HDR setup issues pertaining to hosts.equiv
Whether short name or fully qualified host name depends on DNS and=20 /etc/hosts configuration, and look up order. I would always add both short = name and fully qualified name to the trusted host file. Also trusted host file lookup order is REMOTE=5FSERVER=5FCFG, /etc/hosts.eq=…
12.10.FC6 Mac port released
IBM Informix 12.10.FC6 release for Mac OS is officially available! John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS)…
Informix Authentication failure with Hp-Unix
IDS 12.10.FC4W1X3 on HP-Unix B.11.31 U ia64 (configured to work in trusted mode, NO shadowing) This issue is pertianing to connection with one of the sds nodes I am facing a very weird issue of connectivity with one of the java application trying to connect to informix database…
Database Only Authentication
AIX 6.1 11.70.FC8XB8 Folks, I know that Informix historically relied on Unix access to a server to authenticate access to the database. I also know that LDAP access allows for userid/password or challenge authentication to the database. What I do not know is if there is a datab…
Intermittent DNS failures
It's a well known problem with Informix... or as you correctly put it, with DNS that impacts Informix. Both suggestion I've seen are interesting (ncd daemon and the ns_cache parameter). Unfortunately you cannot consider the later one (you should be aware that 11.1 is out of suppo…
Windows Authentication for Informix Mapped Users
This is the Part 2 to my earlier question on how to permit Win Active Directory authenticated user to access Informix. I have initial guidance from Fernando Nunes to use the 'Mapped Users' feature available on Informix v11.70.FC7. I also have a high level understanding now of ho…
Windows Authentication for Informix on UNIX
Is it possible for a user to use his/her Windows Authentication ( Active Directory) to access Informix running on HP-UX. If so, how is this done? We are running Informix 11.70.FC7 on HP_UX B.11.31 U ia64.…
Windows Authentication for Informix on UNIX
Is it possible for a user to use his/her Windows Authentication ( Active Directory) to access Informix running on HP-UX. If so, how is this done? We are running Informix 11.70.FC7 on HP_UX B.11.31 U ia64.…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
not trusted
Somehow the Informix process doesn't see it self as that name... That's easy to happen if you have multiple TCP interfaces (I assume you're connecting through TCP). It would be interesting to see your "sqlhosts" configuration. The message cleary says that the server resolved the …
ONLINE.LOG verbosity and logging successful authen
Informix community, Is there is setting in the ONCONFIG file to change verbosity of the ONLINE-LOG? Specifically I'm looking to log successfully authentication with Informix, not just failed authentication attempts like -951 errors. Thank-you in advance for any insight. V/r, …
PAM Authentication with certificates
Hi experts, We need to set up an JAVA environment which accesses an IDS instance via JDBC/Datasource Pools. (sounds simple, have done that a 100 times ...) Now comes the challenge: The requirement is that the client does not have a clear text password stored in a config file no…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
Running oninit as root on AIX
It does... although I'm a bit confused (not by you, but by the behavior). Traditionally local connections to PAM ports as informix would ignore the PAM configuration. That's why I always write/say NEVER to test PAM with user informix on the local machine. I seem to recall that th…
Creating and Dropping Trusted Context
Thanks Art, that makes sense as Informix security has always been and the server level. Based on things like /etc/hosts.equiv etc. So now on to my next puzzle... Remember I have 3 databases: trip, support and report So I use dbaccess to connect to database "trip" and create the…
listener-thread: err = -25573: oserr = 72
Resolution to this type of problem also includes adding the remote (application) server to the local database servers' hosts file , and/or changing the order of host lookup in the hosts file; the disabling of DNS lookup when authentication was switched to local but not carried ou…
Nasty, unexpected cluster problem
I didn't do the work but I am guessing we did. From the SDS Primary: 08:09:19 Maximum server connections 1858 08:09:19 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns blocked 1, Plog used 2926, Llog used 3258 08:10:14 Error receiving a buffer from RSS ob1_db3_ha - shu…
when use IfxDataReader.GetIfxDateTime to NULL valu
Hello, The version of Informix products in my environment is: Database server: AIX IBM Informix Dynamic Server Version 10.00.FC5 IBM Informix CSDK Version 2.90 IBM-ESQL Version 2.90.FC4 Client: PC Windows IBM Informix-ESQL 3.70.TC5DE.…
CREATE USER vows
11.70.FC7 / Linux I'm looking into internal db authentication. According to the manual "When the USERMAPPING parameter is set, internal user authentication takes precedence over OS authentication" I have USERMAPPING set to BASIC. I tried this out: create database testusr with …
Re: .rhosts and PAM authentication
Most platforms have a vendor supplied PAM library that does .rhosts authentication. e.g. on Solaris, it is named pam_rhosts_auth.so. Adding this library to your pam service definition (probably before your custom pam library) and marking it "sufficient" should solve your problem.…
Connect 4GL to Informix Server
Nothing, as long as the two servers are trusted and the user running the application has a valid login on the server, a simple DATABASE statement or a CONNECT without a username and password will suffice. Just set INFORMIXSERVER to the appropriate server name and go. Art Art S.…
.rhosts and PAM authentication
I have a mach11 cluster that is configured for PAM authentication using a custom PAM module. Now, I'm trying to get transparent remote logins to work from another host, but the auth isn't working. If I remove the PAM auth, the remote connections work. Is there a way to get .rhos…
connection manager SLA point to DBALIAS not workin
Hi, I have a SERVERSET in the connection manager. In the SLA, I have DBSERVERS set to a dbalias to the server (this service runs PAM authentication). My problem is that the connection manager keeps redirecting to the primary instance instead of the alias - how do I fix that? -J…
Question regarding SSO (keberos authentication)
Hello All, I am trying to setup an instance for the Single Sign-on authentication using the kerberos 5 protocol. I have a basic question that if in same instance, can we have two services for login to the database: 1- Service one using onsoctcp without csm or kerberos [standar…
Re: ER Connection Issues
On 7 May 2013, at 11:49, Keith Simmons wrote: > I suspect I am running into some security block on the RedHat server (note I can only connect using SSH, sftp etc and not telnet or ftp). > Any suggestions on what I need to do to enable this connectivity for dbaccess/ER ? run ipta…
Fwd: ER Connection Issues
Hi I currently have ER running between an AIX server (source) and two Solaris servers (targets) in a 'one-way' replication environment. I need to add a RedHat Enterprise (2.6.32-131.0.15.el6.x86_64) server as a third target (prior to removing one or both of the existing targets)…
ER Connection Issues
Hi I currently have ER running between an AIX server (source) and two Solaris servers (targets) in a 'one-way' replication environment. I need to add a RedHat Enterprise (2.6.32-131.0.15.el6.x86_64) server as a third target (prior to removing one or both of the existing targets)…
Fast Recovery (CKPT REQ) state
Hi Marcus, Thanks for the prompt answer. Unfortunately, we are not able to do any kind of backup in this state : # ontape -S Server is in an incompatible state or user authentication failed. Program over. And it's not the authentication ;-( I'll try to check the other options…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Connecting to a remote server
On Fri, Jan 18, 2013 at 4:14 PM, JOHN CALLICOTTE <john.callicotte@ottawa.edu > wrote: > sqlhosts: > > ksotinfx01 onsoctcp ksotinfx01 istartrain2 > ksotinfx01_shm onipcshm ksotinfx01 ksotinfx01 > istartrain onsoctcp ksotinfx01 istartrain > > onconf.cars: Too long to post here, bu…
authenticate a user via ldap
hello, we are looking for the best (and simple...) way to authenticate a user via ldap. In the documentation, it seems possible using pam. Is it the only solution ? configuration : informix 11.70 for windows - active directory is on windows server 2003 Thanks in advance…
Roles X remote database
On Wed, Nov 28, 2012 at 7:34 PM, Cesar Inacio Martins < cesar_inacio_martins@yahoo.com.br> wrote: > Hi , > > Ifx 11.50 FC9X6 , AIX 6.1 > > We have two databasesatour system, where we work using ROLEs to manage > the users . > Today we have a security problem , which is caused by…
Error -556 on @ reference
In IDS_A have a stored procedure do_some that has a insert into a local table. In IDS_B have a stored procedure do_some that does: call base@IDS_A:do_some(); Calling this sp works ok. In IDS_C i try to run: call base@IDS_B:do_some(); Fails with error -556 Cannot create, drop,…
informix under pam
Restricting a user when using ODBC is a FAQ, but the answer is still: Don't/Can't. If you grant a user write rights (UPDATE/DELETE/INSERT etc.) you can't then limit if the user is connection through ODBC. What you can do is to allow certain users to connect only from certain hos…
IDS 7.31 UD5 data(base) recovery
Informix Dynamic Server Version 7.31.UD5 I understood that IDS 7.31 entered End Of Support in September 2009 ( 2 and a half years ago) I hope this is not a business critical system…
enterprise replication time to replicate data
IBM Informix Dynamic Server Version 11.50.FC6 Question for enterpise experts Does anyone know a command that will give me time that it takes to replicate data to a node? for example i update on server a and it replicates to server b . How long did it take? cdr view profile gives …
Password Authentication
Hi All, We are using IDS 11.50.FC7 on Solaris Sparc. What is the authentication method for performing DML operations on Database Engine. What i know is that there is OS level authentication method supported at Informix Engine. Is there any other (more secure) method, like Datab…
Over 1,000 days of 24x7 database uptime!
On 29.07.2011 20:38 Lester Knutsen wrote: > From one of our customers, their Informix server hit 1,000 days today > .... congratulations;) > > IBM Informix Dynamic Server Version 10.00.FC8 -- On-Line -- Up > 1000 days 00:31:45 -- They beat mine just bit ... IBM Informix D…
MSC VP
Hi, I read some document, The MSC VP performs miscellaneous tasks, such as user licensing and UNIX user authentication. What is user licensing in Informix?…
Setting up HDR- First Time -11.70 Innovator-C
Hi, I am setting up HDR for the first time. onstat - on primary shows IBM Informix Dynamic Server Version 11.70.UC2IE -- On-Line (Prim) -- Up 0:11:5s onstat - on secondry shows IBM Informix Dynamic Server Version 11.70.UC2IE -- Fast Recovery (Sec) -- Up 00s onstat -m on sec…
ISAM error 197: Partition recently appended to
Informix Dynamic Server Version 9.40.UC5 SUSE Linux Enterprise Server 10 (i586) I have done a level 0 backup directed to /dev/null and tried again. still it is throwing the same error.…
Re: ER sync/check with security option
Mark, This is feature request (RTC2850) ER/GRID needs to work in a secure environment. Currently cdr check and cdr sync will not work if using the s=6 option to create a secure network. M.P. From: "MARK JALKIEWICZ" <mark.jalkiewicz@verizon.net> To: ids@iiug.org Date: 04/04/…
Using Pam authtication between IDS10.00.FC5 and Windows Server AD.
On Feb 23, 9:16 pm, Floyd Wellershaus <fl...@fwellers.com> wrote: > I need help with that. pointing me in the right direction.Any ideas how to > authenticate database users from Active Directory ldap, via pam modules to > be able to run stuff in the IDS databases ? Any decent wri…
How about to authenticate without OS account?
When I mentioned LDAP. I meant to say that you can configure the OS to authenticate through LDAP. Not Informix. If the underlying OS is configured for LDAP (properly) it will be transparent for Informix. As for the error, I would need to check that... I was 99% it would work... …
11.70, drda & ldap
Hello, did anybody install 11.70 with ldap authentication and connect client with drda? I installed 11.70, ldap and users can connect with "normal" sqli (with PAM), but I can't configure drda access. Does anybody have cookbook or something similar? Regards, Hrvoje…
dostats IDS 11.70
Hello, dostats no longer seems to work in IDS 11.70. First there seems to be an issue with trusted contexts. informix@dbhostname:~> dostats -d isent98 FAILED: Cannot connect to SMI DATABASE (@ol_dbhostname); error=-28021, isam=2 DatabaseError: SQLCODE -28021 in CONNECT: A trus…
Tool to estimate the size of an index
Sorry, I forgot to provide the version of the installation: IBM Informix Dynamic Server Version 11.50.FC4 Operative System: AIX Version 6.1…
IDS 11.50 (Linux + PAM with MS AD)
Jonathan thanks for interest in the topic. I've managed to make my Linux (SUSE) a member of Windows 2003 domain (using yast2, suprisingly with few clicks - no use of 'vi' this time). It's using samba-client, winbindd, pam_winbind. Don't use LDAP here at all. Linux (winbindd to b…
Connect in Java using JDBC and GSSAPI?
When connecting to an informix database using the JDBC driver (ifxjdbc.jar), is there any way to pass it a delegated GSSCredential? Using DriverManager.getConnection(String url, Property props), maybe? I'm trying to authenticate and connect to the database with a Tomcat 6 webapp…
SDK 3.50.FC7 FUN!
Also - just an fyi - I did create the new linked servers using the new ifxoledbc provider. Looks like this: Provider: IBM Informix OLE DB Provider Product Name: ifxoledbc Data source: database@dbservername We connect using the security context of user informix on the unix box.…
Setting up HDR - 11.50.FC1
TRI TRINH wrote: > Hi, > > I am trying to setup HDR in two Linux servers inftest1 and inftest2. I > followed the instruction below, but step #7 below was confusing. I tried > "onmode -d primary inftest1". The result from onstat - is "On-Line (Prim)". > But I also get message from…
Accessing remote database table
Joe, Here is what the Informix log says: 12:15:48 listener-thread: err = -956: oserr = 0: errstr = jsoude1@XXXXdbs.csc.XXXXX.com: Client host or user jsoude1@XXXXdbs.csc.XXXXX.com is not trusted by the server. It doesn't look like we have a netsvc.conf file on the server curre…
Can't access sysindexes remotely
Hi, We are using IBM Informix Dynamic Server Version 11.50.FC6 using Platform: SunOS 5.10 Generic_125100-09 sun4v sparc SUNW,Sun-Fire-T200 Thanks…
Re: dbaccess authentication?
Thank you very much, That did the trick. On Thu, May 6, 2010 at 10:37 AM, Art Kagel <art.kagel@gmail.com> wrote: > In the dbauser's home directory on the server add 'dbausr@app1' to the > .rhosts file. > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > I…
Re: dbaccess authentication?
In the dbauser's home directory on the server add 'dbausr@app1' to the .rhosts file. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City)…
dbaccess authentication?
I shared the database installation directory on db1 (IDS 11.50) server through Samba (first time with a password and now opened to everyone - which I am going to change back as soon as I figure out the problem but I did just to avoid an extra step.) I tried to access dbaccess fr…
discount authentic Gucci Purse True leather AAA Wholesale ( paypalment )(http://www.brandtrade10.com)
discount authentic PRADA Purse Wholesale discount authentic PRADA bags Wholesale discount authentic PRADA True leather AAA Wholesale discount authentic GUCCI Purse Wholesale discount authentic GUCCI True leather AAA Wholesale discount authentic Gucci bags Wholesale discount authe…
discount authentic D&G Purse True leather AAA Wholesale (http://www.brandtrade10.com)
discount authentic D&G Purse True leather AAA Wholesale (http:// www.brandtrade10.com)…
HDR Problem
Hi Art, Yes, i am planning to use the ol_ross1hdr/ol_ross2hdr as the connection string. BTW, is there any sequence on start up of primary and secondary? I also would like to ask about authentication, is there any authentication needed? like 'hosts.equiv, hosts, .rhosts'... Do w…
Re: How to secure ODBC connection
On Nov 20, 2:57 pm, LIGHT SCANS <light_sc...@yahoo.com> wrote: > Sorry. You cannot encrypt ODBC. For internal systems you can > restrict access to your company's internal network or use your > company's network hardware to do encryption. For both internal and > external (i.e. …
Restricting Connection to Informixservers
Sorry to top post... If I understand your question... You use a single web app user id to connect all of your web application servers to the database. (Not a good idea, you may want to consider a single id per web app server.) But your problem is that anyone who knows the web …
How to secure ODBC connection
Hi, how can i implement secure (encripted) odbc connection from windows clients to informix dynamic servers 11.5 ? I read something about client supports SSL but no idea how to implement or use it. The big problem is some sniffer catching odbc users and passwords, and of course…
Informix Dynamic Server Software Downloads
It appears IBM has cleverly hidden the IDS downloads again on the Passport Advantage Website, at least from my prying eyes. I can find the Solid DB and the DB2 links just fine. Does anyone out there in IIUG-land with a Passport Advantage account know where IBM has stashed the dow…
create user and permissions
nierjesh kumar wrote: > Dear All > > Is there any sql command for creating the users and their roles.please guide > me. Look in the links I sent you for GRANT and CREATE ROLE. You don't create users in Informix, they're authenticated by the operating system. -- Cheers, Obnoxio …
authenticating informix users using winbind
Im setting up a new server with RHEL5 and IDS 11.5.UC1 that will eventually replace another server running RHEL4 and IDS 10. One of the goals on the upgrade project is to authenticate users against Active Directory. ( http://spiralbound.net/2007/04/11/rhel-winbind-authentication-…
OPTCOMPIND and perl
Anyone know if I can change OPTCOMPIND after establishing a DB connection or does it need to be set before connecting? ta SLES10 SP1 IBM Informix Dynamic Server Version 10.00.UC5…
IDS PAM/KRB5 authentication against Windows Active
Hi, We are using PAM/KRB5 to authenticate connections to our IDS 10.0 server against our Windows Active Directory. We are using IDS PAM in "simple password" and not "challenge response" mode. IDS is on HPUX 11.32 Itanium and is a 64-bit port. The Windows ODBC and native client …
OAT onsocssl needs a password?
I'm using IDS 11.50 on HPUX 11, and have successfully used the GSK to configure a serveralias to encrypt with onsocssl and a self-signed certificate with a generic PC client, WinSQL. In order to secure OAT, I've modified the file "template_admin.php" as described in https://www.…
Client connection problem with 7.31FD7-1
1.Is there any other error message such as conerr or oserr as below? 908: Attempt to connect to database server (B, conerr=-25580, oserr=32) failed. 2. Did you used "*" in your "Hostname Information"-"Current Host" field in setnet32 on your windows 2000? 3. Did you used LDAP a…
Block access to databases via odbc
Hello Friends I need help with the following problem: I have a IDS engine hang on Linux platform. I would need to block the access to the databases (bbdd) via ODBC for some users. These users have access for writing, erasing, update information, etc in the databases (bbdd) becaus…
Re: Connection Pooling with the .NET Provider on IIS
On 17 June, 13:59, Fernando Nunes <domusonl...@gmail.com> wrote: > On Wed, Jun 17, 2009 at 1:09 PM, mc <m...@community.nospam> wrote: > > grendal wrote: > > > On Jun 15, 6:16 pm, Fernando Nunes <domusonl...@gmail.com> wrote: > > >> Ian Michael Gumby wrote: > > >>> With respect to…
Re: Informix Connection Strings
Answer was surprisingly simple. I just left the user name and password out of the connection string and all is fine. I have observed some very strange issues, which I think relate to a bug in the connection pooling code. I'll post that as a new thread. mc wrote: > All, > > I'm …
Informix Connection Strings
All, I'm very new to Informix and have been asked to produce a C# based Web Application that interfaces to an Informix 11.10 IDS Database. Due to security requirements I need to pass the current users credentials through to the database server. I do this on SQL Server by specify…
Odd Connectivity Issue
Solaris 10 Informix 10.00.UC8 I am seeing odd behavior from tcp/ip local loopback connections on our new Solaris server. I see in the online.log the following for a user connecting to our 'dvlp' INFORMIXSERVER - the dvlp server is configured as a tcp/ip connection. 12:52:03 lis…
Re: Connection manager redirect
If the security is the main concern, you can have a try with MaxConnect, setting up MaxConnect is very similar to Connection Manager. you can find more information about MaxConnect at http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.ad min.doc/admin16…
RE: Can't connect to database - Unknown error message 84
Ian Michael Gumby <im_gumby@hotmail.com> schrieb: >This is weird in that Informix does use the local machine's authentication methods, >unless you tell it to use a specific authentication method via $INFORMIXDIR/etc/sqlhosts. >An example is LDAP or PAM. > >What does your sqlhost…
Informix Dynamic Server Scheduler question
Hi! I'm working on a project at my faculty. It's a java desktop application with an informix database. I have a problem using informix dynamic server scheduler. I have a particular table in my database. This table contains records that are inserted by the desktop aplication I'm …
Re: Trouble connecting to IDS 11.5 development server using SQuirrel SQL with IDS JDBC driver.
All: Back to the origin of this thread and the promise that I would report back my findings after hours of frustration, I finally found the solution to "ssh" port forwarding on my Debian development server and the SQuirreL SQL client connection. Listed below is configuration I …
Trouble connecting to IDS 11.5 development server using SQuirrel SQL with IDS JDBC driver.
Ian Michael Gumby wrote: > Sigh. Sigh indeed > > /etc/hosts.equiv isn't inherently bad, but it is dangerous. It is > controlled by root access so it limits some exposure. Read this and see if you recognise it: Informix requires a hosts.equiv file for its default authenticatio…
-952 Authentication Error on Solaris 10
I'm running IDS 9.40.FC9 on two new Solaris 10 DB servers - one for prod, one for test. The prod one is live and functioning OK. I'm in the process of setting up the test one (a little backwards, I know, but there are reasons...). I can log into the test box through SSH with info…
IDS 9.40 End of Support Imminent
I have seen a number of posts on CDI recently related to IDS 9.40 As per the announcement on September 7th 2007, effective on the dates listed below, IBM will withdraw support from the following product releases licensed under the IBM International Program License Agreement: 9…
Informix 10 Data Base Links Across Servers
You should include the error you're getting when you try across hosts. I assume it would be an authentitaction problem. If yes, follow this rules: 1- The user must exist on the remote host 2- The user must be trusted on the remote host (.rhosts or /etc/hosts.equiv) or... 3- ... …
install info for ISQL 7.3?
Hi everyone. I can't seem to locate any formal documentation on installing ISQL or actually any of the Informix tools. The IDS engine and client/connectivity install guides are available but I can't find anything on tools. Does anyone know where the ISQL (or general "TOOLS") inst…
urgent - onmonitor and ontape eror
Hi i am getting this error in onmonitor Dynamic Server: Status Parameters Dbspaces Mode Force-Ckpt Archive Logical-Logs Exit Status menu to view Dynamic Server. ** WARNING: Network Down **--On-Line------- Press CTRL-W for Help. -------- onstat is working fine but when i run o…
Determining IP of 27001 Error
> > PS Since Mark T. and Serge both read c.d.i, I'd say that this would be > important to both DB2 and Oracle. > Well - Oracle already tracks connected client IP addresses on the database side, via the SYS_CONTEXT session variables. I sort of presume IDS and DB2 do something sim…
Re: connecting to database instance through remote
Informix does not use ssh to connect to the database. By default it uses a normal unsecure connection which you have blocked. You can connect to the server and maintain the security if you set up a PAM module for connections to the database. Check ou the Security Guide manual for…
connecting to database instance through remote VB
HI We have application on VB which used to connect to remote unix/informix server using RDO. this server was not secured, now we migrated to new server which can only connect through SSH. Now when we are testing application VB client it fails and is not able to connect. can an…
use stored proc that return multiple columns in a query
forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
SSL and Informix
Schmitz, Rob B [EQ] wrote: > IDS Guys, > > I have supported Informix for many years, but I have never had to deal with > security issues - until now. We have an application (AppA) running IDS > 7.31.UD7 on AIX 4.5. Another application (AppB) would like to access AppA's > database…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
IDS pam auth to Kerberos??
We=B9re currently setting up an LDAP server to support LDAP-UX and/or PAM Kerberos for our user authentication for our HPUX systems. For the IDS authentication, since /etc/passwd will be minimal, we are considering implementing Kerberos services. Will IDS pam authentication suppo…
How to use Informix Dynamic Server
I have installed trial version of "Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i am new to informix. Can anyone explain how to use IDS in detail.…
Re: OLEDB connection and AD Windows
Fernando Nunes <spam@onlinedomus.net> schrieb: >But my whole point is this, and i'm not saying I cannot be wrong: > >If you configure the underlying OS to authenticate against an LDAP server, than >normal IDS connections (not the ones on PAM enable DBSERVERALIAS) should be >able…
Centrify single sign on
prichard@blm.gov wrote: > Frenando, > > Thank you again for your reply. After doing more reading with the > understanding you and other respondents gave me I realize pam is > working exactly as it should in my environment in that it is prompting > for a name and password. I'm …
OLEDB connection and AD Windows
Fernando Nunes <spam@onlinedomus.net> schrieb: >Fernandez Garcia, Domingo wrote: >> We would like to configure our dataserver so that our users authenticate >> in the server with their domain (AD) user, no needing the local user. We >> do this with PAM. We connect the O.S. but i…
IDS On Win Vista Ultimate
Thank You. But when the firewall with Advanced security is enabled, I can't connect to the engine. When use onstat, it works fine. But when using dbaccess I get the error 25580 telling socket not connected. If the firewall is off dbaccess connects to the engine as well as any …
What is IPA abbreviation ?
Hi all IBM INFORMIX DYNAMIC SERVER 10.00 PRODUCT RELEASE bug_number 168928 description WITH NON-DEFAULT PAGE SIZE AND ACTIVE IPA'S, TABLE LEVEL RESTORES FAIL product_code ONUTILS component_code ARCHECKR What is IPA ? Thanks…
Encrypting onsoctcp / ODBC traffic
Good evening to you too :o) You can use ssh tunneling to secure connection from client to server. HTH Hrvoje -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of ITS Sent: Thursday, December 13, 2007 8:41 PM To: ids@iiug.org Subject: E…
How to use PAM authentication on IDS 9.40UC7
We are currently stuck with using 9.40UC7 because of our applications and are trying to use PAM to authenticate through Active Directory. I have configured Linux and it works with AD to authenticate users. However, when I try to use an AD account to authenticate in Informix, I ge…
Changing Linux password with IDS 10
Hello group, I need to change user passwords on a linux system through a VB application = and an informix oledb connection. Unfortanatly, the it-policy in this compa= ny does not allow any ssh or telnet clients for this job.=20 So, is there any way to open a shell (passwd) on th…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Re: admin tools like PC client
Mike, What version of Informix are you using? Informix SE? Informix OnLine? Informix Dynamic Server? Most Informix versions these days come with a product call I-Connect that needs to be installed on the PC and rovides the Informix ODBC drivers.…
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
PAM/LDAP Authentication
Hi everybody, I'm implanted LDAP on RH AS 4. Authentication on Red Hat is OK. I can do login successfully. May 10 12:32:09 server remote(pam_unix)[18227]: session opened for user user1 by (uid=0) May 10 12:32:09 server login - user1[18227]: LOGIN ON pts/5 BY user1 FROM pc_clien…
IDS authentication question
We have upgraded a few instances to IDS v10 from 9.4 and are now experiencing a difference in the authentication process. We use a stand alone AIX database server with multiple AIX application servers communicating via onsoctcp protocol. Under 9.4 we have the end user IDs liste…
Re: ODBC credentials and/or PAM
Lots of information on PAM on the IBM techinfo centre http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp In particular http://publib.boulder.ibm.com/infocenter/idshelp/v10/topic/com.ibm.admin.doc/admin218.htm?resultof=%22%50%41%4d%22%20%22%70%61%6d%22%20 A Pluggab…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
Re: Understanding LDAP or MS Active Directory authentication and Informix
Darren_Jacobs@carmax.com wrote: > PAM is not available for 9.40 FCx on HPUX 64 bit which is a problem for me. > I'm just trying to understand what type of user id is needed in the > database to support an LDAP/AD user. > > Does that make sense? > IDS will use OS authentication.…
Re: Understanding LDAP or MS Active Directory authentication and Informix
"Andrew Ford" <aford@networkip.net> wrote in message news:mailman.351.1173294297.10648.informix-list@iiug.org... > In Linux I can get the Informix engine to authenticate a user via LDAP > through PAM by adding the following options to my server's sqlhosts entry > > s=4,pam_serv=(…
Client Host or user is not trusted by the server!
Hi, you need the entries on the SUSE server only (the client entries don't do any harm). Check if you use the correct client hostname in the .rhosts/hosts.equiv file. Maybe your system does name resolution by DNS and gets a different name for the IP-address of the client. Check…
RE: IDS Authentication Problem on AIX
> -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list- > bounces@iiug.org] On Behalf Of RoB > Sent: Friday, November 03, 2006 4:42 AM > To: informix-list@iiug.org > Subject: Re: IDS Authentication Problem on AIX > > >Hello Rob, > > > >It is a k…
Re: IDS Authentication Problem on AIX
>Hello Rob, > >It is a known problem. I don't have the PMR & Bug number, it is >somehow alleviated by TL05. Shortly put, there is a memory leak >when calling a specific OS function (crypt) and it manifests with all >long running programs calling it (Informix/Db2/...). > >You can …
Re: IDS Authentication Problem on AIX
Had the same issue with 9.40.FC5 on AIX 5.3. It was an OS ML that fixed the issue. Here is what we have installed for ML's: All filesets for 5.3.0.0_AIX_ML were found. All filesets for 5300-01_AIX_ML were found. All filesets for 5300-02_AIX_ML were found. All file…
Re: IDS Authentication Problem on AIX
There was a simular issue years ago; AIX had a mem leak in one of the systemcalls causing the db to grow and after it hit some limit it would barf and die??? can not remember the exact details... Go and beat up aix support to get an answer. Superboer. RoB schreef: > Hi group,…
Re: IDS Authentication Problem on AIX
phone IBM back and re open the PMR RoB wrote: > Hi group, > > OS: AIX 5300-05 Service Pack 1 > IDS: 10.00.FC5 > > IHAC that is running into some nasty problems on the latest version of > AIX where an IDS instance is reporting a OS authentication problem of > all users trying to …
IDS Authentication Problem on AIX
Hi group, OS: AIX 5300-05 Service Pack 1 IDS: 10.00.FC5 IHAC that is running into some nasty problems on the latest version of AIX where an IDS instance is reporting a OS authentication problem of all users trying to connect to the instance (even for the informix user). All exi…
HP-UX PA-RISC/Itanium
Please see Ron Macneil's post and my post in response earlier today where Ron comments that HDR will not work for you. Comments on the past problems you've had with IDS replication: > - programmers and aplication errors/crashing HDR crashing In the latest releases this is a ra…
License Extension
Help.. I need a license extension for the IBM Informix Dynamic Server Version 10.00.FC3R1TL which I downloaded to do a evaluation. How can I get the license extened..my project is in the final stages .. Dhaya Commercial bank…
Re: Security Vulnerabilities Addressed in Informix Dynamic Server
Clive Eisen wrote: > Ian Michael Gumby wrote: > > Yes the buffer overflow issues are a pain and frankly they shouldn't occur > > if IBM did formal code reviews. Or rather they should be caught and > > corrected prior to release. > > > > "Paul Watson" <paul@oninit.com> wrote in m…
Security Vulnerabilities Addressed in Informix Dynamic Server
Not sure if this has posted here or not but .... http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=D600&u id=swg21242921&loc=en_US&cs=UTF-8&lang=en Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THER…
Re: Error occurs when oninit: DBSERVERNAME 'sharp' not in sqlhosts file.
Superboer wrote: > BTW i would start the database as user informix, not as root. > there were some security problems in the past.... Thank you. The database server was started successfully as the informix user on my machine. The database was maintained by other people before, I…
WTF PAM???
As far as I know your IDS support must also cover entire CSDK (and so the ODBC). Again as long as your authentication is only password through PAM you should be able to use both "ODBC Test Connection" as well as ODBC VB applications. The simple password authentication doesn't req…
25590: Authentication error
Hi, When trying to connect to a database through dbaccess on Unix, I keep getting this error message 25590: Authentication error I have tried the below steps. - Made sure that the root of O/S and Informix user passwords are same - Restarted the DB in informix login - Checked t…
Re: 668 System command cannot be executed - 1: Not owner
kjuliff (AT) gmail (DOT) com Wrote: > Dous it "login" to the host? > > > gavinrifkind wrote: when creating a JDBC connection to a database it passes in the user login and password, in order to authenticate the user. -- gavinrifkind -----------------------------------------------…
Problem with HDR over Windows 2003 servers
I have done HDR setup over Aix severs before without any problem. I am now running into problem with setting up HDR over Windows 2003 servers. If anyone has experience on setting up Informix HDR on Windows, please help. Windows Server: two identifcal Windows server 2003 (SP1). …
RE: Help needed in transfering or backing up/restoring Informix database via ODBC.
VP usually if you run dbaccess and the Connect to a non-trusted host you get a username/password dialogue. If you enter a valid c combination for he target host you should be able to get access (unless your assword/sshadow files are corrupt). Keith -----Original Message----- F…
Help needed in transfering or backing up/restoring Informix database via ODBC.
vpreatr@gmail.com wrote: > David, > Unfortunately I only have ODBC access, the server is not configured to > trust another INFORMIXSERVER nor can I add trust via allow.hosts (or > .rhosts) due to the level of file corruption on the failing server. > Typically I'd access the serve…
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
Re: Just for fun :o)
Interesting - the text of http://www.oracle.com/technology/products/database/oracle10g/pdf/DS_General_Oracle_Database10gR2_EE_0605.pdf rates a "This text had been classified as AUTHENTIC with a 95.4% chance of being an authentic paper"…
Just for fun :o)
and you post returned the folllowing : This text had been classified as INAUTHENTIC with a 14.6% chance of being authentic text…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
Informix and LDAP
Hi, at best look into utilizing PAM (Pluggable Authentication Modules). It is supported since 9.40.UC2, also on AIX. You may need to check if this is true for 9.40.FC2 and newer (64-bit) on AIX (currently I'm not 100% sure). There should be a file "pam.txt" in the release notes…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Re: Another IDS Feature Request
It would help us. I think it would be a feature that would really fit in with the new redundant fault tolerant application structure that is popular today. For example, we serve web pages from many app-servers that have many connections to the database. You never know from reques…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
Re: Connecting (IConnect) Solaris machine to a Linux server
Ciao, explanation by example: scenario: machine A (Solaris), IDS server name A1 machine B (Linux), IDS server name B1 Configuration machine A: onconfig file: ... SERVERNAME A1 ... sqlhosts file: A1 ontlitcp A portA B1 ontlitcp B portB /etc/services fil…
enhaced secury problems
Changing to enhanced security will expire all passwords. If you are attempting to use the previous password the login will fail. I also experienced a problem with Informix 9.2 where it was impossible to connect via a net connection to Tru64 with enhanced security. Don't know if t…
Re: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
Re: Sql to concatenate multiple rows to a single row / column
Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…
-956 client not trusted error with IDS 10.0 on Windows
If you haven't made any changes to demo1.ec it connects with: EXEC SQL connect to 'stores_demo'; This should connect locally as the user you are logged on as. It works for me when logged in to the server directly and via Remote Desktop. How are you logged in? Are you using any S…
Re: Client host or user is not trusted by the server
Hi. You must have configurated a trusted connection between both servers. The way to do this is different among platforms. Later Omar. ----- Original Message ----- From: <alanmas@gmail.com> To: <informix-list@iiug.org> Sent: Tuesday, Septem…
Auth_Informix_DB for Apache
Gerald wrote: > Does anyone know if there is a authentication module out there for > Informix? I have looked and have seen the one for mysql > (mod_auth_mysql) and for postgres and Oracle but none for Informix. > Also, does anyone know if a generic DB_authentication module …
Auth_Informix_DB for Apache
Does anyone know if there is a authentication module out there for Informix? I have looked and have seen the one for mysql (mod_auth_mysql) and for postgres and Oracle but none for Informix. Also, does anyone know if a generic DB_authentication module exists that can be mod…
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
Re: Informix Problem - Please Help Urgently
Hi, besides password shadowing (which I think actually should not cause such problems), it can be the password encryption method that causes such a problem. Online 5 only supports the classic UNIX encryption method for passwords (as implemented in the "crypt()" system call). O…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
Three tier, JDBC and authorization
Denis Melnikov wrote: >>You can configure tomcat to connect as any user you want to use. > > > Do I need to unlock the user's account at Solaris 8? Don't know I've never tested, I set the shell to /bin/false for all web accounts and setup a proper password. >>Depending on the …
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
Authentication Error
HI, My original plan is to drop a database (ex. stores database). - This informix engine was restored and started by root account. - After bringing up the server still as root account, I tried to drop stores database and I got this error " 359: Cannot drop or rename current dat…
Re: Onstat -g ses only for DBSA?
mosserp@wellsfargo.com wrote: >>From: Art S. Kagel >>Sent: Thursday, April 07, 2005 4:10 PM >> >>Lucho wrote: >>>There are two servers. >>> >>> One of them with an informix server version: IBM Informix Dynamic >>> Server Version 9.30.UC6W4 and the other IBM Informix Dynamic >>> S…
RE: Onstat -g ses only for DBSA?
mosserp@wellsfargo.com wrote: >>From: Art S. Kagel >>Sent: Thursday, April 07, 2005 4:10 PM >> >>Lucho wrote: >>>There are two servers. >>> >>> One of them with an informix server version: IBM Informix Dynamic >>> Server Version 9.30.UC6W4 and the other IBM Informix Dynamic >>> S…
Unix authentication ?
>I was always under the impression that you don't need a password on >Unix, to make a remote call to Informix (tcp connection), as long as >your username exists in the operating system. That's not true (per default). >I have a database server, and 4 application servers, and my …
Unix authentication ?
>I was always under the impression that you don't need a password on >Unix, to make a remote call to Informix (tcp connection), as long as >your username exists in the operating system. That's not true (per default). >I have a database server, and 4 application servers, and my …
Re: Unix authentication ?
Dirk Moolman said: > I was always under the impression that you don't need a password on > Unix, to make a remote call to Informix (tcp connection), as long as > your username exists in the operating system. > > I have a database server, and 4 application servers, and my users do…
Re: Unix authentication ?
Dirk Moolman said: > I was always under the impression that you don't need a password on > Unix, to make a remote call to Informix (tcp connection), as long as > your username exists in the operating system. > > I have a database server, and 4 application servers, and my users do…
Unix authentication ?
I was always under the impression that you don't need a password on Unix, to make a remote call to Informix (tcp connection), as long as your username exists in the operating system. I have a database server, and 4 application servers, and my users do not have a password on the …
Unix authentication ?
I was always under the impression that you don't need a password on Unix, to make a remote call to Informix (tcp connection), as long as your username exists in the operating system. I have a database server, and 4 application servers, and my users do not have a password on the …
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
Re: informix dot net data provider
Michael Wimmer <newsgroup1@ecom.at> wrote in news:4219cf9a$0$23688$91cee783 @newsreader02.highway.telekom.at: > Hi, > > did anyone here successfully use C# to connect to an informix? > Try this connection string Provider='Ifxoledbc.2';User ID=xxx;Data Source='mydb@informixsrv';…
Server is in an incompatible state
Hi, I am geting this message while executing ontape -a : Server is in an incompatible state or user authentication failed. Program over. Even onstat dosent work shared memory not initialized for INFORMIXSERVER 'sysprod' The client dbaccess works fine and all cleint sessions w…
HPUX PAM Authentication configuration problems
We have a new HPUX server that we will be migrating our production IDS database and software to. In this migrations we will be also migrating from IDs 7.31 to IDS 9.4. In our testing everything went well with the upgrade to IDS 9.4, but we are trying to get PAM authentication w…
Enterprise Replication Error
You should make sure that user informix is trusted on each server, from the other server. In other words, user informix should be trusted on dhl-3l when it is coming from dhl-6a and vice versa. The appropriate entry should be added to the /etc/hosts.equiv file. The best way I fo…
LDAP validation
Hi IDS does not support LDAP directly. [ IDS uses normal system calls to get authentication information. These system calls generally do not support LDAP, therefore IDS does not support LDAP. ] There are two ways to get IDS to do authentication via LDAP: a) use PAM which is s…
ontape -s0 -B problem
When I try to set my informix 7.31UD5 database in 'read commited only' mode by commend: 'ontape -s0 -B databasename' the next error occurs: "Incorrectly built binary which accesses errno, h_errno or _res directly. Needs to be fixed. Server is in an incompatible state or user auth…
chunk capacity
we are using BM Informix Dynamic Server Version 9.40.UC2X3 on Linux Kernel 2.4.21 the command 'onstat -d' shows ... Expanded chunk capacity mode: disabled how can I change this mode to 'enabled'?…
IDS 9.4 and LDAP
John Adamski wrote: > We currently are on IDS 7.31 on a HPUX box, and will be upgrading to IDS > 9.4 in the near future and have been asked in IDS 9.4 if it is possible > to authenticate access to the database using LDAP server instead of > using the Unix user password. > > I tho…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
Help with 9.4 UC2 and pam_winbind
I can't seem to get pam authentication working with informix 9.40 UC2 on linux. I'm just trying to get simple password authentication working with our server. We're using pam_winbind.so for most users Following the limited documentation I have (pam.txt) and the article posted on…
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
Re: To build better security
There are OS (and even Informix) based security mechanisms that you can enable through configuration of INFORMIXSQLHOSTS. In the server security option field (5th field) of SQLHOSTS, you can specify s=1 (/etc/hosts.equiv based) s=2 (~/.rhosts based) s=6 ($INFORMIXDIR/etc/hosts.eq…
RE: To build better security
Guys- You should be able to do it with a firewall. Deny access to the Informix port (1525, 1526, etc.) except to connections from specified addresses. --EEM -----Original Message----- From: Andrew Hamm [mailto:ahamm@mail.com] Sent: Friday, July 09, 2004 9:55 PM To: informix-…
Re: To build better security
--0-1806648619-1089724075=:52348 Content-Type: text/plain; charset=us-ascii Andrew, Please enlighten us with your knowledge on why it is wrong to secure connections by IP if there is a need for it from the business ? Thanks. Andrew Hamm <ahamm@mail.com> wrote: Mike Smith wrot…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
Dose anybody have the dbtop script in the Troubleshooting informix course?
Dears, I study the Troubleshooting ibm informix dynamic server course. At the module 4 exercise need the dbtop script. Dose anybody has this dbtop script and post for me? Thanks. Philip Yeh.…
Work group edition - Unlimited edition??
Taken from IBM web site:- =========================================================================== The following Informix Dynamic Server Workgroup Unlimited editions have been added to the IBM Data Management Gold Transaction Processing Bundle for SMB Unlimited: IBM Informix…
Can't get PAM authentication to work
I have IDS 9.40.FC3 installed on a Solaris 9 box. The Solaris OS has been successfully configured to authenticate against an Active Directory server via Samba with winbind PAM module. I can log into Solaris with an AD username and password. However, I have been unable to get Inf…
Re: [Informix Dynamic Server (IDS):] Digest 2671
For a course in the US, check out: http://www-306.ibm.com/services/learning/ites.wss?pageType=course_description&co urseCode=L1760&country=us&language=en (IBM course L1760). There is probably a similar course offered in Europe somewhere. Hope this helps. Kevin Doiron Toronto,…
Can we change the password of the informix user?
My ODBC drivers for Informix are unable to resolve the password for my Informix user 'informix'. This is the default user who is an Win OS-level user. If the change the password of the user does this conflict with the database's ability to authenticate the user? Also can we cre…
Re: Transaction support in informix dynamic server(IDS)
chaithra wrote: > i wanted to know, if in IDS we can get to know the status of a > transaction at any given time. or once any transaction commits or > rollsback we should be able to know the status. > is it possible through c++ interface provided by the IDS. I'm not quite s…
Transaction support in informix dynamic server(IDS)
hi all, i wanted to know, if in IDS we can get to know the status of a transaction at any given time. or once any transaction commits or rollsback we should be able to know the status. is it possible through c++ interface provided by the IDS. thanx in advace chaithra…
Re: Is there P.A.M. or Kerberos authentication support in IDS?
There is PAM support starting with IDS 9.40.UC2, on SOL32, SOL64, HP32, AIX32, and Linux. You could also use ESQL/C as the client , starting CSDK2.81.UC2 (ESQL - 9.53.UC2) . The client has support for PAM on all platforms. Read http://www-106.ibm.com/developerworks/db2/zones/in…
Is there P.A.M. or Kerberos authentication support in IDS?
Hi all, We do not wish to use the age-old, insecure, arcane Unix login authentication method that hits against the /etc/passwd file when logging into our IDS servers. Instead, we would like to use a centralized, networked authentication/account server such as a Kerberos Doma…
Is there P.A.M. or Kerberos authentication support in IDS?
Hi all, We do not wish to use the age-old, insecure, arcane Unix login authentication method that hits against the /etc/passwd file when logging into our IDS servers. Instead, we would like to use a centralized, networked authentication/account server such as a Kerberos Domain …
configure computer for using informix
what shell I do to make my computer work with informix. I have installed winXP on my computer, informix 4 i informix dynamic server? THANKS…
Replication Issue
===> -956 Client client-name or user is not trusted by the database server. Create the /etc/hosts.equiv file and add the remote host on each server. Example: (as root on server1) echo "server2" >>/etc/hosts.equiv chmod 600 /etc/hosts.equiv Example: (as root on server2) echo "s…
Where can I get the client API?
Hi, does anyone knows where to get the client API for Informix Dynamic Server 7.x? Perhaps we want to access the server via api directly. Kind regards, Joachim Engel.…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
TRUNCATE TABLE command in 9.3?
I am aware that Informix Dynamic Server previously has not included the TRUNCATE TABLE command. Does anyone know if 9.3 or 9.4 include this command?…
Linux fgl_getenv
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.…
setuid for dbaccess
Your DBAs can do CREATE PROCEDURE "informix".whatnot(...)... and CREATE TABLE "informix".whosit(...). Don't trust SUID scripts unless you know a lot more about your system than I do. I wouldn't trust them even then. For primarily historical reasons, Informix only pays attention…
Connection problem
Hi all, I have this problem : Error -951 while trying to connect to the Informix 7.31TD2 server (on = win2000) from an windows XP (client APP) via ODBC. The ODBC test connection works ok, but the application throws this error = : user not known on the database server. When I us…
Login greater than 8 Characters
[SNIP] > > Is there a way to have a Login greater than 8 characters? > [SNIP] No way. Since IDS is using OS users and primary OS for Informix is UNIX, ... > > Any ideas? > You can use your own authentication system, but it will take you quite a lot of programming to do it. …
Sniffer Decode for Informix
Hello All, We are currently running 7.31.UC3XE on an AIX 4.3.3 server. One of our goals is to be able to identify all connections/sql statements and log them to a file for security monitoring. I know that I can capture a snapshot of this information from the sysmaster tables h…
RE: Dynamic Server versus Universal Server ??
Originally, Version 7.x was called 'Informix Dynamic Server', Version 9.0x was called 'Universal server' Starting with 9.1, Universal server became 'Dynamic server with Universal data option'. With 9.2, new names 'Internet Foundation 2000 ' and 'Dynamic server 2000' ware given…
Informix Dynamic Server 2000 startup problem
Hi, While starting up informix in multi user mode , we wait for the database to come up by checking the onstat - o/p . But if the system is loaded, even after onstat shows status as online , the connection is rejected by the database . The wait loop that we do is as follow…
Which version to use of Informix Connect?
Hi Community, I have some questions about Informix Connect and hope that somebody knows the answers :-) We are using HP-UX 10.20/Informix 7.31.UD5 and the clients (OS: WIN NT/WIN2000) are connecting to the database through I-Connect 7.20. Are there known problems with this vers…
Re: Authentication with PAM
Use ODBC pass thru security option. i.e. ODBC can be configured to pass your Domain UID & PWD to the database server. You will have to create syncronised list of users accounts and PWD's on the Linux or Unix server. This is 'common as muck'. Most VB apps can pass their worksta…
Re: Authentication with PAM
> > Nevertheless, phear not, because 9.40.UC2 (UC1 had some problems and > > has it disabled)should be able to use PAM modules to authenticate > > users. > Does anybody know when UC2 shoule be expected out? June is just about > over... It is over now. :( sending to informix-li…
Re: Authentication with PAM
Hi, That is client part of PAM support which is available in CSDK 2.81.UC2 onwards. Using this with 9.40.UC1 or prior versions of IDS, will not have any effect. 9.40.UC2 should be available shortly if not already. Thanks and Regards, Gaurav Andrej Falou…
Re: Authentication with PAM
Fernando Nunes <spam@domus.online.pt> writes: > Nevertheless, phear not, because 9.40.UC2 (UC1 had some problems and > has it disabled)should be able to use PAM modules to authenticate > users. Does anybody know when UC2 shoule be expected out? June is just about over... -- Fo…
Re: Authentication with PAM
Adam Williams <adam@morrison-ind.com> writes: >> 2.) It seems that our Informix-version isn't capable of using pam >> at all (I found some hints, but no definitive answer to that). >> So : Is it possible or not ? > > Nope. How the *$*(@ *@$()@)_ heck one is supposed to operate a…
Re: Authentication with PAM
> we have some questions regarding informix authentication on > linux using the pam-system. > At the moment we have a windows nt domain with a pdc and > some workstations, which authenticate themselves using the > domain. Some of the workstations are informix-Clients > with our s…
Authentication with PAM
Hi, we have some questions regarding informix authentication on linux using the pam-system. At the moment we have a windows nt domain with a pdc and some workstations, which authenticate themselves using the domain. Some of the workstations are informix-Clients with our softwar…
why I can't see the output of "onstat -g wts"
test:/informix>onstat -g wst Informix Dynamic Server 2000 Version 9.21.FC7 -- On-Line -- Up 5 days 13:23:03 -- 11132960 Kbytes Wait statistics not enabled How to enable the wait statistics???…
informix SDK 2.81 ifxoledbc OLEDB and ADO
When Updating or deleting a non existing row in a table, the informix oledb provider produces an "UnSpecified error". Environment: Informix Dynamic Server 7.31 Informix SDK 2.81 ADO 2.6 Any help will be appreciated. Thanks in advance…
Help with Error 25590
Hi I am trying to use dbaccess to access a database and I get the following error message "-25590 Authentication error." I am only able to access the database as Informix user only. How can I access the database as other users also. Thanks Shankar…
ODBC Security
Consider this scenario: An ODBC connection configured to allow a user direct access to a database, thus bypassing any application security locking users out from specific records of tables. Any user granted access to a table is granted access to the table level, although when r…
Iplanet iWS 4.1 + Informix ?
Hi all I've tryed to find information about how to use Informix database as an user database for authentication with Iplanet 4.1 WebServer , but so far haven't found any "howto's" of the subject. So if anybody knows a site or way how to do it, could you plz inform. Mauritz Unt…
Kerberos authentication
I want to use kerberos v4 or v5 without DCE for authentication. How do I do this? I use Informix Internet Foundation 2000 on Solaris 2.6. There is an Apache 1.3.14 on the same machine, recompiled for use with informix web datablade. I want one of the servers to be for internal…
RE: Informix user
>I'd like to know how is the user get created in Informix. The OS >Is there any create user command like in oracle ? No >Is the informix user authenticated by the O/S, we are running on HP-UX ? Yes >Can I create an informix user who is authenticated internally by the >databas…
Informix user
I'd like to know how is the user get created in Informix. Is there any create user command like in oracle ? Is the informix user authenticated by the O/S, we are running on HP-UX ? Can I create an informix user who is authenticated internally by the database ? Usually I only see…
Informix Security Lockdown
Hi All, I am currently in the planning stages of securing my informix database server (ids2000 on hpux 11.00). Ideally what I'd like to have is a simple maintenance screen that'll allow our security administrator (who has NO real sql or unix experience) to (by point and click?)…
Re: DB access from multiple server permission problem
Gary Quiring wrote: > I have two servers running Informix 7.31. Some new code was written to > access a database from a different server. It only works if I add that > user to the Unix system. Is there a way of opening up the database to > allow anyone to access it without th…
Informix doesn't support Linux?
We're trying to implement IDS.2000 9.20.UC2 on Linux. Apparently Informix has still not bothered to fix the long-standing bug which prevents PAM password authentication (bug 120510). Is this correct? According to tech support there are no immediate plans to fix it. Is tha…
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
RE: InformixClient for Wins+Delphi+ODBC and DB security
Have been there with security. What people forget is that your user runs both WIN+UNIX apps with full read/write. Load ODBC and all security down the drain. AFAIK There are only 2 options. Tune you Delphi app to connect via ODBC, but use Openlink drivers. They have lots of s…
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
Help: 908 errors with NT client and linux IFS2000/9.20 server
The clients have to be trusted on the server and each user must have a valid login account on the server. You either have to list each client in /etc/hosts.equiv or in the .rhosts file in each user's home directory. Art S. Kagel Fuzzy wrote: > > Argh! > > I can't figure out wh…
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
Re: Testing Linux Client
Thanks Jonathan, Art and John for you help. I plan to port an existing windows informix application to linux and before I start the port, I wanted to ensure the client was correctly set-up. I took your advice and quickly created an ESQL/C application that connects to my server an…
Re: How to search for a string in a TEXT field
Hi, :-( SELECT name, REPLACE(text,"ZNOTREADY","found") AS your_output FROM tablewithtextfield; Blobs are not allowed in this expression. I use Informix Dynamic Server Version 7.31.UC2A…
JDBC login to Informix 7.xx
We're trying to write a batch program in java, which should connect to an Informix database using JDBC. It is of course possible to store the userid and password in, for instance, environment variables, or to hard code them into the program, but for security reasons, that is clea…
RE: User Not Trusted
Is the host listed in hosts.equiv file in %WINDIR%\\system32\\drivers\\etc (could be system instead of system32). The hosts file, among others, is here too. The trust is configured exactly the same as for Unix. MW -----Original Message----- From: owner-informix-list@iiug.iiug…
Re: How to deny CLI access
From: Karl-Heinz Braun <khbraun@vegla.de> > >My server-based application uses Unix logins to connect to an Informix >database. >Some of my (smarter) users have discovered the possibility to access >this database through ODBC/CLI. >How can I prevent them from doing this without re…
Re: Setting password for database user on Linux
In article <396E2770.B32B8626@bloomberg.net>, Art S. Kagel wrote: >Informix does not do its own authentication at all. It relies on the >OS to authenticate users so ostensibly it will use whatever you have >setup for your system. The problem with the Linux version right now >is…
Setting password for database user on Linux
Here's what I found on the Informix TechInfo site, regarding this problem on 7.30: Product: Informix ONLINE Reported: 10/22/1999 ONLINE 7.30.UC7 FOR LINUX: CONNECTION AUTHENTICATION NOT PAM AWARE; WILL FAIL IF NONSTANDARD DES CRYPT ENCRYPTION USED FOR PASSWORD AUTHENTICATION.…
Create user in Informix Dynamic Server
Hello all I`m new in INS. Could you help me? I have Database server with one user Informix. How to create another user to Database?…
Re: Security Hole in Informix
Daniel Wood wrote: > It is a security hole for everyone to be able to read salaries from > a payroll database. > > It is NOT a security hole to know that a payroll database has a > table named employee or that the table has a column named salary. > > These are two very different …
Informix ODS on Win 2000?
Does Informix Dynamic Server V7.31.TC5 for Intel Pentium Windows NT 4 also run on Windows 2000? Thanks for any help. Guy Dillen ITP…
Security Hole in Informix
Currently I am implementing internet system on the IDS 7.3 for Linux. I have found strange security hole in the IDS. User with the only connect privilege has the ability to generate database schema, view database structure etc.. Is there any way to prevent users from d…
Re: authentification
From: "Martin A. Marques" <martin@math.unl.edu.ar> > >I would like to know how informix authenticates when someone tries to >connect >to certain DB. Does it authenticate itself with the OS, or does it have a >database with all the authentification info of the users (like in MySQL…
authentification
hello. I would like to know how informix authenticates when someone tries to connect to certain DB. Does it authenticate itself with the OS, or does it have a database with all the authentification info of the users (like in MySQL)? Thanks -- "And I'm happy, because you make me…
Informix cost???
Someone can said how much does Informix cost? I need to know: -Informix costs -cost for client Thanks very much. I need the last version of dynamic server for Unix. Ciao, Berna…
Security hole?
I pulled the following off CERT. Anyone have comments? Katherine Please describe the vulnerability. - - --------------------------------- What is the impact of this vulnerability? - - ---------------------------------------- (For example: local user can gain root/privileged a…
Re: Web connection
From: "Juan Manuel Hern�ndez del Olmo" <jhernandez@geuropa.com> > >I am interested in developing web-based solutions with my Informix >IDS7.32UC2. I have a Microsoft IIS server, with ASP-pages, and the 1st >solution could be the creation of ASP pages with ODBC-connectivity to >In…
Web connection
Hello. I am interested in developing web-based solutions with my Informix IDS7.32UC2. I have a Microsoft IIS server, with ASP-pages, and the 1st solution could be the creation of ASP pages with ODBC-connectivity to Informix. But I suppose this is not a very secure environment, f…
Replication
Hello everybody. I would like to know if it is possible to replicate an Informix database between a UNIX-based 7.32UC2 Informix Dynamic Server and an linux-based IDS2000 without problems. Thanks in advance. jhernandez@geuropa.com…
Please correct me: Informix security sucks
Greg Starnes wrote: > > Oracle has security at the OS and Database level. All I can find from > Informix is that they only have security at the OS level. SO, if you have > root privileges for the OS, you can get into the tables of our product > (which, obviously we dont want to…
dynamic server with Informix distant database
We have this problem : - write of a html page (this pages will contain many many fields). - Receiving of the page data on a http server based on a M1 machine. - Using of 4gl/informix programs based on the M2 machine with the pages data - 4GL programs will set up a � result � tabl…
-25590 Authentication error
Hello! I have downloaded from Intraware Informix Client-SDK 2.3 for w95/w98. I connect with no problems from Excel, Access, Vb5 to database Informix-SE 7.2 under SCO OpenServer 5.0.5 from my machine. I have installed the same product on another machine and I am not able to con…
Informix - JDBC
Hi, I have a problem with a connection to a database server trough JDBC. After the Informix JDBC driver is loaded when I try conn=DriverManager.getConnection("...") I receive an error message : # Verifier error com/informix/asf/CSMspwd.<init>()V: Cannot find class java/security/…
HELP! Informix Dynamic Server 7.3
I'm trying to install a new IDS on Linux (RedHat 6.1) on a cooked file. Everything looks right, but upon oninit, I receive the following: oninit: Cannot open chunk '/u1/naf_chunk'. errno = 2 oninit: Fatal error in shared memory initialization Log reflects: 09:11:07 Informi…
UDR Support in Informix Dynamic Server.
Can someone tell me what exact version of Informix Dynamic Server that first supported C User Defined Routines. I've tried searching for this on their website with no joy. (their advanced search doesnt work at all !) Rgds, Peter. Sent via Deja.com http://www.deja.com/ Before y…
OFFICE Connect V.1
Informix Office Connect, Version 1.0, is compatible with the following Informix servers: Informix Dynamic Server, Version 7.3 or later Informix Dynamic Server with Universal Data Option, Version 9.14 Informix Dynamic Server 2000, Version 9.2 or later e Informix-SE 7.23 n�o func…
System catalogue
Hello! Can anybody explain me how I can create trigger on "informix".systables? (The server I deal with is Informix Online Dynamic Server 7.3.) Max…
Compatability between Informix products
Hi, I need some version compatability information for the following products. Hardware Platform: Hewlett Packard OS Platform: HP-UX version 10.20 Informix s/w: Informix Universal Server 9.20 Informix Dynamic Server 7.31 Informix Gateway to DRDA vers…
Linux Suse 6..2 and IDS 7.3 HEEELP!!!
Hi Lloyd!! thanks a lot for this tip!! Where can I disable this option?!?! Thans, again!! Serafin Lloyd AJ Wilson <lwilson@harriscomputer.com> schrieb in im Newsbeitrag: FGQ74.1433$B3.4790863@news.magma.ca... > Informix does password authentication through your password's fil…
Re: Can I trace the activities on Informix databases?
The Zero Impact Sql Monitor maintains the information you wish.. Refer to www.sqlpower.com. The product captures all login information (login id, client IP address and port no., application name, host name, time to connect, server IP and port no.) with ZERO impact upon the datab…
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
Informix SE 7.24.UC5 on RedHat Linux 6.2 and password security
There would seem to be some issues with password security and this software/OS combination. We can establish a connection using dbaccess or ODBC only if we attempt to connect with the root login and password. 1 - Has anyone experienced the same problems? 2 - Is there a patch o…
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
add new user
> Informix will let you add permissions for a user that the OS does not know > about, however, that user will not be able to connect to the server from > a client since OS privileging is used by Informix to verify passwords, Ah, the old authentication issue for heterogeneous two…
pricing for informix info?
Hello, Was wondering what other people out there paid for informix dynamic server 7.3... Basically, i wanted to know if they had a web server licensing schem like microsoft. or ibm's db2 (per cpu license). and would the licenses be transferable if I decided to move from le…
Re: Informix Authentication and ODBC
Hi, The Sujit sugestion to use nonexpired passwords is not very good for security resons. Your users have to change their passowrds at some regular intervals. As I know Informix Server has the CSS (Communication Support Component) that support third party security services. You…
Re: Informix Authentication and ODBC
Trebor How about having non-expiring passwords on the Unix side? HTH Sujit "Trebor C. Fenstermaker" <tcfenstermaker@acm.org> on 08/12/99 10:50:35 AM Please respond to "Trebor C. Fenstermaker" <tcfenstermaker@acm.org> To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subje…
Informix Authentication and ODBC
Greetings, In the ten years I've been using Informix, I've never heard a good solution of how to address the problem of PC-based users, connecting with ODBC, authenticating against UNIX-based Informix. The problem of course is that Informix--grounded in its glory days of Unix/U…
Re: Determining version dynamically
Hi, If you have Informix Dynamic Server then use the following sql-statement ' select DBINFO('version', 'full') from systables where tabid = 1' result from the sql is : Informix Dynamic Server Version 7.30.UC5 Take a look in Informix Guide to SQL: Syntax for more about DBINFO…
KAIO: out of OS resources error
Hi~ My informix dynamic server write "KAIO: out of OS resources error .." in online.log. This error log is written during ontape task. How can I solve this problem? platfom : SunOs 5.5.1 Informix Dynamic Server 7.24 uc6 Thanks.…
Re: IECC from windows NT & SQL editor
Adam Richards wrote: > > I use unix and telnet most of the time, but i am supposed to > evaluate the IECC stuff that comes with 7.31. > > i installed the client tools on my NT box with ilogin and setnet32. > > I got past the services problem, but still cannot connect to my unix >…
64bit IDS for Solaris 7/SPARC ?
Is there a 64bit Informix Dynamic Server 7.3x for Solaris 7/SPARC available? tia, joerg…
Posting from the Informix-list
what is the last version of Informix Dynamic Server for HP-UX 10.20, where can i find more Information about this.…
Latest versions for various Informix products ???
Which are the latest versions for Informix Dynamic Server Informix Dynamic Server, Workgroup Edition Informix 4GL Informix SQL on Solaris 7/SPARC ? Where can I find such informations on Informix's website ? tia, joerg…
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
Problem Installing Informix Dynamic Server
I downloaded a Try&Buy version of Informix Dynamic Server V7.30 for NT. I installed it on an NT Server. The install seemed to go ok, but after a short time of investigating IECC, I got a blue screen. After this when I started the Command Center, a task seemed to start, but it w…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
Out of buffer?
Hi, I got the following error message from an Informix IDS 7.30: <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause Dynamic Server to get into a locked state. Recommended minimum buffer pool size is 4 times maximum concurrent user thre…
Re: Two Windows NT servers cooperating
You need a hosts.equiv file in %WINDIR%\\system32\\drivers\\etc This is the same directory as services and hosts table. In this file I forget whether you need the host name or hosts@domain. I think I put them both in. Regards Murray Wood ----- Original Message ----- From: L…
Two Windows NT servers cooperating
Try and include the server names in the hosts.equiv files on each NT server. Create a file that contains the name of the servers that are to be trusted. Name the file hosts.equiv. place this file in c:\\winnt\\system32\\drivers\\etc on the NT server Shannon Leo Cardoso wrote …
Re: Newbie : Trust a PC in the domain
I suppose as in other UNIX'es the file is: /etc/hosts.equiv Try setting a + line in this file (not sure it will work on RH). But I think your problem is not in 'host trusting'. You just have to configure correctly the client side, so users can specify their login name and p…
Re: IDS 7.30 and RH6.0 shadow password
Damijan Sencar wrote: > Hi! > > I have problem with IDS 7.30 on RH6.0. I can't connect to IDS server > with ODBC when I specify > password in Ilogin program. I can connect tp the same server with just > empty password filed. > > I can connect with same client configuration (and …
Linux VS NT4.0
Hi, Is it true that Informix Dynamic Server workgroup edition 7.30 is ported for Linux, and if it is so does anyone can tell me what to chose between Linux and NT4.0 for running Informix Dynamic Server workgroup edition 7.30. Also I'd like to know for which version of Linux, Inf…
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
Re: Securing ODBC connections
> > Is it possible to secure ODBC access to a server's ports even if a client > may be connecting in via their own ODBC s/w > I assume the answer is no, but I'd like to be sure. Any tips on how to make > ODBC connections safer would be appreciated > > Paul Matthews > You can use…
Re: Securing ODBC connections
Hello, I have an idea, but I haven't checked it and I'm not sure how easy is it to be implemented (and is it possible at all). The idea is that you have to install an SSL proxy on the client side and another one on server side. The first SSL proxy have to: 1. Listen for conne…
Securing ODBC connections
Is it possible to secure ODBC access to a server's ports even if a client may be connecting in via their own ODBC s/w I assume the answer is no, but I'd like to be sure. Any tips on how to make ODBC connections safer would be appreciated Paul Matthews…
converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
Hi converting Informix Online 5.1 esql/c to Dynamic Server esql/c? What is the easiest way to do this? Is there a parser that could do this? edward…
Help for Informix JDBC driver 1.4 wanted !
If I try to connect to our database server with ... DriverManager.getConnection(jdbcUrl); ... I have various exceptions: * when applet started within appletviewer "Attempt to connect to database server (Java socket exception encountered: access denied (java.net.SocketPermissi…
Informix Security
Does anyone know where I can find some info, about security of informix database. Besides privilages and roles. I mean things like secure connections to the database. Thank you david.tamburin@protegrity.com…
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
Re: Error -567
DirkM wrote: > > Hallo Everyone, > > Every now and then we get the following error message in some of our > reports - > > Error status -567. Cannot write sorted rows > > All I can think of is that our temporary sort space got full at the time > the report was run. Is thi…
Informix on Linux
Does anybody know how much a copy of Informix Dynamic Server would run me for use on Linux?? Thanks in advance -steve…
Upgrade Dynamic Server 7.13 - 7.24
I need to upgrade Informix Dynamic Server version 7.13 to version 7.24. Can anyone advise of any problems they may have had whilst doing this?…
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
SSL or SHTTP with Java/JDBC
Hi there, I am using the Informix JDBC-Driver Type 4 to connect from an Java applet to a Dynamic Server 7.2 . Is it possible to make the data transfer between the applet and the database secure? I mean using SSL or something similar (S-HTTP, ...), which works fine on secure HTTP…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Re: Security products that work with databases
> I wonder if there are any databases that provide connection to Certification > Authority (CA) products, like Entrust and so on, or are there any 3rd party > products that can glue the database together with the CA? Mike, I know of no such products and SQL doesn't provide the…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Re: Database Internet
Why don't you use informix WebDatablade? It work very fine and fast (server 9.14, webDB 3.32). It is really simple to implement security, also. Erik Ahmad Munif wrote: > How to get connected to the informix database server from the web. > wheter need additional library, or we …
Re: Authentication using PAM
In article <XJzgeJAArTE2EwTm@smooth1.demon.co.uk>, David Williams <djw@smooth1.demon.co.uk> writes: >In article <6ur30h$hbt$1@nnrp1.dejanews.com>, barce@frlp.utn.edu.ar >writes >>Hi! >> >> I�m using Online 7.23.UC4 on Solaris 2.6 >> I�m authenticating Solaris logins using PAM, I…
Re: Authentication using PAM
In article <6ur30h$hbt$1@nnrp1.dejanews.com>, barce@frlp.utn.edu.ar writes >Hi! > > I�m using Online 7.23.UC4 on Solaris 2.6 > I�m authenticating Solaris logins using PAM, Is there any way to authenticate >informix logins using PAM too? > Informix doesn't have a login procedu…
Authentication using PAM
Hi! I�m using Online 7.23.UC4 on Solaris 2.6 I�m authenticating Solaris logins using PAM, Is there any way to authenticate informix logins using PAM too? -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your …
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Informix Authentication Methods
I have been given the task of finding any and all info regarding user authentication methods for Informix's databases. What is of interest to me is: For each version of the databases, what user auth. methods are/were available? ex. version 5.x supported username/password and K…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Authentication on Remote machines
Hi, Is there any possibility to do authentication on Remote machines only with client host names instead of /etc/passwd + .rhosts/hosts.equiv ? We are running Online & Se 7.2x Thanks Michael -- Michael Pauels | Raiffeisenstr. 15-18 System Administrator at …
Smart Card Authentication to Informix Webblade
Does anyone know of an Informix WebBlade smart card authentication solution and/or knows if there are implementations of such systems ?…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
Re: Informix, NT4 and IIS
Hi Bernd Are you able to connect if there is no security on the site? We believe we are very close to making this work but seem to be stuck. We are able to make the site work if there is no security is placed on the site. Once security is placed on the site and NT is rebooted,…
Re: Informix, NT4 and IIS
Hi there, we have a similar problem: we try to use ASP pages with an IIS on a NT4.0-PC and Intersolv-ODBC-Driver 3.10 to connect to an Informix-DB on a UNIX-mashine. But we can't manage to even establish the connection. It seems that it is also an authentication problem. Any advi…
Informix, NT4 and IIS
Hi all, Has anyone been able to use ASP pages running IIS4 on an NT4 machine to query an informix database? We are able to connect when no security is being used but as soon as we try and force authentication, the site crashes after the second person logs on. The first person …
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
Re: Prohibiting ODBC access
Neil Truby wrote: > OnLine v7 on Solaris 2.5. > > Does anyone have any ideas how I can prohibit ODBC access to my database > server from anyone, including users who might otherwise be valid > database users? > > The system I have isn't really Client/Server, in that users telnet …
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
DBSERVERNAME
After configuring interfaces for virtuals hosts (for webservers, say server1, server2) on a host (say host0), where two instances of Informix Universal Server are running, I get the error 956 client host or user (informix@>servername>) is not trusted by the server. <servername> i…
Re: Native Informix Driver for Visual Basic.
In article <3550a32d.14503281@news.newmedia.no>, Nils Myklebust <Nils.Myklebust@nmdata.com> writes >On Tue, 05 May 1998 19:28:01 +0100, Allan Gould ><allang@sco.com.no.spam> wrote: > >>Nils Myklebust wrote: >> >>> > [snip] >>> >> >>> >P.S.: What do you think about the "new" CLI …
Re: Native Informix Driver for Visual Basic.
On Tue, 05 May 1998 19:28:01 +0100, Allan Gould <allang@sco.com.no.spam> wrote: >Nils Myklebust wrote: > >> > [snip] >> > >> >P.S.: What do you think about the "new" CLI 2.8 which is released by >> >informix and now also includes Intersolv 3.0 drivers? Which one is better? >> >…
Re: Need help connecting to NT from UNIX
I'm going to answer your questions at each point below Ravi Navanee wrote in message <353E0512.FD2D31A0@i-kinetics.com>... >Hi, > >I am not sure how to make an UNIX host a trusted host on NT. Here are my >questions. I would appreciate if you can provide any information. > >1) Ho…
Need help connecting to NT from UNIX
Hi, I am not sure how to make an UNIX host a trusted host on NT. Here are my questions. I would appreciate if you can provide any information. 1) How do I make my UNIX machine a trusted host on an NT 4.0 server? I have created a Hosts file in winnt\\system32\\drivers\\etc direc…
Informix Dynamic Server & Text columns
Hi everybody, Can you help me ? I've created a table with the following structure : column type -------- ---- code smallint obs text How can I insert into this table with Java program ? I'm using Informix Java AP…
Intermittent Problem - error 529 Cannot attach to transaction
We have a HP-UX box (Ver 10.20) running Informix Online Dynamic Server Ver 7.13 and a NT Server (NT4.0) running Informix Online Dynamic Server Ver 7.23. We are trying to access some of the database tables resided in the HP-UX box from the NT Server via synonyms. But we faced inte…
How can I read the header tape of the archive created by ontape?
I have Informix Dynamic Server 7.23.UC1. I would like know the tape header structure created by ontape.…
Re: Upgrading Informix from Online engine to Dynamic Server
Seth Grimes wrote: > > Jane Vohden wrote: > > > > I have been talking with Informix about upgrading our site from the > > 5.xx Online engine to 7.2x Dynamic Server. They said there was no cost > > I don't think that anyone has pointed out the mistaken terminology > h…
Newbie Question on Informix Database Connnection
Hi everybody, 1. Is it possible to connect to 2 databases at the same time using Informix Java API? In other words, let's say I want to retrieve data from 2 databases and display the results using Informix Java RMI connection, all at the same time. 2. I have create an Java a…
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
Re: I-Connect error 956
Adam, A 956 error usually means that you will have to create a .rhosts file in your home directory on the target machine or put an entry in the hosts.equiv file (you will probably need root access to do this). You should only need to do this if you are d…
I-Connect error 956
Unix Server SE 5.0 I-NET 5.0 NT workstation ESCL/C 7.2 (I-CONNECT 7.20TE1) The workstation can ping and telnet to the server with no problem but when using the Ilogin program I get error 956 ------------------------------- -956 ________________________________________________…
Re: trusted user ...?
IPCSHM is only available from a local session (shell account, local app, etc.), and is usually installed as NETTYPE = CPU. This tells the engine that you have already passed basic Unix authentication. If the NETTYPE is set to NET, then an entry in /etc/hosts.equiv or the local …
Re: trusted user ...?
Hi, I've got it! nettype for ips was onsoctcp, so when dbaccess tried to initialize ips database authentication failed (/etc/hosts.equiv was empty, no .rhosts!). So I changed onsoctcp to onipcshm and everything was ok. I would call this real security! Thank you all, Zdravko…
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
IDS Server 2.5, Secure JDBC, firewall support, ResultSet Caching
Dear JDBC users, The IDS Server 2.5 Beta is now available for download to both domestic and international users. This latest release features several major enhancements to the IDS JDBC Driver: -- Supports Public-Key Secure JDBC. A client JDBC applet can make a secure conne…
Re: Gaping security hole? (network db connections)
I have a related question. We are running Online 7.22 on DEC Alpha UNIX. Our GUI is in Delphi. Some of our PCs can connect to the server with no problems others get a 956 error "user or host not trusted". I spoke with Informix support they informed me I would have to make an …
Re: Gaping security hole? (network db connections)
Nathan Neulinger wrote: > Jack Parker <jparker@informix.com> wrote: > > At 12:24 AM 11/4/97 GMT, you wrote: > > }Actually, .rhosts is still a problem, > > } > > }It jsut narrows the hole from: > > } > > } ANY user on client can log into ANY user on server > > }to > > } A…
Re: Gaping security hole? (network db connections)
Jack Parker <jparker@informix.com> wrote: > At 12:24 AM 11/4/97 GMT, you wrote: > }Actually, .rhosts is still a problem, > } > }It jsut narrows the hole from: > } > } ANY user on client can log into ANY user on server > }to > } ANY user on client can log into this particular user…
Re: Gaping security hole? (network db connections)
Anders Hackin' Karlsson <anders.karlsson@karlsson.pp.se> wrote: > I'm not getting in to this discussion if .rhosts/hosts.equiv is bad > or not. I'll just comment on a factoid. As you state that anyone can > play with the PC hostaddresses, connecting from a DOS/WIN/NT PC to > Info…
Can't authenticate to Online: password incorrect?
We are running Online 7.22 on Unixware 2.1, Compaq Proliant 1500. Users are able to telnet into the system and fire up `dbaccess`. However, suddenly, they cannot access Online via their Delphi front-end program, even though they are typing in the same login and passwords as when…
Re: Gaping security hole? (network db connections)
> Informix's security is flawed in that /etc/hosts.equiv was really meant > to authtenticate a user on a particular machine. It was meant for a > UNIX to UNIX authentication, rather than a PC to UNIX. (peer to peer, > rather than client server.) This IS!!! for a UNIX to UNIX aut…
Re: Gaping security hole? (network db connections)
On Tue, Nov 04, 1997 at 09:17:24AM -0500, Jack Parker wrote: > At 12:24 AM 11/4/97 GMT, you wrote: > >Actually, .rhosts is still a problem, > > > >It jsut narrows the hole from: > > > > ANY user on client can log into ANY user on server > >to > > ANY user on client can log into t…
Re: Gaping security hole? (network db connections)
At 12:24 AM 11/4/97 GMT, you wrote: }Actually, .rhosts is still a problem, } }It jsut narrows the hole from: } } ANY user on client can log into ANY user on server }to } ANY user on client can log into this particular user on server You can specify user@host to narrow it down to…
Re: Gaping security hole? (network db connections)
Anders Hackin' Karlsson <anders.karlsson@karlsson.pp.se> wrote: > I'm not getting in to this discussion if .rhosts/hosts.equiv is bad > or not. I'll just comment on a factoid. As you state that anyone can > play with the PC hostaddresses, connecting from a DOS/WIN/NT PC to > Info…
Re: Gaping security hole? (network db connections)
Actually, .rhosts is still a problem, It jsut narrows the hole from: ANY user on client can log into ANY user on server to ANY user on client can log into this particular user on server Plus, based on some further testing I have done, it appears that it can be done without e…
Re: Gaping security hole? (network db connections)
I'm not getting in to this discussion if .rhosts/hosts.equiv is bad or not. I'll just comment on a factoid. As you state that anyone can play with the PC hostaddresses, connecting from a DOS/WIN/NT PC to Informix is different than connecting from a UNIX box. Last time I check the…
Re: Gaping security hole? (network db connections)
> > and look at what a connection looks like, and then send that same data to > > our central server. > > > > The problem here isn't the usual security problems with BSD .rhosts / > > hosts.equiv mechanism. We've accepted those. And if it were only that, > > this wouldn't be a pr…
Re: Gaping security hole? (network db connections)
That is quite a price. With an entry in hosts.equiv, the remote user can login as ANY user. I much prefer .rhosts, more of a pain to administer, but less of a gaping security hole. cheers j. At 07:58 PM 10/31/97 +0000, you wrote: }Nathan Neulinger wrote: }> }> Is it just me m…
Re: Gaping security hole? (network db connections)
At 08:58 PM 11/1/97 +0000, you wrote: >> >.rhosts exist in each user's home directory. Anyone can write anything >and the UNIX system will consider it valid. (Milage will vary on >different UNIX systems which also have private lists of trusted sites.) .rhosts is ineffective unle…
Re: Gaping security hole? (network db connections)
Michael Segel <"MailerDaemon"@[127.0.0.1]> wrote: > > The sqlexec process on the client is running as 'joeuser'. Anything that > > a process running as 'joeuser' can do, so can a process running as > > 'freduser'. > > > > The only way .rhosts/hosts.equiv works is that remsh/rlogi…
Re: Gaping security hole? (network db connections)
Michael Segel <"MailerDaemon"@[127.0.0.1]> wrote: > Nathan Neulinger wrote: > > > > Is it just me misreading things, or is there no security whatsoever in the > > network sqlexec connections to an informix DB server? > > > I'll give you the short answer. > Yes and No. > Don't use…
Gaping security hole? (network db connections)
Is it just me misreading things, or is there no security whatsoever in the network sqlexec connections to an informix DB server? I was under the initial impression that the informix server used the .rhosts/hosts.equiv mechanism to validate users - where the remote connection say…
Re: Remote tape Help.
georget wrote: > > Tape defined as remote in 'onconfig.std': > > # System Archive Tape Device > > TAPEDEV hpdemo:/dev/rmt/0mn # Tape device path > TAPEBLK 16 # Tape block size (Kbytes) > TAPESIZE 10240 # Maximum amount of data to …
Re: Help with distributed data access
INFODATA wrote: > > Hi folks, > > I would like some help regarding distributed data access. I have a set-up as > follows: > > A DEC-ALPHA box running I-4GL RDS 6.x and I-Online DS 7.x > > Another NCR box running I-4GL RDS 4.x and I-Online 5.x. > > I have a 4GL app…
Re: NEWERA -- Database Security
Brian Hampson wrote: > Mike Ripley (mike.ripley@excelsys.co.uk) wrote: > : I think this question may have been asked before. [snip] > We want users to be able to connect to our Informix Database, using our > Newera Applications, and only OUR applications. It appears that using >…
Re: NEWERA -- Database Security
brian@asl-labs.bc.ca (Brian Hampson) wrote: :We want users to be able to connect to our Informix Database, using our :Newera Applications, and only OUR applications. It appears that using :ODBC, any putz with excel or msaccess can happily wing over and modify our :tables if our…
Help! Error -956: My system doesen't trust itself
ODS Release 7.13.UC5 Hi family, I'm overlooking some stupid detail in configuring an instance and can't figure out where. I have two instances on one machine. In my default - the one I set up my ENV for when I log in - I have no problem connecting. In the other server instanc…
Re: Java access to Informix at $0 cost?
Make your connection through CGI. The URL class in Java will do the client end. Then pass the data through the command line in and stdout. Use HTTPS if security is a concern. mtidwell@zycon.com wrote in article <5u4gjt$2if@drn.zippo.com>... >Howdy, > >i have Informix 7.12 o…
Next Extent Calc.
Hi, I have INFORMIX-OnLine Dynamic Server Version 7.14.UD2. Does anyone know of a script or program to calculate the next extent size ? Thanks in advance Manuel…
Re: NIS and shadow passwords
NIS and NIS+ on Solaris work. They do not blow the security away. Chao Y. Din Mike Segel wrote: > Ti Lian Hwang wrote: > > > > Does anyone know whether Informix 5.03 and Informix 7.22 supports > > NIS and shadow passwords running on a HP-UX 10.10 ? > > > > What about connecti…
Re: Protocol
Hi Elisa, Elisa Hoffman wrote: > Has anyone connected to an Informix UNIX database through a firewall? > > How does INFORMIX (on UNIX) using I-NET, via ISQL, validate and confirm > who the remote client is? > - Is DNS used? If so, is the lookup based on IP address, where > ser…
Java and Informix Dynamic Server 7.x
Hi friends! I am trying to do server-side java cgi programming to connect to I-ODS 7.x. Do you know how I can do that? I heard it is possible to use the jdbc-odbc bridge( intersolve or openlink's), but the performance is too slow, because of jdbc to odbc and odbc to jdbc convert…
Re: I-Connect Questions
MarkDenham@aol.com wrote: :Openlink???? : :Tried this driver and it was a pig to get to work.... If that's so there must be something very strange. I have never had any problems to get it to work. It's actually easy although they could have made the installation procedure even …
Re: Localhost tricks
Hello guys, Small update on this. I am still struggling to understand what is making Online behavior disparate on those two boxes. There is a nice workaround though: foxie_tcp onsoctcp *localhost servicename note that asterisk. In this case you can forget messing with securi…
Re: Powerbuilder Connections to Informix
mayj@fdhc.state.fl.us ("May, James") wrote: >Hi Informixers, > >I'm forwarding the following content for our applications group. The >PowerBuilder usenet group has already been tried. I was asked to try >the Informix forum. We appreciate any suggestions. > >We are using Infor…
Re: Powerbuilder Connections to Informix
kerry@kcbbs.gen.nz (Kerry Sainsbury) wrote: >In article <5m27u7$emc@cssun.mathcs.emory.edu>, >mayj@fdhc.state.fl.us ("May, James") wrote: > >>If we tell SetNet32 (Informix's connection configuration program) to >>request a password at runtime (i.e. get it from the PowerBuilder l…
Re: Powerbuilder Connections to Informix
In article <5m27u7$emc@cssun.mathcs.emory.edu>, mayj@fdhc.state.fl.us ("May, James") wrote: >If we tell SetNet32 (Informix's connection configuration program) to >request a password at runtime (i.e. get it from the PowerBuilder login >process), we get an Informix error message (…
Re: Powerbuilder Connections to Informix
mayj@fdhc.state.fl.us ("May, James") wrote: :Hi Informixers, : :I'm forwarding the following content for our applications group. The :PowerBuilder usenet group has already been tried. I was asked to try :the Informix forum. We appreciate any suggestions. : :We are using Infor…
Powerbuilder Connections to Informix
Hi Informixers, I'm forwarding the following content for our applications group. The PowerBuilder usenet group has already been tried. I was asked to try the Informix forum. We appreciate any suggestions. We are using Informix 7.22 and Power Builder 5 for client/server devel…
Any user can create a database ???
It seems to me that Informix Online (I am using 7.22) will let any user who can connect to a server can create a database!!! I guess Informix was designed with the asssumption that users would only be allowed to access data through application code. In other words, no ad hoc too…
JDBC Connectivity
Connect Software, Inc. is pleased to announce that release 2.5 of FastForward is now available for download at our website: http://www.connectsw.com/ The new release brings major performance improvements across the entire product line, as well as compatibility with the new Java…
JDBC Connectivity
Connect Software, Inc. is pleased to announce that release 2.5 of FastForward is now available for download at our website: http://www.connectsw.com/ The new release brings major performance improvements across the entire product line, as well as compatibility with the new Java…
Re: Please help: OWS don' trust me...(NT 3,51 OL 7.12)
} Hi, c.d.i.! } } Please help. } } I'm new to OWS&NT and I'm NOT a DBA, so please tolerate my stupidity & } possible ignorance. } } After installing WorkGroup Server trial, I cannot use dbaccess ON THE } SERVER, because: } } 956: Client host or user (...) is not trusted.... } (I …
I-NET and DEC Alpha passwd shadowing
We have DEC Alpha with Enhanced security option ON (Digital Unix 3.2). Also, Informix OnLine DSA 7.20.UC3 No problems with 4GL programs connecting through shared memory. I'm trying to connect as client with INET 5.01 and even though I have correct password I get error -952. Ple…
-956 error
Hi I am using Informix 5.04 on SunOS 4.1.x. I am using my esql/c program as a cgi script. Everytime I tried to connect to the Informix server as a cgi script, I get -956 error -- Client or user is not trusted by the database server. The manual suggests I should modify /etc/ho…
web to informix interface
hi, i am trying to establish web to informix connectivity. lately i have been fiddling with esql/c cgi interface kit available from informix. when i tried, i get -956 error, and the manual suggests that i modify /etc/hosts.conf. of course this is not a practical solution, sin…
RE: Online NT and Online UNIX how to communicate?
Actually, if what I was told is correct, you do have a hosts.equiv (or = should). I was having difficulty authenticating myself, under NT. I was told to = be sure a hosts.equiv file does exist in = %WINDOWSDIR\\system32\\drivers\\etc directory, because it is used. After = creati…
Online NT and Online UNIX how to communicate?
OK sports fans here's a new one. We have Informix 7.X on various UNIX clients. Informix requires the use of hosts.equiv to authenticate for access. How do we get our NT engines to authenticate since they don't have hosts.equiv? -Mikey…
I-NET AND CA-UNICENTER
We have a client server application that establishes a connection to Informix database server on the HP-UX box using I-NET with WINSOCK DLL. It's bypassing CA-Unicenter's security system. Has anyone had this problem? Thanks…
Informix Certified Professional Program Update
Informix offers two certification paths. Each path requires the successful completion of two exams. Each exam is US $250 and is between 60-90 minutes long. * Database Specialist for INFORMIX-OnLine Dynamic Server 7.x 111 - Database Fundamentals Exam 112 - Managin…
Re: getting login name in 4GL
Nils.Myklebust@ccmail.telemax.no wrote: > > : Tim Schaefer <tschaefe@encore.com> wrote some stuff but deleted it so we could get to the point : > : Sometimes it's not just users, but investors and auditors we must satisfy. > > Yes, indeed. > > But have you ever come ac…
Re: getting login name in 4GL
: Tim Schaefer <tschaefe@encore.com> writes: : The original question of getting the : login id is perhaps ( in my little world at least ) involved with a : two-fold process: : : 1 - get the login from the OS ( for me most likely UNIX ) : 2 - get more info about a…
Re: ODBC and Security
> > Some suggestions have been made as to granting and revoking access to > tables and columns. How do you deal with the situation where the 3rd party > application provides security at the value level? That is to say that a > particular user can only see rows in this table of …
Re: ODBC and Security
Hi, > Ray Kaminski said: > Some suggestions have been made as to granting and revoking access to > tables and columns. How do you deal with the situation where the 3rd party > application provides security at the value level? That is to say that a > particular user can only se…
RE: ODBC and Security
I have seen a number of items here regarding ODBC and Security. I think the problem is larger than ODBC when you are talking about client/sever apps. If you place NewEra on a PC do you not have to place I-NET on the PC in order to access the remote database? If you place I-NET…
Tracing sqlturbos back to client connection
To simplify security maintenance on Unix in an environment that handles about 50 changes a week, we do all security checking on Novell and stop application access there. Then, all users come in under the same ID, using Power Builder queries. Using Informix, all their processes o…
Tracing sqlturbo processes back to client PC
To simplify security maintenance on Unix in an environment that handles about 50 changes a week, we do all security checking on Novell and stop application access there. Then, all users come in under the same ID, using Power Builder queries. Using Informix, all their processes o…
Security Issue - I-Net
When I-Net for Windows connects with OnLine, is the user id and password sent in an encrypted form and then decrypted on the server side or are they sent in a decrypted form? Our customer is looking for a little security and I got the bright idea that maybe the password is sent …
Re: INFORMIX-Online Dynamic Server intallation
copy the standard onconfig file and make as few changes as possible to the different parameters. after you are sure you can bring informix online, should you begin to make changes to the onconfig parameters. Use ONMONITOR to make the changes. It will protect you from many mista…
INFORMIX-Online Dynamic Server intallation
I'm about to install INFORMIX-Online Dynamic Server V.7.1 on a SPARC 1000. Has anyone installed this database on a sparc before? If yes...do you have any suggestions or could you give me any advice on certain aspects of the installation you felt might be important to take notice?…
Re: 5.0 and MultiProcessors
Greg asked: }From: KNBJ90A@prodigy.com (Gregory Moye) }Date: 22 Apr 1995 03:01:07 GMT }X-Informix-List-Id: <news.13278> } }I can't seem to get an answer I trust on this one: how do 5.x releases }of OnLine deal with MP's?? } }For example, if 4 people start a query on a four way M…
Informix and PB - security issue
To everyone, who works with Informix from PowerBuilder. We are running Informix 5.01 on DG machine. Using Informix's setnet utility we are able to define there modes of security: no password, password and ask password at run time. We would like to use third mode because we want …
Security issue on ODBC to Informix connectivity
In the recent debates about ODBC to Informix connectivity, I have not seen any discussion about security issues. Say for instance a user accesses a database table using a FourGen defined stored procedure that allows restricted operations. If the user were to leave that program a…
PRESS RELEASE: Informix Ships New Release of Secure Database
Informix Ships New Release of Secure Database Baltimore, MD, (September 20, 1993) Informix Software, Inc. (NASDAQ: IFMX) today announced the availability of INFORMIX-OnLine/Secure 5.0, a new version of its multilevel secure database server for secure UNIX platforms, and INFORM…
PRESS RELEASE: INFORMIX-ONLINE/SECURE FIRST B1, C2 RATED SECURE DATABASE
INFORMIX-ONLINE/SECURE FIRST B1, C2 RATED SECURE DATABASE OnLine/Secure Submitted to NCSC for B2 Security Evaluation Fort Meade, MD, (Sept. 14, 1993) Informix Software, Inc. (NASDAQ:IFMX) and the National Computer Security Center (NCSC), today announced that INFORMIX-OnLine/Se…