Installing with DirectNIC hosting

jatrimar / 2011-07-08 15:07:23   

Hi All,

I realize that this forum has seen many posts about installation and the "XX We cannot connect or install the database" message. However, after spending a whole reading other posts, talking to people at DirectNIC on the phone all day, and so on, I still can't get past it.

I created a database, created a user, added the user to the database. I have the correct database server info: it's shareddb2.dnchosting.com. And yet, always:

XX We cannot connect or install the database

If it helps, the people at DirectNic changed the three folders that I'd changed to "777" to "755." They said 777 permissions settings cause their control panel to crash.

Any help appreciated, of course. I love the look of indexhibit and am willing to sweat a little to make it work.

-jt
www.jamestrimarco.net

rickykappa / 2011-07-08 15:28:39   

looks like you didn't enter your info yet:
http://www.jamestrimarco.net/ndxz-studio/install.php
remember to delete (or rename) the install.php after you're done

jatrimar / 2011-07-08 15:40:32   

Hi,

Thanks for responding, Ricky. I have entered this info (you mean the data server, database name, etc?) many times, but, after I do, I still get only:

XX We cannot connect or install the database

I tried deleting install.php but evidently the process just isn't done yet because I get back an error message that it's looking for install.php.

???

rickykappa / 2011-07-08 15:49:35   

you shouldn't delete the install.php until you're not done...
you need to reupload it in the ndxz-studio folder online and try again to enter -yes- the database required fields.
if it doesn't work don't panic! and post here the info you're typing in (except your password, which I assume you know yourself!) so people can help you
;-)

pernin / 2011-07-08 15:54:26   

i don't understand, the database seems to be installed, and there's the login screen at: www.jamestrimarco.net/ndxz-studio/

have you deleted the index.php at the root?

jatrimar / 2011-07-08 16:05:13   

Hi Pernin,

Yes, I see the login screen, too. Do you think that means installation is complete? I don't think so, as I never specified a login and password, nor have I successfully directed Indexhibit to my database. I tried deleting index.php at the root to see, but the same error message still comes up.

Here are the database required fields as I'm entering them. They refer to a database I created in directNIC's control panel, called jatrimar_writing.

Exhibition Name
writing

Database Server
shareddb2.dnchosting.com

Database Name
jatrimar_writing

Database Username
jatrimar_james

Database Password
XXX

pernin / 2011-07-08 16:08:49   

the database must be installed, otherwise i don't think you could even get a login screen

replace the correct index.php and htaccess at the root and see if you can login

jatrimar / 2011-07-08 16:19:29   

Ok, I replaced index.php and htaccess at the root level, using the files in the download file.

Then I went back to the login screen, using index1 and exhibit to login. But I get

"Your password or login are incorrect. Try again."

rickykappa / 2011-07-08 16:21:52   

there is a reset password tool in the download section...

however I suspect that
Database Server : shareddb2.dnchosting.com
is not exactly what
Database host is meant

if you can't pass through with the above data try once leaving in the localhost info.

jatrimar / 2011-07-08 16:26:24   

Well, I just put the install.php back and then tried the whole thing again with localhost. Doing that, I get a different error message:

XX Please check your config settings again.

jatrimar / 2011-07-08 16:28:23   

Also, trying to use the reset.php code gives me this message in the web browser:

Looks OK.
pernin / 2011-07-08 16:29:45   

yes, it's installed, but my guess is that the installation is corrupted, that's what the error message at www.jamestrimarco.net seems to be saying

it may be that using the reset script would solve it, but on the other hand, this being just the beginning, doing a total clean reinstall would save time and effort in the long run ;-)

rickykappa / 2011-07-08 16:36:07   

can you check via ftp if you have a config.php file already there in the ndxz-studio/config/ folder?
if so erase the config.php and try once more to enter the installation steps

also remember you should put back the index.php and htaccess in your root directory

rickykappa / 2011-07-08 16:37:04   

(late?!) oh yes, maybe better... ;-)

jatrimar / 2011-07-08 17:11:37   

Hi guys,

I'm still stuck:

Trying to reset simply brings up a "Looks OK" screen.

There is nothing in the config folder, so I can't erase that.

I tried deleting everything, re-uploading, and pointing to a new database, but the results are exactly the same:

XX We cannot connect or install the database.

rickykappa / 2011-07-08 17:27:18   

excuse me, but if you reuploaded everything again as you say, how comes your http://www.jamestrimarco.net/index.php is still missing as before?
this all sounds strange...
are you working locally by chance?

jatrimar / 2011-07-08 17:28:40   

Here's what the people at DirectNIC wrote me:

I had to delete your user and recreate it with the password xxxxx. I received a different error this time which indicates that their are problems with the code in the index.php.

pernin / 2011-07-08 17:30:23   

well, if there's nothing in the config folder, then you could try to run the install.php again, as ricky mentioned before

pernin / 2011-07-08 17:32:36   

(hah! late-ish...;-) the index.pphp is there at the root, but the installation seems to be incomplete, weird...

pernin / 2011-07-08 17:36:55   

the index.php at the root looks to see what theme is chosen at line 80-ish, but if it's not eatock it should be looking for sample or another one, and as there's no active choice (incomplete installation) it looks for ndxz-studio/site/index.php, which of course doesn't exist

pernin / 2011-07-08 17:49:29   

ok, a guess, you should have a ndxz-studio/config/config.example.php (i get not response there, but you should find it in the original installation)

try putting the install information in there and rename it config.php I'm guessing that the permissions issue hung up the installation just there, as it is this directory that you needs to be writable at installation and needs to be protected afterwards

once you get that config.php file there, try to login (not reinstall, and see if it accepts the password

jatrimar / 2011-07-08 18:37:48   

Hi Pernin,

Thanks for being so patient with me — my skills are kind of primitive in this sort of thing.

So, I grabbed the config example and put my stuff in the codes, like so:

  1.  <?php  if defined'SITE' exit'No direct script access allowed'

$indx['db']         = 'jatrimar_work';
$indx['user']         = 'jatrimar_jat';
$indx['pass']         = 'XXXXX';
$indx['host']         = 'shareddb2.dnchosting.com';
$indx['sql']        = 'work';

?>

"Work" is the name of the exhibit — is that right? Anyway, I put this in the config folder and tried to login. Password is still wrong.

There seems to be some kind of issue with index.php, judging from the error message on the main site.

jatrimar / 2011-07-08 18:54:55   

Also, in phpmyadmin, it says there are NO TABLES in any of these databases. I can't figure out how that's possible.

rickykappa / 2011-07-08 19:00:27   

this is what I have in my config.php, and it's there by default, you shouldn't touch it:
$indx['sql']        = 'mysql';
leave "work" aside, it is useless at this stage.
try again, good luck 'till tomorrow
(late night here... ;-)

Vaska A / 2011-07-18 14:57:28   

I managed to install this - but there are some odd things about the server.

What I did was manually installed the database with PHPMyAdmin. The installer does work, but does not install the tables.

I believe it's a mod_security issues. If you find this thread in the future and are having some issues you might ask your host if that could be the issue. Normally, they are happy to make small adjustments on that front.

This thread has been closed, thank you.