*** Alex|off is now known as Alex| | 00:14 | |
*** Gerhard has joined #ingres | 01:04 | |
Gerhard | Hi all | 01:04 |
---|---|---|
*** atrofast has joined #ingres | 05:08 | |
*** mull has joined #ingres | 06:45 | |
*** FrankW has joined #ingres | 07:03 | |
*** Gerhard has quit IRC | 07:05 | |
*** DarylM has joined #ingres | 07:06 | |
*** rossand has joined #ingres | 07:36 | |
*** ChanServ sets mode: +o rossand | 07:36 | |
*** rossand has quit IRC | 09:27 | |
cytrinox | hi.. | 10:38 |
pboro | hi cytrinox | 10:39 |
cytrinox | huhu pboro | 10:39 |
cytrinox | pboro: the procedure problem yesterday is a bug.. :) | 10:39 |
pboro | hehe, good (bad) to hear :) | 10:40 |
cytrinox | over a jdbc connection it "should" work, so I have tried to install the ingres database workbench | 10:40 |
cytrinox | I have entered this jdbc url: jdbc:ingres://localhost:5000/demodb | 10: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 |
cytrinox | is there anything wrong with the jdbc url? | 10:43 |
pboro | the port is funny | 10:47 |
pboro | I bet it should be something else than 5000 :) | 10:47 |
cytrinox | hmm really? I thought 5000 is the default ingres port.. | 10:47 |
pboro | did you use port II when installing= | 10:48 |
pboro | ? | 10:48 |
cytrinox | ..port II? | 10:48 |
pboro | try: jdbc:ingres://localhost:II7/demodb | 10:48 |
cytrinox | hm | 10:49 |
cytrinox | now i responds very fast.. | 10:49 |
cytrinox | "ping failed" | 10:49 |
pboro | hm, you should see the correct port if you check errlog.log under files directory | 10:50 |
pboro | files directory under Ingres installation directory | 10:50 |
cytrinox | hmm interesting | 10:51 |
cytrinox | error.log tells me "network initialization error" | 10:52 |
pboro | ahh, well that could be a problem :) | 10:52 |
cytrinox | sure, but _why_ does initialization failed? :) | 10:53 |
pboro | is there any extra information about the problem? | 10:53 |
cytrinox | jep, but I think the main problem is: Starting data access server... FAIL | 10:57 |
cytrinox | II_SYSTEM must be set | 10:57 |
cytrinox | ..what is the csinstall program? | 10:58 |
pboro | hmm csinstall... no idea :) | 10:58 |
pboro | DAS is required for JDBC connectivity, yup | 10:58 |
cytrinox | iirundbms: server would not start. II_SYSTEM must be set in your environment. Has the csinstall program been run? | 10:59 |
*** Nornagest has quit IRC | 11:01 | |
*** Alex| has quit IRC | 11:01 | |
*** Alex| has joined #ingres | 11:01 | |
*** ChanServ sets mode: +o Alex| | 11:02 | |
*** Nornagest has joined #ingres | 11:02 | |
cytrinox | do'h | 11:04 |
cytrinox | ingstop | 11:04 |
cytrinox | ingsetenv II_TCPIP_VERSION 4 | 11:04 |
cytrinox | ingstart | 11:04 |
cytrinox | ..helps :) | 11:04 |
cytrinox | not really | 11:06 |
*** Alex| is now known as Alex|off | 11:06 | |
cytrinox | now DAS starts without any errors, but IDW still returns "ping failed" | 11:07 |
cytrinox | and error.log contains afer the last server restart no more errors | 11:08 |
*** Alex|off is now known as Alex| | 11:09 | |
pboro | the correct tcp/ip port should be mentioned in the errlog.log | 11:09 |
cytrinox | jep. "ping error" means "wrong password" | 11:10 |
cytrinox | ... | 11:10 |
pboro | hehe :D | 11:10 |
cytrinox | soooo eh, is there a default pw for the system account? | 11:11 |
pboro | hmm on unix ingres uses system's user passwords | 11:11 |
cytrinox | yeah, i can select my user "cytrinox", but the windows password doesn't work | 11:12 |
cytrinox | ping success | 11:13 |
cytrinox | ..juhu! | 11:13 |
pboro | \o/ | 11:14 |
cytrinox | Displayed 0 of 14 records.. nice, but how can i see the records?! | 11:24 |
cytrinox | ..it seems I'm incompatible to ingres :) | 11:26 |
cytrinox | ah. after restarting the idw it shows the query status & result | 11:32 |
cytrinox | if I select "run" from the context menu of my procedure, idw displays | 11:32 |
cytrinox | call cytrinox.userstats( rangestart='2009-01-01' ANSIDATE INPUT, rangeend='2009-12-31' ANSIDATE INPUT) | 11:32 |
cytrinox | but 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 #ingres | 11:34 | |
*** ChanServ sets mode: +o rossand | 11:34 | |
*** rossand has quit IRC | 11:47 | |
*** mull_ has joined #ingres | 12:26 | |
*** mull has quit IRC | 12:28 | |
*** mull_ has quit IRC | 12:44 | |
*** mull_ has joined #ingres | 12:46 | |
*** rossand has joined #ingres | 13:00 | |
*** ChanServ sets mode: +o rossand | 13:00 | |
*** rossand has quit IRC | 13:28 | |
*** Alex| is now known as Alex|off | 13:40 | |
*** rossand has joined #ingres | 14:03 | |
*** ChanServ sets mode: +o rossand | 14:03 | |
*** rossand has quit IRC | 14:43 | |
*** rossand has joined #ingres | 14:47 | |
*** ChanServ sets mode: +o rossand | 14:47 | |
*** rossand has quit IRC | 15:10 | |
*** mull_ has quit IRC | 15:36 | |
*** rossand has joined #ingres | 15:41 | |
*** ChanServ sets mode: +o rossand | 15:41 | |
*** atrofast1 has joined #ingres | 15:45 | |
*** rossand has quit IRC | 15:48 | |
*** atrofast has quit IRC | 16:02 | |
*** rossand has joined #ingres | 17:14 | |
*** ChanServ sets mode: +o rossand | 17:14 | |
*** rossand has quit IRC | 18:36 | |
*** mull_ has joined #ingres | 18:46 | |
*** toumi01 has quit IRC | 19:16 | |
*** cytrinox_ has joined #ingres | 19:20 | |
*** cytrinox has quit IRC | 19:28 | |
*** cytrinox_ is now known as cytrinox | 19:28 | |
*** mull_ has quit IRC | 19:59 | |
*** zxiiro has quit IRC | 21:44 | |
*** zxiiro has joined #ingres | 21:45 | |
*** ChanServ sets mode: +v zxiiro | 21:45 | |
*** Alex|off is now known as Alex| | 22:42 | |
*** Alex| is now known as Alex|off | 23: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!