MySQL - install help

Regular Joined: Apr 26, 2007 Posts: 89

Up loaded latest version of RN when it got to this I received this message.

[14:58:18] 257 "/htdocs/BMF/images/nukesentinel/countries"
[14:58:18] TYPE A
[14:58:18] 200 Switching to ASCII mode.
[14:58:18] PASV
[14:58:18] 227 Entering Passive Mode (xxx,xxx,xxx,xx,xxx,xx)
[14:58:18] Opening data connection to xxx.xxx.xxx.xx Port: 57384
[14:58:18] LIST -aL
[14:58:39] A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
[14:59:18] 425 Failed to establish connection.
[14:59:18] CWD /htdocs/BMF
[14:59:18] 250 Directory successfully changed.
[14:59:18] PWD
[14:59:18] 257 "/htdocs/BMF"
[14:59:18] PASV
[14:59:18] 227 Entering Passive Mode (xxx,xxx,xxx,xx,xx,xxx)
[14:59:18] Opening data connection to xxx.xxx.xxx.xx Port: 13822
[14:59:18] LIST -aL
[14:59:18] 150 Here comes the directory listing.
[14:59:19] 2511 bytes transferred. (15.7 KB/s) (156 ms)
[14:59:19] 226 Directory send OK.
[14:59:19] Transfer failed.

So after this I proceeded to continue with the install.

http://www.yourdomain.tld/INSTALLATION/installSQL.php

And I was able to get steps 1-5 done with no problem.

Step 6 no go...

step 6a no go - message I received.

The exact error message that your MySQL server reported is:
MySQL Error # 4 = Duplicate entry '982745088-982753279' for key 1

tried it again and the same message. I would think that this has to do with the FTP up-load ?

Any help would be cool.

GOM

Posted: Thu May 03, 2007 1:30 pm

ok. did the http://www.yourdomain.tld/INSTALLATION/setup.php

All was fine till I went to http://www.yourdomain.tld/index.php

Blank page, nothing.....

????????

GOM

Posted: Thu May 03, 2007 3:18 pm

It looks like your FTP process did not complete successfully. Without that completing nothing will work. Compare the directory structure of your unzipped distribution with that on your server. They need to be identical ... the same set of files. Otherwise you will have problems consistently. It's not possible to tell from your posting how far your FTP transfer got but it needs to do the whole thing.

registered · Posted: Thu May 03, 2007 6:38 pm

Also, you will find us preaching here quite often to make sure and use a good FTP client. I personally recommend FileZilla as it is both free (from sourceforge.net) and I have NEVER had an issue with it uploading properly.

Posted: Thu May 03, 2007 7:33 pm

Well got FileZilla up loaded the CMS again. When I tried to do the /INSTALLATION/installSQL.php, I received a

PAGE NOT FOUND

We cannot locate the page you're looking for. Please check the address and make sure all letters are lowercased with no spaces. You may also move to a different page by using the links in the menu bar above.

So I am trying again to up load everything to see whats happens now...

Thanks for everybody help...

GOM

Posted: Fri May 04, 2007 6:08 am

If you physically see the file there in that directory with your FTP client, then are you certain that you are giving the right address in your browser? It should be:

http://yourdomain/INSTALLATION/installSQL.php

If that is truelly not working, you may have to get with your host as it sounds like you may have a setup issue.

Posted: Fri May 04, 2007 6:20 am

montego wrote:

If you physically see the file there in that directory with your FTP client, then are you certain that you are giving the right address in your browser? It should be:

http://yourdomain/INSTALLATION/installSQL.php

If that is truelly not working, you may have to get with your host as it sounds like you may have a setup issue.

Well it did work on my first up load, the one that did not complete all the way. I was able to get steps 1-5 done. So I am up loading every thing again to see what happens. will let you all know the out come..

Posted: Fri May 04, 2007 6:32 pm

K.

I don't know now.

On my first up load that did not complete right, I was able to go to http://www.xxxxxxxxx.com/INSTALLATION/installSQL.php and run the set up and got done with steps 1-5.. look above at the rest of post.

So I trashed everything in the root and up loaded again, and I get this message.

PAGE NOT FOUND
We cannot locate the page you're looking for. Please check the address and make sure all letters are lowercased with no spaces. You may also move to a different page by using the links in the menu bar above.

