today, apache and mysql services were X, but started 1.8.0

Problems with the Windows version of XAMPP, questions, comments, and anything related.

today, apache and mysql services were X, but started 1.8.0

Postby jmichae3 » 22. July 2012 08:19

Initializing Control Panel
10:51:08 PM [main] Windows Version: Windows XP SP3 32-bit
10:51:08 PM [main] XAMPP Version: 1.8.0
10:51:08 PM [main] Control Panel Version: 3.0.12 [ Compiled: June 24th 2012 ]
10:51:08 PM [main] Running with Administrator rights - good!
10:51:08 PM [main] XAMPP Installation Directory: "e:\xampp\"
10:51:08 PM [main] Initializing Modules
10:51:08 PM [apache] Possible problem detected!
10:51:08 PM [apache] Port 80 in use by "httpd.exe"!
10:51:08 PM [apache] Possible problem detected!
10:51:08 PM [apache] Port 443 in use by "httpd.exe"!
10:51:08 PM [filezilla] XAMPP FileZilla FTP Server Service is already running on port 21
10:51:08 PM [filezilla] XAMPP FileZilla FTP Server Service is already running on port 14147
10:51:08 PM [main] Starting Check-Timer
10:51:08 PM [main] Control Panel Ready
10:52:22 PM [main] Executing "services.msc"


this is what worries me about mysql... I saw this in event log.
E:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.25a-log' socket: '' port: 3306 MySQL Community Server (GPL)
Event Scheduler: Loaded 0 events
Server socket created on IP: '0.0.0.0'.
- '0.0.0.0' resolves to '0.0.0.0';
Server hostname (bind-address): '0.0.0.0'; port: 3306
Plugin 'FEDERATED' is disabled.
SeaPort:Service started/resumed

I have my.ini currently configured for host="127.0.0.1"
there may be some replication settings turned on MAYBE,but only because that's the way xampp sets things that way on installation.
socket = "MySQL"

and in the mysql logs,
120722 0:10:27 [Note] Plugin 'FEDERATED' is disabled.
120722 0:10:27 InnoDB: The InnoDB memory heap is disabled
120722 0:10:27 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120722 0:10:27 InnoDB: Compressed tables use zlib 1.2.3
120722 0:10:27 InnoDB: Initializing buffer pool, size = 16.0M
120722 0:10:27 InnoDB: Completed initialization of buffer pool
120722 0:10:27 InnoDB: highest supported file format is Barracuda.
120722 0:10:27 InnoDB: Waiting for the background threads to start
120722 0:10:28 InnoDB: 1.1.8 started; log sequence number 1591535
120722 0:10:28 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
120722 0:10:28 [Note] - '0.0.0.0' resolves to '0.0.0.0';
120722 0:10:28 [Note] Server socket created on IP: '0.0.0.0'.
120722 0:10:28 [Note] Event Scheduler: Loaded 0 events
120722 0:10:28 [Note] E:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.25a-log' socket: '' port: 3306 MySQL Community Server (GPL)


where does this 0.0.0.0 come from?
-------------------------
Jim Michaels
jmichae3
 
Posts: 39
Joined: 12. November 2007 09:41
Operating System: win7-64-sp1-ult-retail

Re: today, apache and mysql services were X, but started 1.8

Postby jmichae3 » 22. July 2012 09:46

problems were being caused by older version of rim blackberry desktop manager 4.6.
it is delaying the start of all winsock and networking I think by several minutes and might be causing a problem with the startup of apache and other server services (which try to start immediately). the network stuff isn't up.

mysql still comes up with 0.0.0.0 even though I wait until networking starts.

