Trouble Installing

[Arsht]

Hi,

I am trying to install Indexu Lite on my sites server. I have done everything that the readme said and when I go to install, I fill in the configuration details. All are correct, have checked them several times. Have checked the MySQL database is working on the server and that it exists. (Server is Unix/Linux). After completing the details, I hit the configure button and the install.php tells me:

Message
Unable to select database

I installed the script on my personal computer and it worked fine (Windows OS) yet for some reason it wont install on the actual webserver the site is located on.

Please help, the script looks great.

[Polo5]

make sure you have the correct information to connect to your database. the error that you are experiencing is because you enter the name of your database and/or databaseuser wrong. Hope this helps

[bigdaddy]

im having the same problem

although I did enter all of the correct information

triple checked it too..

[Polo5]

can you give your server details?>

[bigdaddy]

i fixed it, had to edit the install.php file

[Polo5]

what exaclty did you modified?

tell... just in case other people find the same problem...

thanks..

[bigdaddy]

I forced the variable definitions, instead of letting the form process them.

i think over here:
@MYSQL_CONNECT($db_hostname,$db_username,$db_pwd)
OR $error_msg = "Unable to connect to database";

@mysql_select_db($db_name)
or $error_msg = "Unable to select database";

I actually inputted my details.

[toneranger]

tried thie above fix - but will not read hostname correctly. my server is not using localhost but xxxxx.net. the script does not like .net

[toneranger]

Just about ready to give up on this script.

Since starting yesterday I have also installed 2 other related scripts (link directories) both ran 1st time using the same information indexu lite asks for during installation and on the same database/server.

Is there a fix for the line unable to select database, as editing the templates of indexu looks easier than the other scripts I have tried.

Toneranger

[esm]

you could try editing the database section of the application.php file starting about line 28:

// ----- database -----

$dbHostname = "localhost";
$dbUsername = "user";
$dbPassword = "password";
$dbName = "database";

if you have installed 2 other scripts, then you should be able to just copy a database section from one of those.

for official support from Nicecoder, send an email to support@nicecoder.com



.

[toneranger]

Hello - had tried this, completing all the detail down to line 55. Still fails with the same errors.

regards Toneranger

[esm]

...completing all the detail down to line 55.

not my area of expertise; but try editing line 404 with the actual values

  MYSQL_CONNECT($dbHostname,$dbUsername,$dbPassword)

.

[toneranger]

Hi esm, Thanks but no joy from your last post either.

host insists localhost will not work in connecting to database on their server.
have to use cogia.net

Thanks again
Regards Toneranger

[esm]

host insists localhost will not work in connecting to database on their server. have to use cogia.net

and so you tried something like?

  MYSQL_CONNECT("cogia.net","your_user_name","your_password")

a connection is just a connection. the PHP command MYSQL_CONNECT works the same way for INDEXU lite as it does for the other two prgrams you installed.

upload the following as a file to your server after making the needed changes for your_db_user_name and your_db_password. what are the results?

<?php
$link = mysql_connect("cogia.net", "your_db_user_name","your_db_password");
if (!$link) {
   die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>

.

[toneranger]

hi esm - that little script returns

Connected successfully

install script does not run index.php contains errors



» New Listings » Hot Listings » Top Rated » Editor Pick




Warning: mysql_query(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /home/www/tonwil.cogia.net/links/index.php on line 24

Warning: mysql_query(): A link to the server could not be established in /home/www/tonwil.cogia.net/links/index.php on line 24

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/www/tonwil.cogia.net/links/index.php on line 25

been in touch with host, who reports connection through socket not available

thanks again for your help.Toneranger