Mysql & Apache problems (mysql daemon doesn't start?)

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

Mysql & Apache problems (mysql daemon doesn't start?)

Postby drjake » 02. October 2006 11:42

Hello everybody,

First off, thanks for a great piece of software, i've never found a piece of server software so easy to install and use on linux.
That said, i do have some problems keeping my servers up and running. It appears that especially the mysql process is killed from time to time without a apparant reason.

I run a VPS (w. lycos) with RedHat 9.0 installed (i could also install other distro's like debian if that may help). After a clean install for my machine i installed XAMPP like the instruction told me to and the server seems to be working fine. Because i use the server in a production enverioment i enabled the security. I copied my site using fptcopy to my server and imported the datbase in the sql server. After some modifcations to site (joomla, so i edited the configuration files) and testing i edited the httpd.conf and php.ini to match some settings i need.

I added the following settings:
Code: Select all
#
# Use name-based virtual hosting.
#
NameVirtualHost my.ip.adress

#
# VirtualHost example:
# Almost any Apache directive may go into a VirtualHost container.
# The first VirtualHost section is used for all requests that do not
# match a ServerName or ServerAlias in any <VirtualHost> block.
#
<VirtualHost my.ip.adress>
    DocumentRoot /opt/lampp/htdocs
    ServerName my.dns.name
</VirtualHost>

<VirtualHost xxx.xxx.xxx>
    ServerAdmin xxx@xxx.xxx
    DocumentRoot /www/dir/to/my/files
    ServerName xxx.xxx.xxx
</VirtualHost>


Futhermore i edited php.ini to my needs:
Code: Select all
Registerglobals off instead of on
Memory to 16m instead of 8m


I also changed the httpd.conf to run as the user
apache and group apache that i created (group apache already existed)
i chown my htdocs and www folder to apache:apache.

Finally i added xampp to my startup scripts as described in the FAQ

The problem is that mysql process keeps getting terminated. When i want to restart xampp it states the following:
Code: Select all

# /opt/lampp/lampp stop

Stopping XAMPP for Linux 1.5.4a...
XAMPP: Stopping Apache with SSL...
XAMPP: XAMPP-MySQL is not running.
XAMPP: Stopping ProFTPD...
XAMPP stopped.

# /opt/lampp/lampp start

Starting XAMPP for Linux 1.5.4a...
XAMPP: Starting Apache with SSL (and PHP5)...
XAMPP: Starting MySQL...
XAMPP: Starting ProFTPD...
XAMPP for Linux started.

Sometimes it says mysql deamon already running. But my status page show the mysql server as offline!

I have no clue want could be wrong? I have no other mysql/webserver or whatever installed. After a reboot everything seems to be working fine for 10 minutes or so, then it happens all over again!

Here is my error.log:
Code: Select all
[Mon Oct 02 12:21:41 2006] [notice] caught SIGTERM, shutting down
[Mon Oct 02 12:22:29 2006] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Mon Oct 02 12:22:29 2006] [warn] RSA server certificate CommonName (CN) `localhost' does NOT match server name!?
[Mon Oct 02 12:22:30 2006] [notice] Digest: generating secret for digest authentication ...
[Mon Oct 02 12:22:31 2006] [notice] Digest: done
[Mon Oct 02 12:22:33 2006] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Mon Oct 02 12:22:33 2006] [warn] RSA server certificate CommonName (CN) `localhost' does NOT match server name!?
[Mon Oct 02 12:22:33 2006] [notice] Apache/2.2.3 (Unix) DAV/2 mod_ssl/2.2.3 OpenSSL/0.9.8d PHP/5.1.6 mod_apreq2-20051231/2.5.7 mod_perl/2.0.2 Perl/v5.8.7 configured -- resuming normal operations
[Mon Oct 02 12:37:26 2006] [notice] caught SIGTERM, shutting down
[Mon Oct 02 12:37:40 2006] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Mon Oct 02 12:37:40 2006] [warn] RSA server certificate CommonName (CN) `localhost' does NOT match server name!?
[Mon Oct 02 12:37:41 2006] [notice] Digest: generating secret for digest authentication ...
[Mon Oct 02 12:37:41 2006] [notice] Digest: done
[Mon Oct 02 12:37:42 2006] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Mon Oct 02 12:37:43 2006] [warn] RSA server certificate CommonName (CN) `localhost' does NOT match server name!?
[Mon Oct 02 12:37:43 2006] [notice] Apache/2.2.3 (Unix) DAV/2 mod_ssl/2.2.3 OpenSSL/0.9.8d PHP/5.1.6 mod_apreq2-20051231/2.5.7 mod_perl/2.0.2 Perl/v5.8.7 configured -- resuming normal operations


Should the /opt/lampp dir set to anyone specfic (chmod/chown?)
I hope someone can help! Thanx in advance!
drjake
 
Posts: 9
Joined: 02. October 2006 11:17

Postby Wiedmann » 02. October 2006 12:52

1st) You have problems with MySQL without your changes?
2nd) With MySQL problems, you should post the MySQL logfile (and not the Apache logfile).
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby drjake » 02. October 2006 13:01

