| *** Alex| has quit IRC | 00:00 | |
| *** bonro01 has quit IRC | 00:16 | |
| *** bonro01 has joined #ingres | 00:16 | |
| *** Alex| has joined #ingres | 00:20 | |
| *** ChanServ sets mode: +o Alex| | 00:20 | |
| *** FrankW has quit IRC | 00:39 | |
| *** grantc has quit IRC | 01:42 | |
| *** grantc has joined #ingres | 01:42 | |
| *** ChanServ sets mode: +o grantc | 01:42 | |
| *** cthibert has joined #ingres | 02:22 | |
| *** toumi01 has joined #ingres | 03:39 | |
| *** cthibert has left #ingres | 05:19 | |
| *** mull has joined #ingres | 05:45 | |
| *** rossand has joined #ingres | 06:00 | |
| *** ChanServ sets mode: +o rossand | 06:00 | |
| *** cthibert has joined #ingres | 06:02 | |
| *** DarylM has joined #ingres | 07:07 | |
| *** ccsidiot has joined #ingres | 07:25 | |
| *** Gerhard has joined #ingres | 07:27 | |
| ccsidiot | Hey guys, I have now got Apache 2.2 running as a service and trying to get it talking to Ingres, here is what I did, http://i-wa.blogspot.com/2009/10/ucosp-status-report-10.html | 07:28 |
|---|---|---|
| ccsidiot | When I ran the code here: http://ingres.pastebin.com/m456665df | 07:31 |
| ccsidiot | It says couldn't connect | 07:31 |
| Gerhard | Are you running the apache service as a specific user or as system account? | 07:34 |
| ccsidiot | System account | 07:34 |
| ccsidiot | and when I do select name, password from iiuser \g, I can see the username SYSTEM in the database | 07:35 |
| Gerhard | you mean, in iidbdb? | 07:37 |
| ccsidiot | Yes | 07:37 |
| ccsidiot | I first do sql iidbdb | 07:37 |
| ccsidiot | then that line above | 07:37 |
| ccsidiot | :) | 07:37 |
| Gerhard | so the user is known to your installation.... | 07:37 |
| Gerhard | sure that "system" is correct...? Maybe "localsystem"...? | 07:38 |
| ccsidiot | Yes, system is correct | 07:38 |
| Gerhard | Anything in errlog.log? Like "...unknown user..." or something like that? | 07:38 |
| ccsidiot | It has this error message here: http://ingres.pastebin.com/m41a44da6 | 07:41 |
| ccsidiot | some iso file is missing | 07:41 |
| Gerhard | The DB you want to connect to, is "drupal", right? | 07:42 |
| ccsidiot | Oops.. ico | 07:42 |
| ccsidiot | Yes | 07:42 |
| ccsidiot | drupal | 07:42 |
| ccsidiot | and I have do: createdb drupal before I log into iidbdb | 07:42 |
| Gerhard | I think, the favicon.ico message is a separate problem... | 07:43 |
| Gerhard | I think you should.... | 07:45 |
| Gerhard | isql iidbdb | 07:45 |
| Gerhard | GRANT access ON DATABASE drupal to system;commit; | 07:45 |
| Gerhard | -> F9 -> F10 -> F10 | 07:45 |
| ccsidiot | Executed, restarted apache, could not connect, error.log says : http://ingres.pastebin.com/d34ad6752 | 07:49 |
| Gerhard | Who's the owner of the DB drupal? ingres? | 07:50 |
| *** Gerhard has quit IRC | 07:51 | |
| ccsidiot | I don't think so, I login to my windows account using my own user name and created that db | 07:52 |
| *** Gerhard has joined #ingres | 07:55 | |
| Gerhard | Who's the owner of your drupal DB? | 07:56 |
| ccsidiot | I'm trying to figure out the way how to check this | 07:56 |
| Gerhard | Maybe you should let run Apache service as that user? | 07:56 |
| Gerhard | as which user were you logged in when running "createdb drupal"? | 07:57 |
| ccsidiot | The owner of the drupal db is for sure my windows username, since I createdb drupal under this windows user name | 07:57 |
| ccsidiot | and the user name for Apache is system.. Humm | 07:57 |
| Gerhard | Could you try to run Apache as that user? | 07:57 |
| Gerhard | I mean your Windows user... | 07:58 |
| *** Gerhard has quit IRC | 07:58 | |
| ccsidiot | That option is picked back at the time the installer prompts me | 08:00 |
| ccsidiot | :( | 08:00 |
| *** Gerhard has joined #ingres | 08:01 | |
| Gerhard | could you try with different user? | 08:02 |
| ccsidiot | I'm trying to find a way how to do this | 08:02 |
| ccsidiot | I'm now changing the properties in "Computer Management", argh I hate how they are not consistent with the name system | 08:07 |
| ccsidiot | When I open up "Task Manager", it shows me that httpd.exe is running as system | 08:07 |
| ccsidiot | and then I go to "Computer Management" and see that it's actually "Local System" | 08:08 |
| Gerhard | --> start --> run --> services.msc | 08:08 |
| ccsidiot | Yea, I'm at there | 08:08 |
| Gerhard | search your Apache service and than --> right click --> properties | 08:08 |
| ccsidiot | Trying to change how Apache2.2 is Log On at start | 08:08 |
| ccsidiot | I'm at there too | 08:08 |
| ccsidiot | Should I select "This account"? | 08:09 |
| *** Alex| has quit IRC | 08:09 | |
| Gerhard | "this account" sounds good | 08:09 |
| ccsidiot | Yea, I clicked that and type system, and it forcefully change that to .\system :( | 08:11 |
| ccsidiot | when I confirm | 08:11 |
| *** FrankW has joined #ingres | 08:12 | |
| Gerhard | Why "system"? Is your Windows user "system"? | 08:12 |
| Gerhard | BTW, it's normal that Windows adds a .\ here... | 08:13 |
| Gerhard | ...that just means your using a local user and not a domain user | 08:13 |
| Gerhard | BTW, did you use separate installers for Ingres and Apache or the integrated EasyIngres package? | 08:15 |
| ccsidiot | no, since the system's default name in database is "system" | 08:16 |
| ccsidiot | I install them separately :( I didn't know there's such a thing as EasyIngres | 08:16 |
| Gerhard | http://esd.ingres.com/product/Community_Projects/Development_Tools/Windows_32-Bit/EasyIngres/ | 08:21 |
| grantc | EasyIngres gives you PHP and Ingres and Apache all configured in a single bundle | 08:22 |
| grantc | It gives you what you have now | 08:22 |
| ccsidiot | :( The UCOSP students didn't know about this... but it's good since I understand more about the bigger picture | 08:23 |
| ccsidiot | So how can I make Windows not adding that .\ ? | 08:32 |
| ccsidiot | I've come this far and don't want to destroy everything I did and just go EasyIngres :( | 08:32 |
| grantc | i don't think you need to add the .\ to the user name in ingres | 08:34 |
| grantc | at least when I have setup ingres on windows with php i have never added the username with .\ | 08:34 |
| grantc | I also have run apache under the "Local System" account | 08:36 |
| ccsidiot | Grant: Oh, and it gives you no problem? | 08:37 |
| grantc | providing system is an ingres user and has the "security admin" privilege | 08:37 |
| grantc | it gives me other problems but that's windows | 08:37 |
| ccsidiot | Yea, just now Gerhard also asked me to do this : GRANT access ON DATABASE drupal to system;commit; | 08:38 |
| grantc | surely that's not needed unless the database has be created private | 08:38 |
| grantc | by default all ingres databases have public access, providing your username is valid you get access to the database | 08:39 |
| grantc | whether you have access to the tables is another matter | 08:39 |
| ccsidiot | Yup, I also got the last point when I was playing around with the database | 08:40 |
| grantc | Before you try and diagnose why drupal is not working you should write some simple php code that connects to the database and executes a select against a table | 08:41 |
| grantc | a good db to use is demodb | 08:42 |
| grantc | and a query like "select up_first, up_last from user_profile" will give you some output | 08:42 |
| grantc | see http://community.ingres.com/wiki/Ingres_Examples#PHP for complete code snippets | 08:43 |
| ccsidiot | http://ingres.pastebin.com/m456665df That is the code that I sent Gerard just now | 08:43 |
| ccsidiot | That I ran to test the connection | 08:43 |
| grantc | and that works? i'd be surprised as you need to supply a password | 08:43 |
| ccsidiot | It doesn't work | 08:43 |
| ccsidiot | it dies and output Could not connect | 08:44 |
| grantc | either you supply just a database name or that + user/pass | 08:44 |
| ccsidiot | so we are suspecting there are something wrong with either the database drupal itself or my username | 08:44 |
| ccsidiot | Hum, when I take the "" for the password param off, no news | 08:47 |
| grantc | what about if you just send the dbname and that's it | 08:47 |
| grantc | http://ingres.pastebin.com/d1fdd5203 | 08:48 |
| ccsidiot | OH! It says connected successfully | 08:48 |
| ccsidiot | ! | 08:48 |
| ccsidiot | ARGH :)!! Thanks so much Grant and Gerard! | 08:49 |
| *** Gerhard has quit IRC | 08:50 | |
| ccsidiot | Now move on why the query there is not executing | 08:51 |
| grantc | which database? | 08:52 |
| ccsidiot | Query: Select name from iiuser | 08:52 |
| ccsidiot | http://ingres.pastebin.com/d143f6b32 | 08:53 |
| *** FrankW_ has joined #ingres | 08:55 | |
| grantc | that can only be done against the database iidbdb | 08:56 |
| ccsidiot | Oh I see :) | 08:56 |
| ccsidiot | Now I understand why Drupal couldn't connect to Ingres, can it be possibly it asks for username and password for that database when it tries to connect? | 09:11 |
| ccsidiot | Like I just did | 09:11 |
| ccsidiot | Is there a way to change that in Drupal? | 09:11 |
| ccsidiot | Since by default, the way how Drupal configure a database is to ask for the username and password for a database | 09:23 |
| grantc | it is possible to provide a username/password to drupal | 09:29 |
| grantc | does your useraccount not have a password? | 09:29 |
| ccsidiot | Yea, it doesn't have a password | 09:30 |
| ccsidiot | But drupal is not yet prompting me for the username and password | 09:30 |
| ccsidiot | it's still stuck here | 09:31 |
| ccsidiot | Database configuration | 09:31 |
| ccsidiot | Your web server does not appear to support any common database types. | 09:31 |
| atrofast | ccsidiot: What does your httpd.log say when you start Apache up? Does it say something about module couldn't be loaded? | 09:38 |
| ccsidiot | For today, no | 09:41 |
| ccsidiot | Time for me to prepare for class =( | 09:42 |
| atrofast | ccsidiot: When will you get back? | 09:48 |
| grantc | ccsidiot, for ingres you will need to assign an operating system password | 09:51 |
| grantc | either that or create another account that has a password | 09:51 |
| ccsidiot | around 6pm today =( I have meeting for my other assignment groups | 09:51 |
| ccsidiot | But I guess 6pm, you guys will be off work | 09:52 |
| ccsidiot | =( | 09:52 |
| grantc | me - for sure and I am not back till tues | 09:54 |
| atrofast | I'll probably be off then too that's around dinner time here | 09:54 |
| ccsidiot | :( I'll try to play around with the username/password and stuffs, THANKS SO MUCh EVERYONE and plus rossand: the UCOSP students need to submit the marking scheme today, and Evan will send me details and finialize that soon, and then send the compiled version for you to see if it's okay or not | 09:57 |
| rossand | ccsidiot: Thanks. Yes, please do send me a copy before turning it in/finalizing. | 09:58 |
| rossand | I wouldn't mind seeing a draft asap. | 09:58 |
| ccsidiot | Sure | 09:59 |
| ccsidiot | Really need to go | 09:59 |
| ccsidiot | Bye | 09:59 |
| rossand | see you | 09:59 |
| *** dyki has joined #ingres | 10:14 | |
| dyki | \q | 10:25 |
| *** dyki has quit IRC | 10:25 | |
| *** grantc has quit IRC | 10:28 | |
| *** pitschi has joined #ingres | 10:53 | |
| pitschi | hi anybody there? | 10:54 |
| *** Alex| has joined #ingres | 10:57 | |
| *** ChanServ sets mode: +o Alex| | 10:57 | |
| *** cthibert has left #ingres | 11:06 | |
| *** pitschi has left #ingres | 11:09 | |
| *** Alex| has quit IRC | 12:40 | |
| *** Alex| has joined #ingres | 12:42 | |
| *** ChanServ sets mode: +o Alex| | 12:42 | |
| *** toumi01 has left #ingres | 12:48 | |
| *** Alex| has quit IRC | 13:20 | |
| *** Alex| has joined #ingres | 13:21 | |
| *** ChanServ sets mode: +o Alex| | 13:21 | |
| *** Alex| has quit IRC | 13:57 | |
| *** Alex| has joined #ingres | 13:59 | |
| *** ChanServ sets mode: +o Alex| | 13:59 | |
| *** mull has quit IRC | 15:25 | |
| *** DarylM has quit IRC | 15:35 | |
| *** Alex| has quit IRC | 16:08 | |
| ccsidiot | Hi rossand, what is going to be asscessed for the group of UCOSP students as a whole? | 16:48 |
| *** cytrinox_ has joined #ingres | 20:25 | |
| *** cytrinox has quit IRC | 20:36 | |
| *** cytrinox_ is now known as cytrinox | 20:36 | |
| *** FrankW has quit IRC | 20:57 | |
| *** zxiiro has joined #ingres | 21:02 | |
| *** ChanServ sets mode: +v zxiiro | 21:02 | |
| ccsidiot | Hi pitschi | 22:05 |
| ccsidiot | Oops | 22:06 |
| ccsidiot | Sorry, wrong message | 22:06 |
| *** ccsidiot has left #ingres | 22:36 | |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!