Monday, 2009-10-12

*** Alex|off is now known as Alex|00:14
*** Gerhard has joined #ingres01:04
GerhardHi all01:04
*** atrofast has joined #ingres05:08
*** mull has joined #ingres06:45
*** FrankW has joined #ingres07:03
*** Gerhard has quit IRC07:05
*** DarylM has joined #ingres07:06
*** rossand has joined #ingres07:36
*** ChanServ sets mode: +o rossand07:36
*** rossand has quit IRC09:27
cytrinoxhi..10:38
pborohi cytrinox10:39
cytrinoxhuhu pboro10:39
cytrinoxpboro: the procedure problem yesterday is a bug.. :)10:39
pborohehe, good (bad) to hear :)10:40
cytrinoxover a jdbc connection it "should" work, so I have tried to install the ingres database workbench10:40
cytrinoxI have entered this jdbc url: jdbc:ingres://localhost:5000/demodb10:42
cytrinox..I'm waiting now for ~17min for a response after clicking "test connection", but all I see is a hourglass cursor :(10:42
cytrinoxis there anything wrong with the jdbc url?10:43
pborothe port is funny10:47
pboroI bet it should be something else than 5000 :)10:47
cytrinoxhmm really? I thought 5000 is the default ingres port..10:47
pborodid you use port II when installing=10:48
pboro?10:48
cytrinox..port II?10:48
pborotry: jdbc:ingres://localhost:II7/demodb10:48
cytrinoxhm10:49
cytrinoxnow i responds very fast..10:49
cytrinox"ping failed"10:49
pborohm, you should see the correct port if you check errlog.log under files directory10:50
pborofiles directory under Ingres installation directory10:50
cytrinoxhmm interesting10:51
cytrinoxerror.log tells me "network initialization error"10:52
pboroahh, well that could be a problem :)10:52
cytrinoxsure, but _why_ does initialization failed? :)10:53
pborois there any extra information about the problem?10:53
cytrinoxjep, but I think the main problem is: Starting data access server... FAIL10:57
cytrinoxII_SYSTEM must be set10:57
cytrinox..what is the csinstall program?10:58
pborohmm csinstall... no idea :)10:58
pboroDAS is required for JDBC connectivity, yup10:58
cytrinoxiirundbms: server would not start. II_SYSTEM must be set in your environment. Has the csinstall program been run?10:59
*** Nornagest has quit IRC11:01
*** Alex| has quit IRC11:01
*** Alex| has joined #ingres11:01
*** ChanServ sets mode: +o Alex|11:02
*** Nornagest has joined #ingres11:02
cytrinoxdo'h11:04
cytrinoxingstop11:04
cytrinoxingsetenv II_TCPIP_VERSION 411:04
cytrinoxingstart11:04
cytrinox..helps :)11:04
cytrinoxnot really11:06
*** Alex| is now known as Alex|off11:06
cytrinoxnow DAS starts without any errors, but IDW still returns "ping failed"11:07
cytrinoxand error.log contains afer the last server restart no more errors11:08
*** Alex|off is now known as Alex|11:09
pborothe correct tcp/ip port should be mentioned in the errlog.log11:09
cytrinoxjep. "ping error" means "wrong password"11:10
cytrinox...11:10
pborohehe :D11:10
cytrinoxsoooo eh, is there a default pw for the system account?11:11
pborohmm on unix ingres uses system's user passwords11:11
cytrinoxyeah, i can select my user "cytrinox", but the windows password doesn't work11:12
cytrinoxping success11:13
cytrinox..juhu!11:13
pboro\o/11:14
cytrinoxDisplayed 0 of 14 records.. nice, but how can i see the records?!11:24
cytrinox..it seems I'm incompatible to ingres :)11:26
cytrinoxah. after restarting the idw it shows the query status & result11:32
cytrinoxif I select "run" from the context menu of my procedure, idw displays11:32
cytrinoxcall cytrinox.userstats( rangestart='2009-01-01' ANSIDATE INPUT, rangeend='2009-12-31' ANSIDATE INPUT)11:32
cytrinoxbut if I copy this query into the sql scrapbook, idb returns an error: syntax error, last symbol was "call"11:33
cytrinox..wtf?11:33
*** rossand has joined #ingres11:34
*** ChanServ sets mode: +o rossand11:34
*** rossand has quit IRC11:47
*** mull_ has joined #ingres12:26
*** mull has quit IRC12:28
*** mull_ has quit IRC12:44
*** mull_ has joined #ingres12:46
*** rossand has joined #ingres13:00
*** ChanServ sets mode: +o rossand13:00
*** rossand has quit IRC13:28
*** Alex| is now known as Alex|off13:40
*** rossand has joined #ingres14:03
*** ChanServ sets mode: +o rossand14:03
*** rossand has quit IRC14:43
*** rossand has joined #ingres14:47
*** ChanServ sets mode: +o rossand14:47
*** rossand has quit IRC15:10
*** mull_ has quit IRC15:36
*** rossand has joined #ingres15:41
*** ChanServ sets mode: +o rossand15:41
*** atrofast1 has joined #ingres15:45
*** rossand has quit IRC15:48
*** atrofast has quit IRC16:02
*** rossand has joined #ingres17:14
*** ChanServ sets mode: +o rossand17:14
*** rossand has quit IRC18:36
*** mull_ has joined #ingres18:46
*** toumi01 has quit IRC19:16
*** cytrinox_ has joined #ingres19:20
*** cytrinox has quit IRC19:28
*** cytrinox_ is now known as cytrinox19:28
*** mull_ has quit IRC19:59
*** zxiiro has quit IRC21:44
*** zxiiro has joined #ingres21:45
*** ChanServ sets mode: +v zxiiro21:45
*** Alex|off is now known as Alex|22:42
*** Alex| is now known as Alex|off23:11
*** Alex|off is now known as Alex|23:27

Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!