*** withdefault has joined #ingres | 00:10 | |
*** ChanServ sets mode: +o withdefault | 00:10 | |
*** grantc has joined #ingres | 01:10 | |
*** ChanServ sets mode: +o grantc | 01:10 | |
*** rossand has joined #ingres | 01:49 | |
*** ChanServ sets mode: +o rossand | 01:49 | |
*** cthibert has joined #ingres | 02:51 | |
*** withdefault has quit IRC | 03:24 | |
*** Dejan has joined #ingres | 04:02 | |
Dejan | hello | 04:03 |
---|---|---|
bonsaikitten | hai | 04:04 |
*** tonysimpson has joined #ingres | 04:30 | |
Dejan | guys, i need a robust way of generating a sequence (identity) column in a table, in ingres that does not support this? | 04:38 |
Dejan | i remember someone told me they used some approach to workaround this problem | 04:38 |
grantc | create sequence my_table_id; create table my_table ( id not null default my_table_id.nextval, .......) | 04:52 |
grantc | or you can use the identity type from 9.3 onwards | 04:52 |
*** rossand has quit IRC | 04:52 | |
*** Alex| has joined #ingres | 05:06 | |
*** ChanServ sets mode: +o Alex| | 05:06 | |
*** toumi01 has joined #ingres | 05:10 | |
tonysimpson | grantc: would it be possible to get win32 binary distributions of the ingres python dbi for 2.5 and 2.6 up on pypi? | 05:18 |
*** mull has joined #ingres | 05:19 | |
tonysimpson | I can build the python 2.5 package if that would help | 05:19 |
grantc | hi tonysimpson - let me chat with clach04 | 05:24 |
grantc | we need a download for each Ingres release which is the problem | 05:24 |
tonysimpson | really? that is a problem - why it that? do things change in odbc from version to version? | 05:26 |
grantc | hmm - may be you have a point. I've never looked in to it and assumed that for each Ingres release you will need a corresponding build for every python release | 05:28 |
tonysimpson | I don't know anything much about odbc but I can't think of anything in the driver that would tie it to a particular ingres version. | 05:30 |
tonysimpson | I haven't tested the driver for python 2.6 compatability but I don't think it would require major changes if any at all | 05:31 |
tonysimpson | I think I can set myself up as a maintainer on pypi then all that needs to be done is "python setup.py bdist_wininst upload" to upload a new binary distribution and anyone can pull it with easyinstall etc. | 05:32 |
tonysimpson | need to go play pool back in half an hour | 05:34 |
grantc | Personally I have no issue with distributing source/binaries on pypi but I think its something that needs to be discussed. | 05:36 |
tonysimpson | agreed, I'll email you and chris about it | 05:59 |
grantc | i just mailed him, cc'd you too. I think chris is about to do a release so now is a good time to discuss this :) | 06:08 |
*** mull has quit IRC | 06:17 | |
*** mull has joined #ingres | 06:19 | |
*** Alex| has quit IRC | 06:37 | |
*** DarylM has joined #ingres | 06:43 | |
*** FrankW has joined #ingres | 06:59 | |
Dejan | guys | 07:16 |
Dejan | what date types are available in 2.6 ? | 07:16 |
Dejan | ingresdate, timestamp and ansidate does not work | 07:16 |
Dejan | :( | 07:16 |
Dejan | and date is not enough | 07:16 |
toumi01 | you're quite right that in 2.6 there is just the pre-ANSI spec original Ingres date implementation, which was re-christened ingresdate when ANSI support was added | 07:19 |
Dejan | so which type to use for : '1997-01-05 00:00:00' | 07:20 |
Dejan | ??? | 07:20 |
toumi01 | there are various II_DATE_FORMAT options in the SQL Reference | 07:27 |
*** ccsidiot has joined #ingres | 07:33 | |
Dejan | uh... | 07:34 |
*** ccsidiot has left #ingres | 07:50 | |
*** DarylM has quit IRC | 07:57 | |
*** DarylM has joined #ingres | 08:07 | |
grantc | Dejan: you can use ISO4 for that format | 08:18 |
Dejan | the problem is that i cannot change it on that server | 08:20 |
Dejan | it is production server which is still on 2.6 | 08:20 |
grantc | it's a client setting | 08:20 |
Dejan | is it? | 08:21 |
Dejan | great, i will try it | 08:21 |
Dejan | erm, neither sys env variable works, nor ingsetenv | 08:25 |
Dejan | i am doing something wrong | 08:25 |
grantc | export II_DATE_FORMAT=ISO4 | 08:27 |
grantc | then execute your query | 08:28 |
grantc | which app interface are you using? | 08:28 |
Dejan | TM | 08:32 |
Dejan | i did exactly that | 08:33 |
Dejan | did not work | 08:33 |
Dejan | i am getting "E_US10D0 2009 is not a valid month for a date column." | 08:33 |
grantc | and "select date('now')"? | 08:34 |
DarylM | ISO4 is yyyymmdd | 08:36 |
*** tonysimpson has quit IRC | 08:39 | |
Dejan | DarylM: yep | 08:39 |
Dejan | that is why i am getting error | 08:39 |
*** siman01 has joined #ingres | 08:39 | |
siman01 | Dejan: SWEDEN is yyyy-mm-dd | 08:39 |
Dejan | insert into dejan_test2 values(3, '20091010 10:00:00'); worked | 08:39 |
grantc | according to the docs yyyy-mm-dd is valid for ISO4 | 08:40 |
DarylM | Yes. SWEDEN is used for the Ruby driver :-) | 08:40 |
grantc | or FINLAND... | 08:41 |
Dejan | http://www.w3.org/TR/NOTE-datetime | 08:41 |
Dejan | it is not sweden, it is ISO standard | 08:41 |
Dejan | ISO 8601 | 08:41 |
pboro | yeah, we don't really use yyyy-mm-dd in finland, but dd.mm.yyyy :) | 08:41 |
DarylM | How nordic of ruby. :-) | 08:42 |
Dejan | http://en.wikipedia.org/wiki/ISO_8601 | 08:42 |
grantc | pboro: now you're being picky ;) | 08:42 |
pboro | the same goes for sweden afaik, don't know where the ingres has taken the format :) | 08:42 |
Dejan | nope | 08:42 |
grantc | Dejan: this topic came up on c.d.i. today and Ingres does not have a date format that complies with ISO8601 | 08:42 |
Dejan | in sweden people use exactly as in ISO 8601 | 08:42 |
siman01 | grantc: 9.2 sql reference says YMD and SWEDEN(FINLAND) support yyyy-mm-dd but no others | 08:42 |
Dejan | sweden is advanced country | 08:43 |
Dejan | ;) | 08:43 |
pboro | Dejan, really? wtf :) they didn't teach that on my swedish lessons :( | 08:43 |
Dejan | sa, du kan svenska? ;) | 08:43 |
siman01 | I spent about a month with the living nightmare that is dateformats on a customer migration project - now hate it more than unicode | 08:44 |
pboro | Dejan, naturligtvis! | 08:44 |
Dejan | that format is IMHO the best date/time format human kind came with | 08:44 |
Dejan | because it is sorted by default | 08:44 |
pboro | Dejan, svenska is the second official language in Finland | 08:44 |
Dejan | if you know what i mean... | 08:44 |
Dejan | i always use it | 08:45 |
DarylM | The 9.3 documentation specifically states yyyy-mm-dd is acceptable ISO4 input format | 08:45 |
Dejan | DarylM: probably | 08:45 |
Dejan | my client is 10 | 08:45 |
Dejan | and server is 2.6 | 08:46 |
Dejan | when i set ISO4 and do date('now') it returns something like '20091010 10:00:00' | 08:46 |
DarylM | Although Ingres has one of the finest (IMHO) compatibility records between clients and servers, you obviously cannot use Ingres 10 features against an Ingres 2.6 (technically 8) server. I don't really know which of these various date abilities actually showed up in each version. | 08:47 |
bonsaikitten | siman01: be glad if you never have to parse emails | 08:49 |
bonsaikitten | that makes dates look trivial ;) | 08:49 |
pboro | or do any other character set processing either... | 08:50 |
siman01 | ok yes email headers are notorious | 08:50 |
* DarylM thinks of an old Chicago song: "Does anyone really know what time it is? Does anyone really care; about time" | 08:50 | |
bonsaikitten | pboro: most character sets are well defined | 08:53 |
grantc | i did when my alarm went off 1 hour earlier than it should have.. damn smart phone adjusted the clock for the change in DST but also pushed the alarm back | 08:53 |
bonsaikitten | email ... just because the encoding of that field is mandatory doesn't mean anyone has to use the right one ;) | 08:53 |
siman01 | id include char set processing with unicode encode/decode so I have a scale of avoidance: email headers > dateformat/callender locals > unicode encode decode | 08:54 |
*** ccsidiot has joined #ingres | 08:59 | |
ccsidiot | Hey | 08:59 |
ccsidiot | I'm trying to follow this http://community.ingres.com/wiki/Drupal_on_Ingres_Documentation | 09:00 |
ccsidiot | and revise my steps see if anything is wrong | 09:00 |
ccsidiot | On the wiki, it says that | 09:00 |
ccsidiot | Add an apache user to Ingres, then create a database named drupal with the apache user | 09:00 |
ccsidiot | * Note: If your apache installation uses a different user name, please adjust as needed | 09:00 |
grantc | ccsidiot: that's correct | 09:01 |
grantc | on windows the user is "system" if you are running apache as a service | 09:01 |
ccsidiot | Does it mean that the user name under Apache = windows account user name | 09:01 |
grantc | yup | 09:01 |
grantc | its the process owner as indicated in the task manager | 09:01 |
ccsidiot | and that should be equal to the user name for the database that I have created under Ingres II | 09:02 |
grantc | it does not need to equal the db owner but it does make life easier | 09:03 |
ccsidiot | Grant, I saw your reply and Andrew's to my questions on mailing list, I have Drupal 6.14 now, and phpinfo(); does not have a SECTION about ingres | 09:03 |
ccsidiot | Right now, I'm stepping through the wiki see if I've done anything wrong | 09:04 |
Dejan | ccsidiot: did you put ingres extension into the php.ini ? | 09:11 |
Dejan | if you did, then even from the console window "php -m" will list "ingres" among other modules | 09:12 |
ccsidiot | Yes, I have the line extension=php_ingres.dll | 09:12 |
ccsidiot | and plus the cygwin GNU plugins for windows cmd does not come with php commands | 09:13 |
ccsidiot | So when I type php -m it gives me nothing | 09:13 |
ccsidiot | nothing as in it does not recognise php as a command that it can execute | 09:14 |
ccsidiot | although my PATH variable has C: | 09:14 |
ccsidiot | So I'm suspecting maybe I have done something silly when I'm stepping through the wiki page | 09:15 |
ccsidiot | :p | 09:15 |
ccsidiot | Let me double check them first | 09:15 |
ccsidiot | Like the other day I had the extension_dir=C:/php/ext when it should be C:\php\ext | 09:17 |
ccsidiot | So when I'm creating an Apache User | 09:18 |
ccsidiot | Is there a specific filename that I need to put in when I type the following command: htpasswd -cbm filename.txt user pass | 09:18 |
ccsidiot | ? | 09:18 |
*** siman01 has quit IRC | 09:22 | |
pboro | bonsaikitten, yeah the problem is the missing header for the character set... or... wrong header | 09:22 |
*** DerMeister has joined #ingres | 09:33 | |
*** toumi02 has joined #ingres | 09:37 | |
grantc | ccsidiot: what do you get running \php\php.exe -m ? | 09:39 |
*** toumi02 has quit IRC | 09:40 | |
ccsidiot | php is not recognized as an internal or external command, operable program or batch file | 09:40 |
ccsidiot | OOps | 09:41 |
ccsidiot | In the wrong directotry | 09:41 |
*** toumi02 has joined #ingres | 09:41 | |
ccsidiot | I see a list of [PHP Modules] | 09:42 |
ccsidiot | and Ingres is not on it | 09:42 |
*** toumi02 has left #ingres | 09:42 | |
*** toumi01_ has joined #ingres | 09:45 | |
*** toumi01 has quit IRC | 09:46 | |
*** toumi01_ has quit IRC | 09:46 | |
*** toumi01 has joined #ingres | 09:46 | |
grantc | what about "echo "<?php ini_get('extension_dir'); ?>" | php | 09:50 |
ccsidiot | C:\php\ext | 09:51 |
ccsidiot | and I have php_ingres.dll inside that directory | 09:52 |
Dejan | did you edit php.ini ? | 09:53 |
Dejan | properly | 09:53 |
ccsidiot | I have extension_dir=C:\php\ext and this line extension=php_ingres.dll | 09:54 |
Dejan | than you must have ingres in the list of modules... | 09:54 |
ccsidiot | But it's not :( | 09:54 |
Dejan | try to use absolute path | 09:54 |
ccsidiot | in extension_dir? | 09:55 |
ccsidiot | That's already an absolute path | 09:55 |
ccsidiot | isn't it? | 09:55 |
ccsidiot | or absolute path of something else? | 09:55 |
Dejan | absolute path would be something like this in php.ini | 09:56 |
Dejan | [PHP_INGRES] | 09:56 |
Dejan | extension=C:\php\ext\php_ingres.dll | 09:56 |
ccsidiot | Okay, let me try | 09:57 |
ccsidiot | :) | 09:57 |
grantc | the path is relative to the extension dir setting | 09:58 |
grantc | you can use either unix or windows dir separators | 09:59 |
ccsidiot | Okay, I tried extension=C:\php\ext\php_ingres.dll and restarted Apache, ran this command: C:\php\php.exe -m | grep ingres, gives me nothing | 10:00 |
grantc | and the command C:\php\php.exe gives no errors¿ | 10:01 |
Dejan | does it list other modules? | 10:01 |
ccsidiot | Yes, no errors | 10:02 |
ccsidiot | Yes, it lists other modules | 10:02 |
grantc | on windows it will as there are many static modules | 10:02 |
ccsidiot | like SimpleXML, zip, zlib | 10:02 |
Dejan | khm, try to add C:\php\ext into the path | 10:02 |
Dejan | or hell, it could be that you do not have ingres libraries | 10:02 |
ccsidiot | I do @@ | 10:02 |
grantc | do you have PHPRC defined? | 10:02 |
Dejan | do you have libs in the path? | 10:02 |
ccsidiot | have php_ingres.dll in C:\php\ext | 10:03 |
grantc | Dejan: adding the ext dir to the path is not needed | 10:03 |
Dejan | grantc: Ingres libraries | 10:03 |
grantc | then she would get erros | 10:03 |
ccsidiot | Grant: What does PHPRC refer to? | 10:04 |
Dejan | maybe something in php.ini prevents from showing errors for modules that could not be loaded | 10:04 |
grantc | it can be used to override the location of the php.ini file | 10:04 |
grantc | i believe it's a windows only setting | 10:04 |
Dejan | omg | 10:04 |
Dejan | it could be that she has php.ini | 10:04 |
Dejan | in windows directory | 10:04 |
Dejan | i think that is the prefered place | 10:04 |
Dejan | i do not remember | 10:05 |
Dejan | i do not use php on windows that often | 10:05 |
grantc | if you have used the standard php installer the ini file is in \windows as Dejan just said | 10:05 |
grantc | what does "\php\php.exe -i | grep php.ini" give? | 10:05 |
ccsidiot | It gives "Configuration File(php.ini) Path => C:\WINDOWS" | 10:06 |
Dejan | that is it! | 10:06 |
Dejan | :D | 10:06 |
Dejan | we nailed the problem :D | 10:07 |
ccsidiot | :D I don't quite understand though | 10:07 |
Dejan | copy C:/php/php.ini into C:/Windows/ | 10:07 |
Dejan | and that is all | 10:07 |
Dejan | or better edit C:/Windows/php.ini | 10:08 |
Dejan | (i would do that actually | 10:08 |
Dejan | ) | 10:08 |
grantc | or what do you see with "\php\php.exe -c php.ini -m" | 10:08 |
Dejan | that should work | 10:08 |
Dejan | definitely | 10:08 |
Dejan | or give error in case ingres dlls are not found... | 10:09 |
ccsidiot | Grant: It give me a list of PHP Modules, that does not have Ingres on it. Dejan: Let me try your way | 10:09 |
ccsidiot | :) | 10:09 |
*** mull has quit IRC | 10:11 | |
*** mull has joined #ingres | 10:13 | |
ccsidiot | Grant, Dejan: Yay :) I copied the php.ini to C:\WINDOWS, and now when I do \php\php.exe -m it gives me erro | 10:14 |
ccsidiot | *error | 10:15 |
ccsidiot | :D Hurray, error! | 10:15 |
grantc | and the error is? | 10:15 |
ccsidiot | The error says PHP Warning: PHP Startup: ingres: Unable to initialize module | 10:15 |
grantc | strange... | 10:15 |
ccsidiot | Module compiled with module API=20090626, debug=0, thread-safety=1 | 10:16 |
ccsidiot | PHP compiled with module API=20071006, debug=0, thread-safety=1 | 10:16 |
grantc | and the values for PHP? | 10:16 |
grantc | which version of PHP do you have? | 10:16 |
ccsidiot | PHP 5.3 | 10:17 |
grantc | nope not with that api version | 10:17 |
grantc | php -v | 10:17 |
Dejan | ccsidiot: that is good | 10:17 |
* grantc thinks php on windows sucks | 10:17 | |
Dejan | that means that you do not have ingres dlls in the parth | 10:18 |
grantc | no it does not - the dll was built for php 5.3 and ccsidiot has an earlier version not 5.3 | 10:18 |
grantc | there is a sanity check in php that makes sure the APIs are compatible | 10:18 |
grantc | i guess it's 5.2.x | 10:18 |
Dejan | wait | 10:18 |
Dejan | C:\Users\dejan>php -ver | 10:19 |
Dejan | PHP 5.3.0 (cli) (built: Jun 29 2009 21:55:01) | 10:19 |
ccsidiot | php -v gives me: A few lines with those warning that the ingres module is unable to initialized, then follow by PHP 5.3.0alpha3-dev (cli) built:Sep 25 2008 11:02:14 | 10:19 |
Dejan | that is what i have | 10:19 |
Dejan | and ingres works like a charm | 10:19 |
Dejan | i had to install it because of netbeans | 10:19 |
Dejan | so i can run PHP scripts and debug them directly here on windows workstation | 10:20 |
grantc | the dll was built using the final release of PHP not an alpha release | 10:20 |
grantc | i guess they've changed the API level | 10:20 |
Dejan | probably | 10:20 |
ccsidiot | Okay, let me go back and grab that version of PHP | 10:21 |
ccsidiot | :) | 10:21 |
ccsidiot | Since those guys from PHP told me not to install PHP 6 since it's still buggy, and I grab off the 5.3 latest one | 10:22 |
ccsidiot | Apparently I didn't know it's alpha | 10:22 |
ccsidiot | @@ | 10:22 |
ii_log | ccsidiot: Error: "@" is not a valid command. | 10:22 |
grantc | php 6 is not even a twinkle in anyone's eyes it's at least 1-2 years away from release | 10:24 |
ccsidiot | Time to go class :( Dejan, Grant: Thanks so much !!! Let me try and let you guys know about the result as soon as I can | 10:24 |
grantc | no problem - i am outta here time to buy another replacement hard disk :( | 10:25 |
Dejan | ccsidiot: good luck :) | 10:27 |
Dejan | ccsidiot: it 5.3.0 works for me | 10:27 |
Dejan | if* | 10:27 |
Dejan | then it will work for you | 10:27 |
*** toumi01 has left #ingres | 10:28 | |
*** toumi01 has joined #ingres | 10:28 | |
*** toumi01 is now known as toumi02 | 10:29 | |
*** toumi02 is now known as toumi01__ | 10:29 | |
*** toumi01__ is now known as toumi03 | 10:30 | |
*** toumi03 is now known as toumi01 | 10:30 | |
*** cthibert has quit IRC | 10:48 | |
*** ccsidiot has quit IRC | 11:48 | |
*** grantc has quit IRC | 12:26 | |
*** Dejan has quit IRC | 12:29 | |
*** atrofast has quit IRC | 12:30 | |
*** atrofast has joined #ingres | 14:19 | |
*** DerMeister has quit IRC | 14:58 | |
*** toumi01 has left #ingres | 15:26 | |
*** mull has quit IRC | 15:44 | |
*** ccsidiot has joined #ingres | 17:44 | |
*** ccsidiot has quit IRC | 19:05 | |
*** ccsidiot has joined #ingres | 19:05 | |
*** zxiiro has quit IRC | 19:07 | |
*** zxiiro has joined #ingres | 20:12 | |
*** ChanServ sets mode: +v zxiiro | 20:12 | |
*** cytrinox_ has joined #ingres | 20:20 | |
*** cytrinox has quit IRC | 20:36 | |
*** cytrinox_ is now known as cytrinox | 20:36 | |
*** rossand has joined #ingres | 20:41 | |
*** ChanServ sets mode: +o rossand | 20:41 | |
*** dyki has quit IRC | 20:42 | |
*** ccsidiot has quit IRC | 23:37 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!