WS2 - No localhost,Apache or Mysql
Posted by: annie1 (---.2-1.cable.virginm.net)
Date: October 29, 2014 07:54PM

hi - i use WS2 to customize my cubecart v4.3 skins.

i last used it about 4 months ago but when i tried it today i found the following:

1) could not connect to localhost.

2) apache>service>start/resume service give error box "could not execute item (internal error)....." also test port 80 give "Your port 80 is not actually used"

3) clicking the the mysql start/resume service has no effect other than closing the menu & still shows green arrow.

is there a "relatively easy" way to fix this without installing another version of WS & having onerous task of having to install cubecart again?

to be honest i found it very difficult to get CC up & running last time but was fortunate to use the help of JLBN.net.

however, the JLBN site now seems to have problems with missing content etc.

many thanks


XP - 3 pack
firefox 30.0.2
wampserver v2 apache 2.2.6 - msql 5.0.45



Edited 1 time(s). Last edit at 10/29/2014 08:22PM by annie1.

Options: ReplyQuote
Re: WS2 - No localhost,Apache or Mysql
Posted by: RiggsFolly (---.dynamic.dsl.as9105.com)
Date: October 29, 2014 08:43PM

This usually means that Apache has not started.

We need to work out why!

Look at the APache error log, and if that does not give any clues, then look at teh Windows Event Viewer for messagesfrom Apache.

If its not obvious then post the errors here and we will apply our brains

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: WS2 - No localhost,Apache or Mysql
Posted by: annie1 (---.2-1.cable.virginm.net)
Date: October 29, 2014 09:17PM

thanks for your reply.

i checked the windows viewer & found nothing relating to apache.

howver a few of the most recent ws error log entries are:

[Mon Jun 30 02:20:34 2014] [notice] Child 4092: Starting 250 worker threads.
[Mon Jun 30 02:20:34 2014] [notice] Child 4092: Starting thread to listen on port 80.
[Mon Jun 30 02:21:30 2014] [error] [client 127.0.0.1] File does not exist: C:/wamp/www/favicon.ico
[Mon Jun 30 02:21:30 2014] [error] [client 127.0.0.1] File does not exist: C:/wamp/www/favicon.ico

Options: ReplyQuote
Re: WS2 - No localhost,Apache or Mysql
Posted by: RiggsFolly (---.dynamic.dsl.as9105.com)
Date: October 30, 2014 01:15AM

They are from June, and are not errors.

If Apache is failing to start, there almost definitely are error messages in the Windows Event Viewer

Look under 'Windows Logs -> Application'


Alternatively, what has changed on your system in the last 4 months that may effect Apache's operation??

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: WS2 - No localhost,Apache or Mysql
Posted by: annie1 (---.2-1.cable.virginm.net)
Date: October 30, 2014 03:20AM

hi - my apologies - i checked windows log again (way down the list) & found 5 errors:


date:29/10/14 (all errors)
source: application
type: error
event id = 1000

description: faulting application wampserver.exe version 1.6.1.33
failing module Kernel32.dll version 5.1.2500.5781.
fault address 0x00012alb

don't know how to resolve the "dll" problem?

thanks again

Options: ReplyQuote
Re: WS2 - No localhost,Apache or Mysql
Posted by: RiggsFolly (---.dynamic.dsl.as9105.com)
Date: October 30, 2014 10:05AM

Ok lets start by making sure you have all the required Microsoft C/C++ runtime libraries loaded on your system.

Read this and make sure you have them all [forum.wampserver.com]

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: WS2 - No localhost,Apache or Mysql
Posted by: annie1 (---.2-1.cable.virginm.net)
Date: October 30, 2014 05:11PM

hi - i don't have a "programs & features" but i checked "add/remove programs" & found:

ms visual c++ 2005 redistributable - version 8.0.59153

and

ms visual c++ 2008 redistributable - x86 9.0.30729.4148

thank you.

Options: ReplyQuote
Re: WS2 - No localhost,Apache or Mysql
Posted by: annie1 (---.2-1.cable.virginm.net)
Date: October 30, 2014 11:48PM

hi - i did a system restore to last month.


i can now get localhost & apache is now in service however mysql is still showing as not in service

when i tried my cubecart i got

Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'localhost' (10061) in C:\wamp\www\cubecart430\classes\db\db.php on line 42
Can't connect to MySQL server on 'localhost' (10061)

thanks

Options: ReplyQuote
Re: WS2 - No localhost,Apache or Mysql
Posted by: RiggsFolly (---.dynamic.dsl.as9105.com)
Date: October 31, 2014 12:24AM

Look at the mysql error log and/or Windows Event Viewer for messages from MySQL.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: WS2 - No localhost,Apache or Mysql
Posted by: annie1 (---.2-1.cable.virginm.net)
Date: October 31, 2014 07:02PM

