| *** Alex| has joined #ingres | 00:34 | |
| *** ChanServ sets mode: +o Alex| | 00:34 | |
| *** Gerhard has joined #ingres | 01:25 | |
| *** grantc has joined #ingres | 01:59 | |
| *** ChanServ sets mode: +o grantc | 01:59 | |
| *** cthibert has joined #ingres | 03:45 | |
| *** zxiiro has quit IRC | 04:40 | |
| *** zxiiro has joined #ingres | 04:41 | |
| *** ChanServ sets mode: +v zxiiro | 04:41 | |
| *** zxiiro has quit IRC | 04:46 | |
| *** zxiiro has joined #ingres | 04:48 | |
| *** ChanServ sets mode: +v zxiiro | 04:48 | |
| *** zxiiro has quit IRC | 04:49 | |
| * grantc is away: wanders off | 05:30 | |
| *** Sara_ has joined #ingres | 05:36 | |
| *** Sara_ has quit IRC | 05:43 | |
| *** mull has joined #ingres | 05:47 | |
| *** zxiiro has joined #ingres | 06:03 | |
| *** ChanServ sets mode: +v zxiiro | 06:03 | |
| *** cthibert has left #ingres | 06:09 | |
| *** cthibert has joined #ingres | 06:13 | |
| *** Alex| has quit IRC | 06:23 | |
| *** Gerhard has quit IRC | 06:58 | |
| cthibert | Is there a way to convert a char* into a long byte data value? | 07:42 |
|---|---|---|
| cthibert | I've tried putting the char* into a vbyte and using adu_lvch_move but that truncates large streams. | 07:43 |
| grantc | cthibert, are you doing this in the server or via an external app? | 07:44 |
| cthibert | In the server. | 07:44 |
| grantc | in that case i don't know - i suspect you will need to stream/segment the data | 07:45 |
| grantc | drop alison stilway an email, i think she has dealt with LOB data in the server | 07:45 |
| cthibert | Okay, cool. Thanks. | 07:46 |
| *** FrankW has joined #ingres | 08:04 | |
| *** Alex| has joined #ingres | 08:06 | |
| *** ChanServ sets mode: +o Alex| | 08:06 | |
| *** ccsidiot has joined #ingres | 08:10 | |
| ccsidiot | Hey | 08:24 |
| ccsidiot | I'm back | 08:24 |
| ccsidiot | I was playing around with the username with the Ingres database, is there a way to login to a database, say, drupal, as another user other than the windows account username? | 08:26 |
| ccsidiot | Like login as system? | 08:27 |
| Vroomfondle | on unix I'd do "isql -usystem drupal" | 08:27 |
| Vroomfondle | so Ingres is capable of it... whether it can be done via VDBA I'm not sure | 08:28 |
| ccsidiot | Vroomfondle: I typed in sql -usystem drupal | 08:29 |
| Vroomfondle | and it didn't work? | 08:29 |
| ccsidiot | and then select dbmsinfo('system_user')\g | 08:30 |
| ccsidiot | It gives me my user account name | 08:30 |
| ccsidiot | =( | 08:30 |
| ccsidiot | i mean the windows user account name | 08:30 |
| ccsidiot | I'm still stuck in the same place, want to let Drupal know that the windows default account "SYSTEM" also have access to the database drupal that I created under my windows user account name, say "ccsidiot" | 08:33 |
| grantc | ccsidiot, it should be possible - the basic steps are documented for Linux in the Ingres wiki | 08:41 |
| grantc | @google ingres apache ubuntu | 08:41 |
| ii_log | grantc: Ingres with Apache on Debian Etch - Ingres Community Wiki: <http://community.ingres.com/wiki/Ingres_with_Apache_on_Ubuntu>; problem while install PHP Driver on Ubuntu - Ingres Community Forums: <http://community.ingres.com/forum/php/2552-problem-while-install-php-driver-ubuntu.html>; Servers/Ingres - Community Ubuntu Documentation: <https://help.ubuntu.com/community/Servers/Ingres>; Servers - Community (2 more messages) | 08:41 |
| grantc | the first link has the information for ubuntu | 08:41 |
| grantc | for windows replace "www-data" with system | 08:41 |
| grantc | you may need to give the system account the ingres security administrator privilege | 08:42 |
| ccsidiot | The system user already exists | 08:44 |
| ccsidiot | when I do select name from iiuser\g | 08:44 |
| ccsidiot | after login to iidbdb | 08:44 |
| grantc | can you get a simple php application working that does a select? | 08:45 |
| ccsidiot | Hum wait, maybe not, I thought that I did, but just spot something silly in the code | 08:48 |
| ccsidiot | Yes, it failed | 08:55 |
| ccsidiot | Gives me errno 3502 | 08:57 |
| grantc | ok - does your code connect using - ingres_connect($dbname) | 08:57 |
| ccsidiot | Yes, the code connects | 08:58 |
| ccsidiot | now googling 3502 | 08:58 |
| ccsidiot | Yay: it says no GRANT or GRANT compatible permit exists | 08:59 |
| grantc | if you use the function "ingres_error" you should get some text | 09:00 |
| grantc | or the error message | 09:00 |
| ccsidiot | Yea, that's the error message print from there | 09:00 |
| ccsidiot | But I thought the table by default is created as public, and system should have access? | 09:03 |
| grantc | it depends... | 09:03 |
| grantc | let me check something | 09:03 |
| ccsidiot | Sure :) | 09:04 |
| grantc | ok - when you create a database the access to the database is public, when you create a table/view/procedure the access is restricted to the owner until you issue a "grant...." on the object | 09:05 |
| grantc | e.g. "grant select on xxxx to public" | 09:06 |
| grantc | or "grant all on xxxx to public" | 09:06 |
| ccsidiot | Granted, something wrong, I don't think it's with the code itself. But the browser is continuously waiting | 09:17 |
| ccsidiot | I removed the loops in the code, and it did the same thing | 09:17 |
| grantc | can you paste your code to http://ingres.pastebin.com | 09:18 |
| ccsidiot | Here: http://ingres.pastebin.com/d6b46d079 | 09:21 |
| ccsidiot | This is with the while loop, but when I took it off, it does the same thing | 09:22 |
| ccsidiot | Funny, Firefox has this line before it says "Waiting for localhost", "http://drupal.org/requirements" | 09:27 |
| *** Alex| has quit IRC | 09:44 | |
| grantc | what do you get if you change your script to http://ingres.pastebin.com/d103ab091 | 09:47 |
| ccsidiot | There is nothing printed | 09:51 |
| ccsidiot | I tried with var_dump($rc) before to see what's in $rc, but same thing happens | 09:52 |
| grantc | ah - add "echo " before .. | 10:03 |
| ccsidiot | I tried that too | 10:04 |
| ccsidiot | :( | 10:04 |
| grantc | you should get something for $rc | 10:04 |
| grantc | it should either be a boolean with a value of false or an ingres result resource | 10:05 |
| ccsidiot | That's what I'd expect too :( But no | 10:05 |
| ccsidiot | When i took out every line under var_dump then Firefox waiting for localhost, when I put it back, the script prints nothing | 10:06 |
| ccsidiot | Argh! | 10:07 |
| ccsidiot | I know why | 10:07 |
| ccsidiot | I logined that database drupal :) | 10:07 |
| ccsidiot | I just logged out | 10:07 |
| ccsidiot | and then it gives me something | 10:08 |
| ccsidiot | Yes :) It's now printing values from the table | 10:08 |
| ccsidiot | Thanks Grant, Vroomfondle | 10:09 |
| ccsidiot | ! | 10:09 |
| grantc | err no problem.. | 10:09 |
| ccsidiot | Back to the drupal | 10:12 |
| ccsidiot | :( Still the old message | 10:13 |
| *** ccsidiot is now known as ccsidiot_away | 10:59 | |
| *** grantc has quit IRC | 11:54 | |
| *** Alex| has joined #ingres | 12:54 | |
| *** ChanServ sets mode: +o Alex| | 12:54 | |
| *** Alex| has quit IRC | 13:13 | |
| *** Alex| has joined #ingres | 13:16 | |
| *** ChanServ sets mode: +o Alex| | 13:16 | |
| *** Alex| has quit IRC | 13:32 | |
| *** zxiiro_ has joined #ingres | 13:57 | |
| *** zxiiro has quit IRC | 13:57 | |
| *** zxiiro_ has left #ingres | 14:02 | |
| *** zxiiro has joined #ingres | 14:03 | |
| *** ChanServ sets mode: +v zxiiro | 14:03 | |
| *** zxiiro has quit IRC | 14:03 | |
| *** cthibert has left #ingres | 14:44 | |
| *** toumi01 has quit IRC | 14:55 | |
| *** mull has quit IRC | 15:04 | |
| *** zxiiro has joined #ingres | 15:06 | |
| *** ChanServ sets mode: +v zxiiro | 15:06 | |
| *** cytrinox_ has joined #ingres | 19:20 | |
| *** cytrinox has quit IRC | 19:36 | |
| *** cytrinox_ is now known as cytrinox | 19:36 | |
| *** Alex| has joined #ingres | 21:06 | |
| *** ChanServ sets mode: +o Alex| | 21:06 | |
| *** Alex| has quit IRC | 21:41 | |
| *** grantc has joined #ingres | 23:02 | |
| *** ChanServ sets mode: +o grantc | 23:02 | |
| *** ccsidiot_away has left #ingres | 23:34 | |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!