time to upgrade my old phone. :-(
-------------------------
Jim Michaels
jmichae3
 
Posts: 39
Joined: 12. November 2007 09:41
Operating System: win7-64-sp1-ult-retail

Re: today, apache and mysql services were X, but started 1.8

Postby jmichae3 » 23. July 2012 05:40

mod_perl didn't come with 1.8.0 either. I had moved all the older-dated modules to a subfolder and did a reinstall of 1.8.0 hoping it would do a better "upgrade" and replace older files.
12/20/2009 12:00 AM 33,424 mod_apreq2.so
12/20/2009 12:00 AM 29,432 mod_authn_alias.so
12/20/2009 12:00 AM 29,440 mod_authn_default.so
12/20/2009 12:00 AM 29,440 mod_authz_default.so
12/20/2009 12:00 AM 41,616 mod_autoindex_color.so
12/20/2009 12:00 AM 29,432 mod_bucketeer.so
12/20/2009 12:00 AM 29,440 mod_case_filter.so
12/20/2009 12:00 AM 29,448 mod_case_filter_in.so
12/20/2009 12:00 AM 33,528 mod_disk_cache.so
12/20/2009 12:00 AM 29,440 mod_example.so
12/20/2009 12:00 AM 33,528 mod_mem_cache.so
12/20/2009 12:00 AM 135,824 mod_perl.so
12/20/2009 12:00 AM 41,616 php5apache2_2.dll
12/20/2009 12:00 AM 41,616 php5apache2_2_filter.dll


I still see no new PHP DLL or module. I am unsure what to make of the upgrade process.
I have data and my.ini settings in my very old mysql database.
I have settings in my old filezilla ftp server I have to migrate... all of old xampp plus a new version install to a different drive.

now I hear that 1.8.0 is not an upgrade. I need an upgrade, and I am trying to make this as much of an upgrade/migration as possible.
I have exported my old mysql data successfully just in case.

apache starts fine now.
mysql will start, but only with address 0.0.0.0
filezilla starts just fine.
-------------------------
Jim Michaels
jmichae3
 
Posts: 39
Joined: 12. November 2007 09:41
Operating System: win7-64-sp1-ult-retail

Re: today, apache and mysql services were X, but started 1.8

Postby hackattack142 » 24. July 2012 22:45

The red 'X' beside the components only indicates that it is not installed as a Windows Service which is not an issue or required.

If you want to make MySQL listen on a different IP, you need to have
Code: Select all
bind-address="127.0.0.1"
in your "my.ini" file under the "[mysqld]" section. If it is there but has a '#' in front of it, remove that to uncomment it.

As for the other files, the different XAMPP versions are not necessarily "upgrade friendly". The new 1.8.0 has a new major upgrade to Apache (2.2.x -> 2.4.x) and all the older modules will not necessarily be compatible without specially recompiling them.
XAMPP Control Panel Developer
Latest CP: viewtopic.php?f=16&t=48932
hackattack142
 
Posts: 703
Joined: 20. May 2011 23:29
Operating System: Windows 7 Ultimate SP1 64-Bit

Re: today, apache and mysql services were X, but started 1.8

Postby jmichae3 » 25. July 2012 00:56

I tried that, but it still says 0.0.0.0 for some strange reason. I don't understand this.
I did the mysql_upgrade.
yeah, it does seem to be a little like Perl with its comments...
[client]
host = .
port = 3306
socket = "MySQL"
bind-address = "127.0.0.1"


had the information in the wrong section. (client, not mysqld). one teeny problem left - can't use mysql.
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'jmichae3'
boy I haven't dealt with this kind of stuff in years.
-------------------------
Jim Michaels
jmichae3
 
Posts: 39
Joined: 12. November 2007 09:41
Operating System: win7-64-sp1-ult-retail

Re: today, apache and mysql services were X, but started 1.8

Postby hackattack142 » 25. July 2012 01:11

As an example, my "my.ini" looks like this (default except for bind-address uncommented and the paths will probably be different for you):
Code: Select all
# Example MySQL config file for small systems.
#
# This is for a system with little memory (<= 64M) where MySQL is only used
# from time to time and it's important that the mysqld daemon
# doesn't use much resources.
#
# You can copy this file to
# D:/XAMPP/xampp180/mysql/bin/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is D:/XAMPP/xampp180/mysql/data) or
# ~/.my.cnf to set user-specific options.
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.

# The following options will be passed to all MySQL clients
[client]
# password       = your_password
port            = 3306
socket          = "D:/XAMPP/xampp180/mysql/mysql.sock"

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port= 3306
socket = "D:/XAMPP/xampp180/mysql/mysql.sock"
basedir = "D:/XAMPP/xampp180/mysql"
tmpdir = "D:/XAMPP/xampp180/tmp"
datadir = "D:/XAMPP/xampp180/mysql/data"
pid_file = "mysql.pid"
skip-external-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
log_error = "mysql_error.log"
 
bind-address="127.0.0.1"

# Where do all the plugins live
plugin_dir = "D:/XAMPP/xampp180/mysql/data/lib/plugin/"

# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
#
# commented in by lampp security
#skip-networking
skip-federated

# Replication Master Server (default)
# binary logging is required for replication
# log-bin deactivated by default since XAMPP 1.4.11
#log-bin=mysql-bin

# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id   = 1

# Replication Slave (comment out master section to use this)
#
# To configure this host as a replication slave, you can choose between
# two methods :
#
# 1) Use the CHANGE MASTER TO command (fully described in our manual) -
#    the syntax is:
#
#    CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
#    MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
#
#    where you replace <host>, <user>, <password> by quoted strings and
#    <port> by the master's port number (3306 by default).
#
#    Example:
#
#    CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
#    MASTER_USER='joe', MASTER_PASSWORD='secret';
#
# OR
#
# 2) Set the variables below. However, in case you choose this method, then
#    start replication for the first time (even unsuccessfully, for example
#    if you mistyped the password in master-password and the slave fails to
#    connect), the slave will create a master.info file, and any later
#    change in this file to the variables' values below will be ignored and
#    overridden by the content of the master.info file, unless you shutdown
#    the slave server, delete master.info and restart the slaver server.
#    For that reason, you may want to leave the lines below untouched
#    (commented) and instead use CHANGE MASTER TO (see above)
#
# required unique id between 2 and 2^32 - 1
# (and different from the master)
# defaults to 2 if master-host is set
# but will not function as a slave if omitted
#server-id       = 2
#
# The replication master for this slave - required
#master-host     =   <hostname>
#
# The username the slave will use for authentication when connecting
# to the master - required
#master-user     =   <username>
#
# The password the slave will authenticate with when connecting to
# the master - required
#master-password =   <password>
#
# The port the master is listening on.
# optional - defaults to 3306
#master-port     =  <port>
#
# binary logging - not required for slaves, but recommended
#log-bin=mysql-bin


# Point the following paths to different dedicated disks
#tmpdir = "D:/XAMPP/xampp180/tmp"
#log-update = /path-to-dedicated-directory/hostname

# Uncomment the following if you are using BDB tables
#bdb_cache_size = 4M
#bdb_max_lock = 10000

# Comment the following if you are using InnoDB tables
#skip-innodb
innodb_data_home_dir = "D:/XAMPP/xampp180/mysql/data"
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = "D:/XAMPP/xampp180/mysql/data"
#innodb_log_arch_dir = "D:/XAMPP/xampp180/mysql/data"
## You can set .._buffer_pool_size up to 50 - 80 %
## of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
## Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

## UTF 8 Settings
#init-connect=\'SET NAMES utf8\'
#collation_server=utf8_unicode_ci
#character_set_server=utf8
#skip-character-set-client-handshake
#character_sets-dir="D:/XAMPP/xampp180/mysql/share/charsets"

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout


I have no 'host' entry in mine so it is probably not necessary to have that in yours. I tried for mine and uncommenting the 'bind-address' results in '127.0.0.1' appearing in my mysql log file.

For the permissions issues, you can't use mysql in that you cannot start the server or you just can't query the server once it is running?
XAMPP Control Panel Developer
Latest CP: viewtopic.php?f=16&t=48932
hackattack142
 
Posts: 703
Joined: 20. May 2011 23:29
Operating System: Windows 7 Ultimate SP1 64-Bit

Re: today, apache and mysql services were X, but started 1.8

Postby jmichae3 » 25. July 2012 08:46

I also had one too many port= lines in the my.ini
thanks.
by the way, 1.8.0 changed key_buffer to key_buffer_size.

I tried to set a password to secure my xampp directory, and I got this bogus message:
ERROR: The string for the user name and password must have at least three characters and not more then 15 characters. Special characters like <öäü (usw.) and empty characters are not allowed!

this is definitely the wrong message.
-------------------------
Jim Michaels
jmichae3
 
Posts: 39
Joined: 12. November 2007 09:41
Operating System: win7-64-sp1-ult-retail

Re: today, apache and mysql services were X, but started 1.8

Postby jmichae3 » 25. July 2012 08:54

I looked at the code, it's a generic "setup not OK" error message. what to do about it I don't know.
-------------------------
Jim Michaels
jmichae3
 
Posts: 39
Joined: 12. November 2007 09:41
Operating System: win7-64-sp1-ult-retail

Re: today, apache and mysql services were X, but started 1.8

Postby hackattack142 » 26. July 2012 00:26

Setting up a .htaccess has nothing to do with MySQL. That feature works fine for me in the latest version. Did you install over or try to upgrade an older version of XAMPP in any way?

I copied that example my.ini directly from the default one in 1.8.0. If your rows are named differently, that makes me wonder a bit too.
XAMPP Control Panel Developer
Latest CP: viewtopic.php?f=16&t=48932
hackattack142
 
Posts: 703
Joined: 20. May 2011 23:29
Operating System: Windows 7 Ultimate SP1 64-Bit

Re: today, apache and mysql services were X, but started 1.8

Postby jmichae3 » 26. July 2012 07:08

hmm. I will try extracting a portable version and see if maybe a file didn't get updated like it should have.
it LOOKED like they did. the dates are 6/2012.
-------------------------
Jim Michaels
jmichae3
 
Posts: 39
Joined: 12. November 2007 09:41
Operating System: win7-64-sp1-ult-retail

Re: today, apache and mysql services were X, but started 1.8

Postby jmichae3 » 16. August 2012 00:05

I am having problems with the apache service sometimes showing up as "not installed" (red X) after boot.
-------------------------
Jim Michaels
jmichae3
 
Posts: 39
Joined: 12. November 2007 09:41
Operating System: win7-64-sp1-ult-retail


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 42 guests