You know this from the post above..

So to make this short, I ended up trying 3 FTP clients. FileZilla, SmartFTP & I even try it on my MAC using Fetch, and all give me

PAGE NOT FOUND
We cannot locate the page you're looking for. Please check the address and make sure all letters are lowercased with no spaces. You may also move to a different page by using the links in the menu bar above.

when I go to http://www.xxxxxxxxx.com/INSTALLATION/installSQL.php

But all files are in root.

Now, when I go to http://www.xxxxxxxxx.com/

I get this message

There seems to be a problem with the MySQL server Configuration Table - It's missing.

If you are installing this for the first time, did you remember to run INSTALLATION/installSQL.php file?

Otherwise, please report this to the Administrator ASAP.

We should be back shortly.

I am able to see all files, I can see the HowToinstall, etc.

I was able to get to the http://www.xxxxxxxxx.com/INSTALLATION/installSQL.php

My first try, but not now.

INSTALLATION is chmod 765, is this right ?
installSQL.php is chmod 664, is this right..

I think that this is what it should be, but hay what do I know. lol

The only thing I can think of now is did my RavenNuke_v2.10.00.zip get messed up..

Time for some Halo, let of some steam....

GOM

Posted: Sat May 05, 2007 7:52 am

it's a new day did another up load.

Same thing no go. I do not see why it work the first time but now it does not want to work.

I am way to frustrated now.

Posted: Sat May 05, 2007 7:53 am

You can CHMOD the INSTALLATION directory 777 and the install.sql if you must, it doesnt really matter as you'll be deleting after a succesful install.
From the problems you are experiencing, you might want to run a tracert to the server IP, it sounds very much like you ftp connection is dropping out.
Assuming you took the advice above and compared the file structures, did you notice of any of the installation files have a zreo byte count?

Posted: Sat May 05, 2007 10:04 am

The only one w/ zero byte count is index.html

My other files like let's say installSQL.php shows 20KB on my PC but on the server shows 19758 KB

setup.php on pc shows 25KB on server shows 24212 KB

Could this make or break it.. ?

Ftp client says - Upload successful

registered · Posted: Sun May 06, 2007 5:30 pm

There is no problem there - the server is showing bytes!
19758 bytes rounds up to 20 kilobytes (KB)
24212 bytes rounds up to 25 kilobytes (KB)

Posted: Tue May 08, 2007 6:04 am

k.

Still not working after yet another up load. Now I am wondering if it has to do with the path ? The only reason I have not thought about this before as it worked the first time other then the bad up load, as you all know from this post. I host over at netsol and my path to the directories is /htdocs/07BSU/ all the nuke file are in 07BSU. Would I need to change any thing in the config.php or in any other file for absolute path ? I would think not as it did work on my first try for the most part. my domain name points to 07BSU in my netsol preff's...

Thanks for all the help that you have been giving me..
I rely want to get this up and running, I just don't see why it worked on the first try all the way up to step 5 in the install and now no go.. Crazy electrons do not want to play nice..

Posted: Tue May 08, 2007 10:21 am

So I have decided to install on my local box here at home to see if i could get it to work and all. w/ MySql 5.0.37

this is what I get when i go to INSTALLATION/instalSQL.php

404 Error

Not Found
The requested URL /INSTALLATION/'.$_SERVER['PHP_SELF'].' was not found on this server.

Apache/1.3.33 Server at g5.local Port 80

I have looked at this post http://www.ravenphpscripts.com/postt12866.html but this post was for a This post was for a 400 error. As I am a noob, how do I get to the php.ini file ? I have set this up on my MAC - OS 10.4.8

This is all crazy I no problem setting up Nuke 8.0 on my mac or on my server, but Rnuke is giving me problems.

Help.. I am getting bummed out now.

Posted: Tue May 08, 2007 10:23 am

PS,

Can I just use MyphpAdmin to import all DB tables with out using the installSQL.php ?

Posted: Wed May 09, 2007 6:26 am

gom, I use the XAMPP distribution of Apache, PHP, mySQL, etc. on my local PC and have installed this probably over a hundred times. A 404 error is sounding to me like you are not getting the URL to your site files right. I just don't know what else to tell you. Smile

