| *** Gerhard has joined #ingres | 00:01 | |
| *** Mud|afk has joined #ingres | 00:18 | |
| *** Mud|afk is now known as Mud | 00:27 | |
| *** PaulM05 has joined #ingres | 00:56 | |
| PaulM05 | morning all | 00:56 |
|---|---|---|
| *** Dejan has joined #ingres | 01:21 | |
| *** Dejan has quit IRC | 02:11 | |
| *** PaulM05 has quit IRC | 02:11 | |
| *** Dejan has joined #ingres | 02:13 | |
| *** PaulM05 has joined #ingres | 02:13 | |
| *** cthibert has joined #ingres | 03:29 | |
| *** Gerhard has left #ingres | 03:44 | |
| *** grantc has joined #ingres | 03:51 | |
| *** ChanServ sets mode: +o grantc | 03:51 | |
| *** atrofast has joined #ingres | 04:59 | |
| *** zxiiro has quit IRC | 05:07 | |
| *** PaulM05 is now known as Paul_lunch | 05:11 | |
| *** FrankW has joined #ingres | 05:33 | |
| *** Mary_ has joined #ingres | 05:54 | |
| *** raial01 has joined #ingres | 06:04 | |
| *** rossand has joined #ingres | 06:11 | |
| *** ChanServ sets mode: +o rossand | 06:11 | |
| *** zxiiro has joined #ingres | 06:15 | |
| *** ChanServ sets mode: +v zxiiro | 06:15 | |
| *** cthibert has quit IRC | 06:16 | |
| *** Paul_lunch has quit IRC | 06:16 | |
| *** Dejan has quit IRC | 06:16 | |
| *** Dejan has joined #ingres | 06:20 | |
| *** cthibert has joined #ingres | 06:21 | |
| *** thoda04 has joined #ingres | 06:21 | |
| *** Dejan is now known as Guest93733 | 06:21 | |
| *** Guest93733 is now known as Deyan | 06:24 | |
| *** cthibert has left #ingres | 06:32 | |
| *** cthibert has joined #ingres | 06:51 | |
| *** PaulM05 has joined #ingres | 06:55 | |
| *** ccsidiot has joined #ingres | 07:09 | |
| *** SaraDanaher has joined #ingres | 07:30 | |
| *** SaraDanaher has quit IRC | 07:32 | |
| *** raial01 has quit IRC | 07:32 | |
| *** cthibert has quit IRC | 07:32 | |
| *** rossand has quit IRC | 07:32 | |
| *** FrankW has quit IRC | 07:32 | |
| *** Mud has quit IRC | 07:32 | |
| *** dyki has quit IRC | 07:32 | |
| *** pboro has quit IRC | 07:32 | |
| *** grantc has quit IRC | 07:32 | |
| *** PaulM05 has quit IRC | 07:32 | |
| *** Deyan has quit IRC | 07:32 | |
| *** zxiiro has quit IRC | 07:32 | |
| *** atrofast has quit IRC | 07:32 | |
| *** clach04 has quit IRC | 07:32 | |
| *** Deyan has joined #ingres | 07:33 | |
| *** zxiiro has joined #ingres | 07:33 | |
| *** irc.freenode.net sets mode: +v zxiiro | 07:33 | |
| *** rossand has joined #ingres | 07:33 | |
| *** SaraDanaher has joined #ingres | 07:33 | |
| *** PaulM05 has joined #ingres | 07:33 | |
| *** cthibert has joined #ingres | 07:33 | |
| *** raial01 has joined #ingres | 07:33 | |
| *** FrankW has joined #ingres | 07:33 | |
| *** grantc has joined #ingres | 07:33 | |
| *** Mud has joined #ingres | 07:33 | |
| *** pboro has joined #ingres | 07:33 | |
| *** dyki has joined #ingres | 07:33 | |
| *** irc.freenode.net sets mode: +oo rossand grantc | 07:33 | |
| *** atrofast has joined #ingres | 07:34 | |
| *** withdefault has joined #ingres | 07:35 | |
| *** ChanServ sets mode: +o withdefault | 07:35 | |
| SaraDanaher | i am trying to install the drupal and i have error when i am trying to enter the user name and database | 07:36 |
| SaraDanaher | i got this message: Failed to connect to your Ingres database server. Ingres reports the following | 07:37 |
| * grantc is away: Away | 07:38 | |
| SaraDanaher | i am using linux system (Ubuntu) | 07:38 |
| withdefault | what does ingres report? | 07:38 |
| SaraDanaher | well i am trying to install drupal and this information i am entering is on drupal | 07:40 |
| SaraDanaher | i get this message: Failed to connect to your Ingres database server. Ingres reports the following | 07:41 |
| withdefault | there are a number of levels of failed to connect | 07:43 |
| withdefault | - the ingres dbms server isn't started | 07:43 |
| withdefault | - the process that is trying to connect doesn't have the ingres environment | 07:43 |
| withdefault | - the credentials used to connect aren't correct | 07:43 |
| SaraDanaher | well if i do the accessdb i can see my data base drupal | 07:45 |
| SaraDanaher | and the owner drupal | 07:47 |
| *** rossand has quit IRC | 07:47 | |
| Deyan | withdefault: are ingres builds tagged in svn? | 07:49 |
| Deyan | withdefault: for an example, the current build 112 | 07:50 |
| SaraDanaher | yes | 07:50 |
| Deyan | good, because i would like to build it on my machine with exactl source tree | 07:50 |
| SaraDanaher | i believe just make sure how i can double check? | 07:50 |
| withdefault | deyan, there are tags you can see them here http://code.ingres.com/ingres/tags/ | 07:51 |
| Deyan | brilliant | 07:51 |
| withdefault | SaraDanaher, is there an operating system user drupal created? Ingres will use that user to authenticate | 07:52 |
| SaraDanaher | yes | 07:53 |
| Deyan | or, did you setup ingvalidpw properly? | 07:53 |
| Deyan | if i remember well, it needs setuid bit set | 07:53 |
| SaraDanaher | when i created the data base using the command "createdb -udrupal drupal" | 07:54 |
| SaraDanaher | now if i enter the command "accessdb" i can see the database drupal and owner drupal | 07:54 |
| Deyan | did you try to use it as "drupal" user? | 07:55 |
| SaraDanaher | yes | 07:55 |
| Deyan | it works? | 07:55 |
| SaraDanaher | no | 07:55 |
| SaraDanaher | i get this message: Failed to connect to your Ingres database server. Ingres reports the following | 07:55 |
| Deyan | ok, first test this: | 07:56 |
| Deyan | whether ingvalidpw tool has setuid bit set | 07:56 |
| Deyan | and root:ingres ownership | 07:56 |
| Deyan | -rwsr-xr-x 1 root ingres 19201 2009-11-25 11:30 ingvalidpam | 07:57 |
| Deyan | -rwsr-xr-x 1 root ingres 13275 2009-11-27 11:55 ingvalidpw | 07:57 |
| Deyan | it should be like this | 07:57 |
| Deyan | these two files are in II_SYSTEM/ingres/bin directory | 07:58 |
| SaraDanaher | ok thanks let me go and check it out | 07:58 |
| withdefault | you should also run | 07:58 |
| withdefault | ingprenv II_SHADOW_PWD | 07:58 |
| Deyan | SaraDanaher: if these two files have correct ownerships and modes | 07:59 |
| Deyan | than make sure you have drupal user | 07:59 |
| Deyan | SYSTEM user | 07:59 |
| Deyan | Ingres by default requires a system user | 07:59 |
| * Deyan wishes a nice syntax for working with days and intervals | 08:00 | |
| Deyan | so i can do like in MySQL: SELECT '2009-12-19' + INTERVAL 2 DAYS; | 08:01 |
| Deyan | instead i need to use interval('days', blabla...) | 08:01 |
| PaulM05 | select '27-nov-2009' + '2 days' should work | 08:02 |
| * Deyan is going to try that out | 08:03 | |
| Deyan | ty PaulM05 \o/ | 08:03 |
| PaulM05 | np | 08:03 |
| Deyan | between you and me, documentation about INTERVAL should cover more examples | 08:04 |
| PaulM05 | possibly - haven't looked at it recently | 08:04 |
| PaulM05 | even though I am currently fixing a date-format related bug! | 08:04 |
| Deyan | result: 27-nov-20092 days | 08:05 |
| PaulM05 | what's your II_DATE_FORMAT? | 08:05 |
| Deyan | it concatenated the strings | 08:05 |
| Deyan | :D | 08:05 |
| PaulM05 | yeah it's done that because it doesn't recognise 27-nov-2009 as a valid input format for your date format so it's assumed it's a string | 08:06 |
| Deyan | select date('27-nov-2009') + '2 days'; | 08:06 |
| Deyan | this worked though | 08:06 |
| Deyan | which is fine | 08:06 |
| Deyan | i can live with it | 08:06 |
| Deyan | < PaulM05> select '27-nov-2009' + '2 days' should work | 08:07 |
| Deyan | that one just concatenated those two strings | 08:07 |
| PaulM05 | see comment re date format | 08:07 |
| Deyan | ok, let me see | 08:07 |
| PaulM05 | brb | 08:08 |
| Deyan | "worked" | 08:08 |
| Deyan | 2009-11-272 days | 08:08 |
| Deyan | ah, no | 08:08 |
| *** Mud has quit IRC | 08:08 | |
| Deyan | again concatenation | 08:08 |
| Deyan | nah, does not work | 08:09 |
| Deyan | but ok, date('27-nov-2009') + '2 days' does work | 08:09 |
| Deyan | which is fine | 08:09 |
| PaulM05 | it's all about date formats - read up on II_DATE_FORMAT | 08:09 |
| PaulM05 | but if you're happy with that... ;) | 08:10 |
| Deyan | i do not have it set at all | 08:10 |
| Deyan | just timezone | 08:10 |
| Deyan | it uses default date format | 08:11 |
| Deyan | which, i hope, is ISO or ISO4 | 08:11 |
| PaulM05 | is it set in ingprenv? | 08:12 |
| withdefault | Deyan, try this select ansidate('2009-11-27') + interval_dtos('2 days')\g | 08:14 |
| Deyan | PaulM05: nope | 08:14 |
| Deyan | ingprenv does not list it | 08:14 |
| Deyan | withdefault: select date('27-nov-2009') + '2 days' | 08:14 |
| Deyan | this works well | 08:14 |
| PaulM05 | should default to US then which DD-MMM-CCYY is | 08:14 |
| Deyan | select date('2009-11-27') + '2 days' works too | 08:15 |
| Deyan | i really think select '27-11-2009' + '2 days' should always return a string though... | 08:16 |
| Deyan | not a date | 08:16 |
| Deyan | :D | 08:16 |
| PaulM05 | :) | 08:28 |
| PaulM05 | you're right, you'd always need date(' ') around it in that context - my mistake - I blame too much multi-tasking! | 08:34 |
| *** Mud|afk has joined #ingres | 08:36 | |
| Deyan | yeah, so ingres can do implicit type conversion | 08:49 |
| PaulM05 | yes | 08:50 |
| *** cthibert has left #ingres | 09:13 | |
| *** cthibert has joined #ingres | 09:15 | |
| *** Deyan has quit IRC | 09:25 | |
| *** raial01 has quit IRC | 09:28 | |
| *** grantc has quit IRC | 09:34 | |
| *** DerMeister has joined #ingres | 10:15 | |
| *** ccsidiot has quit IRC | 10:45 | |
| *** SaraDanaher has quit IRC | 10:45 | |
| *** PaulM05 has quit IRC | 10:58 | |
| *** withdefault has left #ingres | 11:19 | |
| *** cthibert has left #ingres | 12:18 | |
| *** rossand has joined #ingres | 12:32 | |
| *** ChanServ sets mode: +o rossand | 12:32 | |
| *** zxiiro has quit IRC | 14:12 | |
| *** DerMeister has quit IRC | 14:33 | |
| *** zxiiro has joined #ingres | 14:52 | |
| *** ChanServ sets mode: +v zxiiro | 14:52 | |
| *** Mud|afk has quit IRC | 17:41 | |
| *** cytrinox_ has joined #ingres | 19:21 | |
| *** cytrinox has quit IRC | 19:37 | |
| *** cytrinox_ is now known as cytrinox | 19:37 | |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!