Geeklog Forums

I need help with my (new) installation of GL.

I get the first two windows of installation correctly. 1st one asks me to select whether its a NEW DATABASE or an UPGRADE. Same window shows me the path to GL. When I click NEXT here, the next window shows up correctly as well with a warning to back up the existing files and stuff with PREVIOUS and NEXT buttons. When I click NEXT, I get the following error:

error selecting database

I tried searching for this topic, but didn't find anything helpful to me. One post seemed useful that showed how to grant privileges from the command line. I tried copying the same thing in myPhpAdmin, but wasn't able to do so correctly. Also, its not mentioned in the /docs/install.html file so i am not sure whether it could stop me from installing the file. I think I've set up my config.php correctly, but here's some of the information that I have:$_DB_dbms = 'mysql';
$_DB_host = 'localhost';
$_DB_name = 'ana_db';
$_DB_user = 'ana_*****';
$_DB_pass = '******';
$_DB_table_prefix = 'gl_';
$_DB_mysqldump_path = '/usr/bin/mysqldump/'; //i am not sure the path, so i kept it as it is
$_CONF['allow_mysqldump'] = 1;

I also have the database set up correctly, and have used the information from there.

You can email me at thatsmehul@hotmail.com and I'll give you my username/pw to my ftp, and you can take a look at it.

Thanks in advance.

- M

Try this running this php file to see if you can connect to your db ok. It's a basic script that should return the contents of the table you choose to your browser window. Just fill in the appropriate info (i.e., replace the your_db.. with your info), save it as mysqlconnect.php and call it in your browser. <?php $link = mysql_connect("localhost", "your_db_username", "your_db_password" or die ("Could not connect"; print ("Connected successfully"; mysql_select_db ("your_db_name" or die ("Could not select database"; $query = "SELECT * FROM your_db_table"; $result = mysql_query ($query) or die ("Query failed"; // printing HTML result print "<table>\n"; while ($line = mysql_fetch_array($result)) { print "\t<tr>\n"; while(list($col_name, $col_value) = each($line)) { print "\t\t<td>$col_value</td>\n"; } print "\t</tr>\n"; } print "</table>\n"; mysql_close($link); ?>

I'm running into a similar problem; I get to the third page of the install and it's blank. I run the script here, and it said query failed. what do I need to do to fix it?

any ideas? query failed - what to try?

I had the exact same problem and did that test script and still couldn't get anywhere. this is what I did: ----------------------------------------------- GRANT ALL ON db_name.* TO user; Query OK, 0 rows affected (0.00 sec) <The user will be added to the mysql.user table. There's no password for the user so I had to do an UPDATE on the user table.> use mysql; UPDATE user SET password = PASSWORD('userpass') WHERE user = 'user'; <Now I can do the IDENTIFIED BY option in the GRANT cmd.> GRANT ALL ON db_name.* TO user IDENTIFIED BY 'userpass'; This problem was driving me crazy for about 2 hours. I haven't used mysql in a long long time and haven't created a user in a while in mysql. Anyways.. this could be totally incorrect. let me know if it is. charding.

I have the same problem. error selecting database Please help.

Here I am again. I reread the above articles and noticed the reference to php.ini I do not understand why the developers do not address this issue fully. There are people here that spend days even months trying to install! 1. How do you write a php.ini? 2. Is there an example of this? 3.Where do you place it? I run in a Unix environment. Thanks! Michael