I'm currently reinstalling everything on debian. I'll try to do without the changes. Normally i would just create 1 database and 1 user for that database. I couldn't see a mysql log file (or it was empty) in the log dir, i'll keep an eye for it this time!

Thanks for your quick reply, i'll let you know!

ps. Are the changes i made in the config files correct? Or could they cause trouble?
drjake
 
Posts: 9
Joined: 02. October 2006 11:17

Postby Wiedmann » 02. October 2006 13:08

I couldn't see a mysql log file (or it was empty) in the log dir, i'll keep an eye for it this time!

The log dir is for Apache. MySQL logs are in the MySQL data dir.
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby drjake » 02. October 2006 13:23

Hi, thanks for your response.
I reinstalled everything in debian now, but when clicking around in phpmyadmin some errors showed telling the server was gone or similair notes. So i checked the error file with the following info:

Code: Select all
061002 13:13:11  mysqld started
061002 13:13:14 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '5.0.24a'  socket: '/opt/lampp/var/mysql/mysql.sock'  port: 3306  Source distribution
061002 13:42:02 [Note] /opt/lampp/sbin/mysqld: Normal shutdown

061002 13:42:03 [Note] /opt/lampp/sbin/mysqld: Shutdown complete

061002 13:42:03  mysqld ended

061002 14:02:50  mysqld started
061002 14:02:51 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '5.0.24a'  socket: '/opt/lampp/var/mysql/mysql.sock'  port: 3306  Source distribution
libgcc_s.so.1 must be installed for pthread_cancel to work
libgcc_s.so.1 must be installed for pthread_cancel to work

Number of processes running now: 0
061002 14:03:19  mysqld restarted
061002 14:03:19 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '5.0.24a'  socket: '/opt/lampp/var/mysql/mysql.sock'  port: 3306  Source distribution
libgcc_s.so.1 must be installed for pthread_cancel to work

Number of processes running now: 0
061002 14:03:23  mysqld restarted
061002 14:03:23 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '5.0.24a'  socket: '/opt/lampp/var/mysql/mysql.sock'  port: 3306  Source distribution
libgcc_s.so.1 must be installed for pthread_cancel to work

Number of processes running now: 0
061002 14:03:54  mysqld restarted
061002 14:03:54 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '5.0.24a'  socket: '/opt/lampp/var/mysql/mysql.sock'  port: 3306  Source distribution
libgcc_s.so.1 must be installed for pthread_cancel to work

Number of processes running now: 0
061002 14:03:55  mysqld restarted
061002 14:03:55 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '5.0.24a'  socket: '/opt/lampp/var/mysql/mysql.sock'  port: 3306  Source distribution
libgcc_s.so.1 must be installed for pthread_cancel to work

