What am I doing wrong

[Anonymous]

This is my setup:

OpenRealty 3.01
Linux box
PHP 4.2
MySQL 3.2

This is my database setup;

I created a blank databse called 'test'. Set up a user called 'henry' with password 'henry1' on localhost.

This is from the common.php file:

$config[baseurl] = "155.239.118.163/phpMyAdmin/test/openrealty";
$config[basepath] = "/srv/www/htdocs/phpMyAdmin/test/openrealty";


global $db_type;
$db_type = "mysql";

$db_user = "henry";
$db_password = "henry1";
$db_database = "test";
$db_server = "localhost";

When I use this config it gives me;

Warning: Access denied for user: 'henry@localhost' (Using password: YES) in /srv/www/htdocs/phpMyAdmin/test/openrealty/include/adodb/drivers/ adodb-mysql.inc.php on line 120

When I change $db_user = "henry"; to
$db_user = "root"; it does not give me any errors, I get the login pages, but it would not let me log in. I even changed the priviledges on the 'test' databse to;

Select Insert Update Delete Create Drop Reload Shutdown Process File Grant References Index Alter

I know I did something wrong, I just can not figure it out for the life of me.

Configurator did not work for me at all. I ran the openlistings.sql scripts in phpMyAdmin. It created all the databases without a problem.

I can not log on. I can not create a new user. Basically I can not do anything.

Any help would be greatly appreciated, because this is my first project with php and mysql.

[Anonymous]

Oh yes, I even went as far as setting all the permissions on all the files and folders to 777 (read,write,execute)

I sincerely hope all this info is helpful.

[greengiant]

The login username and password for open-realty is different then the database username and password.. You should be using the username of "admin" and password of "password" to login to open-realty the first time.

[Anonymous]

I used those, but it just stands there laughing at me

[greengiant]

Is "register_globals = on" in your php.ini file?

[Denver Dave]

If the items listed are your real logon and passwords, be sure to soon change them.

Are you able to connect to the database with any other script such as a simple one of your own or phpMyAdmin ?

[Anonymous]

I tried multiple times to get logged in....phpmyadmin shows you, Ryna as the admin user...however when I try to log in it does not work...I am not a programmer..but I am an intuitive enough script kiddie to know that you buggered something up... my setup is presently running a shopping cart/store application/classifieds listings and a client login application..i will send any information you need..lets just get this fixed!!!grrrrrrrrrrrr

[greengiant]

Hi,

Can you send me or post a link to your phpinfo().

[Anonymous]

Warning: Access denied for user: 'open@localhost' (Using password: YES) in /home/admin/internet/deprise.com/www/open-realty/include/adodb/drivers/adodb-mysql.inc.php on line 175

If I change the user name and password in the common.inc.php file to 'root' and 'rootpassword' I no longer get the above error but open-realty tells me there is a problem and to contact the system admin.

What are we missing?

I can connect to the database 'openrealty-site' with phpmyadmin.

Thanks,
Chuck

[Anonymous]

I'm getting exactly the same problems, I've set up jon's version quite a few times on diferent servers and can't get either his or this fork version to work.

Any ideas greatly appreciated (especiallly as my Client is now moaning about the website that worked fine on my own hosted site demo area but not on his hosting....

tx

[cjreynolds]

Just curious but did you give your "open" user a grant to the database with all the permissions checked???. What I usally do is setup a user with no access to the server database then give a grant to a specific database with all the permissions checked. Maybe the user "open" doesnt have any rights to modify that database

[reporticatoo]

Red Hat Linux 6.2 53
Apache version 1.3.22
Open-Realty 1.0.6

Link to phpinfo sent to ryan/greengiant in a separate email.

I cannot get the system to accept the username admin and the password. I have set up the database user and database with all permissions just for debugging, no help. register_globals being on The configure script did not work but the information was added to the database manually.

Thanks for any tips you might have.

Sheryl :(

[reporticatoo]

I re-started apache, now I can log in, but it is not reading config info from common.php. At least, the name of the realty does not reflect the info I typed in.

[reporticatoo]

: Unable to access /home/jeff/www.jerseysuccess.com/htdocs/realty/images/user_photos/thumb_3_p.jpg in /home/jeffde/www.jerseysuccess.com/htdocs/realty/admin/user_edit.php on line 277

Warning: getimagesize: Unable to open '/home/jeff/www.thedomain.com/htdocs/realty/images/user_photos/thumb_3_p.jpg' for reading. in /home/jeff/www.thedomain.com/htdocs/realty/admin/user_edit.php on line 277

Warning: Division by zero in /home/jeffde/www.jerseysuccess.com/htdocs/realty/admin/user_edit.php on line 280

----------------------------------
I looked in the images directory and there is no user_photos. I never attempted to create one.

[Anonymous]

Hi,

Did anyone sort out the problem? I have had a bad day basically installing and re-installing the same thing all day and get exactly the problems Sheryl describes in the above post.

Please help

Bob

:shock:

[greengiant]

: Unable to access /home/jeff/www.jerseysuccess.com/htdocs/realty/images/user_photos/thumb_3_p.jpg in /home/jeffde/www.jerseysuccess.com/htdocs/realty/admin/user_edit.php on line 277

Your base path is incorrect it should be

/home/jeffde/www.jerseysuccess.com/htdocs/realty

not

/home/jeff/www.jerseysuccess.com/htdocs/realty

[Anonymous]

Hi, Think it was the basepath but sorted apart from the access to form edit.

One day I'll learn stuff .

Cheers

Bob :D