| pboro | I think that there's one in Community Wiki, lemme check | 00:00 |
|---|---|---|
| *** hanje04 has quit IRC | 00:00 | |
| pboro | http://community.ingres.com/wiki/Install | 00:02 |
| pboro | there's a movie how to install on Linux | 00:02 |
| pboro | also the Install Guide can be useful | 00:02 |
| Mud | ok coolw :) | 00:04 |
| Mud | thanx | 00:04 |
| Mud | ! | 00:04 |
| pboro | if you have trouble installing, just come here and ask :) | 00:05 |
| Mud | sure :) | 00:05 |
| Mud | what ingres version I should install? | 00:14 |
| Mud | 9.2? | 00:14 |
| pboro | I would recommend 9.3 or 9.2 | 00:14 |
| pboro | 10.0 is still under heavy development | 00:14 |
| Mud | ke | 00:16 |
| Mud | pboro: do i need take none RPM release | 00:20 |
| Mud | or the source? | 00:20 |
| pboro | RPM is for Red Hat, SuSE etc... lemme check if there's some other option, source is a bit evil since you will need to compile it yourself | 00:21 |
| Mud | I am running ubuntu 8.04 btw | 00:21 |
| pboro | I would try "Non-RPM format binaries" | 00:22 |
| pboro | "ingres-9.3.0-151-NPTL-gpl-pc-linux-ingbuild-i386.tgz" | 00:22 |
| pboro | that's a binary version that can be installed using a simple script (included) | 00:22 |
| Mud | ah coolw | 00:22 |
| Mud | ke ke | 00:22 |
| Mud | gonna get some thee | 00:22 |
| Mud | tea* | 00:23 |
| Mud | brb | 00:23 |
| Mud | back | 00:32 |
| Mud | hmm | 00:32 |
| Mud | that 9.3 release gets stuck on 70% (download) | 00:33 |
| Mud | 9.1 goes wel | 00:33 |
| Mud | shall I install 9.1 pboro? | 00:33 |
| *** hanje04 has joined #ingres | 00:35 | |
| pboro | Mud, I would not install 9.1, it's rather old already | 00:40 |
| *** hanje04 has quit IRC | 00:41 | |
| Mud | is there 9.3 on a mirror? | 00:42 |
| Mud | that downloads is keep getting stuck @ 70% | 00:42 |
| Mud | and the file on my hdd is 36MB, so thats also wrong | 00:42 |
| pboro | hmm I don't know about mirrors :/ | 00:43 |
| Mud | opera and IE both dont go futher then 70% :< | 00:44 |
| pboro | hmmh... lemme try that | 00:44 |
| pboro | 32- or 64-bit? | 00:45 |
| Mud | 32bit | 00:46 |
| Mud | hmm | 00:47 |
| Mud | IE finally downloaded it | 00:47 |
| Mud | the right size | 00:48 |
| Mud | I extract it right now | 00:48 |
| Mud | seems to be good | 00:48 |
| pboro | ah, good :) | 00:48 |
| Mud | ke gonna install it via the sh | 00:48 |
| Mud | long live snapshots on esx <3 | 00:53 |
| Mud | uh | 00:53 |
| Mud | what install I must do? | 00:53 |
| Mud | full installation? | 00:53 |
| Mud | I can choose 5 things >.> | 00:53 |
| Mud | - Full installation, - Ingres networked client, -Ingres networked DBMS server, - -Ingresnetwerked DBMS w/start and DBMS standalone | 00:54 |
| pboro | depends what you want to do :) if you're trying it first time, I would do full | 00:54 |
| Mud | well | 00:55 |
| Mud | I want to get apache2 working with a remote ingres DB | 00:55 |
| Mud | Vroomfondle explained yesterday that I must create local DB's that connects to the remote DB's | 00:55 |
| pboro | ok, so you're currently installing it on a web server and you only need to access database on other servers?? | 00:56 |
| pboro | -? | 00:56 |
| Mud | yes | 00:56 |
| Mud | thats correct | 00:56 |
| pboro | then you only need client installation, ie. no DBMS server but the libraries etc... lemme check if there's a wiki page for that :) | 00:57 |
| pboro | you're going to use PHP? | 00:57 |
| Mud | Yep | 00:57 |
| Mud | php5.2.x | 00:57 |
| pboro | hmm funny | 00:59 |
| *** Gerhard has joined #ingres | 00:59 | |
| pboro | i can't find any documentation on what components need to be installed in Ingres to make the Ingres PHP driver compile | 00:59 |
| Gerhard | Hi all | 00:59 |
| Mud | http://community.ingres.com/wiki/Ingres_with_Apache_on_Ubuntu this is all what I found | 01:00 |
| pboro | grantc, do you have a list of minimum components to install so that the PHP driver compiles? | 01:00 |
| Mud | php5 is already install btw | 01:00 |
| Mud | via apt-get install php5 | 01:00 |
| pboro | Mud, yeah, that page doesn't say anything about the Ingres configuration :( | 01:00 |
| Mud | indeed | 01:00 |
| Mud | shall I do a full installation then? | 01:00 |
| Mud | just to be sure | 01:01 |
| pboro | it's kind of overkill, but it will work | 01:01 |
| grantc | hi - sorry i was otherwise distracted | 01:03 |
| grantc | the min requirements for a usable PHP driver would be a net install | 01:03 |
| Mud | :? | 01:03 |
| Mud | installing Ingres now btw (full installation) | 01:04 |
| grantc | when doing an ingbuild/install you can select a "net installation" (not sure what the actual phrase is") | 01:04 |
| grantc | that'll work too :) | 01:04 |
| grantc | once you have ingres installed you can do : pecl install ingres | 01:04 |
| pboro | thanks grantc :) | 01:05 |
| grantc | it will pull the last release from http://pecl.php.net/ingres | 01:05 |
| Mud | okido :) | 01:05 |
| grantc | or you can go to http://pecl.php.net/get/ingres and it will download it for you | 01:05 |
| Mud | All installed products are now available for use. | 01:05 |
| grantc | before you install make sure you have II_SYSTEM in your local environment | 01:05 |
| grantc | it should say that in TFM | 01:06 |
| grantc | @google ingres php pecl installation | 01:06 |
| ii_log | grantc: PECL :: Package :: ingres: <http://pecl.php.net/package/ingres>; PHP Driver - Ingres Community Wiki: <http://community.ingres.com/wiki/PHP_Driver>; PHP and Ingres on OpenVMS with CSWS PHP 2.0 - Ingres Community Wiki: <http://community.ingres.com/wiki/PHP_and_Ingres_on_VMS>; PHP Manual: Ingres II Functions: <http://www.nusphere.com/kb/phpmanual/ref.ingres.htm>; PHP: Installation - Manual: (2 more messages) | 01:06 |
| grantc | http://www.php.net/manual/en/ingres.installation.php | 01:07 |
| grantc | brb | 01:07 |
| *** grantc has quit IRC | 01:07 | |
| *** grantc has joined #ingres | 01:07 | |
| *** ChanServ sets mode: +o grantc | 01:07 | |
| *** Gerhard has quit IRC | 01:12 | |
| Mud | grantc: | 01:12 |
| Mud | Starting to download ingres-2.2.1.tgz (86,547 bytes) | 01:12 |
| Mud | .....................done: 86,547 bytes | 01:12 |
| Mud | 10 source files, building | 01:12 |
| Mud | running: phpize | 01:12 |
| Mud | sh: phpize: not found | 01:12 |
| Mud | ERROR: `phpize' failed | 01:12 |
| grantc | you need the php dev package - let me check to see what it's called | 01:13 |
| grantc | php5-dev | 01:13 |
| Mud | php5-dev I think | 01:14 |
| Mud | yes | 01:14 |
| Mud | lol | 01:14 |
| grantc | assuming you are using ubuntu's packages | 01:14 |
| Mud | yes :) | 01:14 |
| Mud | ubuntu <3 | 01:14 |
| Mud | lol | 01:15 |
| Mud | 12m remaining downloading | 01:15 |
| Mud | :X | 01:15 |
| grantc | download using http://pecl.php.net/get/ingres | 01:16 |
| grantc | wget ... | 01:16 |
| grantc | or you can pull the latest bleeding edge source from http://dl.dropbox.com/u/2191213/ingres-2.2.2.tgz | 01:17 |
| Mud | its a slow internet connection :/ | 01:21 |
| Mud | 2/2Mbit SDSL | 01:21 |
| grantc | that's not that slow | 01:21 |
| Mud | :o | 01:22 |
| Mud | I have 10/1 Mbit @ other line (but that runs via proxy and shit) | 01:22 |
| Mud | that is a fast line xD | 01:22 |
| Mud | uhm | 01:23 |
| Mud | grantc | 01:23 |
| Mud | I get this: 1. Ingres II_SYSTEM dir? : | 01:23 |
| Mud | 1-1, 'all', 'abort', or Enter to continue: | 01:23 |
| Mud | what do here? give path to ingres dir? | 01:24 |
| grantc | do you have the II_SYSTEM variable defined in your environment? | 01:24 |
| Mud | uhm | 01:24 |
| Mud | I dont know | 01:24 |
| Mud | how do I see that? | 01:24 |
| grantc | press return - if it fails then you don't :) | 01:24 |
| Mud | configure: error: Cannot find iiapi.h under /ingres/files - is $II_SYSTEM set? | 01:25 |
| Mud | ERROR: `/tmp/pear/cache/ingres-2.2.1/configure --with-ingres=' failed | 01:25 |
| *** Gerhard has joined #ingres | 01:27 | |
| grantc | II_SYSTEM is not set | 01:27 |
| Mud | found your post how to set variables | 01:28 |
| grantc | or use http://pastebin.com/f6037fcac as script - change II_SYSTEM to the path you installed ingres to and you can load that script doing ". script" | 01:29 |
| Mud | nop | 01:32 |
| Mud | still the error | 01:32 |
| Mud | and I did sh script.sh | 01:32 |
| Mud | renamed script.sh to setvar | 01:33 |
| Mud | and runned . /path/setvar | 01:34 |
| Mud | but stil the same error @ install | 01:34 |
| Mud | root@mosseltest:~# echo $II_SYSTEM | 01:34 |
| Mud | /opt/Ingres/IngresII | 01:34 |
| Mud | :X | 01:34 |
| Mud | wtf | 01:34 |
| Mud | :X | 01:35 |
| Mud | @ grantc' | 01:35 |
| grantc | oh wll you need to supply that value | 01:35 |
| ii_log | Mud: Error: "grantc'" is not a valid command. | 01:35 |
| Mud | 1-1, 'all', 'abort', or Enter to continue: $II_SYSTEM | 01:36 |
| Mud | 1. Ingres II_SYSTEM dir? : | 01:36 |
| grantc | http://ingres.pastebin.com/m2f500e6f is what i get | 01:36 |
| grantc | enter your value for II_SYSTEM | 01:36 |
| Mud | when I use /opt/Ingres/IngresII | 01:38 |
| Mud | it doesnt accept the value | 01:38 |
| Mud | 1-1, 'all', 'abort', or Enter to continue: /opt/Ingres/IngresII | 01:38 |
| Mud | 1. Ingres II_SYSTEM dir? : | 01:38 |
| grantc | is that the directory where you installed ingres? | 01:39 |
| Mud | yes | 01:39 |
| Mud | I did now 'All" | 01:39 |
| Mud | and got this | 01:39 |
| Mud | 1-1, 'all', 'abort', or Enter to continue: all | 01:39 |
| Mud | Ingres II_SYSTEM dir? [] : | 01:39 |
| Mud | ahh | 01:40 |
| Mud | I got it | 01:40 |
| Mud | nevermind.... | 01:40 |
| Gerhard | Hi all, I'm surprised about the "patch frequency" of Ingres 9.2 on Win32 | 01:41 |
| Mud | w00t | 01:42 |
| Mud | grantc: | 01:42 |
| Mud | install ok: channel://pecl.php.net/ingres-2.2.1 | 01:42 |
| Mud | configuration option "php_ini" is not set to php.ini location | 01:42 |
| Mud | You should add "extension=ingres.so" to php.ini | 01:42 |
| Mud | :D | 01:42 |
| Gerhard | I have 9 different patches in my collection and 2 of them are from this month | 01:42 |
| grantc | Mud, cool | 01:46 |
| Mud | grantc: ingres lib is running for php | 01:48 |
| Mud | <?php | 01:48 |
| Mud | echo INGRES_EXT_VERSION . " " . INGRES_API_VERSION . "<br />\n"; | 01:48 |
| Mud | ?> | 01:48 |
| Mud | = 2.2.1 6 | 01:48 |
| Mud | so thats coolw also :D | 01:48 |
| grantc | :) | 01:49 |
| Mud | do i need more now, to connect to a remote DB ? | 01:49 |
| Mud | the php connect script for ingres DB is not a problem | 01:50 |
| Mud | grantc: on this page: http://community.ingres.com/wiki/Ingres_with_Apache_on_Ubuntu | 01:54 |
| grantc | it depends on what you want to do - if your Ingres server is on another machine you either need to configure a vnode using the netutil command or you can use " @hostname,tcp_ip,listen_address[username,password]::database" | 01:54 |
| Mud | this section is not working for me: Verifying the setup | 01:54 |
| grantc | that page is a generic page for setting up apache | 01:54 |
| Mud | and I did the section before it | 01:55 |
| Mud | so the confs are set in apache2 | 01:55 |
| grantc | but you get no output? | 01:56 |
| Mud | I dont get any output | 01:56 |
| grantc | strange - you should get something - check your apache log files (error.log) | 01:58 |
| Mud | [Thu Nov 12 11:00:25 2009] [warn] PassEnv variable II_SYSTEM was undefined | 02:00 |
| Mud | [Thu Nov 12 11:00:25 2009] [warn] PassEnv variable LD_LIBRARY_PATH was undefined | 02:00 |
| Mud | [Thu Nov 12 11:00:25 2009] [warn] PassEnv variable ODBCSYSINI was undefined | 02:00 |
| Mud | etc | 02:00 |
| Mud | LOL | 02:01 |
| Mud | I restarted apache2 again | 02:01 |
| Mud | and now somehow its working | 02:01 |
| Mud | What the hell :+ | 02:01 |
| Mud | II_SYSTEM is :/opt/Ingres/IngresII | 02:02 |
| Mud | LD_LIBRARY_PATH is :/opt/Ingres/IngresII/ingres/lib | 02:02 |
| Mud | or you can use " @hostname,tcp_ip,listen_address[username,password]::database" <<< Via PHP you mean grantc? | 02:03 |
| grantc | yes - in the database name | 02:04 |
| Mud | aha | 02:04 |
| Mud | ok | 02:04 |
| grantc | remove the leading space, that's not supposed to be there | 02:04 |
| grantc | in fact all ingres interfaces should accept that style of connection string including sql | 02:05 |
| Mud | so $db = @hostname,tcp_ip,listen_address[username,password]::database; and then $link = ingres_connect($db, "user", "pass"); ? | 02:05 |
| Mud | right? | 02:05 |
| Mud | I forgot some " btw , but thats ok | 02:05 |
| grantc | you don't need to supply the user/password if you are using the @url | 02:05 |
| Mud | okido :) | 02:06 |
| Mud | I gonna try it :) | 02:06 |
| *** Alex_ has joined #ingres | 02:09 | |
| grantc | Alex_, what happened to your | it fell over ? ;) | 02:10 |
| Alex_ | nick already in use... tztz | 02:10 |
| *** Alex_ is now known as Alex| | 02:10 | |
| *** ChanServ sets mode: +o Alex| | 02:10 | |
| Mud | grantc | 02:12 |
| grantc | mud | 02:13 |
| Mud | must I change that hostname,tcp_ip, listen_address etc into real values? | 02:13 |
| grantc | yup | 02:15 |
| Mud | tcp_ip = ? | 02:16 |
| grantc | tcp_ip you leave as is - sorry | 02:18 |
| grantc | the syntax is @hostname,protocol,listen_address[username,password]::database | 02:19 |
| grantc | tcp_ip is one of the net protocols we support | 02:19 |
| Mud | hmm | 02:20 |
| Mud | unable to connect | 02:20 |
| Mud | grantc: http://ingres.pastebin.com/m15984a98 | 02:23 |
| Mud | something wrong with the code? | 02:23 |
| grantc | 10.205.61.51 is the IP address of the server? | 02:25 |
| grantc | that needs to be changed to the listen address which is normally the value for II_INSTALLATION (ingprenv II_INSTALLATION) on the server | 02:25 |
| Mud | yes | 02:26 |
| Mud | but I have several ingres servers | 02:26 |
| Mud | (I work @ a cardealer, we have 7+ company's which each one a own ingres DB | 02:26 |
| Mud | ) | 02:26 |
| Mud | on a other physical machnie | 02:27 |
| Mud | machine* | 02:27 |
| Mud | so we have 7 different IP's :) | 02:27 |
| Mud | but I am trying to connect 1 of them | 02:27 |
| Mud | but target is, to fetch info from all of them | 02:27 |
| grantc | and rsdb177 is the name of the server you are connecting to? | 02:28 |
| Mud | yes | 02:28 |
| grantc | in that case the following should work "@rsdb177,tcp_ip,II[ingres,secret]::gidsprod" | 02:29 |
| grantc | where II is the value for II_INSTALLATION on the server node | 02:29 |
| grantc | (the default is II) | 02:29 |
| Mud | yes, but I have several nodes.. | 02:29 |
| grantc | assuming everything else is the same all you need to do is change the name for each node | 02:30 |
| Mud | how do I add a node to my configuration? | 02:31 |
| grantc | add a vnode? | 02:31 |
| Mud | I never worked with ingres before on linux | 02:32 |
| Mud | so I am lost here | 02:32 |
| grantc | http://docs.ingres.com/Ingres/9.2/Connectivity%20Guide/netutil.htm has an overview of creating a vnode using netutil | 02:33 |
| grantc | vnode is like an alias for a remote machine | 02:33 |
| grantc | so you can do "sql server1::dbname" where server1 is the alias/vnode which contains the connection information you have in the @ string | 02:34 |
| Mud | hmm | 02:34 |
| Mud | ke | 02:34 |
| grantc | the alias/node does not need to match the name of the machine you are connecting to | 02:34 |
| grantc | although it makes sense if it does :) | 02:35 |
| Mud | yes | 02:36 |
| Mud | but | 02:36 |
| Mud | I cant run netutil on ubuntu | 02:36 |
| grantc | why not? | 02:43 |
| Mud | root@mosseltest:/# netutil | 02:43 |
| Mud | E_GC0126 There is no Name Server running in this installation. The | 02:43 |
| Mud | installation may not have been started. | 02:43 |
| Mud | E_ST003E Cannot connect to name server on local host: 'mosseltest' | 02:43 |
| grantc | ingres is not running - use "ingstart" to start it | 02:44 |
| Mud | administrator@mosseltest:/$ ingstart | 02:45 |
| Mud | -bash: ingstart: command not found | 02:45 |
| grantc | in which account did you install ingres? | 02:49 |
| Mud | root | 02:49 |
| Mud | and when i wanted to start it as root, is says it cant start as root | 02:50 |
| Mud | I rebooted the server now | 02:54 |
| Mud | root@mosseltest:~# netutil | 02:55 |
| Mud | -bash: netutil: command not found | 02:55 |
| Mud | wth :/ | 02:55 |
| Mud | :/ | 02:55 |
| Alex| | source /opt/Ingres/IngresII/.ingIIbash ? | 02:55 |
| pboro | or /opt/Ingres/IngresII/.ingIIsh? is there a separate file for bash nowadays? | 02:55 |
| Alex| | depends on the version... I saw both | 02:56 |
| pboro | ok :) | 02:56 |
| Mud | -bash: /opt/Ingres/IngresII/.ingIIbash: No such file or directory | 02:56 |
| Alex| | sometimes it's called bash, sometimes sh :) | 02:56 |
| Alex| | Mud - could be called slightly different | 02:56 |
| Alex| | .ingIIsh | 02:56 |
| Alex| | could also be in /home/ingres or the user you used to install ingres | 02:57 |
| Mud | I had no homedirectory for the ingres | 02:57 |
| Mud | when i installeed ingres | 02:57 |
| Mud | for the ingres user* | 02:57 |
| Alex| | is there a file /opt/Ingres/IngresII/.ingII* ? | 02:58 |
| Mud | nop | 02:58 |
| Mud | only a folder called ingres | 02:59 |
| Alex| | could even be in /opt/Ingres/IngresII/ingres | 02:59 |
| Alex| | never understood when we put it where and why | 02:59 |
| Mud | nop | 02:59 |
| Mud | not there also | 02:59 |
| Alex| | sure? Hm... it should be somewhere | 02:59 |
| Mud | its really not there | 03:00 |
| Alex| | it should look like this http://pastebin.com/meeb9849 | 03:01 |
| Mud | I have created that file | 03:01 |
| Mud | somewhere else | 03:01 |
| Alex| | if the path is the same as yours you can just take this, put it in a file and do "source file" or just put it in your bashrc | 03:01 |
| Mud | in my install dir | 03:01 |
| Alex| | you need to source that file to set the env vars | 03:02 |
| Alex| | and to get II_SYSTEM/bin into your PATH variable | 03:02 |
| Mud | ahhh | 03:02 |
| Mud | ok | 03:02 |
| Mud | done | 03:03 |
| Mud | Alex|: this doesnt look good | 03:04 |
| Mud | http://pastebin.com/mdf4406e | 03:04 |
| Alex| | you installed it as user root? | 03:04 |
| Mud | yes | 03:05 |
| Mud | ofc | 03:05 |
| Alex| | that's never a good idea because permissions are broke then... do it as user ingres | 03:05 |
| Mud | but user ingres is a normal user | 03:05 |
| Alex| | yup, Ingres runs as normal user | 03:06 |
| Mud | so he never can install that package | 03:06 |
| Alex| | do you use the rpms? | 03:06 |
| Mud | no | 03:06 |
| Alex| | ingbuild? | 03:06 |
| Mud | yes | 03:06 |
| Alex| | didn't do an ingbuild for a while but I think it'll ask you for root password when it needs it | 03:07 |
| Alex| | /opt/Ingres/ should belong to user ingres... the things that need more permissions have setuid | 03:07 |
| Mud | it belongs to root | 03:07 |
| Mud | drwxr-xr-x 3 root root 4096 2009-11-12 09:52 Ingres | 03:08 |
| Alex| | and the process is started as Ingres which is why it cannot write there | 03:08 |
| Mud | I didnt see anything with process Ingres starting up | 03:08 |
| Mud | I just restarted the machine | 03:08 |
| grantc | mud, there is an express install script that should help you to get ingres installed as simply as possible. installing ingres as root creates all sorts of problems beyond file permissions | 03:09 |
| Mud | ok.. | 03:09 |
| grantc | shared memory and semaphore issues IIRC | 03:09 |
| Mud | how do I unistall ingres? | 03:09 |
| grantc | ingstop; ipcclean; rm -rf /opt/Ingres; reboot | 03:10 |
| Mud | ke done | 03:11 |
| Mud | rebooting now | 03:11 |
| Mud | $ sh ingres_express_install.sh | 03:13 |
| Mud | ingres_express_install.sh must be run as root | 03:13 |
| Mud | .... | 03:13 |
| Mud | >.> | 03:13 |
| grantc | that script gets run as root as it needs to create directories but it sets up an ingres user and ingres properly (or did the last time i checked) | 03:14 |
| Mud | I think there is a problem with my ingres user | 03:15 |
| Mud | the [tab] function is not working etc..when I am logged in as ingres | 03:16 |
| Mud | brb guys | 03:24 |
| Mud | back | 03:35 |
| Mud | grantc: running the express install now | 03:37 |
| Mud | and again | 03:38 |
| Mud | the permissions are set to root.... | 03:38 |
| Mud | on the IngresII folder | 03:39 |
| Mud | See errlog.log for detail. | 03:45 |
| Mud | where is that errlog.log grantc ? | 03:45 |
| Mud | not in /var/log | 03:45 |
| Mud | not in /opt/Ingres/IngresII/ingres/log etc | 03:45 |
| Vroomfondle | default is /opt/Ingres/IngresII/ingres/files I think? | 03:46 |
| Mud | yep there it is | 03:47 |
| Mud | thanx | 03:47 |
| *** cthibert has joined #ingres | 04:11 | |
| Mud | grantc: got netutil running and working | 04:12 |
| grantc | ok | 04:12 |
| Mud | but now php says: Fatal error: Call to undefined function ingres_connect() | 04:13 |
| Mud | :X | 04:13 |
| grantc | the module is not loaded into php | 04:13 |
| grantc | what does php -m say? | 04:13 |
| Mud | a lot of stuff | 04:13 |
| Mud | but not anything with ingres | 04:14 |
| Mud | extension=ingres.so is in php.ini | 04:14 |
| grantc | which php.ini have you changed? | 04:15 |
| Mud | the one in /etc/php5/apache2/php.ini | 04:15 |
| Mud | I have no other php.ini | 04:15 |
| Mud | grantc: strange is that it worked before..as you have noticed | 04:16 |
| grantc | do you not have /etc/php5/cli/php.ini | 04:16 |
| Mud | yes I have | 04:18 |
| Mud | added that line also there | 04:19 |
| Mud | restarted apache2 | 04:19 |
| Mud | but still nothing | 04:19 |
| Mud | I reinstalled that pecl ingres | 04:23 |
| Mud | (first unistall, then install, gave correct path etc) | 04:24 |
| Mud | restarted apache2..still nothing | 04:24 |
| Mud | grantc: php -m gives ingres back | 04:25 |
| Mud | wth grantc | 04:28 |
| Mud | I rebooted the server | 04:28 |
| Mud | and working again :X | 04:28 |
| grantc | interesting | 04:28 |
| Mud | ye :X | 04:28 |
| Mud | oh grantc | 04:28 |
| Mud | I need to set that env vars everytime I login again | 04:29 |
| Mud | how do I fix that? | 04:29 |
| Mud | put the file in a startup script? | 04:29 |
| grantc | edit your .profile or the system /etc/profile | 04:29 |
| grantc | and add the command you used | 04:29 |
| Mud | that worked wel | 04:34 |
| Mud | w00t | 04:35 |
| Mud | working :) | 04:35 |
| Mud | grantc: I made one vnode | 04:35 |
| Mud | I can succesfully connect to it, but how i use that vnode in my connect script? | 04:35 |
| Mud | grantc: php.net manual says: | 04:43 |
| Mud | The database name. Must follow the syntax: | 04:43 |
| Mud | [vnode::]dbname[/svr_class] | 04:43 |
| Mud | must I change that vnode into the vnode I have? | 04:43 |
| Mud | or what? | 04:43 |
| Mud | I dont get it :/ | 04:43 |
| grantc | it can also do the @ syntax | 04:43 |
| grantc | i need to update the docs | 04:43 |
| Mud | do you have a example? | 04:43 |
| Mud | or its the example that you first gave me? | 04:44 |
| Mud | that @host...thing | 04:44 |
| grantc | http://ingres.pastebin.com/f31884019 is working code | 04:48 |
| Mud | hmm :) | 04:51 |
| Mud | grantc | 04:51 |
| Mud | there is one thing | 04:51 |
| *** toumi01 has joined #ingres | 04:51 | |
| Mud | everything we install the cardealer program on XP clients | 04:51 |
| Mud | we must change the II in I2 | 04:51 |
| Mud | when I do that II in my netutil, I cant connect, when I do I2 I can connect | 04:52 |
| Mud | is that important for the script also? | 04:52 |
| grantc | yup - change II to I2 and it should connect too | 04:52 |
| Mud | well, it doesnt :D | 04:53 |
| Mud | I get this error back | 04:53 |
| Mud | Fatal error: Failed to connect - 786757 - Installation paswords may only be used in vnodes. in /data/www/data/phpinfo/ingres.php on line 29 | 04:53 |
| grantc | you are using * as the username? | 04:55 |
| Mud | yes | 04:56 |
| Mud | i filled that in in my netutil also | 04:56 |
| Mud | and that is working | 04:56 |
| *** zxiiro has quit IRC | 04:58 | |
| grantc | you cannot use * in the @ form | 05:06 |
| grantc | so you need to connect using vnode::dbname | 05:06 |
| Mud | so rsdb177::gidsprod ? | 05:07 |
| Mud | hmm | 05:09 |
| Mud | Fatal error: Failed to connect - 6399 - User authorization check failed. Your user identifier was not known to this installation. Contact your system manager for further assistance | 05:09 |
| Mud | must they add the www-data user to the ingres DB ? | 05:10 |
| Mud | hich shows two user accounts for Apache. The root account can be ignored since it is a monitor/control process that starts up and shuts down servers as required. The processes run under the www-data account will be used to connect to Ingres. | 05:17 |
| Mud | To add www-data to Ingres run the following, as the ingres administrator | 05:17 |
| Mud | that is my problem... | 05:17 |
| Mud | the problem is, we dont control those remote machines | 05:17 |
| Mud | hmmm | 05:17 |
| grantc | you can change the user for apache | 05:18 |
| grantc | there's a file in /etc/apache2 that has the info | 05:18 |
| Mud | ke ke | 05:21 |
| Mud | let me look :D | 05:21 |
| Mud | # These need to be set in /etc/apache2/envvars | 05:22 |
| Mud | User ${APACHE_RUN_USER} | 05:22 |
| Mud | Group ${APACHE_RUN_GROUP} | 05:22 |
| Mud | :D | 05:22 |
| Mud | edited | 05:26 |
| Mud | :) | 05:26 |
| Mud | w00t | 05:26 |
| Mud | I can make a connection | 05:26 |
| Mud | hmm | 05:26 |
| Mud | grantc: I noticed something else | 05:26 |
| Mud | Ingres isnt automatic starting | 05:26 |
| Mud | under ingres | 05:26 |
| Mud | how i fix that? | 05:26 |
| Mud | add ingstart to /etc/rc.local didnt helped | 05:34 |
| Mud | ahhh | 05:40 |
| Mud | found it :) | 05:40 |
| Vroomfondle | Mud: how'd you do it? | 05:41 |
| Vroomfondle | I've been meaning to add it to my startup scripts for a while, but haven't got round to figuring out exactly what to do | 05:41 |
| Mud | Vroomfondle: it doesnt work yet | 05:51 |
| Mud | but I am bit futher | 05:51 |
| *** zxiiro has joined #ingres | 05:51 | |
| *** ChanServ sets mode: +v zxiiro | 05:51 | |
| grantc | to auto start you need to either link the script to the correct run-level or use chkconfig to do it for you | 05:55 |
| Vroomfondle | no chkconfig in ubuntu | 05:58 |
| Mud | indeed | 05:58 |
| Vroomfondle | the equivalent is update-rc.d | 05:59 |
| Mud | Vroomfondle: must ingres acc have a pwd/ | 06:05 |
| Mud | ? | 06:05 |
| *** mull has quit IRC | 06:06 | |
| grantc | Description: Ubuntu 9.10 Release: 9.10 /sbin/chkconfig | 06:13 |
| Mud | I am running 8.04 | 06:17 |
| grantc | hmm | 06:22 |
| *** mull has joined #ingres | 06:37 | |
| *** cthibert has left #ingres | 06:38 | |
| *** cthibert has joined #ingres | 06:44 | |
| Vroomfondle | grantc: where'd you get chkconfig from? | 06:46 |
| Vroomfondle | It's not installed by default. | 06:46 |
| *** Alex| has quit IRC | 06:54 | |
| *** rossand has joined #ingres | 07:27 | |
| *** ChanServ sets mode: +o rossand | 07:27 | |
| grantc | Vroomfondle, I installed it when i had 9.04 installed | 07:51 |
| grantc | i think the package is called chkconfig | 07:52 |
| *** hanje04 has joined #ingres | 07:54 | |
| Mud | << off to home | 07:59 |
| Mud | :W :W | 07:59 |
| Mud | see ya tonight (or tomorrow) | 07:59 |
| Mud | cya! | 07:59 |
| *** Gerhard has quit IRC | 08:00 | |
| *** Mud has quit IRC | 08:18 | |
| *** bonsaikitten has joined #ingres | 08:44 | |
| *** ccsidiot has joined #ingres | 08:45 | |
| *** Alex| has joined #ingres | 09:26 | |
| *** ChanServ sets mode: +o Alex| | 09:26 | |
| *** grantc has quit IRC | 09:41 | |
| *** Mud has joined #ingres | 09:52 | |
| *** Alex| has quit IRC | 10:05 | |
| *** ccsidiot has quit IRC | 10:46 | |
| *** ccsidiot has joined #ingres | 10:47 | |
| *** atrofast has quit IRC | 10:53 | |
| *** atrofast has joined #ingres | 10:58 | |
| *** Mud has quit IRC | 11:02 | |
| *** Mud has joined #ingres | 11:36 | |
| *** SaraDanaher has joined #ingres | 11:39 | |
| SaraDanaher | Alex or Andrew | 11:40 |
| SaraDanaher | are guys here? | 11:40 |
| SaraDanaher | or Tony | 11:41 |
| *** SaraDanaher has quit IRC | 11:53 | |
| *** ccsidiot has left #ingres | 11:58 | |
| *** ccsidiot has joined #ingres | 12:02 | |
| *** DerMeister has joined #ingres | 13:17 | |
| *** atrofast has quit IRC | 13:41 | |
| *** cthibert has left #ingres | 13:56 | |
| *** toumi01 has left #ingres | 14:05 | |
| *** zxiiro has quit IRC | 14:07 | |
| *** Mud has quit IRC | 14:10 | |
| ccsidiot | Hey | 14:22 |
| Vroomfondle | allo | 14:22 |
| ccsidiot | I've got the geospatial code checked out on school's server | 14:22 |
| ccsidiot | with limited rights to install only | 14:22 |
| ccsidiot | I'm just wondering, is there any configure script lying somewhere that I can install libxerces27-dev libxerces27 pax jam libpam0g-dev, in a non-standard location? | 14:23 |
| hanje04 | You can point XERCESCROOT to where ever you put the Xerces source | 14:29 |
| hanje04 | XERCESLIB points to the built library (usually under XERCESCROOT if you build the code | 14:30 |
| hanje04 | set PAXLOC to point to the location of the pax binary | 14:30 |
| hanje04 | Not sure about pam though | 14:31 |
| hanje04 | you might have to fake it out by creating a link under $ING_BUILD/lib | 14:31 |
| hanje04 | set the variable before sourcing the rest of the build environment | 14:32 |
| ccsidiot | hanje04: So now i'm in //src/tools/port/jam/precheck_functions, | 14:45 |
| ccsidiot | is that the only XERCESCROOT variable to change? | 14:45 |
| hanje04 | If you're building the Xerces source, then you won't need to set XERCESLIB | 14:46 |
| hanje04 | The environment script should find it | 14:46 |
| hanje04 | You will still need to set PAXLOC though | 14:46 |
| ccsidiot | Oh, what's PAXLOC? | 14:50 |
| hanje04 | It a variable that can be used to point to the pax binary should you need to install it in a non standard location | 14:53 |
| hanje04 | but pax will probably already be in the system, it usually is | 14:53 |
| hanje04 | what version of Linux are you using | 14:54 |
| hanje04 | ? | 14:54 |
| ccsidiot | I'm on Debian | 14:54 |
| hanje04 | OK, I've not used that much. Don't know if it'll be there or not | 14:54 |
| hanje04 | I'm on the west coast in the US so feel free to ask questions as you go | 14:55 |
| hanje04 | I'll be here | 14:55 |
| ccsidiot | I've confirmed with Andrew and Grant that should be the same as the wiki on Ubuntu | 14:57 |
| ccsidiot | but the problem that I have now is to make everything that I install at school at a non standard location | 14:58 |
| ccsidiot | since I don't have enough rights to install at root | 14:58 |
| ccsidiot | It'd be helpful if I know where to change all these paths that I need to | 14:58 |
| ccsidiot | :) Thanks in advance hanje04 | 14:59 |
| hanje04 | set the variables I mentioned above to point the locations where you've installed stuff before sourcing buildtools/set_env.sh and you should be fine | 15:04 |
| ccsidiot | Okay, let me try :) Thanks in advance | 15:04 |
| *** DerMeister has quit IRC | 15:06 | |
| *** zxiiro has joined #ingres | 15:10 | |
| *** ChanServ sets mode: +v zxiiro | 15:10 | |
| *** rossand has quit IRC | 18:09 | |
| *** mull has quit IRC | 18:14 | |
| *** hanje04 has quit IRC | 18:49 | |
| *** mull has joined #ingres | 19:19 | |
| *** cytrinox_ has joined #ingres | 19:20 | |
| *** cytrinox has quit IRC | 19:37 | |
| *** cytrinox_ is now known as cytrinox | 19:37 | |
| *** mull has quit IRC | 20:25 | |
| *** zxiiro has quit IRC | 21:20 | |
| *** zxiiro has joined #ingres | 21:22 | |
| *** ChanServ sets mode: +v zxiiro | 21:22 | |
| *** bonro011 has joined #ingres | 22:18 | |
| *** bonro01 has quit IRC | 22:18 | |
| *** Alex| has joined #ingres | 22:36 | |
| *** ChanServ sets mode: +o Alex| | 22:36 | |
| *** Mud has joined #ingres | 22:56 | |
| *** ccsidiot has left #ingres | 23:03 | |
| *** Alex| has quit IRC | 23:12 | |
| *** Gerhard has joined #ingres | 23:31 | |
| Gerhard | Morning all | 23:31 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!