Oninit® Archive
Results for “S6_USE_REMOTE_SERVER_CFG”
Not enough room in ROOT DBspace
Reduce the size of your PHYSFILE. You probably moved it to another dbspace after setting up the first server. Start it smaller, then create the plog dbspace and move it there and resize. j. On 1/4/17 4:09 PM, STEVEN AB wrote: > Hi, > > I'm trying to setup a new server with the …
DRDA redirection to HDR primary
Andreas: Doug is correct. Using an sqlhosts group that includes both primary and secondary servers, a connection to the group name will preferentially connect to a primary over secondaries even if the secondaries are listed earlier in the group within the sqlhosts file. It has al…
Cannot connect to Informix database via Python
what is in your sqlhosts file ? On 5/5/2025 7:37 AM, Malcom Terry via IBM TechXchange Community wrote: 01000196a0e1356a-c9bb359d-2d22-42dc-b2c3-e548d7b5fa47-000000@email.amazonses.com"> I am trying to modify an existing Python script that has run in a custom…
HDR Issue
Remove the s=6 from the sqlhosts files, until you have verified the connectivity. Then, from your secondary server, see if you can connect to the primary server with that connection, e.g.: (On ifxdb2), run: dbaccess sysmaster@ol_ganga_prim Check any error messages and check the …
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 ------------------------------…
Is it possible to import the copy made with ontape from one database to another PC?
I believe even in 7.31 versions, a sqlhosts file was needed, independent of the platform. Informix is mostly dependent on some environment variables which point to the location of the informix base dir, the onconfig file (if deviating file name) and so on. Honestly, I never insta…
Informix HA Cluster and CM
Thanks so much David, that clears many of my questions. From what I have read on the CM, it only routes the connection request. It uses its local sqlhosts file to accommodate the connection or any sqlhost on the primary instance or HDR. The next question is. My current single i…
JDBC & TLS/SSL
Yes the SSLCONNECTION=true is required regardless of using the SQLHOST file. The driver looks to this parameter to setup the TLS to make the connection. It does not look at the SQLHOST protocols for this purpose. The point is valid that if the SQLHOST file has enough information…
DRDA w/SSL
Has anyone here had any luck getting a client connected to Informix using the IBM DRDA protocol over SSL? I opened a case on this some months ago and the DB2 and Informix sides of the fence just kept punting back and forth. Setting up a drsocssl listener on the engine side is sim…
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…
Connection MAnager error
For clarity since when reading it back to myself I realised I didn't explain this bit very well: "CLUSTER g_cluster" is just for the benefit of Connection Manager. "g_cluster" does not appear in sqlhosts. I mean that the value of the CLUSTER parameter does not appear in sqlhost…
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…
Re: 12.10.FC9 1809 Error
i'm just connecting on shared memory (onipcshm in sqlhosts) regards…
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…
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…
Connection Manager for HDR in Windows server
Thanks Mr.Art But still little confusion. On the host of each client application, create an sqlhosts file entry for each service-level agreement (SLA) in each Connection Manager configuration file. My SLA is sla_1, which is configured in the connection manager cmsm.cfg file. n…
OAT is not connecting to database server
Thank you all who are responding and very active in IIUG. Hello, I am able to connect to database server through OAT only while i mention the IP address instead of hostname in SQLHOSTS file. but whlie using the hostname in SQLHOSTS file it is not connecting to database server. …
Trusted Connection on Windows Environment
Hello All, How to establish trusted connection to implement HDR on Windows server. Please need in detail steps, since last 1 month im trying but no solution. SQLHOSTS, hosts files are placed in %INFORMIXDIR%\\\\etc Please any one help me…
Rebuid sysmaster database and effects in a HDR/RSS
Actually I created the hosts.equiv file on both servers contains the hostname and user of opposite server. But the connection is not establishing. I unable to connect through DBACCESS to other server. It is promoting for username and password. So i think trusted connection is no…
Error -956 Listener Thread
Hi, what is the best place to find information on error logs? Searches on the IBM website haven't been successful for me. Anyone know what this error is telling me? listener-thread: err = -956 =0; errstri=root@servername: Client host or user root@servername is not trusted by th…
HDR Implementaion
Please give the detail steps for trusted connection of hosts…
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…
IDS and keepalive
Hard to test since the client that is having issues comes from app server/odbc. Here's something interesting ... changed sqlhosts connection to: engine_soc onsoctcp box.here.com 1521 k=1 And now any remote connections to this entry is failing due to being untrusted? You've all…
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…
SQLEditor
I was using it a year ago as a developer, you will have problems if you have "modern" data types as bigint. squirrel wont let you cast unloads and loads, and is very slow. And of course the best thing sqleditor had was the "connect to 'afasf@asfasf';" feature to write scripts t…
Sqlhost entry on the client server
Original post: Hi All, I have two client server and one database server. In the database server sqlhost file defined as db1 onipcshm serverA sv db1.1 onsoctcp ServerA sv db2 onipcshm serverA sv1 db2.1 onsoctcp ServerA sv1 etc/services sv -750 sv1 -7002 Client A db1 onipcshm…
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…
Trusted Connection
Hi everyone, How do I create a synonym in a Server that runs informix 11.7 FC7 on HPUX itanium pointing to a table in a Linux distriubution with informix 11.7 FC7? It always gave me a password error. Thanks André Luiz Rufino…
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…
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.…
SQLHOSTS for HDR
I have never used group names in sqlhosts on the servers. I have used them in clients so they can connect to a group rather than an individual instance name.…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
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?…
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 …
sqlhosts file
On UNIX, the sqlhosts file contains connectivity information that is loaded from the default location in $INFORMIXDIR/etc/sqlhosts, when the database server is started. My problem is, the sqlhosts file gets changed after the server is started, and I do not know where or how I ca…
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.…
.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…
PERL trusted connection
Hi, Folks, [informix@stephanie ontape]$ onstat -version Program Name: onstat Build Version: 11.70.FC7 Build Number: N011 Build Host: hans Build OS: Linux 2.6.18-128.el5 Build Date: Tue Nov 27 21:54:02 CST 2012 Build Timestamp: 27-Nov-2012.21:30:00UTC-06 GLS Version: glslib-5.00.…
Re: How to connect Java/JDBC with Connection Manag
You will need the version of the Java jar which supports this syntax and you will need the sqlhost file on your windows server. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of O KHAN Sent: Monday, July 08, 2013 3:39 PM To: ids@iiu…
How to connect Java/JDBC with Connection Manager
I see one example with HDR pair group name in http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.do cnotes.doc/uc7/jdbc_docnotes_3.00.html we can connect to any group name in SQLHOSTS file the same way. Thanks…
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…
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…
connection redirection with HDR secondary
Hi, first thanks for the reply. my requirement is i have windows app server for .net web application so i need to redirect connection when the primary side down to secondary which should be automated. i'm trying to do this without doing any changes in sqlhosts file and onconfig …
Trusted JDBC Connections to IDS
Hi Forum, I understand that it is possible to configure IDS to trust DB connections from particular hosts, so that a password is not required. In the past I have done this with 4GL and dbaccess client connections to remote linux servers, by specifying the client host names in t…
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…
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,…
Same server name on the same host
Am Dienstag, 13. November 2012 11:58:41 UTC+1 schrieb joe: > Version : ids 9.4 > > Can I set up 2 instance which has the same server name ? > > What if I set 2 different SQLHOSTS files ? You can as long as INFORMIXSERVER is a tcp connection and of course use INFORMIXSQLHOSTS to …
S6_USE_REMOTE_SERVER_CFG
I'm working with a brand new 11.7 IDS install (server and client updated with W1 update). On the server side, if I create the hosts.equiv to allow the client access in $INFORMIXDIR/etc/hosts.equiv the remove access does not work (Error 956 on the server-side). If I put the file i…
sqlhosts setup enterprise replicatiion window - un
IBM Informix Dynamic Server Version 11.50.FC9DE Software Serial Number AAA#B000000 windows V 6.1 Build 7601 service pack1 IBM Informix Dynamic Server Version 11.50.FC6 HP-UX wuasp132 B.11.23 U 9000/800 sqlhosts setup enterprise replication window - UNIX Does anyone know if you…
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 …
HDR not working
Thanks for input Looks like trusted connections are the problem. Working on solution. Rgds Derrick Muller…
HDR-Connectivity issue
try to test your connection first from primary to secondary server dbaccess> databases > connect. If you cannot, check the setup, sqlhosts and authentication. If you can connect to the secondary server,you can setup by onmode -d primary <secondary server>…
Enterprise Replication Problem
Hi! The sqlhosts-file and the ports are ok. A connect via dbaccess is possible between all servers. The replication is partially working, here in my example between testserver B and C. Only one way of replication is not working. The problem must be located on an other position. …
Implementing Pluggable Auth Module for dbaccess
Why do you need this? Do you need to have trusted connections to the database? If not, just disable trusted connections in SQLHOSTS options field and voila... all your connections will require a password. Regards On Wed, Oct 5, 2011 at 10:59 PM, ANEES AHMAD <aanees@i2cinc.com> …
Inter-Server Permissions
> 'Client host or user (xxx@yyy) is not trusted by the server.' Who created the view? maybe that user is not trusted??? Superboer. On 27 sep, 18:44, Keith Simmons <smile...@gmail.com> wrote: > Here's strange one !! > IDS10 on Solaris 8 and IDS9.4 on AIX 5.3 (I know all abou…
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.…
dbserver name "group" doesn't connect from Windows
From Unix /Linux: dbaccess database@database_group .... That works. From Windows: (Get -25555, saying it isn't in sqlhosts file... But the group is in the registry sqlhosts file.) ilogin and testing odbc connection to database server group ... Does not work. Unix sqlhost file…
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…
-648 error opening DEBUG file
This will be a long post, as I am trying to get all of the relevant information in the first posting. I have a problem in an old environment. This is Informix 7.30.UC7, running on HP-UX 10.20. Yes, I know, neither of these are supported by their respective vendors anymore, but t…
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
The problem with trusted contexts occurs when: (A) The program uses CONNECT and WITH CONCURRENT CONNECTIONS, and (B) Was compiled with CSDK 3.50 or earlier, and (C) Is run against CSDK 3.70.xC1 Iibraries. This is a bug, and an awkward one. There are two immediate workarounds a…
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…
RE: IDS 11.70
Hi, Just wanted to mention this. I had the same problem after upgrade to 11.70.UC1 from 11.50.UC7. listener-thread: err = -28021: oserr = 0: errstr = : A trusted connection was not established because a trusted context is not defined or enabled for the specified authorization I…
IDS 11.70
Hello friends, in IDS 11.70 i get the following error message after CONNECT: -------------------------------------------------------------------------------- ---------------------------------- >>> import informixdb >>> c = informixdb.connect('forenstat') Traceback (most recent …
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…
HDR says my secondary is not trusted
I need a little help i am trying to setup a second server for HDR. The two servers are identical. and in the same DOMAIN. They are Windows 2003 R2 64Bit with IDS 11.50 FC7 Entp. I was able to set the primary with onmode -d and do the restore with a backup of serv1 to serv2. The o…
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…
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 …
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…
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: Connection manager redirect
Hi Madison, and how we work around this problem, because in a real situation when we have remote clients connecting throw the connection manager, the information that receive the client about the way to connect directly to the IDS server is the same that the server has at the sql…
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 …
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…
IDS connectivity with Client running INFORMIX STAR
Informix NET Version is 5.01 - UD3 We could nt find any file like sqlhosts in 5.01 version. Can we install some other informix utilities on top of 5.01, so that we can establish connection between IDS 11.0 and Informix 5.01…
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…
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…
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…
How I can to change status from SDS secondary to Primary.
rootdbs@gmail.com wrote: >> Question --- why is it necessary to revert the server status? You are >> using the connection manager, so you could configure an SLA to point to >> the current primary. > > I don�t think about it. > But I think that not only SLA need configure. Sqlh…
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…
Trusted Conection
Try with this checklist: - Verify if in the remote host, you have the tcp alias defined in your sqlhosts file. - With dbaccess, try the option 'Connect'. With this option, you use the user/password for the conection. If don't work, something in your configuration is incorrect. …
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…
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…
JDBC Connection
CHRIS JENKINS wrote: > I'm trying to connect to an Informix DB V7, using the jdbc driver. > The connection string I'n using is; > > jdbc:informix-sqli://<HOST>:<PORT>/<DB>:INFORMIXSERVER=<SERVER_NAME> > > I'm not sure the info I'm being given is correct. > I can ping the host. > …
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…
windows-1252?Q52=45=3A=49=6E=66=6F=72=6D=69=78=20=
Yes, that should work. Informix verifies users using the OS' login facilities, so if a remote user has a valid login that the server machine recognizes and can otherwise remotely access the server machine, IDS will permit the connection. In networking there is the concept of a '…
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…
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=(…
Informix Installation Crashed
shahid.mehmood schrieb: > When trying to install IDS 7.3 on SCO Openserver Release 5, I am getting > following error continuously ... can any body help where should I do??? > > In fact the "Setup" hangs, when "Launching sysmaster database ...", and > then it crashes. > > Early re…
Re: Attempt to connect to database server (mydbSer
On 1/17/07, ART KAGEL, BLOOMBERG/ 731 LEXIN <kagel@bloomberg.net> wrote: > That's very odd. I've never had to add a shared memory port to /etc/services. > indeed the manual says: > > Because this is a shared-memory connection, no entries in network > configuration files are requi…
Onspaces freezes!
Marcus, I have disabled my firewall, but when i do telnet <MyserverIP> <MyportNum> i get the following error : "Unable to connect to remote host: Connection refused" Yes, my_srv is in the client services file with the same name. By the way how can i use numerics service numbe…
Re: ISQL install problem
andrew.burridge@gmail.com wrote: > Hi, > > It's pretty much everything regarding isql that isn't working... > > When I go to query language, it attempts to connect to the server to > find a list of databases, but fails with the error: > > "908: Attempt to connect to the database …
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…
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…
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 -----------------------------------------------…
Re: unixODBC connection to Informix db - user informix not trusted byserver
> > If you will see "Password:" prompt, add your machine in $HOME/.rhosts. > > Then try again. > But it is on the same machine! I'm not logging in from a remote > machine. So, it is still an IP connection.…
unixODBC connection to Informix db - user informix not trusted by server
I get the following error [informix@kylie bin]$ ./isql -v pic2 [S1000][unixODBC][Informix][Informix ODBC Driver][Informix]Client host or user informix@localhost.localdomain is not trusted by the server. [ISQL]ERROR: Could not SQLConnect [informix@kylie bin]$ I am logged on as …
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: Are selects accross DB instances possible?
It is a valid request. You make be able to connect to either instance but try dbaccess testdb@TESTDB_1_NET choose Query->New and enter database testdb@TESTDB_2_NET . When you do this instance TESTDB_1_NET makes a connection on your behalf to instance TESTDB_2_NET. Does the sq…
Re: Cannot create/access database on NFS mount.
Yes, sqlhosts is reconfigured per http://www.iiug.org/resources/linux/linux_faq/english/iolfaq-5.html#s1_remote_conn. I'm trying to open an ODBC connection from a Windows XP SP2 machine to an IBM AIX/Informix machine.…
Cannot create/access database on NFS mount.
Help! I've read every post on this board, and looked over a number of documents. sqlhosts is reconfigured and running, listening on 1536. What am I doing wrong? (Connecting from XP SP2, using both IBM's ODBC and OpenLinks, same result, to AIX 4.x.)…
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: 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.…
Re: Select from 2 Servers
"Omar Mu�oz Perez" <omunoz@segurosatlas.com.mx> schrieb: > From Server#2 it would be: > >select * >from Server#1@xx1:abc > > I'm supposing that Server#1 and Server#2 are informix-server names >as defined at first field in sqlhosts file. There is one additional…
Re: Hi group
unbelieveable! the problem was that the name fedora1 in sqlhosts file (and also in /etc/hosts) was the same as localhost. I changed fedora1 with fedora1-ifx (added an entry in /etc/hosts and changed the hostname in sqlhosts) and it worked! Thanks a lot Cliff, thanks to you all …
Re: Hi group
HI Kostas. Still you got the -908 error, tyr the following. Add + /etc/hosts.equiv on SERVER. ie) % cat /etc/hosts.equiv + Regards. -- Tsutomu Ogiwara from Tokyo Japan. >From: "Kostas Vasilikiotis" <k.vassilikiotis@mfd.gr> >Reply-To: "Kostas Vasilikiotis" <k.vassilikiotis@mfd…
Re: configuring sqlexecd for remote tcp connections.. problems :(
I ended up getting everything working. It was a combination of: for connecting from the local server with dbaccess: 1. setting the DBPATH=//database_connection_name/path/to/db I also had to set 1. on the client plus the following: 2. changing the sqlhosts from onsoctcp to se…
Hi group
thanks for answering, I did what you suggested : 1. ping fedora1 from the client and it answered 2. dbaccess from the server (after setting INFORMIXSERVER=demo_on_tcp) and it was worked 3. yes. the services file and sqlhosts file are the ones you mentioned with the difference t…
-956 client not trusted error with IDS 10.0 on Windows
Have installed IDS 10.0 on Windows XP. From the local host (that IDS 10.0 is installed on) I can connect to the stores7 sample database using dbaccess and Ilogin executable. When I attempt to connect locally to IDS 10.0 using the esql demo1.ec example program, receive the error …
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…
Client host or user is not trusted by the server
Hello Does anybody knows why when I try to connect from a database from a certain Host to a database from another host via DBlink it appears the following message: Error: Client host or user (informix@9fc74fb2) is not trusted by the server. (State:S1000, Native Code: FFFFFC44) …
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: 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:…
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…
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…
Windows client via ODBC host or user is not trusted by the server
I am trying to connect a Windows XP user (odbc) to a 9.4 UNIX server. The online.log is complaining about "Client host or user (odbc@x.x.x.x) is not trusted by the server. No other windows user is getting this error. I tried placing that user and ip in /etchosts and hosts.equiv …
RE: test
Sebastian, Norma J. wrote: > > I guess I have failed the geek test.... Maybe I better have you > guys do my homework ;) The delay can be ten minutes sometimes, and sometimes worse, but not too often. Also, some news servers are not very well connected or timely, so until you…
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…
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…
Re: PEMEX - CDR WITH NAT
CDR uses the CDRID to replicate, not the IP address. The CDRID is the 'i=3D' field in the sqlhosts options column. As long as you make sure that your sqlhost files have the proper mapping, then changing the network, the ip address, and/or the port numbers should not impact CDR. …
how can I make a conection to informix
first create an entry in sqlhosts or modify. $INFORMIXDIR/etc/sqlhosts os whereever INFORMIXSQLHOSTS points to myserver sesoctcp <yourhostname> <someserverice or 1533> #----------^^^^^^^^ or setlitcp check rel notes. if you use someserverice add someserverice to …
Error accessing IDS 9.4 on Windows
dlgllhn@inhisstepssoftware.com wrote: > I have finally gotten the trial version of IDS 9.4 running. I can > access the stores database using ODBC and Delphi. But when I transfer > the test Delphi Application to another PC and try to access it I get > "Client host or user is not…
Informix Connect w/ODBC on Remote-Host with SAS
may be your odbc connection uses a different sqlhosts file pointed to by $INFORMIXSQLHOSTS; you could try to use truss eq truss <your odbctestprogram> > afile 2>&1 look for something which looks like sqlhosts check that file for the existance of the relaint dbservers, Superbo…
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…
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…
JDBC reading from SQLHOST file
It seems JDBC applications can make connections to the database without a SQLHOST file by specifying everything in the database URL. However JDBC manual also mentioned SQLH_TYPE=file and SQLH_FILE being the SQLHOST file. What is the format of this SQLHOST file. Is it the standar…
Connect to remote server
Dear All, I am trying to connect to a remote server in another city. I have made an entry of the server in sqlhosts file at my place. I can connect to the server through winsql. I need to find out the difference in database at my end & the remote server. Do i need to make an ent…
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…
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.…
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. …
Define replication server problem
Hi, All. I want set up "primary-target" replication between two servers. I setup host files, sevices file, trusted environment and sqlhost files on both systems. I test trusted environment by dbaccess. Connection by server names and group names without prompting logins and passwo…
IfxSQL
I downloaded the IBM Client SDK and installed it. Its basically IBM's ODBC driver. I cannot connect using it. So IfxSQL does not work. My protocol in the sqlhosts file is "ontlitcp" and that does not show up in the protocol combo box on the IBM DSN setup. None of the others seem…
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…
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…
native connection to 2nd network card
We currently have our sqlhosts file setup to allow connection for one port on ip address aaa.aa.aa.aaaa through odbc or native connection. I want to add another network card on the same server to the sqlhosts file so that we can connect to that ip address of bbb.bb.bb.bbbb as wel…
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…
sqlhosts on W2k
Hi all, I have got define the group on the UNIX server : #sqlhosts on UNIX g_repl1 group - - i=1,e=tranzit tranzit ontlitcp tranzit online g=g_repl1 How do I define this group on W2k in registry? I have got this in the registry, but this isn't functional: [HKEY_LOCAL_MACHIN…
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…
[Help] Connect to informix without a password...
Make sure the client machines are not trusted on the server or in the users' .rhosts files on the server. Then the user will be required to connect with a login name and password. Art S. Kagel Sangho Cho wrote: > > Hi. > > I am using Informix 7.2 on IBM AIX Machine. > After So…
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…
Help please (reposted)
Hi all. We try to configure an IDS 9.21 FC2 on Solaris 7 with HDR. The clients though are 32-bits, so we were told to use TCP connections, not shared memory. For the previous version used (7.30), we were using shared memory, and our sqlhosts on one of the servers looks like: …
protocol
I notice that our informix server has the sqlhosts set to ONSOCTCP and that the windows connect is set to OLSOCTCP shouldn't these be the same? What is the difference between the two?…
Help needed: sqlhosts basics
Hi all. We try to configure an IDS 9.21 FC2 on Solaris 7 with HDR. The clients though are 32-bits, so we were told to use TCP connections, not shared memory. For the previous version used (7.30), we were using shared memory, and our sqlhosts on one of the servers looks like: …
Can't connect to remote DB
I'm trying to connect a SCO (OpenServer 5) box running 7.31 to a Sun box running 7.31 on Solaris 7. The Sun box is new. I have a DB installed on the SUN box, but when I connect remotely I keep receiving a 908 error. Local connects are fine. I added the Sun box (emco5) to SCO'…
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 …
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
PHP Informix connect Question, or wtf is /opt/informix/etc/sqlhosts?
Hi all, I've managed to install the Informix SDK on a RH 6.2 linux box, and get PHP compiled to support it. However, when I try to connect to an Informix database on a remote server (AIX 4.2.1, with an old version of informix online 5.02), I get an error which translates to "in…
Connecting to Remote NT Database Server
I am trying to connect to a NT database server from a Sun Unix machine. I am receiving the following error message: EXCEPTION 1: SQLSTATE=IX000 MESSAGE TEXT: Client host or user %s is not trusted by the server. Can anyone tell me how to resolve this problem? Thank you, Andy…
HDR: Error -956 on WindowsNT
Hello, we are trying to set up HDR with Informix 7.31 using the Administrator's guide. Everything is ok until the secondary server shall connect to the primary server using the onmode command. The connection fails and error -956 (Client host or user not trusted by server) is sho…
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…
908 connect error with Linux
I am getting a 908 connect error when I try to connect to a Linux box using IIF2000 either with I-connect from a PC or dbaccess from my SCO unix. I can ping from all directions with no errors and I can use dbaccess to connect to the Unix box from IIF2000 with no errors but not t…
Limit database connections
Is there a way to limit the number of connections to the Informix database? I know Informix works on the trust system as far as the number of licenses, but I would like to limit it on my end. I am running IDS 7.3.1 UC2A on a RS/6000 AIX 4.2.1 Any ideas would be helpful. Thank …
Limit database connections
Is there a way to limit the number of connections to the Informix database? I know Informix works on the trust system as far as the number of licenses, but I would like to limit it on my end. I am running IDS 7.3.1 UC2A on a RS/6000 AIX 4.2.1 Any ideas would be helpful. Thank …
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…
Re: Puzzled: connect
Norbert.Heidbrink@home.of.the.brave.de wrote: > Sorry, folks, for a basic question, but at the moment I am absolutely > puzzled and do not see anything. > > Scenario: > SERVER is a Linux machine. > There is IDS running von Computer SERVER. > On Computer SERVER there is a user "d…
Re: Puzzled: connect
Norbert.Heidbrink@home.of.the.brave.de wrote: > > Sorry, folks, for a basic question, but at the moment I am absolutely > puzzled and do not see anything. > > Scenario: > SERVER is a Linux machine. > There is IDS running von Computer SERVER. > On Computer SERVER there is a user "…
RE: Puzzled: connect
Two words "trusted hosts" -----Original Message----- From: Norbert.Heidbrink@home.of.the.brave.de [mailto:Norbert.Heidbrink@home.of.the.brave.de] Sent: Wednesday, July 12, 2000 6:24 AM To: informix-list@iiug.org Subject: Puzzled: connect Sorry, folks, for a basic question, but …
Puzzled: connect
Sorry, folks, for a basic question, but at the moment I am absolutely puzzled and do not see anything. Scenario: SERVER is a Linux machine. There is IDS running von Computer SERVER. On Computer SERVER there is a user "databaseowner" who has got access to certain databases, table…
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?…
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…
Re: no remote access with dbaccess
Norbert.Heidbrink@home.of.the.brave.de wrote: > Hello! > > I am trying to connect remotely to an Informix Server but I do not make > it. > ... Try changing your Client's sqlhosts to use the actual IP address & Service. e.g sun onsoctcp 93.105.200.15 5432 Rudy…
Re: no remote access with dbaccess
Hello! > Are the machines trusted by each other? /etc/hosts.equiv No, they are not. Do they need to be when I try to connect using a username and password? (Of course, the user does exist on the server machine as well.) > Can you ping? I can. > Can you telnet from the client t…
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…
Network driver cannot bind a name to the port.
Ben Wilde wrote: > Hi, > > Just having a quick look at your services file and sqlhosts... > > cert_db is the service you are trying to connect to (in SQLHOSTS) but in > your services file "cert_db" is listed as being "service used by Phone List" > where as for "ifmx_srvc" the co…
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…
Shadow passwords and IDS
I believe it is scheduled to be fixed in the 9.21 release due out in a few weeks and a 7.31 interrum release also due soon. The result of this 'bug' is that you can connect from a trusted host without a password if you have valid login on the server but you cannot connect, even …
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…
Informix Client on Solaris 8
In article <39194595.CDDBE442@mail.ru>, maratkotik@mail.ru wrote: > Have you checked /etc/services, $INFORMIXDIR/etc/sqlhosts, $INFORMIXSERVER and $INFORMIXDIR/etc/sqlhosts are the same as on the (working) Solaris 2.6 clients. We've never modified /etc/services on any client-m…
RE: Query on SQLHOSTS
You could also add the service to the /etc/services file on server A. This is needed to resolve the service name listed in the sqlhosts file to a known port number. Srinivas Sreekumar wrote: > Thanks for the reply. > My problem was solved. In SQLHOSTS file instead of giving th…
dbping TCP/IP connection fail
Dear there, Have the following problem happen to you? It seems difficult. I've setup the ODBC via driver informix v3.30 32 bit in my pc. Then use 'dbping' to test connection and it show out: connection failed It said the passward is wrong, but the passward I key-in is correct.…
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…
NETTYPE and sqlhosts workings
The facts: IDS 7.31.UC2 on HP K260 w/ HP-UX 10.20 If I have the following in my $ONCONFIG: NETTYPE ipcshm,2,75,CPU NETTYPE soctcp,2,75,NET But only have the following in my sqlhosts file: ndrmain onsoctcp ndrmain sqlexec Does this mean …
-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…
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…
Informix Client SDK on Solaris 2.7
I am attempting to connect to an Informix server running on an HP-UX machine from a Sun Solaris box. I installed the Client SDK 2.40 on the Sun box and I am not able to connect. I get the following error from a simple esqlc program: Error -25574 while connecting to the database:…
Connect Error 25507
I am attempting to connect from a Sun Solaris machine to an Informix database server which is running on an HP-UX machine. When my esqlc program attempts to connect to the database server, I get the following error: Error 25507 while connecting to the database: The specified se…
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…
connection 25507 error
I've got informix installed on an aix box. I'm trying to connect to it via the client sdk installed on a solaris 2.5 box, but I'm getting error 25507. My sqlhosts on the client has the entry: INF2 onsoctcp tirade 1536 I've tried the ip, the full domain name, and just the…
Informix denying access
I'm using Informix ODS 7.30 UC2 on Solaris and running client application on the same host as Informix server. The client application uses loopback TCP connection for Informix server. Informix SQLHOSTS file (/usr/informix/etc/sqlhosts): server_name ontlitcp localhost service…
Error 25591 on INFORNIX SE 7.24 ( Linux )
Hello Please help me asap. I install informix-se 7.24 on Linux RedHat 6.0 In $INFORMIXDIR/etc/sqlhosts I wrote: demo_se seipcpip new sqlexec In /etc/setveces : sqlexec 1527/tcp INFORMIXDIR, INFORMIXSERVER, PATH are set. Dbaccessdemo7 returned: 25591…
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…
se 7.24 uc5 with redhat 6.1
i. cant connect to my database server either from dbaccess or informix cli from windows i receive the error -952 user's password is not correct for the database server the configuration in sqlhosts in correct, any idea Thanks Ruben…
err = -956 Client host or user is not trusted by the server
Hello all ! I use Informix-SE for Windows-95. When I connect to the server using seipcpip service - its OK. But if I want connect by sesoctcp service - I receive message err = -956: Client host or user is not trusted by the server. Thanks for help. Victor Vat vavic@chat.ru…
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…
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…
RE: -25507 error - ilogin tool?
Is there any tool in Unix that is similar to the ilogin tool in Windows for testing connections? Thanks, Dianne -----Original Message----- From: dianne.pendleton@autodesk.com [mailto:dianne.pendleton@autodesk.com] Sent: November 01,1999 3:22 PM To: informix-list@iiug.org Subjec…
-25507 error
We have a Sun server, Solaris 2.6 on which I installed CLIENT SDK 2.x. The database that we want to connect to is on another server, HP-UX 10.20 running IDS 7.31.UC4. We modified the sqlhosts file and /etc/services on the Sun server. Informatica is the application which is runnin…
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…
ESQLC/CGI/Security question...
Hello all, I am trying to run an CGI application across the network. I have set the client as a trusted host and so there is no problem connecting to the DB on the server when I login as Informix or any other login on the client machine -the trusted host feature takes care of th…
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.…
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…
Multiplexed connection
Hi, I am trying to use multiplexed connection to connect between 2 machine. Server is AIX4.3.2 with IDS 7.31 UC2. Client is ESQL/C 7.24 application on AIX4.2, IDS 7.22. I have configured server for multiplexed connection like it says in manuals, but when I connect with 25 users…
error 951
Austin Castro wrote: > > Hi guys, > When trying to connect to a network server from a client, I get an > error 951. any ideas would help. I'm sure that the user name i'm using is > correct, and I can access the server and database without any problems from > the console t…
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…
More details
Eric Shipek wrote: > > Sorry, I can log into the server -- I just can't log into the database. In > fact I can log into the Unix server with the informix login and password. > Then I run dbaccess and try to connect to the database ol_nisbc. Then when > I try to connect with the…
ilogin demo setnet32, can not connect, please help
I am trying to connect to out AIX online 7.24 tries to fill as much info from sqlhosts file, just cant do it, I get 908 error message, What I am doing wrong, is there an example that I can use. Thanks for the replay.…
Re: client troubles
Do you mean $INFORMIXDIR/etc/sqlhosts ? Have you tried adding the host entries in /etc/hosts.equiv or $HOME/.rhosts ? Best Regards, Octav Peter Sloboda wrote: > > Anyone an idea about error : > 956: Client host or user <user@host> is not trusted by the server. ??? > > I try …
client troubles
Anyone an idea about error : 956: Client host or user <user@host> is not trusted by the server. ??? I try to connect from a perl script to the server and I'm logged as DBA. I edited /etc/sqlhosts about ten times and a couple of others in /etc too. It' s 7.20 on Solaris. Tha…
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…
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…
GLS connectivity question
I recently recieved 7.31.UC2 with the GLS int'l language supplement and setup my instance. I can easily connect to it from a remote server running version 5.04 by adding an entry to the sqlhosts file. If I try to connect from a remote server running 7.24 I get error: 23101: U…
Connecting to SE 4.1 on SG IRIX 5.3
sorry, if this is a FAQ, but I am new to this group and I could not find any appropriate answer. We are running on the PC side NT 4 and VB 6.0 with ODBC. On the same net there is a trusted old Iris running IRIX 5.3 and Informix 4 SE. Any chance to connect these two, and if so w…
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…
RE: Remote Connections
Cardwell Lori B wrote: > > The hosts file at both sites are in lower case. > > Questions: > > Server1 is connecting to Server2 using "dbaccess db1@server2". > > 1) When the connection is made, was the IP of server1 sent, or the hostname > that is listed in the sqlhosts file on S…
About INFORMIX-Connect
ita wrote: > > Tell my, please, how must I configure Informix_Connect(on Linux) > for connect to IDS on another host and how I can check connection. You just basically have to create an sqlhosts file which has the remote server's onsoctcp entry, enter the remote host in /etc/ho…
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…
Example sqlhosts file
Thanks for the reply - I'm just trying to set up a local connection- NON-tcp, using unamed pipes, but I get an error msg - 25591: Transport control received an invalid connection address My sqlhosts file: local_se seipcpip local_hostname sqlexec any thoughts? -rick Art S. …
informix IDS on Linux and ODBC access from Client SDK
I have configured the NETTYPE onsoctcp,1,50,NET on the onconfig - file and the sqlhosts file to: oopen_odbc onsoctcp oopen sqlturbo the sqlturbo service is in the services - file. I do not get a connection to the database. The setnet -error on windows side is -908 (c…
Connection to SE database
Aaron Shilts wrote: > > Informix Standard Edition issue: > > We're attempting to use I-Connect or ODBC to connect to an Informix server > running on a Digital Unix box. The Unix machine has three physical > interfaces. Two are utilizing internal IP addresses (not pingable) and t…
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…
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…
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.…
Re: Establish Informix network listener...
T. Saunders wrote: > > Hello all. I am currently having difficulty reconfiguring my lab's > Informix database to support network connections. We are running Informix > Universal Server 9.12.UC2X21 on a Solaris 2.6 platform. I can, using the > old onconfig and sqlhosts files, b…
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 to INFORMIX connection
Hi folks, We are using Informix DS 7.23 on Windows NT 4.0 Boxes. We have several Database servers. The problem is; I am tring to select data from one database server (e.g: server2) while connected to another one (e.g: server1) via SQL. Such as; suppose we are connected to db1@…
Error 25506
I am new to this listserve, so I apologize if this has been asked before. I am trying to connect to Informix5.03 from a Windows95 pc using odbc. I installed Client SDK from Intraware. The sqlhosts file and /etc/services on the server are setup correct. The sqlexecd daemon is …
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.…
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: 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…
Re: Problem getting a connection with Informix's JDBC class
Hi; You must update your etc/services and sqlhosts; write a service name and a port number for it. > <$INFORMIXDIR/etc/sqlhosts> museo onsoctcp myhost muse_tcp # tcp connection > </etc/services> muse_tcp 1099/tcp # service name and port number you use in t…
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 …
Re: 908 can't connect to database
Steve Macmillan wrote: > > On our test network we have an NT 4 web server running Informix 7.23 > and a SCO box (5.04) running a unix version. I can telnet into the SCO > box...connect to it's database. I can telnet directly into the server > and connect to it's database. But if …
Re: INFORMIX x DELPHI
Thanks. And now? How can I do the first solution? I have user@client_machine != user@server_machine Haw can I do the client_machine be trusted by the server_machine At 15:17 27/07/98 +0200, you wrote: >Hi, > >You get this message when yoy tried to make a connection >to the da…
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…
Newbie question: Informix SE on Linux
I just installed Informix SE on Redhat Linux 5.1, and created the $INFORMIXDIR/etc/sqlhosts file that contains one entry: demo_se seipcpip localhost sqlexec I set $INFORMIXSERVER to demo_se, and ran the dbaccessdemo7 program according to the manual, but got the err…
Re: INFORMIX x DELPHI
Hi, You get this message when yoy tried to make a connection to the database without specifying a password for the user , while the client machine isnt trusted by the server machine. If you dont like the option of making the client machine trusted, you can specify the users pas…
INFORMIX x DELPHI
Is there anybody using Informix DS 7.23 on AIX 4 and DELPHI? The connection error is -956: Client host or user (valid_user@xxx.xxx.xxx.xxx.xx) is not trusted by the server. The problem is: the valid_user is valid but not the @xxx.xxx.xxx.xxx.xx. The solution that Inrformix Find…
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 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…
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: oninit -i Problem Err -956
Hi to all! My problem is solved! The thing which was wrong was simple: My DB had only a onsoctcp connection. After i've changed this to onipcshm everything went well. The conclusion out of this is that a new DB doesn't trust anyone, even the DBA informix! --> Is this a bug or…
Online 7.22 Aix/Cli Nt Problem
Hello, we have got an Online 7.22 System installed and running "perfectly" (as far as we can see) under Aix 4.01. Now we want to connect Delphi 3.0 CS (under NT 4.0) with this system. We did everything as the manuals told us. But now there appears everytime we try to get a conne…
Problem with connection PC to INFORMIX ONLINE 7.22
I have problem with connection PC (WIN95) to INFORMIX ONLINE server 7.22. On my PC I have instaled Informix Connect software as a Informix client and I traying to connect to INFORMIX ONLINE 7.22 server on SCO Unix - there is no efect. I configured every needing file on my PC ( C:…
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: +…
user not trusted
Hi all, We have just changed the ip address on our test machine and know Informix gives user or host not trusted. I have reviewed the host.equiv and .rhosts files and they are correct. We are running online 7.2 on SCO 5.0. I am trying to use a nettype of ontlitcp. If I change th…
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…
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: 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…
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…
956 on Unix Client to NT Server
I seem to recall seeing an answer to this, not too long ago, but...... I have OWS installed on NT server. I am attempting to connect from a UNIX client application (ie. dbaccess), and receive -956 errors. Now I know how to deal with this in the UNIX world, but as for NT ?? We d…
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)
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…
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…
930 Error - Trying to connect win95 client to Informix 5.02
I'm trying to connect a windows 95 client to a RS6000 (Unix) system. I configured the sqlhosts file, services files on both systems and I keep getting the 930 error when I try to run ilogon. Does anyone have the correct procedure for setting this up?…
Trusted System on HP-UX 10.20
All, I upgraded our HP H50 from HP-UP 9.04 to 10.20. Along with that I went from On-line 5.01 to 5.08. We are also using Inet 5.08.ud1. The upgrade went ok and it all works as advertised but when I converted to a trusted system then clients could no longer connect as the pass…
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…
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: Can ping, but can't connect.
> you may check out sqlhosts file in etc directory to see if the protocol > is correct, or some hidden file ( I cant remember correctly) related to > trusted client connection. It should be resident in $INFORMIXDIR, and > I encountered this kind of error accidently even no para c…
Re: Opinions Welcom on One Security Problem
Igor I. Lisyansky wrote: > > Hello All! > > 1) Can systems based on emulation of trusted connections in a very heterogeneous environment be considered > reasonably secure for corporate use? Simple answer: NO > 2) Is it safe to create a special hidden login for the Web server,…
Opinions Welcom on One Security Problem
Hello All! I bring my apologies in advance since this problem is somewhat common, but, IMHO, it's significant for the developer working with any particular DBMS server. Some of the database applications get designed to work in Intranets of mixed nature, where conventional front-…
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: Secure Environment - Kerberos
Michael Segel wrote: > snip... > > Second, what does rsh have to do with your databases talking to one > another? Nothing directly, but you need the same type of trust setup (hosts.equiv, .rhosts etc.) as you do for rsh so maybe he means that these are disabled. > Usually, usin…
Re: Informix OnLine 7.2 for Windows NT Problems...
Primarily, it requires trusted status between the hosts (/etc/hosts.equiv or ~/.rhosts), for the most part. Using explicit connect with user and password shouldn't, but otherwise it does. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> }From: "Billy Wheele…
Informix sqlhosts and LiveWire connection
Do anyone know what's wrong here? I have an entry in the sqlhosts file with a g=xxx option(used for replication?). Trouble is that LiveWire reports this error during connect: [VENDORLIB] Vendor Library Error: Illegal sqlhosts file option/parameter Removing the g=xxx option wou…
Re: trusted connection
Dirk Schmidtpott <schmidtpott.pad@sni.de> wrote: :B. Liu wrote: :> :> How to set up trusted connection for Informix Online for NT server? :> Basically, I want to do is using SQL*editor on my Win95 machine to access :> Informix server on NT server. :> :> TIA : :Hi ! : :The proble…
Re: trusted connection
B. Liu wrote: > > How to set up trusted connection for Informix Online for NT server? > Basically, I want to do is using SQL*editor on my Win95 machine to access > Informix server on NT server. > > TIA Hi ! The problem is that there is no real client application for Informix on…
trusted connection
How to set up trusted connection for Informix Online for NT server? Basically, I want to do is using SQL*editor on my Win95 machine to access Informix server on NT server. TIA…
Re: Delphi 2.01 and Informix 7.x
Here are a few suggestions to check: 1. Read your release notes to see if your server supports streams, TCP/IP, etc. 2. Go into your sqlhosts file on the server to make certain that you have a remote connection defined. (See Admin. Guide 1 for NETTYPE, services, and host definit…
Anyone Using Security Option under SQLHOSTS?
Hi, I would like to know if anyone has used the security option feature under sqlhosts where you can specify r=x for client settings and s=x for server settings. This feature is available starting in 7.1 and allows you to disable or enable(default) the /etc/hosts.equiv and the ~…
Delphi 2.01 and Informix 7.x
Hi all. I'am trying to connect to Informix 7.2 on Unix. I first got an error saying that I am missing a couple of ddl's. I received them from Informix Corp. Now when I try to connect, delphi tells me that "INFORMIXSERVER is not defined in the sqlhosts file". Any help Thank …
Informix & DNS...HELP!!
Thanks in advanced for anyone able to help me. I have and existing database installed and I am trying to load the DNS named on this server. When I move the /etc/reolve.conf in place, I start to get CONNECT errors saying the database does not trust the server. I have edited the …
Re: Shared memory connections
>>The purpose of the alias is to allow the same server to have different types of >>connections. If you only need shared memory connections you only need one line >>in the sqlhosts file per server. > >True. And I also have a need for network connections, and have a line for tha…
Re: Informix On-Line error: "not trusted by server"
Hi, The 956 error usually indicates that the connecting machine is not known as a trusted machine by the server. The quickest way to fix this is to create an entry in a file named .rhosts file in your home directory on the server. In this file make an entry of the following form…
-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…
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…
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: 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: Connecting From Client to Server in Online
In <D5LAEx.C74@shakti.ncst.ernet.in> mastek1@shakti.ncst.ernet.in (Mastek Limited) writes: >$INFORMIXDIR/etc/sqlhosts on Server is as follows >testing ontlitcp Client telnet ^^^^^^ According to this entry, the connection is using…
Connecting From Client to Server in Online
We are working in Online 6.0. Had a tough time connecting from one Unix Client to the other Unix Server. $INFORMIXDIR/etc/sqlhosts on Client I hope need not be the same as of on the server. $INFORMIXDIR/etc/sqlhosts on Server is as follows testing ontlitcp Client telnet where…