Welcome to Geeklog, Anonymous Monday, April 15 2024 @ 09:01 am EDT

Geeklog Forums

Installation Problem, please help!


Anonymous

Anonymous
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
 Quote

Anonymous

Anonymous
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"Wink or die ("Could not connect"Wink; print ("Connected successfully"Wink; mysql_select_db ("your_db_name"Wink or die ("Could not select database"Wink; $query = "SELECT * FROM your_db_table"; $result = mysql_query ($query) or die ("Query failed"Wink; // 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); ?>
 Quote

Pujinka

Anonymous
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?
 Quote

Anonymous

Anonymous
any ideas? query failed - what to try?
 Quote

charding

Anonymous
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. Smile charding.
 Quote

Michael

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

Michael

Anonymous
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
 Quote

All times are EDT. The time is now 09:01 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content