*** Gerhard has joined #ingres | 01:23 | |
Gerhard | Hi all. | 01:36 |
---|---|---|
grantc | morning Gerhard | 01:44 |
Vroomfondle | our new 9.2 server is refusing net connections from other servers with: "An installation password has been defined for the remote vnode, but that installation is not allowing use of installation passwords." | 03:55 |
*** cthibert has joined #ingres | 03:57 | |
grantc | Vroomfondle, check netutil on the server for a vnode entry that matches the hostname who's user is "*" | 04:00 |
grantc | vnode name = servername... | 04:02 |
Vroomfondle | The hosts are called Cordelia and Miranda. Miranda has a remote vnode showing in netutil called Cordelia, and Cordelia has a vnode called Miranda. | 04:03 |
Vroomfondle | is that what you mean? | 04:03 |
grantc | no - iirc Cordelia should have a vnode entry "cordelia" and the same on miranda | 04:04 |
Vroomfondle | (Cordelia is acting as the "server", as such, btw - Miranda's running the app code) | 04:04 |
Vroomfondle | really? Hmm, k | 04:04 |
grantc | ah.. on Miranda is the username "*" | 04:04 |
grantc | in netutil.. | 04:04 |
Vroomfondle | the username for the "cordelia" vnode, in netutil on Miranda, is * | 04:05 |
grantc | did you use installation passwords before the upgrade? | 04:05 |
Vroomfondle | yep | 04:05 |
grantc | ok on cordelia define a vnode name of cordelia with a user of * and the installation password used on miranda | 04:06 |
Vroomfondle | but the upgrade has involved wiping the slate clean and starting fresh, and changing the name of the server, so we have to set up the link again | 04:06 |
Vroomfondle | k, will do | 04:06 |
grantc | you may have to bounce the client and server installations and delete ingres/files/name/*TICKET* | 04:07 |
Vroomfondle | grantc: it worked | 04:09 |
grantc | nice | 04:09 |
Vroomfondle | thanks :) | 04:09 |
grantc | no problem - if you ever change the password you might have to delete the ticket files or wait 30 mins | 04:09 |
* grantc is dusting off some old knowledge | 04:10 | |
*** cthibert has left #ingres | 04:20 | |
*** cthibert has joined #ingres | 04:31 | |
*** toumi01 has joined #ingres | 04:51 | |
*** zxiiro has quit IRC | 04:59 | |
*** mull has joined #ingres | 05:13 | |
*** zxiiro has joined #ingres | 05:47 | |
*** ChanServ sets mode: +v zxiiro | 05:47 | |
*** rossand has joined #ingres | 06:08 | |
*** ChanServ sets mode: +o rossand | 06:08 | |
*** DarylM has quit IRC | 06:30 | |
*** cthibert has left #ingres | 07:33 | |
*** cthibert has joined #ingres | 07:35 | |
Vroomfondle | Just found out that optimizedb was last run on our live database in 2004. | 08:15 |
pboro | :D | 08:16 |
Vroomfondle | This might explain some of the performance problems we've been seeing since, oh, about 2004. | 08:16 |
Vroomfondle | apparently CA told us to turn it off, for some reason | 08:16 |
pboro | what about sysmod? | 08:16 |
Vroomfondle | I'm not even sure what sysmod is. What's sysmod? :) | 08:16 |
Vroomfondle | <-- not a DBA. Just likes to tread on the System Manager's toes whenever possible :D | 08:17 |
pboro | :DDD | 08:17 |
pboro | once optimizedb is ran, you need to run sysmod so that the dbms takes the new statistics (generated by optimizedb) in use | 08:17 |
pboro | normal maintenance task is to run optimizedb & sysmod occassionally | 08:18 |
grantc | Vroomfondle, perhaps that was a goodbye present from CA? :/ | 08:18 |
grantc | to add to what pboro says - sysmod is used to re-organize the system tables. If you have batch jobs that create/drop tables then it would be useful to run it more frequently as iirelation will become a bit disorganizewd | 08:20 |
pboro | usermod may also be useful | 08:21 |
pboro | I guess we run usermod & optimizedb & sysmod every now an then | 08:21 |
pboro | and even | 08:21 |
*** Gerhard has quit IRC | 08:22 | |
Vroomfondle | I shall pass on the advice, cheers | 08:24 |
Vroomfondle | looking at our scripts, we did used to run sysmod too, until 2004 | 08:24 |
pboro | :D | 08:25 |
pboro | "forget all maintenance, the db will do juuuuust fine..." | 08:25 |
*** atrofast has quit IRC | 09:23 | |
*** atrofast has joined #ingres | 09:24 | |
*** grantc has quit IRC | 10:42 | |
*** hanje04 has joined #ingres | 10:52 | |
*** rossand has quit IRC | 11:04 | |
*** atrofast has quit IRC | 11:08 | |
*** cthibert has quit IRC | 11:08 | |
*** mull has quit IRC | 11:08 | |
*** Nornagest has quit IRC | 11:08 | |
*** SaraDanaher has joined #ingres | 11:40 | |
*** atrofast has joined #ingres | 11:48 | |
*** cthibert has joined #ingres | 11:48 | |
*** mull has joined #ingres | 11:48 | |
*** Nornagest has joined #ingres | 11:48 | |
*** ii_log has joined #ingres | 11:57 | |
*** rossand has joined #ingres | 12:20 | |
*** ChanServ sets mode: +o rossand | 12:20 | |
*** Mud has joined #ingres | 12:51 | |
Mud | hi guys | 12:51 |
Mud | is someone here to help me? | 12:51 |
Mud | I have some questions | 12:51 |
hanje04 | @ mud sure, I can try | 12:52 |
ii_log | hanje04: Error: "mud" is not a valid command. | 12:52 |
hanje04 | sure, I can try | 12:52 |
Mud | hanje04: I am working as a webdev for a cardealer and their company work with a application with a ingres DB behind it | 12:52 |
Mud | I want to get PHP talking with the ingres DB | 12:53 |
Mud | just like a Mysql DB | 12:53 |
Vroomfondle | how old's their Ingres system? | 12:53 |
Mud | I really dont know | 12:53 |
Mud | we have no control about that application and DB | 12:53 |
Vroomfondle | Mud: we run PHP with Ingres | 12:53 |
Vroomfondle | do you have a specific problem, or are you looking for pointers regarding how to get started? | 12:54 |
Mud | Vroomfondle: I have looked at this page: http://community.ingres.com/wiki/Ingres_with_Apache_on_Ubuntu | 12:55 |
Mud | I run ubuntu webservers btw | 12:55 |
Mud | but is Ingres required to be installed? | 12:55 |
Vroomfondle | yes. You must have a local Ingres installation. | 12:55 |
Mud | because the ingres DB is not local.. :) | 12:55 |
Mud | its a remote machine that we dont control | 12:55 |
Vroomfondle | the PHP driver talks to the local Ingres, which talks to remote Ingres | 12:55 |
Mud | hmm | 12:55 |
Vroomfondle | you can't do it directly, I'm afraid | 12:55 |
Mud | well, that was the idea | 12:56 |
Mud | to fetch information directly from the DB | 12:56 |
Vroomfondle | that's still effectively what happens | 12:56 |
Vroomfondle | the local installation is just used as a conduit | 12:56 |
Mud | how easy is ingres to install on a ubuntu server? | 12:57 |
Mud | I never worked with ingres before | 12:57 |
Vroomfondle | easy-peasy to install, sometimes a little tricky to configure | 12:57 |
Mud | can I install it via apt-get for example? | 12:57 |
Vroomfondle | just download it, un-tar/gz it, then run the install script as root. | 12:57 |
Vroomfondle | no, there's no debs | 12:57 |
Vroomfondle | which is unfortunate | 12:57 |
Mud | btw, offtopic, what is the main difference between ingres & mysql? | 12:58 |
Vroomfondle | I've submitted a package request to Ubuntu, but no-one's offered to maintain such a thing, and I don't have the skills or time myself | 12:58 |
Vroomfondle | Ingres is more mature and uses an SQL dialect which is closer to the standard. It's also better at subselects. Otherwise I don't notice much difference. | 12:59 |
Mud | I never use subselects xD | 12:59 |
Mud | Vroomfondle: what timezone are you in? | 12:59 |
Vroomfondle | Ingres also has its own forms-based dev tools, but you won't be interested in those | 13:00 |
Mud | I can work on the installation tomorrow, could me usefull if someone is here then :) | 13:00 |
hanje04 | The main difference is that it's designed to be transactional from the ground up. | 13:00 |
Mud | could be* | 13:00 |
Vroomfondle | I'm in GMT+0 at the moment. UK. | 13:00 |
Mud | ok coolw | 13:00 |
Mud | I am @ GMT +1 | 13:01 |
Mud | (holland ;) ) | 13:01 |
Mud | uhm | 13:01 |
Mud | I thinking @ one thing.. | 13:01 |
Vroomfondle | ah. Hallo :) | 13:01 |
Vroomfondle | (that's the only dutch I know) | 13:01 |
Mud | Hoi :+ | 13:01 |
Mud | heheh :P | 13:02 |
Mud | uhm how I gonna explain this.. | 13:02 |
Mud | The cardealer have several company (7+), each company has each one machine with ingres DB, so each machine has a different IP | 13:03 |
Mud | Main target is, to fetch information from those DB's | 13:03 |
Mud | but like it said, we dont control those ingres machines, they are not ours | 13:03 |
Mud | is it possible to get this situation working, with PHP ? | 13:03 |
Vroomfondle | sure. | 13:04 |
Mud | ke | 13:04 |
Mud | coolw :) | 13:04 |
Vroomfondle | you'll just need to set them all up as "vnodes" in your local Ingres installation, then you just tell PHP to use the relevant vnode when you want to send a query to one of the servers | 13:04 |
Mud | oh btw | 13:04 |
Mud | yes | 13:04 |
Mud | that vnodes I reconize | 13:04 |
Vroomfondle | you'll use a tool called "netutil" to make up a list of vnodes. It's CLI-based and a bit clunky, but it's fairly simple to use. | 13:05 |
Mud | we have 7 different vnodes @ our ODBC settings on our clients | 13:05 |
Mud | Vroomfondle: for that application we have script that creates that list of vnodes in netutil | 13:06 |
Vroomfondle | I see | 13:06 |
Mud | its a old ugly application (ported from unix -> linux -> windows :X ) | 13:06 |
Mud | its only looks good in 1024x768 screens :X | 13:06 |
Vroomfondle | heh | 13:07 |
Vroomfondle | it's still probably prettier than Ingres' netutil ;) | 13:07 |
Mud | hehehe | 13:07 |
Vroomfondle | Ingres does have graphical tools but they're not currently available on Linux | 13:07 |
Vroomfondle | as far as I know | 13:07 |
Mud | we all run windows XP clients | 13:07 |
Vroomfondle | Mud: there is a user on here called grantc. He's Grant Croker, maintainer of the Ingres PHP driver. | 13:08 |
Vroomfondle | he's a very helpful chap. | 13:08 |
Mud | is he on irc ? | 13:09 |
Vroomfondle | yes - he logs on to this channel most days | 13:09 |
Mud | ke coolw :)\ | 13:09 |
hanje04 | He's in Spain though, so he'll be on tomorrow morning your time | 13:09 |
Mud | :o | 13:11 |
Mud | oh btw, do I need to reconfigure PHP for ingres? | 13:11 |
Mud | I always install php5 via apt-get install php5 | 13:12 |
Vroomfondle | you'll need to install the Ingres driver, which you can get from PECL, but ideally you should install Ingres before you do that | 13:12 |
hanje04 | Take a look here if you haven't already http://community.ingres.com/wiki/Ingres_PHP_Development_Center | 13:12 |
Mud | how can I check what ingres version they use? | 13:13 |
Vroomfondle | I think you'll need to ask them | 13:14 |
Mud | I hacked one of machine (first converted the fysical machine VM etc) ( I did reset the root pw) | 13:14 |
Mud | so I can access just 1 of them | 13:15 |
Mud | Vroomfondle: its not readable in conf files or whatever? | 13:15 |
hanje04 | vroomfondle: re Ingres DEBS. We can actually generate them at the moment. There are a few issues which need to be resolved before they can really be useful though. http://community.ingres.com/wiki/AddingDEBPackagingSupport | 13:15 |
Vroomfondle | su in to the "ingres" user, then run "isql iidbdb", then run this query: "select dbmsinfo('_version');commit;" | 13:16 |
Mud | ok | 13:16 |
Mud | wait a sec then :) | 13:16 |
Vroomfondle | hanje04: Ah, cool | 13:16 |
hanje04 | I'm working on changing the installation process to make us more standards compliant and resolve those issues. Once that's done, will hopefully get them up in a repository | 13:17 |
Mud | when I boot the machine | 13:18 |
Mud | it says: Ingres icebreaker R2 | 13:18 |
Mud | does that ring a bell Vroomfondle? | 13:18 |
Vroomfondle | I think that's based on Ingres 2006 r2, which (correct me if I'm wrong, hanje04) is otherwise known as Ingres 9.2 | 13:19 |
*** cthibert has left #ingres | 13:20 | |
pboro | Release 2 is 9.1 | 13:20 |
Vroomfondle | ah | 13:20 |
Vroomfondle | Mud: that's reasonably recent | 13:21 |
hanje04 | Yeah, but icebreaker r2 in 9.2 | 13:21 |
Mud | Vroomfondle: gonna do that query to be 100% sure | 13:21 |
pboro | hanje04, oh boy... all those "releases" :) | 13:21 |
Vroomfondle | certainly recent-enough to work well with the PHP driver. We've had occasional issues with PHP+Ingres 2.6 (though nothing show-stopping). | 13:21 |
hanje04 | pboro: uhuh, gotta love it | 13:22 |
pboro | :D | 13:22 |
pboro | I hope the latest versioning scheme sticks with Ingres for at least 10 years | 13:22 |
pboro | 9.2, 9.3, 10.0 and so on | 13:22 |
hanje04 | I'm pretty sure it will, it got pretty embarrassing | 13:23 |
Vroomfondle | I quite like the numbering jump from 2.6 to 9.2. It makes management types think our soon-to-be-complete upgrade is like moving from the dark ages to the 21st century | 13:23 |
hanje04 | :-) | 13:23 |
pboro | :D | 13:24 |
Vroomfondle | though actually in I.T. terms it's not too far off that ;) | 13:24 |
hanje04 | It's actually original versioning system, it match the internal version of the server | 13:24 |
pboro | ahh, just installed patch 13599 on 9.2 and finally I get no errors during day in error.log \o/ | 13:24 |
Mud | Vroomfondle: 9.1.0 | 13:25 |
Mud | and something else behind it | 13:25 |
Mud | int.rpl/123 | 13:25 |
Mud | that thing | 13:25 |
Vroomfondle | 9.1's not too old. 9.2 is the current "stable" version, with 9.3 being the latest release. | 13:26 |
Mud | ke coolw :) | 13:27 |
Vroomfondle | Ingres has backwards-compatibility so you can install 9.2 locally and still use it to talk to a remote 9.1 | 13:27 |
pboro | 9.3 is already stable for some platforms :) | 13:27 |
Mud | I never heard of ingres before btw (before I started @ this company) | 13:29 |
Mud | how much users/companies use it? | 13:30 |
Mud | most common DB what you hear is Mysql, MSSQL, Postgres... | 13:30 |
toumi01 | there's a pretty good Ingres history here: http://en.wikipedia.org/wiki/Ingres_(database) | 13:32 |
toumi01 | and the strange history of Ingres version numbers is revealed in all its glory here: http://community.ingres.com/wiki/Ingres_Versions | 13:34 |
Mud | thanx toumi01 | 13:34 |
Vroomfondle | Ingres is.... not as big as it once was, to be blunt (it used to be hugely popular, years ago). That said, recently it's turned into an open-source outfit with a pretty decent little community. | 13:34 |
Vroomfondle | Mud: one of the original authors of Ingres is the main man behind Postgres (hence the name) | 13:34 |
Mud | Ingres Icebreaker – Integrated software appliance that combines the Ingres Database with the Linux operating system, enabling people to simultaneously deploy and manage a database and operating system. | 13:35 |
Mud | lol | 13:35 |
Mud | @ Vroomfondle: aha ke ke :) | 13:35 |
ii_log | Mud: Error: "Vroomfondle:" is not a valid command. | 13:35 |
pboro | :D | 13:36 |
Mud | _O- | 13:36 |
Mud | LOL | 13:37 |
* Vroomfondle throws an exception | 13:37 | |
Mud | why are these installation path's starting with II_ ? | 13:38 |
Vroomfondle | II_ is the prefix used on Ingres-related environment variables | 13:39 |
Mud | aha ke ke | 13:39 |
Mud | << off to bed :W | 13:40 |
Mud | good night and thank you for your help! | 13:40 |
Mud | see ya tomorrow | 13:40 |
Vroomfondle | nn :) | 13:40 |
*** Alex______ has joined #ingres | 13:43 | |
*** Alex| has quit IRC | 13:45 | |
*** Alex______ is now known as Alex| | 13:45 | |
*** ChanServ sets mode: +o Alex| | 13:45 | |
*** _Alex| has joined #ingres | 13:45 | |
*** Nornagest has quit IRC | 13:46 | |
*** Alex| has quit IRC | 13:46 | |
*** Alex| has joined #ingres | 13:47 | |
*** ChanServ sets mode: +o Alex| | 13:47 | |
*** zxiiro has quit IRC | 13:54 | |
*** Mud has quit IRC | 13:59 | |
*** hanje04_ has joined #ingres | 14:00 | |
*** Alex| has quit IRC | 14:01 | |
*** hanje04 has quit IRC | 14:02 | |
*** hanje04_ is now known as hanje04 | 14:02 | |
*** zxiiro has joined #ingres | 14:33 | |
*** ChanServ sets mode: +v zxiiro | 14:33 | |
*** DarylM has joined #ingres | 14:56 | |
*** mull has quit IRC | 17:28 | |
*** mull has joined #ingres | 18:03 | |
*** cytrinox_ has joined #ingres | 19:20 | |
*** SaraDanaher has quit IRC | 19:20 | |
*** cytrinox has quit IRC | 19:29 | |
*** cytrinox_ is now known as cytrinox | 19:29 | |
*** rossand has quit IRC | 19:53 | |
*** toumi01 has left #ingres | 20:10 | |
*** Alex| has joined #ingres | 22:34 | |
*** ChanServ sets mode: +o Alex| | 22:34 | |
*** Mud has joined #ingres | 22:58 | |
Mud | morning :W | 22:59 |
*** chenzhen has joined #ingres | 23:06 | |
*** chenzhen has left #ingres | 23:07 | |
*** Alex| has quit IRC | 23:10 | |
*** grantc has joined #ingres | 23:35 | |
*** ChanServ sets mode: +o grantc | 23:35 | |
Mud | ey guys | 23:59 |
Mud | is there a tutorial to install ingres on ubuntu? | 23:59 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!