Monday, 2009-11-30

Mudyes00:01
MudI have script (/etc/setvar)00:02
Mudthat I run when a user logons00:02
MudI will run that before the real scrip starts00:02
Mudgrantc: I will let ya know the results00:03
grantcok00:03
Mudgrantc: nop didnt work :<00:04
Mudhmm00:05
Mudmaybe I need to do sh /etc/setvar00:06
Mudand not . /etc/setvar00:06
grantci do . /env/script00:06
Mudhmm00:06
grantce.g. http://ingres.pastebin.com/d1deb031000:07
Mudyes I do that too in my /etc/profile00:07
Mudwhy you do : #!/bin/bash ?00:07
grantcbecause it's a bash script00:07
Mudok wait..00:08
grantci guess it depends on what the default shell is for cron, sh perhaps?00:08
grantcon some systems sh != bash ubuntu for example00:08
Mudyou have a script /etc/blabla and that baste-bin is in that file?00:08
Mudhhmm00:12
MudI tried some things now00:12
MudI will keep you posted00:12
Mudits working00:15
Mudthanx grantc!00:15
Mud\o/00:15
Mudlove ya man <300:15
grantcno problem00:15
Mudgonna work on project  (collega is here)00:15
Mud:W00:15
GerhardMud: concerning your crontab problem...00:30
Gerhardthere is a /home/ingres/.ingIIbash that contains the environment variables for user ingres00:31
Gerhard...one moment, telephone call, will come back in few minutes...00:32
Mudnop, I dont have that file Gerhard :P00:42
MudI created manually /etc/setvar00:42
GerhardMud: strange, I think the Ingres installer always creates that file...? At least the RPM-based installers....00:56
MudGerhard: I had the same issue (home folder) on my test machine01:02
Mudwhat I did as sudo ingres_express_installer.sh01:02
MudI did a chown ingres:ingres on /opt/IngresII/01:02
Mudso ingres user can do ingstart01:03
GerhardDo you have a /home/ingres/.bashrc file? Is /bin/bash the login shell for ingres?01:04
MudGerhard: yes I have a .bashrc in /home/ingres01:14
MudGerhard: the strange part also in under my ingres account01:16
Mudthat I cant do /etc/ph[tab]01:16
Mudthe tab function doesnt work01:17
Mudalso when I do arrow up, I get weird tokens01:17
Mudinstead of the history of commands01:17
grantcdoes 'ps' show you with the bash shell?01:19
grantce.g. http://ingres.pastebin.com/f66be6b6701:19
Gerhardif you do a "printenv | grep II_SYSTEM" in a command shell, what is the output?01:25
Mud$ ps01:26
MudPID TTY TIME CMD01:26
Mud18331 pts/2 00:00:00 sh01:26
Mud18333 pts/2 00:00:00 ps01:26
Mud$01:26
Mudthat one is working Gerhard :)01:26
Mudthe cronjob is working now btw Gerhard, only have that small issue on my ingres account01:27
GerhardOK.01:27
GerhardDon't know if still of interest but my way for crontab is to use01:28
Gerhard( source /home/ingres/.bashrc ; /mydir/myjob.sh )01:29
Gerhardinstead of just01:29
Gerhardinstead of just /mydir/myjob.sh01:29
Mud:?01:32
Mudwhy is that Gerhard01:32
grantcMud which operating system are you on?01:35
Mudubuntu 8.0401:36
Mudlts01:36
Mudits a production server, so I cant upgrade for a sec (it has serveral important webapps running on it)01:37
Mudgrantc: tried shell=/bin/bash under my ingres account01:39
Mudbut didnt helped01:39
Mudthe strange part is, that I have a 'administrator' account (it can the permission to sudo) and that one is working perfectly01:40
grantcI cannot remember when but from a particular Ubuntu release sh became symlinked to dash and not bash01:40
grantc@googe ubuntu sh as dash01:40
ii_loggrantc: Error: "googe" is not a valid command.01:40
grantc@google ubuntu sh as dash01:40
ii_loggrantc: DashAsBinSh - Ubuntu Wiki: <https://wiki.ubuntu.com/DashAsBinSh>; Dash as /bin/sh : Ubuntu: <https://launchpad.net/ubuntu/+spec/dash-as-bin-sh>; [ubuntu/karmic] dash 0.5.5.1-2ubuntu1 (Accepted): <https://lists.ubuntu.com/archives/karmic-changes/2009-April/000181.html>; Idea #2225: "Make /bin/sh = bash (solves zillions of issues ...: <http://brainstorm.ubuntu.com/idea/2225/>; install.sh failing at (1 more message)01:40
Mudke ke :)01:40
Mud[10:43:29] <grawity> Mud: chsh -s /bin/bash theusername did fix the problem01:46
Mud@ grantc01:48
ii_logMud: Error: "grantc" is not a valid command.01:48
grantcthat's one way to change the shell01:49
grantcyou can reset the OS so that the default shell is bash not dash as well01:49
Mudke ke :)01:51
Mudgrantc: I will google a bit :)02:00
Mudhehe02:00
Mudgrantc: first hit02:00
Mudhttp://linuxwave.blogspot.com/2009/03/changing-default-shell-in-ubuntu.html02:00
*** Dejan has joined #ingres02:04
Dejanhello everyone02:04
Mudhi02:05
Mudsup/02:05
Mud?02:05
Dejanwork work work02:05
Mud:)02:05
Mudme too here :/02:05
Mudfixing little issues02:05
Mudetc02:05
Mudneed to document a lot02:06
Dejani am finalising a large class built around JTable...02:07
Dejanwhich basically gives me ability to filter content in various ways02:07
Dejanin a fashion similar to Excel's pivot table feature02:07
Mudhehe I am not a ingres user :P I am using ingres only for some little ingres query on a remote machine :P02:09
Mudwhats Jtable?02:09
Mudlike a mysql table?02:09
Mudor something like a php class :)02:09
Dejanit is a Java table widget (GUI stuff)02:18
Mudhmm02:19
Mudok02:19
*** Adross has quit IRC02:53
*** FrankW has joined #ingres04:13
*** Gerhard has quit IRC04:17
*** Gerhard has joined #ingres04:47
GerhardHi all04:47
grantcmorning04:48
*** zxiiro has quit IRC04:50
GerhardI'd like to see a networked version of the command "relocatedb db1 -new_database=db"04:50
Gerhardlike "relocatedb db1 -new_database=another_server::db2"04:51
grantc:)04:51
GerhardIn MySQL you can pipeline mysqldump's output into an ssh session  --> network copying a db in just one command line...04:54
grantcthat's hardly relocating a database... but still05:01
GerhardYes, I know that relocatedb has some other usages but db copying is my favorite one05:02
GerhardLet's say you have a developer PC with between 10 and 20 DBs migrating to a new PC can be a PITA with unload / reload...05:08
grantcsure - there's no easy solution short of shutting down the server and copying across the data location ...05:12
*** cthibert has joined #ingres05:31
Gerhardgrantc: you mean directly copying II_DATABASE location of source server into II_DATABASE location of target server?05:39
grantcyup - assuming the locations are the same etc..05:39
grantcstill not as clean as the mysql soln05:39
*** zxiiro has joined #ingres05:42
*** ChanServ sets mode: +v zxiiro05:42
GerhardHas nobody ever thought about a mysqldump style utility for Ingres? I mean exporting data into a text file that consists only of SQL statements...05:59
*** rossand has joined #ingres06:01
*** ChanServ sets mode: +o rossand06:01
grantcI've not thought of it - although it would be an interesting project for a sprint or some such event...06:09
*** atrofast has joined #ingres06:14
*** DarylM has joined #ingres06:22
DejanGerhard: that would be a huge thing06:33
DejanGerhard: PS. Ingres does not (yet) have bulk inserts06:33
Dejanso that dump would contain maaaaany INSERTS06:33
Dejani mean, multiple inserts06:34
*** Alex| has quit IRC06:41
*** cthibert has left #ingres07:02
*** cthibert has joined #ingres07:05
*** mull has joined #ingres07:14
*** Mud|game has joined #ingres07:20
GerhardDejan: yes, I know that dump file would be large, one insert into... statement for each row, like in MySQL.07:21
*** grantc has quit IRC07:22
*** grantc has joined #ingres07:22
*** ChanServ sets mode: +o grantc07:22
DejanIt would be great if Redmine could be configured to use Ingres07:26
Dejanif Redmine was not a Ruby-based project, I might do the Ingres support myself... :D07:27
*** Gerhard has quit IRC07:29
grantcfeel free to try out the latest RoR incantation for Ingres - I've not tried it with Redmine so I would be interested in any feedback07:31
*** Mud has quit IRC07:31
*** FrankW has quit IRC07:44
DarylMSpeaking of Ruby, doesn't the activerecord adapter require a primary key definition?07:46
*** dyki has quit IRC07:47
*** dyki has joined #ingres07:48
grantcas it stands right now yes it does and will do going forward, although there is a client that is not using a PK constraint07:49
DarylMactiverecord seems to have a set_primary_key method07:50
grantcso you can set the name, from reading the source, much the same way you can override the tablename07:53
*** zxiiro has quit IRC07:53
*** zxiiro has joined #ingres07:54
*** ccsidiot has joined #ingres07:54
*** ChanServ sets mode: +v zxiiro07:54
*** bonro011 has quit IRC08:20
*** bonro01 has joined #ingres08:20
*** Mud|game has quit IRC08:20
*** Mud has joined #ingres08:44
*** atrofast has quit IRC08:46
*** atrofast has joined #ingres08:47
*** dyki has quit IRC09:25
*** dyki has joined #ingres09:28
ccsidiotHey everyone, I was trying to make sense to myself to the TODO parts error messages in adupoint.c09:44
ccsidiotI boiled down that the function GEOSWKBWriter_write_r returns null definitely when the handle that we passed in is null when a thread-safe library is used09:46
ccsidiotSo I think I need to add 1 more error checking to the code other than modifying error messages, is that okay?09:47
ccsidiot:)09:47
ccsidiotI'm not sure am I supposed to just improving the meaning of error messages or actually do the modification to the code base09:48
*** FrankW has joined #ingres09:52
*** grantc has quit IRC10:19
*** ccsidiot has left #ingres10:36
*** thiagomz has joined #ingres10:43
*** clach04 has joined #ingres10:44
*** thiagomz has quit IRC10:59
*** rossand1 has joined #ingres12:46
*** cthibert has left #ingres13:02
*** rossand has quit IRC13:02
*** rossand1 has quit IRC13:04
*** Mud has quit IRC13:05
*** rossand has joined #ingres13:23
*** ChanServ sets mode: +o rossand13:23
*** zxiiro has quit IRC13:40
*** zxiiro has joined #ingres14:26
*** ChanServ sets mode: +v zxiiro14:26
*** atrofast has quit IRC15:13
*** mull has quit IRC15:35
*** SaraDanaher has joined #ingres16:56
SaraDanaherhi everyone,16:58
SaraDanaheri am installing Drupal and i got an error during install site16:59
SaraDanaherthis the error Parse error: syntax error, unexpected '{' in /var/www/html/drupal/includes/menu.inc on line 315  Warning: query: UPDATE sessions SET uid = 0, cache = 0, hostname = '127.0.0.1', session = '', timestamp = 1258857616 WHERE sid = 'fc338c25d707262c88ddc741990890c1' in /var/www/html/drupal/includes/database.ingres.inc on line 28016:59
SaraDanahersorry i copyed the error17:01
SaraDanaherhere is the error again17:01
SaraDanaher      * user warning: line 1, Syntax error on ')'. The correct syntax is: OPEN CURSORID CURSOR FOR fullselect [FOR [DIRECT | DEFERRED] UPDATE OF column {, ... }] [FOR READONLY] query: SELECT * FROM menu_router WHERE path IN () ORDER BY fit DESC OFFSET 0 FETCH NEXT 1 ROWS ONLY in /var/www/html/drupal/includes/menu.inc on line 315.17:01
*** SaraDanaher has quit IRC17:07
*** rossand has quit IRC17:20
*** zxiiro has quit IRC18:47
*** zxiiro has joined #ingres18:48
*** ChanServ sets mode: +v zxiiro18:48
*** cytrinox_ has joined #ingres19:21
*** cytrinox has quit IRC19:36
*** cytrinox_ is now known as cytrinox19:36
*** zxiiro has quit IRC20:18
*** zxiiro has joined #ingres20:19
*** ChanServ sets mode: +v zxiiro20:19
*** zxiiro has quit IRC21:02
*** zxiiro has joined #ingres21:02
*** ChanServ sets mode: +v zxiiro21:02
*** FrankW has quit IRC22:26
*** bonro011 has joined #ingres22:47
*** grantc has joined #ingres22:52
*** ChanServ sets mode: +o grantc22:52
*** bonro01 has quit IRC22:53
*** Mud has joined #ingres23:29
Mudmorning all23:29
*** ii_log` has joined #ingres23:48
*** ii_log has quit IRC23:49

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