Number of processes running now: 0
061002 14:03:55  mysqld restarted
061002 14:03:55 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '5.0.24a'  socket: '/opt/lampp/var/mysql/mysql.sock'  port: 3306  Source distribution
libgcc_s.so.1 must be installed for pthread_cancel to work

Number of processes running now: 0
061002 14:04:21  mysqld restarted
061002 14:04:22 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '5.0.24a'  socket: '/opt/lampp/var/mysql/mysql.sock'  port: 3306  Source distribution
libgcc_s.so.1 must be installed for pthread_cancel to work

Number of processes running now: 0
061002 14:04:33  mysqld restarted
061002 14:04:33 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '5.0.24a'  socket: '/opt/lampp/var/mysql/mysql.sock'  port: 3306  Source distribution
libgcc_s.so.1 must be installed for pthread_cancel to work

Number of processes running now: 0
061002 14:04:47  mysqld restarted
061002 14:04:47 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '5.0.24a'  socket: '/opt/lampp/var/mysql/mysql.sock'  port: 3306  Source distribution
libgcc_s.so.1 must be installed for pthread_cancel to work

Number of processes running now: 0
061002 14:04:50  mysqld restarted
061002 14:04:50 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '5.0.24a'  socket: '/opt/lampp/var/mysql/mysql.sock'  port: 3306  Source distribution
libgcc_s.so.1 must be installed for pthread_cancel to work

Number of processes running now: 0
061002 14:05:07  mysqld restarted
061002 14:05:07 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '5.0.24a'  socket: '/opt/lampp/var/mysql/mysql.sock'  port: 3306  Source distribution
libgcc_s.so.1 must be installed for pthread_cancel to work

Number of processes running now: 0
061002 14:05:20  mysqld restarted
061002 14:05:20 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '5.0.24a'  socket: '/opt/lampp/var/mysql/mysql.sock'  port: 3306  Source distribution
libgcc_s.so.1 must be installed for pthread_cancel to work

Number of processes running now: 0
061002 14:06:51  mysqld restarted
061002 14:06:51 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '5.0.24a'  socket: '/opt/lampp/var/mysql/mysql.sock'  port: 3306  Source distribution
libgcc_s.so.1 must be installed for pthread_cancel to work

Number of processes running now: 0
061002 14:07:31  mysqld restarted
061002 14:07:31 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '5.0.24a'  socket: '/opt/lampp/var/mysql/mysql.sock'  port: 3306  Source distribution
libgcc_s.so.1 must be installed for pthread_cancel to work

Number of processes running now: 0
061002 14:07:49  mysqld restarted
061002 14:07:49 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '5.0.24a'  socket: '/opt/lampp/var/mysql/mysql.sock'  port: 3306  Source distribution
libgcc_s.so.1 must be installed for pthread_cancel to work

Number of processes running now: 0
061002 14:08:21  mysqld restarted
061002 14:08:21 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '5.0.24a'  socket: '/opt/lampp/var/mysql/mysql.sock'  port: 3306  Source distribution
libgcc_s.so.1 must be installed for pthread_cancel to work

Number of processes running now: 0
061002 14:08:31  mysqld restarted
061002 14:08:31 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '5.0.24a'  socket: '/opt/lampp/var/mysql/mysql.sock'  port: 3306  Source distribution
libgcc_s.so.1 must be installed for pthread_cancel to work

Number of processes running now: 0
061002 14:08:41  mysqld restarted
061002 14:08:41 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '5.0.24a'  socket: '/opt/lampp/var/mysql/mysql.sock'  port: 3306  Source distribution
libgcc_s.so.1 must be installed for pthread_cancel to work

Number of processes running now: 0
061002 14:08:43  mysqld restarted
061002 14:08:43 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '5.0.24a'  socket: '/opt/lampp/var/mysql/mysql.sock'  port: 3306  Source distribution
libgcc_s.so.1 must be installed for pthread_cancel to work

