HotelDruid

After installing on my web-site I tried to configure PHP-Residence. It gave me the error as mentioned above. There has been a topic about this issue earlier, but this was different because also an access issue. Here's my information:

- I created an empty database and username
- I used the prefix for my username (I don't get access error anymore)

It looks like I have to resolve a simple issue prior to using PHP-Residence.

Hi
Have a look at this thread, If you haven't already
http://www.digitaldruid.net/php-residen ... .php?t=396

I'd,
Try another install, do you have Cpanel or something like that to check your files after install???
There may be a problem with the settings on the files....!!!
Walter

I looked into your article already. It does not solve my issue. I do have PHPAdmin and that shows nothing from the application (no tables are made what so ever). The username and password are OK though

Hi
Ok then I guess the next question would be whether your website provider would support

REQUIRED SOFTWARE
-apache (>=1.3.26) or another web server that supports php
-php (>=3.0.18) with extension for postgresql, mysql or sqlite
-postgresql (>=7.4.7) or mysql (>=4.1.11) or sqlite
-a browser that supports forms with utf-8 encoding

I'm uploading all the file now for a new install, to see where the problem maybe..
This will help me remember what I did
Walter

Hi
Did you create the database prior to installing the software??
If you create the database first, you should be able to verify that it's there using MYSQL...
I believe that after you install PHP Residence, you would have a window wher you enter the respective Table name, username and password which you used when you created the database!!
Walter

Create a new DATABASE in MySQL Databases eg.' onlinebook"
Create new USER eg ' tester ' with PASSWORD eg ' testing'
, select all privileges Add USER to DATABASE

Thank you for your reply Walter,

-I have asked PHP version from IP. No response yet. I think it's 2.11.4. Any way around this?
-All other advices I have done accordingly without succes.

Again thanks,

Jeroen

Hi
Have a look at your Private Messages
As far as what to do with respect to PHP version, I don't no, Marco may be able to answer that!!!
I wonder if your problem is with creating the database and or access to it with PHP residence

In MYSQL
The first thing you would do is create the Database
Then you would create a Username, with a password, or you may already have some user names...
Next you Add Users to your Database ( the one you just crated , you will have to select it as well as the user), and select all Priveledges...
A note here you will find that the database has a prefix with an _ in front of the name..
It is important that you use the entire database name including that prefix as the database name when you configure PHP Residence initially...

Also, when you have this database created you can then go into PHPMYADMIN (I have Version 2.11.0) and see that it was created as well there you should also see the prefix again for that database
Walter

Hello Jeroen,
I doubt you have a php version lower than 4. This issue seems related to server configuration and not to php-residence, so once checked that all the parameters are correct (not only username and password) you should ask for support to your hosting provider. If you're the one in charge of the server management try reading about database configuration in the php-residence README.

Marco

Hello marco and Walter,

It indeed was an access problem. I misinterpreted user rights. Now it's correct I seem te get further.

Thanks for your prompt help