*** rati has joined #ingres | 00:08 | |
rati | Hi All | 00:08 |
---|---|---|
rati | I am new to ingres, I had installed ingres on my Windows machine | 00:09 |
rati | Is there any query browser for ingres? | 00:09 |
*** Alex|off is now known as Alex| | 00:11 | |
rati | ii_log,help | 00:24 |
pboro | rati, query browser? | 00:25 |
rati | pboro, like Mysql have query browser? I can connect any remote MySQL server and access that database and do all things on remote database | 00:26 |
pboro | rati, there's a DTP plugin for Eclipse, it provides alike features | 00:27 |
rati | pboro, How to connect remote ingres database? what should I need to install on my (client) machine | 00:27 |
pboro | From where are you connecting? Ingres supports for example JDBC and .NET ds | 00:28 |
pboro | you can also install Ingres client installation on another computer to remotely access the database with Ingres tools (isql, sql, qbf, etc.) | 00:29 |
rati | pboro, I have a machine on my LAN and it has ingres installed, I would like to access that | 00:29 |
rati | pboro, so I need to install client. do I need to configure any thing on remote Server machine to give access? | 00:30 |
pboro | yes you do, you need to define vnode for the server | 00:30 |
pboro | you should check Ingres Connectivity Guide :) | 00:30 |
pboro | you can read it at http://docs.ingres.com | 00:31 |
pboro | there's instructions how to install Ingres Net (to access remote Ingres installations) and also some info about JDBC, ODBC and .Net providers | 00:31 |
rati | pboro, Ok Let me re check that, I read that but couldnt get what they are trying to say :( | 00:32 |
pboro | you first use "netutil" to configure connections and then you can access remote database for example this way: "isql <remotenode>::<dbname>" | 00:34 |
pboro | for example if I had remote server named "foo", I would connect to its database "bar" using "isql foo::bar" | 00:34 |
rati | pboro, okay, I just opened netutils. I can give any node name, username and password to authenticate? | 00:37 |
pboro | hmm I'm not sure, I have not really used netutil that much | 00:37 |
rati | okay, Let me do that, Just a sec | 00:38 |
rati | pboro, Hey do you know which protocol I need to use wintcp or tcp-ip? | 00:42 |
pboro | wintcp | 00:43 |
pboro | if it's Windows :) | 00:43 |
pboro | hmm, oops, lemme recheck | 00:44 |
pboro | sorry, forget wintcp, it's deprecated | 00:44 |
pboro | use tcpip | 00:44 |
pboro | tcp_ip I mean | 00:44 |
rati | pboro, ok, I done tcp_ip. Do you know difference of Network Address and Listen Address? | 00:45 |
pboro | hm hm... I should know, but can't recall :D | 00:46 |
pboro | I guess network address is the hostname like "foo" or "foo.example.tld" and listen address is the port | 00:47 |
pboro | port being like "II7" or "I67" or what ever have been defined | 00:47 |
rati | pboro,Ohh okay. which ports are defined is I dont know, Can I use II7? | 00:49 |
pboro | II7 is the default, so I would try that | 00:50 |
rati | pboro, is II7 is also called as II? | 00:51 |
pboro | yes | 00:51 |
pboro | oops, I7 prolly... not sure | 00:51 |
pboro | I guess the first I is compulsory and the rest is up to user | 00:51 |
Alex| | nope, you can have any combination of a letter + a letter or a number | 00:52 |
Alex| | AA, AB, AC.... | 00:52 |
pboro | Alex|, okay, thanks :) | 00:52 |
Alex| | the 7 in II7 is then "II + 7" | 00:52 |
rati | Ohh I have used II only is that fine? | 00:53 |
Alex| | II is caclulated into a TCP listening port (21064 I think) and II7 is 21064 + 7 which is the TCP listening port for JDBC and .NET connections | 00:53 |
rati | now it shows me a vnode has beed created | 00:53 |
Alex| | so your Ingres installation as a two-letter identifier and to connect via jdbc you use your identifier with the 7 | 00:53 |
Alex| | II7, AA7, AB7... | 00:54 |
rati | Alex|, so do I need to create 2 vnodes? | 00:54 |
rati | one for II and second for II7? | 00:55 |
Alex| | nope, to connect via JDBC/Java you need no vnode at all | 00:55 |
Alex| | vnodes are for connections over php, perl, odbc, etc | 00:55 |
Alex| | .NET and JDBC use the newer Data Access Server which doesn't require vnodes | 00:55 |
rati | Alex|, I need to access remote ingress database and then do create database, drop and other things | 00:57 |
Alex| | via JDBC you can simply connect with jdbc:ingres://%host%:II7/%db%; | 00:57 |
Alex| | that you can't do over jdbc unfortunately... for that you need visual dba which uses vnodes | 00:57 |
pboro | createdb doesn't work remotely either? | 00:57 |
Alex| | create database I mean... that's one of the things that only vdba can do remotely | 00:57 |
Alex| | sad but still true :( | 00:58 |
Alex| | ckpdb, createdb, destroydb, etc... you either need console access or use VDBA which itself uses the remote command server to call these programs | 00:58 |
rati | Alex|, Ohhh then what should I need to install on client machine. and with II7 I need to create vnode? | 00:58 |
rati | Alex|,console access also needs vnodes? | 00:59 |
Alex| | you need to install an Ingres client on your machine and create a vnode to II (not II7) on the other machine... but VDBA is a win-only tool! | 00:59 |
rati | ya I have windws machine only | 01:00 |
Alex| | ok, go and install Ingres on your machine selecting "Client" instead of typical server | 01:00 |
rati | Alex|, Ok. Let me do that | 01:00 |
Alex| | then you'll have Ingres -> Visual DBA in the start menu | 01:00 |
Alex| | there you can create a vnode to your remote host using "II" | 01:01 |
rati | Alex|, that client I need to install on my client machine right? or that on remote server machine? | 01:02 |
Alex| | you have one DBMS and one client - the DBMS I guess is your remote machine where you want to host the database... and on your machine you have the client to access the server | 01:03 |
Alex| | of course you can have everything on one machine as well... that depends on what you want | 01:04 |
rati | Alex|,yea, server is already installed | 01:04 |
rati | Alex|, Let me install client on client machine | 01:04 |
rati | Alex|, Hey installed typical client | 01:20 |
rati | I had created vnode using netutils on server machine, Is that fine? | 01:21 |
Alex| | vnodes are created locally and will point to the remote machine... so you don't need the vnode on the server but on the client | 01:21 |
rati | Alex|,Ohh, so I need to create vnode on my client using visual DBA? | 01:22 |
Alex| | yes... VDBA -> create vnode -> enter your remote host and a user that is known to the server (probably ingres with some password) | 01:23 |
rati | Alex|, Wow I got connected | 01:28 |
rati | so I need to install client on client machine and create vnode | 01:28 |
rati | and I got ready to access remote server | 01:29 |
rati | Is that? Am I right? | 01:29 |
Alex| | if you want to use commands like createdb, yes... if you have a database and you only want to create tables, do selects, updates, etc you can use JDBC (like that Eclipse plugin) and don't need a local Ingres client | 01:29 |
rati | Alex|,Okay | 01:30 |
rati | Alex|, Thanks a lot,, I got it working. | 01:31 |
rati | That also clears my questions | 01:31 |
Alex| | you can also take a look at docs.ingres.com - we have getting started guides there that will tell you more | 01:31 |
rati | Alex|,sure, I had searched in google and got to there | 01:31 |
rati | but there is not good docs will tell you straigh away | 01:32 |
rati | no direct configuration, Just file based and other things, so I got confused more :o | 01:32 |
Alex| | yeah, we still miss something like a cheat sheet that will get you running quickly | 01:32 |
Alex| | you need to read through some pages before you can start - without asking here ;) | 01:33 |
rati | Alex|, ya sure, I was hanging on net wround 2-3 weeks for that, But couldnt find | 01:33 |
Alex| | community.ingres.com may help you as well | 01:34 |
rati | Finally get inges IRC and got help | 01:34 |
Alex| | the wiki and the forum | 01:34 |
rati | Alex|, okay | 01:34 |
rati | Alex|, Thanks a lot again :D | 01:40 |
Alex| | no problem | 01:40 |
*** rati has left #ingres | 02:34 | |
*** zxiiro_ has joined #ingres | 03:57 | |
*** zxiiro has quit IRC | 03:57 | |
*** zxiiro_ is now known as zxiiro | 03:57 | |
*** ChanServ sets mode: +v zxiiro | 03:57 | |
*** grantc has joined #ingres | 04:50 | |
*** ChanServ sets mode: +o grantc | 04:50 | |
*** Dejan has joined #ingres | 04:51 | |
*** Alex| is now known as Alex|off | 05:19 | |
*** Alex|off is now known as Alex| | 05:32 | |
*** atrofast has quit IRC | 05:47 | |
*** rossand has joined #ingres | 05:51 | |
*** ChanServ sets mode: +o rossand | 05:51 | |
*** mull has joined #ingres | 06:11 | |
*** DarylM has joined #ingres | 06:18 | |
*** mull has quit IRC | 06:58 | |
*** mull has joined #ingres | 06:59 | |
*** zxiiro_ has joined #ingres | 07:02 | |
*** zxiiro has quit IRC | 07:02 | |
*** zxiiro_ is now known as zxiiro | 07:02 | |
*** ChanServ sets mode: +v zxiiro | 07:02 | |
*** Alex| is now known as Alex|off | 07:06 | |
*** clach04 has joined #ingres | 09:03 | |
*** withdefault1 has joined #ingres | 09:11 | |
*** grantc_ has joined #ingres | 09:18 | |
*** ChanServ sets mode: +o grantc_ | 09:18 | |
*** grantc has quit IRC | 09:19 | |
*** Alex|off is now known as Alex| | 09:23 | |
*** grantc_ has quit IRC | 09:36 | |
*** grantc_ has joined #ingres | 09:38 | |
*** ChanServ sets mode: +o grantc_ | 09:38 | |
*** grantc_ has quit IRC | 09:52 | |
*** cthibert has joined #ingres | 10:01 | |
*** grantc_ has joined #ingres | 10:05 | |
*** ChanServ sets mode: +o grantc_ | 10:05 | |
*** grantc_ has quit IRC | 10:11 | |
*** Dejan has quit IRC | 10:20 | |
*** atrofast has joined #ingres | 11:52 | |
*** clach04 has quit IRC | 12:15 | |
*** cthibert has left #ingres | 13:28 | |
*** thiagomz has quit IRC | 13:59 | |
*** clach04 has joined #ingres | 14:15 | |
*** DarylM has quit IRC | 14:27 | |
*** Alex| is now known as Alex|off | 15:18 | |
*** mull has quit IRC | 15:30 | |
*** toumi01 has left #ingres | 17:44 | |
*** rossand has quit IRC | 18:17 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!