Number of processes running now: 0
061002 14:08:48  mysqld restarted
061002 14:08:48 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '5.0.24a'  socket: '/opt/lampp/var/mysql/mysql.sock'  port: 3306  Source distribution
libgcc_s.so.1 must be installed for pthread_cancel to work

Number of processes running now: 0
061002 14:08:57  mysqld restarted
061002 14:08:57 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '5.0.24a'  socket: '/opt/lampp/var/mysql/mysql.sock'  port: 3306  Source distribution
libgcc_s.so.1 must be installed for pthread_cancel to work

Number of processes running now: 0
061002 14:09:08  mysqld restarted
061002 14:09:08 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '5.0.24a'  socket: '/opt/lampp/var/mysql/mysql.sock'  port: 3306  Source distribution
libgcc_s.so.1 must be installed for pthread_cancel to work
libgcc_s.so.1 must be installed for pthread_cancel to work

Number of processes running now: 0
061002 14:09:11  mysqld restarted
061002 14:09:11 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '5.0.24a'  socket: '/opt/lampp/var/mysql/mysql.sock'  port: 3306  Source distribution
libgcc_s.so.1 must be installed for pthread_cancel to work

Number of processes running now: 0
061002 14:09:42  mysqld restarted
061002 14:09:42 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '5.0.24a'  socket: '/opt/lampp/var/mysql/mysql.sock'  port: 3306  Source distribution
libgcc_s.so.1 must be installed for pthread_cancel to work

Number of processes running now: 0
061002 14:09:54  mysqld restarted
061002 14:09:55 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '5.0.24a'  socket: '/opt/lampp/var/mysql/mysql.sock'  port: 3306  Source distribution
libgcc_s.so.1 must be installed for pthread_cancel to work

Number of processes running now: 0
061002 14:10:02  mysqld restarted
061002 14:10:02 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '5.0.24a'  socket: '/opt/lampp/var/mysql/mysql.sock'  port: 3306  Source distribution
libgcc_s.so.1 must be installed for pthread_cancel to work

Number of processes running now: 0
061002 14:10:10  mysqld restarted
061002 14:10:10 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '5.0.24a'  socket: '/opt/lampp/var/mysql/mysql.sock'  port: 3306  Source distribution
libgcc_s.so.1 must be installed for pthread_cancel to work

Number of processes running now: 0
061002 14:10:27  mysqld restarted
061002 14:10:27 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '5.0.24a'  socket: '/opt/lampp/var/mysql/mysql.sock'  port: 3306  Source distribution
libgcc_s.so.1 must be installed for pthread_cancel to work

Number of processes running now: 0
061002 14:10:48  mysqld restarted
061002 14:10:48 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '5.0.24a'  socket: '/opt/lampp/var/mysql/mysql.sock'  port: 3306  Source distribution
libgcc_s.so.1 must be installed for pthread_cancel to work

Number of processes running now: 0
061002 14:10:50  mysqld restarted
061002 14:10:50 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '5.0.24a'  socket: '/opt/lampp/var/mysql/mysql.sock'  port: 3306  Source distribution
libgcc_s.so.1 must be installed for pthread_cancel to work

Number of processes running now: 0
061002 14:10:59  mysqld restarted
061002 14:10:59 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '5.0.24a'  socket: '/opt/lampp/var/mysql/mysql.sock'  port: 3306  Source distribution
libgcc_s.so.1 must be installed for pthread_cancel to work

Number of processes running now: 0
061002 14:10:59  mysqld restarted
061002 14:10:59 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '5.0.24a'  socket: '/opt/lampp/var/mysql/mysql.sock'  port: 3306  Source distribution
libgcc_s.so.1 must be installed for pthread_cancel to work

Number of processes running now: 0
061002 14:11:09  mysqld restarted
061002 14:11:09 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '5.0.24a'  socket: '/opt/lampp/var/mysql/mysql.sock'  port: 3306  Source distribution
libgcc_s.so.1 must be installed for pthread_cancel to work