With regards to using phpMyAdmin, you absolutely can use this, but make sure you import the files in the right order:

rn_core_pl32.sql
rn_nsngroups.sql
rn_htmlnewsletter.sql
rn_resendemail.sql
rn_sentinel.sql

The difficulty comes in with the IP to Country files. These are HUGE. For now, I'd recommend not loading them until you get a working nuke version.

Posted: Thu May 10, 2007 6:28 am

As you can see by this long topic I have not been able to get this to work.

http://yourdomain/INSTALLATION/installSQL.php

Like I said it work the very first time steps 1-5.. but step 6 did not.

I have up loaded this to many time and no go every time.

I keep getting 401 Authorization Required error

Message reads :

PAGE NOT FOUND

We cannot locate the page you're looking for. Please check the address and make sure all letters are lowercased with no spaces. You may also move to a different page by using the links in the menu bar above.

----
Everything is in root it's ALL of it.
I do not see why it would work one time and now not at all. Could my host provider have put a flag up do the the step 6 part of the install ? I do not no what to do any more, so I guess I can not use this product, to bad for me. It would have been nice to give it a try. I guess I just have to stay with FB's crappy unsafe 8.0 at least this works for me and I had no problem setting it up.

Thanks for all you help, but none of it worked..

Lost in the 010101010101 world.

GOM

Posted: Thu May 10, 2007 6:32 am

PS.

Here is my domain if any one wants to check it out.

http://www.blackmountainfoods.com/

Posted: Thu May 10, 2007 6:32 am

Wait a minute! This is the first time that you have said this was a 401 error. All along, unless I missed it, you've been saying 404. Those are completely different problems.

Try, for now, removing the uploaded .htaccess file. I have a "hunch".

Posted: Thu May 10, 2007 6:37 am

404 was for my local install sry.. I am back to my uploaded in stall now..

Posted: Thu May 10, 2007 6:37 am

I went to your site and I am not getting 401.

I tried this just now:

http://www.blackmountainfoods.com/INSTALLATION/installSQL.php

That file is definitely NOT in your root. Although I may not be able to get to it until Monday, you might want to PM me your FTP userid / password and I'll try and get this going for you. However, also in that PM you need to give me your dbname, dbuser and dbpasswd OR make sure those are correct in your config.php file.

Posted: Thu May 10, 2007 6:38 am

Quote:

That file is definitely NOT in your root.

Sorry, the above should have read:

"That file is definitely not accessible by the web server in that location"

Posted: Thu May 10, 2007 6:48 am

Like I was saying this is with netsol. I have a directory pointer to /07BSU for my domain. It worked the the first time but not now. So the root to my domain is 07BSU and all files in html have been uploaded to 07BSU and this would be root for www.blackmountainfoods.com I have a few sites up and running on my server with netsol, and only one of them is in htdocs/ all the rest have pointers to there directory's

site 1. htdocs/07BSU

stie 2. htdocs/ xxxx

site 3. htdocs/ xxxx etc. you can see now how I have my sites set up.

I was thinking that my pointer was messed up but when you go to www.blackmountainfoods.com you get the nuk message about Sql DB tables not being installed. so the pointer is working.

everything is in root..

Posted: Thu May 10, 2007 6:50 am

domain pointer is what I meant... sry

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

Some of these steps may already have been mentioned but I am writing this as if nothing has been tried.

Since you can get to http://www.blackmountainfoods.com/ and trying to goto any file in the INSTALLATION folder is returning a 401/Page Not Found error, there is either something wrong with the permissions/ownership on the INSTALLATION folder and/or there is something in your .htaccess file that is causing it. The INSTALLATION folder and all folders beneath it should be set to 755. All files should be 644.

If those are correct then check the ownership of the INSTALLATION folder and its contents to be sure that they are correct. Also make sure that the INSTALLATION folder has this structure (case sensitive). The size(s) may vary a little but they should be close.

INSTALLATION (folder)
-- language (folder)
-- sql (folder)
-- index.html (0 bytes)
-- installSQL.php (18,698)
-- installSQLREADME (390 bytes)
-- lang_config.php (76 bytes)
-- logo.gif (6017 bytes)
-- setup.php (22,241 bytes)

If it still doesn't work, delete the INSTALLATION folder and all its contents and ftp it again using BINARY transfer.