similar to: How to reconnect to the database?

Hi everyone, There''s a separate database I''m using to get mail group info for our users (Sympa), and I''ve got Rails configured to pull data directly from it via an entry in database.yml The issue we''re having is that the database server in question is behind an internal firewall that has idle timeouts set at 30 minutes. If the connection isn''t used

I want to set default value to current time of database: class CreateUsers < ActiveRecord::Migration def self.up create_table :users do |t| # ... t.column :created_at, :timestamp, :null => false, :default => ''now'' end end #... end On postgresql, it is converted to: created_at timestamp NOT NULL DEFAULT ''2006-04-25

Is there an easy way to display the SQL in script/console (similar to what is done in development.log)? The following works but it''s ugly: $ script/console Loading development environment. >> class ActiveRecord::ConnectionAdapters::AbstractAdapter >> def logger= (logr) >> @logger = logr >> end >> end => nil >>

I have an application that creates quite a few threads. I keep getting the "mysql too many connections" error. ActiveRecord does not close the connection once a thread had died out. To make things worse mysql has a wait_timeout variable that would basically kill off these connections for me, but there is a bug and I can not change the value of it. I have tried at least 10 different

Hi,all I am developing a Rails application supporting both Mysql and Oracle. I have to use Native SQL statements some place. While we know the SQL grammar is quite different for Mysql and Oracle, so I have to get database adapter type programmatically in my codes to process different native SQL statements. I haven''t found any document for this situation. After some research, I have found

Hi, I really need help to understand what is happening while Rails connect to a database, (we area actually using postgresql, so my example will be with postgresql) What I understand is Rails is able to connect to different DB. Actually, this is what we want, and we have made some tests, everything is juste fine. However, all these tests lead us to some important questions that we did find the

Hi, Guus I noticed th default reconnect for the first time is 5s, if failed the timer will be increase, I would like to know if this timer can be adjusted? The Max Timeout you mentioned seems not exactly the one, from the description below, it looks to me it is the total time for connect to be re-established, if not it trying other tinc daemon? Different tinc deamons have nothing related to

On Thu, Aug 10, 2017 at 09:37:13PM +0800, Bright Zhao wrote: > When the meta connection get lost, it’ll be reconnect like below: > Trying to re-establish outgoing connection in 5 seconds, and if it’s failed, then the timer will be increased for another try. > > My question is, how to adjust the reconnect timer, in some cases, the reconnect delay for a while(increase to something

Hi, When the meta connection get lost, it’ll be reconnect like below: Trying to re-establish outgoing connection in 5 seconds, and if it’s failed, then the timer will be increased for another try. My question is, how to adjust the reconnect timer, in some cases, the reconnect delay for a while(increase to something longer) will be beneficial for the unstable connection.

Hi, We have experienced some problems with ActiveRecord::Base class of Ruby-Rails. We are building a web-application based on the Ruby-rails framework and the web-application needs to access to difference databases, so we do not pre-define our database accesses in the database.yml file. In fact, we are using the ActiveRecord::Base.establish_connection() to connect to our database, the function

Currently, o2net connects to a node on hb_up and disconnects on hb_down and net timeout. It disconnects on net timeout is ok, but it should attempt to reconnect back. This is because sometimes nodes get overloaded enough that the network connection breaks but the disk hb does not. And if we get into that situation, we either fence (unnecessarily) or wait for its disk hb to die (and sometimes hang

It seems people were getting confused by the message that taskomatic was disconnected and not logging a reconnect message. This patch makes it log on reconnect as well. Signed-off-by: Ian Main <imain at redhat.com> --- src/task-omatic/taskomatic.rb | 7 ++++++- 1 files changed, 6 insertions(+), 1 deletions(-) diff --git a/src/task-omatic/taskomatic.rb b/src/task-omatic/taskomatic.rb

vmail*CLI> realtime mysql status Jan 11 09:53:04 ERROR[3597]: res_config_mysql.c:623 mysql_reconnect: MySQL RealTime: Failed to reconnect. Check debug for more info. vmail*CLI> realtime mysql status Connected to asterisk_vm@tritonvoice.com, port 3306 with username voicemail for 1 days, 5 hours, 32 minutes, 7 seconds. vmail*CLI> realtime mysql status Connected to

Oh my. I guess I was hungry... or maybe it's the heat... or maybe I'm just damn stupid. Thanks! Vincent ?t?p?n Bro? a ?crit : >Hello Vincent, > >you haven't attached your patch :). > >Cheers, > >Kato > > > > > > -------------- next part -------------- Index: config.html =================================================================== ---

Currently if asterisk loses its connection to the postgresql it does not attempt to reconnect. I have searched all over for a setting that would have asterisk attempt to reconnect but I can not find anything. Is there something I am missing? Thanks! -Eric -------------- next part -------------- An HTML attachment was scrubbed... URL:

This may be better off on the developer list, but I thought I would see if I was way off-base before I went there. I am working on a manager CTI client (currently for windows but with hopes of porting it elsewhere later). [Hold/Reconnect] I have many of the features working. I can originate calls (using the call-in/call-out originate that the manager provides) display call-related information

https://bugzilla.samba.org/show_bug.cgi?id=5058 Summary: Rsync re-copies up-to-date files on external FAT drive after reconnect Product: rsync Version: 2.6.9 Platform: x86 OS/Version: Windows XP Status: NEW Severity: normal Priority: P3 Component: core AssignedTo:

Hi, Our mail system uses dovecot-1.0-1.2.rc15.el5 in Centos-5.1 as our imap server. It connects to a pgsql database in another server as authentication backend. It works fine except occasionally fails to reconnect to the database after temporary network block, and dovecot has to be restarted to work again in such case. Since I can't find any specific setting in dovecot.conf to handle

I've just reconfigured my Samba 3 setup so that Windows users basically only see shares they are supposed to see when they browse the Samba server through Explorer. At the suggestion of others on this list, I used the "include = /etc/samba/smb.%U.conf" feature and create a "smb.username.conf" file for each Linux user. To get Explorer to display the shares assigned to

Folks, I have been working on a problem with the usbhid-ups driver and the MGE / Eaton Ellipse series UPS. There seems to be light at the end of the tunnel. For whatever reason, these devices seem to trigger error 'EPIPE' randomly. So far, the response to this of the usbhid-ups (and previously, newhidups) driver is to reconnect. Most of the time this will succeed on the first