Number of processes running now: 0
061002 14:17:16  mysqld restarted
061002 14:17:17 [Note] /opt/lampp/sbin/mysqld: ready for connections.
Version: '5.0.24a'  socket: '/opt/lampp/var/mysql/mysql.sock'  port: 3306  Source distribution


So it seems i need to install the libgcc to make it work?
I couldn't find any info concerning depancies on the apachefriends homepage?
But i'm just beginner, perhaps you could help me a bit further?
Thanks!
drjake
 
Posts: 9
Joined: 02. October 2006 11:17

Postby Wiedmann » 02. October 2006 13:56

libgcc_s.so.1 must be installed for pthread_cancel to work

Sorry, you have to wait for Oswald (because I have no Linux).

BTW:
You have any libgcc_s.so.* in your Linux?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby drjake » 02. October 2006 14:19

Thanks for your response, i'll install the lib now anyway. See if it helps...

In the mean time, i have just one more question that your perhaps could help me with.
I want to modify the httpd.conf and php.ini as stated in my first post.
So i want to:
-add virtualhosts (do i also need to add namevirtualhost?)
-remove the global register on (for security of my joomla site)
-set de memory size to 16M

The virtual host could also be located in e.g. /www/xxx/html?

I'm sorry for also these questions but i'm relative new to webserving (been using linux a bit longer though). And i must so i really like this software and the quick responses/support and this site!

Thank you!
drjake
 
Posts: 9
Joined: 02. October 2006 11:17

Postby Wiedmann » 02. October 2006 14:24

-remove the global register on (for security of my joomla site)
-set de memory size to 16M

Both in "php.ini".

-add virtualhosts (do i also need to add namevirtualhost?)

Difficult to answer. Because it depends on your situation, if you need a ipbased vhost or a namebased vhost.
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby drjake » 02. October 2006 14:34

Thnx, for your respones.

For my virtualhost i have a record set up in the zone file of my domain:
xxx.xxx.xxx pointing to the ipadres of my server.
That's the basic idea of the whole webserver. I want to locate this site in the /www/sitename/html dir. That's basically al the extra configing i need..

So do i need the namevirtualhost in this case?
Is it necessary to change the user and group in which apache runs? It is just for a joomla installation where the script should be able to modify/delete files themselves.

Thank again, and i promise that'll stop bothering you after this question.. :oops:
At least as long as mysql keeps up and running ;)
drjake
 
Posts: 9
Joined: 02. October 2006 11:17

Postby Wiedmann » 02. October 2006 14:51

Well, what is a vhost? You need a vhost, if you have different content for different hostnames. Is this the case?

What is a ipbased vhost? You have for each vhost a different ip. What is a namebased vhost? You have only one ip for all vhosts. What is your situation?

Is it necessary to change the user and group in which apache runs?

Necessary? No. XAMPP is a webserver package (for local development) which is working out of the box, without modifications.
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby drjake » 02. October 2006 15:02

Allright i think i've got it!
Thank you for your support!
drjake
 
Posts: 9
Joined: 02. October 2006 11:17

Were you able to get it working?

Postby goochose » 28. October 2006 02:55

Howdy,

I am having the same problem... you said you were going to re-install GCC... did that help at all? Can you tell me what you did, if it works now, what you did?

Thanks much!

Tyson
goochose
 
Posts: 2
Joined: 27. October 2006 00:50

Postby drjake » 30. October 2006 07:18

Hi!

I first reinstalled the GCC lib, that take of the apache problems. Furthermore i also increased the RAM memory of my virtual server.
However i found (with some help on the IRC channel) that XAMPP was to loaded for my system. So I reinstalled the various packages seperatly from the debian sources list.

Good luck, and perhaphs you could check in on the IRC channel!
drjake
 
Posts: 9
Joined: 02. October 2006 11:17


Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 5 guests