# Radiant 9.0.1 hangs up after a while, and how i store forminputs in mysqldatabase

**URL:** <https://www.ruby-forum.com/t/radiant-9-0-1-hangs-up-after-a-while-and-how-i-store-forminputs-in-mysqldatabase/200508>\
**Category:** Radiant CMS\
**Created:** [December 14, 2010, 1:33am UTC](https://www.ruby-forum.com/t/radiant-9-0-1-hangs-up-after-a-while-and-how-i-store-forminputs-in-mysqldatabase/200508 "2010-12-14T01:33:22Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dobai-Pataky\_BSSSSl](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/77aa72/32.png) [@Dobai-Pataky\_BSSSSl](https://www.ruby-forum.com/u/Dobai-Pataky_BSSSSl)\
**Post date:** [December 14, 2010, 1:33am UTC](https://www.ruby-forum.com/t/radiant-9-0-1-hangs-up-after-a-while-and-how-i-store-forminputs-in-mysqldatabase/200508/1 "2010-12-14T01:33:22Z")

</div>

Hello,  
i hope somebody is able to help me please. I have installed a working  
Radiant CMS on my Webspace

# Configuration:

- Ubuntu Linux 8.0.4 LTS (Virtual Server 1 & 1)
- Apache/2.2.8 (Ubuntu)
- git version 1.5.5.3
- Phusion Passenger version 3.0.0
- Rails 3.0.3
- Ruby 1.8.7 (2008-08-11 patchlevel 72) [x86\_64-linux]
- WEBrick 1.3.1
- gem 1.3.7

# Problem 1 - Server hangs up after a while:

When i start my radiant with this command: script/server -e production  
my cms will run nearly 2 hours and after this time it keeps to be hang  
up.

Does somebody know why, please?

# Problem 1 - Store userinputs from webformular in MYSQL Database

How it is possible - to send formularinputs to a phpscript that stores  
this values  
in my database?

Please help me, i searched and googled but i have no solution for this  
problem.

Regards and Thank You  
Thomas

---

<div class="post-metadata">

**Author:** ![thomasptacek](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/a9a28c/32.png) [@thomasptacek](https://www.ruby-forum.com/u/thomasptacek)\
**Post date:** [December 14, 2010, 8:14am UTC](https://www.ruby-forum.com/t/radiant-9-0-1-hangs-up-after-a-while-and-how-i-store-forminputs-in-mysqldatabase/200508/2 "2010-12-14T08:14:30Z")

</div>

> # Configuration:
> 
> - Apache/2.2.8 (Ubuntu)
> - Phusion Passenger version 3.0.0
> - Rails 3.0.3
> - Ruby 1.8.7 (2008-08-11 patchlevel 72) [x86\_64-linux]
> - WEBrick 1.3.1
> - gem 1.3.7
> 
> # Problem 1 - Server hangs up after a while:
> 
> When i start my radiant with this command: script/server -e production  
> my cms will run nearly 2 hours and after this time it keeps to be hang  
> up.

I’m not sure script/server is the way to run your webserver. I think  
that starts WEBrick, which is not an ideal choice for production  
webserver.

There should be a site configuration file for apache that points to your  
application’s public directory. Let me know if you have that  
configuration file – if not, I’ll send you a sample configuration file.

> # Problem 1 - Store userinputs from webformular in MYSQL Database
> 
> How it is possible - to send formularinputs to a phpscript that stores  
> this values  
> in my database?

Do you mean you have a PHP script that receives the form input and needs  
to store the input into the database?

---

<div class="post-metadata">

**Author:** ![thomasptacek](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/a9a28c/32.png) [@thomasptacek](https://www.ruby-forum.com/u/thomasptacek)\
**Post date:** [December 14, 2010, 9:23pm UTC](https://www.ruby-forum.com/t/radiant-9-0-1-hangs-up-after-a-while-and-how-i-store-forminputs-in-mysqldatabase/200508/3 "2010-12-14T21:23:02Z")

</div>

Hi Kevin,

thank you for your answer, but i think my configuration is not optimal  
and the server hangs up again after 2 hours. # Problem 2 - to write in  
Database, i have solved it by use of a simple php scirpt and it works  
fine.

Now, i have replaced Webrick with Mongrel, and in my apache  
configuration file  
i put this entries and start mongrel with this command script/server -e  
production:

\<VirtualHost \*:80\>  
ServerName [www.betriebsgesellschaft.de](http://www.betriebsgesellschaft.de)

 Order deny,allow Allow from all 

ErrorLog /var/log/apache2/0049e.log  
CustomLog /var/log/apache2/0049a.log combined

DocumentRoot /var/www/public/  
PassengerHighPerformance on

\<VirtualHost \*:80\>  
ServerName [betriebsgesellschaft.de](http://betriebsgesellschaft.de)  
redirect permanent / [http://www.betriebsgesellschaft.de/](http://www.betriebsgesellschaft.de/)

My document Root (and radiant root) is  
/var/www/public

* * *

At apache restart i get this message, can you be so kind and tell me  
what its mean?

[Tue Dec 14 21:00:23 2010] [error] VirtualHost _:80 – mixing \* ports  
and non-_ ports with a NameVirtualHost address is not supported,  
proceeding with undefined results

(I am sure the mistake is here)

Thank you for your help and a look in your above mentioned config file  
would very helpful for me.

Regards and Thanks  
Thomas

---

<div class="post-metadata">

**Author:** ![thomasptacek](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/a9a28c/32.png) [@thomasptacek](https://www.ruby-forum.com/u/thomasptacek)\
**Post date:** [December 15, 2010, 4:06am UTC](https://www.ruby-forum.com/t/radiant-9-0-1-hangs-up-after-a-while-and-how-i-store-forminputs-in-mysqldatabase/200508/4 "2010-12-15T04:06:36Z")

</div>

> [Tue Dec 14 21:00:23 2010] [error] VirtualHost _:80 – mixing \* ports  
> and non-_ ports with a NameVirtualHost address is not supported,  
> proceeding with undefined results

From what I’ve read online and the error message, if you find the  
configuration file that specifies NameVirtualHost address and change it  
to \*:80, that may fix the problem.

I also notice that your configuration file refers to Passenger and that  
you have Passenger on your server. Make sure that Passenger is unloaded  
from Apache:

> **[Phusion Passenger users guide, Apache version](https://www.phusionpassenger.com/documentation/Users%20guide%20Apache.html)**

Kevin

---

<div class="post-metadata">

**Author:** ![thomasptacek](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/a9a28c/32.png) [@thomasptacek](https://www.ruby-forum.com/u/thomasptacek)\
**Post date:** [December 20, 2010, 10:43pm UTC](https://www.ruby-forum.com/t/radiant-9-0-1-hangs-up-after-a-while-and-how-i-store-forminputs-in-mysqldatabase/200508/5 "2010-12-20T22:43:05Z")

</div>

Hi Thomas,

I’m not sure what is wrong. I think this is a question for Rails forum  
or for someone in this forum that knows more about it.

You may want to post this in a new thread, so that it is clear this is a  
new issue.

Sorry that I failed to help you … I’m new to Rails and servers myself.

Good luck!  
Kevin

---

<div class="post-metadata">

**Author:** ![thomasptacek](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/a9a28c/32.png) [@thomasptacek](https://www.ruby-forum.com/u/thomasptacek)\
**Post date:** [December 19, 2010, 12:52am UTC](https://www.ruby-forum.com/t/radiant-9-0-1-hangs-up-after-a-while-and-how-i-store-forminputs-in-mysqldatabase/200508/6 "2010-12-19T00:52:48Z")

</div>

Hi Kevin,

thank you for your help i have now this configuration:

=\> Booting Mongrel  
=\> Rails 2.3.8 application starting on [http://0.0.0.0:8080](http://0.0.0.0:8080)

I started radiant with: script/server -e production -p 8080

* * *

after 3 hours, that happens

Read from remote host [betriebsgesellschaft.de](http://betriebsgesellschaft.de): Operation timed out  
Connection to [betriebsgesellschaft.de](http://betriebsgesellschaft.de) closed.

Do you know why?

Thank you in advantage  
Greetings  
Thomas

Kevin Triplett wrote in post #968463:

> > [Tue Dec 14 21:00:23 2010] [error] VirtualHost _:80 – mixing \* ports  
> > and non-_ ports with a NameVirtualHost address is not supported,  
> > proceeding with undefined results
> 
> From what I’ve read online and the error message, if you find the  
> configuration file that specifies NameVirtualHost address and change it  
> to \*:80, that may fix the problem.
> 
> I also notice that your configuration file refers to Passenger and that  
> you have Passenger on your server. Make sure that Passenger is unloaded  
> from Apache:
> 
> [Phusion Passenger users guide, Apache version](http://tinyurl.com/39l3ave)
> 
> Kevin

---

<div class="post-metadata">

**Author:** ![thomasptacek](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/a9a28c/32.png) [@thomasptacek](https://www.ruby-forum.com/u/thomasptacek)\
**Post date:** [January 21, 2011, 4:33am UTC](https://www.ruby-forum.com/t/radiant-9-0-1-hangs-up-after-a-while-and-how-i-store-forminputs-in-mysqldatabase/200508/7 "2011-01-21T04:33:06Z")

</div>

> When i start my radiant with this command: script/server -e production  
> my cms will run nearly 2 hours and after this time it keeps to be hang  
> up.

I sense a buggy request that makes a regexp (or alike) crap out. Check  
your log files to see when your app hangs, which controller/action is at  
fault, and which request params were sent.

I have been through that in the past.
