GreenSQL

hey there Ace,

i cant put my finger on it specifically,
but check the following:

1. make sure that you can login with the mysql user and password written in config.php.
mysql -u -p

also check that the table "admin" exists and looks something like this:

mysql> select * from admin;
+---------+-------+------------------------------------------+-------+
| adminid | name | pwd | email |
+---------+-------+------------------------------------------+-------+
| 1 | admin | 37fa265330ad83eaa879efb1e2db6380896cf639 | |
+---------+-------+------------------------------------------+-------+
1 row in set (0.00 sec)

the default user and password is indeed "admin" and "pwd", which are used from the table.
the pwd column is simply encrypted.

2. make that that the php5-mysql package is installed although it seems like it is

Hi elishemer, thanks for replay

Unfortunately, I have to say that you're right but wrong turn :) because:

1. I can login with data provided in config.php, for example: greens:greens

2. table "admin" exist and contains proper data, admin:pwd

3. package php5-mysql is installed and is already in the newest version

4. I even installed Smarty :) :)

any other idea ??

thx

hey Ace

I just noticed something in the error message you provided earlier

the greensql-console is supposed to be installed to /usr/share/greensql-fw/
not to /var/www/ in the new version

try to see if you have the apache DocumentRoot directing to the old directory

hey elishemer

ok, i will put greensql-console in /usr/share/greensql-fw/ as you suggest, then we will see

but I think I should make an alias to this directory in apache, right

actually the files should be in there flat, not a directory within that directory

you can have a look at this howto: http://www.greensql.net/howto
Yuli there run the following:
cd /var/www && ln -s /usr/share/greensql-fw/ greensql

so you can have /var/www/greensql/ configured in apache.conf
even though the files are really in /usr/share/greensql-fw/*.php

you can also take a look at /etc/greensql/greensql-apache.conf if it's of any help for some examples

cheers

Hi elishemer

I did as yuli described in howto point 5 , thats OK
even uncomment needed lines in greensql-apache.conf and then try to login again

and of course got the same error
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/greensql/lib.php on line 146