*** 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!