Getting started after Installation

On 7 Aug, 00:49, w1ndy wrote:
> I found a post on the ingres forum, and I guess i dont need a username
> and password unless its a private db, and the demodb shouldn't be, i
> was able to connect to it when i tried this on windows no problem. im
> stuck i guess

On windows the user that installed windows will be the user that
created demodb. If the same user is the one running PHP then you will
be able to connect without problem.

Can you check the user who owns the database demodb, the user who is
running PHP and the user who is running apache?

You should be able to find more information and examples on the Ingres
wiki (http://community.ingres.com/wiki/Category:Examples) which
includes examples of connections with credentials and changing the
effective user.
 >> Stay informed about: Getting started after Installation 

On/El 07/08/08 01:49, w1ndy wrote/escribió:
> I found a post on the ingres forum, and I guess i dont need a username
> and password unless its a private db, and the demodb shouldn't be, i
> was able to connect to it when i tried this on windows no problem. im
> stuck i guess
>
Without knowing the error you are getting when issuing the
ingres_connect() it is a bit difficult to know what the problem is.
However the normal stumbling block is not having the web server process
owner as a valid Ingres user. I am not that familiar with Ubuntu,
however if it is like Debian the Apache web server runs as the user
"www-data". The process owner of Apache can be determined using:

ps -fe | grep apache

To add that user to ingres run the following as the ingres user:

sql iidbdb <<EOSQL
create user "www-data"\g
commit\g
\q
EOSQL

From there you should be able to connect to demodb using:

$link = ingres_connect("demodb");
if (!is_resource($link))
{
echo ingres_errno() . " - " . ingres_error();
}
....

If not then can you post the error you get. That should help us track
down the actual cause.

regards

grant

ps the steps for setting up Apache on Ubuntu may be similar to those
outlined in
http://community.ingres.com/wiki/Ingres_with_Apache_on_Debian_Etch.
Since Ubuntu is a derivative of Debian there should be many similarities
between the two.

--
Grant Croker - Ingres PHP, Ruby and Python maintainer
I first saw this program in the same week that evidence was discovered
of life on Mars. This is more exciting. -On the subject of Creatures,
an artificial-life computer program
 >> Stay informed about: Getting started after Installation 

On/El 07/08/08 01:49, w1ndy wrote/escribió:
> I found a post on the ingres forum, and I guess i dont need a username
> and password unless its a private db, and the demodb shouldn't be, i
> was able to connect to it when i tried this on windows no problem. im
> stuck i guess
>
Hi w1ndy,

Without knowing the error you are getting when issuing the
ingres_connect() it is a bit difficult to know what the problem is.
However the normal stumbling block is not having the web server process
owner as a valid Ingres user. I am not that familiar with Ubuntu,
however if it is like Debian the Apache web server runs as the user
"www-data". The process owner of Apache can be determined using:

ps -fe | grep apache

To add that user to ingres run the following as the ingres user:

sql iidbdb <<EOSQL
create user "www-data"\g
commit\g
\q
EOSQL

From there you should be able to connect to demodb using:

$link = ingres_connect("demodb");
if (!is_resource($link))
{
echo ingres_errno() . " - " . ingres_error();
}
....

If not then can you post the error you get. That should help us track
down the actual cause.

regards

grant

ps the steps for setting up Apache on Ubuntu may be similar to those
outlined in
http://community.ingres.com/wiki/Ingres_with_Apache_on_Debian_Etch.
Since Ubuntu is a derivative of Debian there should be many similarities
between the two.

--
Grant Croker - Ingres PHP, Ruby and Python maintainer
I first saw this program in the same week that evidence was discovered
of life on Mars. This is more exciting. -On the subject of Creatures,
an artificial-life computer program




--
Grant Croker - Ingres PHP, Ruby and Python maintainer
The teacher usually learns more than the pupils. Isn't that true?
"It would be hard to learn much less than my pupils," came a low growl
from somewhere on the table, "without undergoing a pre-frontal
lobotomy."


--
Grant Croker - Ingres PHP, Ruby and Python maintainer
The teacher usually learns more than the pupils. Isn't that true?
"It would be hard to learn much less than my pupils," came a low growl
from somewhere on the table, "without undergoing a pre-frontal
lobotomy."
 >> Stay informed about: Getting started after Installation 

Regarding the following pointer:

>You should be able to find more information and examples on the Ingres
>wiki (http://community.ingres.com/wiki/Category:Examples) which
>includes examples of connections with credentials and changing the
>effective user.

Not all examples on the Ingres Community Wiki have a category of
Examples. This is because some of the code examples referenced on the
wiki are stored in the Subversion Code repository & there is a pointer
to these examples with an explanation from the general Article page.

Articles about using Ingres & integration with other technologies can
be found at http://community.ingres.com/wiki/Ingres_Articles (Tech
Tips in the side naviagation pane) or http://community.ingres.com/wiki/Ingres_Examples
(Coding Samples in the side navigation pane).

As an aside, if you have any useful tips on using Ingres or Code
Samples that you would like to share with the Ingres Community via the
Ingres Community Wiki, please submit them as we all benefit from this
information. If you have the info but don't have time to learn how
to create articles on the wiki, feel free to email me with the
information & I'll gladly post it for you, giving you proper credit
for the contribution.

We are also very interested in any feedback you may have on the
Community Wiki as we are constantly looking to improve it. It's come
a long way but still has lots of room for improvement.

Regards,
Teresa
 >> Stay informed about: Getting started after Installation