hi - i'm giving up trying to fix my WS2 for my cubecart. but thanks for your help.

instead i'm going to install WS 2.2e (for xp) but as it was about 3 yrs ago when i installed the old WS 2 version i have forgotten the procedure for adding zend optimizer & ioncube loader.

as mentioned i originally used the guides provided by JLBN.net but when i checked again i found end pages missing from most of the guides.

i have 2 questions:

1) can any one please point me to a guide or help regarding the above mentioned?

2) regarding the old WS 2 - do i just uninstall it? - the "www" contains my cubecart , ioncube loader, zend optimizer both originally downloaded from JLBN - i have a copy of my cubecart.

again thanks for your help

Options: ReplyQuote
Re: WS2 - No localhost,Apache or Mysql
Posted by: RiggsFolly (---.dynamic.dsl.as9105.com)
Date: October 31, 2014 08:41PM

Regarding installing a new WampServer release read this to help you do it without loosing what you already have.

RE: ioncube loader

Instructions can be found here [www.ioncube.com]

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: WS2 - No localhost,Apache or Mysql
Posted by: annie1 (---.2-1.cable.virginm.net)
Date: November 01, 2014 03:14AM

hi RiggsFolly it's me again - i installed WS v2.2e - all is "green light" except for phpmyadmin.


i'm getting the error:

#2002 - No connection could be made because the target machine actively refused it.

The server is not responding (or the local server's socket is not correctly configured).


i've tried looking for stray my.ini/my.cnf files, changing listen 80 to listen 000:80 & deleting session files in tmp as suggested - no luck

here's the mysql log:for the new install:

141031 23:27:43 [Note] Plugin 'FEDERATED' is disabled.
141031 23:27:44 InnoDB: The InnoDB memory heap is disabled
141031 23:27:44 InnoDB: Mutexes and rw_locks use Windows interlocked functions
141031 23:27:44 InnoDB: Compressed tables use zlib 1.2.3
141031 23:27:44 InnoDB: Initializing buffer pool, size = 128.0M
141031 23:27:44 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
141031 23:27:44 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
141031 23:27:45 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
141031 23:27:45 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
141031 23:27:46 InnoDB: Waiting for the background threads to start
141031 23:27:47 InnoDB: 1.1.8 started; log sequence number 0
141031 23:27:48 [Note] Server hostname (bind-address): '(null)'; port: 3306
141031 23:27:48 [Note] - '(null)' resolves to '0.0.0.0';
141031 23:27:48 [Note] Server socket created on IP: '0.0.0.0'.
141031 23:27:58 [Note] Event Scheduler: Loaded 0 events
141031 23:27:58 [Note] wampmysqld: ready for connections.
Version: '5.5.24-log' socket: '' port: 3306 MySQL Community Server (GPL)
141101 1:55:16 [Note] Plugin 'FEDERATED' is disabled.
141101 1:55:16 InnoDB: The InnoDB memory heap is disabled
141101 1:55:16 InnoDB: Mutexes and rw_locks use Windows interlocked functions
141101 1:55:16 InnoDB: Compressed tables use zlib 1.2.3


appreciated if you can help.

Options: ReplyQuote
Re: WS2 - No localhost,Apache or Mysql
Posted by: RiggsFolly (---.dynamic.dsl.as9105.com)
Date: November 02, 2014 02:09PM

Well MySQL seems to have initialized correctly, so maybe its a this bit that is the problem

(or the local server's socket is not correctly configured).

SO lets try this to reset your network

Open a command prompt as Administrator and
Run

netsh winsock reset
netsh winsock reset catalog
netsh int ip reset reset.log
netsh int ipv4 reset reset.log
netsh int ipv6 reset reset.log
ipconfig /flushdns

Reboot if necessary

Try apache again

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: WS2 - No localhost,Apache or Mysql
Posted by: annie1 (---.2-1.cable.virginm.net)
Date: November 04, 2014 01:59AM

many thanks RiggsFolly for your help - done as suggested & great, WS is now working.

i've tried to install my cubecart 4.3 having initially setup db & user in phpmyadmin.& created a new

global.inc.php file

however, i am getting a blank page during install on going from step 3 (input of db & admin info etc) to step 4

(permission).

once again, thanks

Options: ReplyQuote
Re: WS2 - No localhost,Apache or Mysql
Posted by: RiggsFolly (---.dynamic.dsl.as9105.com)
Date: November 04, 2014 10:46AM

If you are using any kind of CMS/Framework it will make your life easier if you create a Virtual Host in Apache for it to run in.

A Virtual Host has many benefits but the main one is it makes the site think it is running as the only site under Apache, and allows the DocumentRoot to be set correctly rather than just putting the software in a subfolder of \wamp\www

Here is a Document describing how to set them up. [forum.wampserver.com]

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote


Sorry, only registered users may post in this forum.