similar to: Running general purpose queries

Displaying 20 results from an estimated 1000 matches similar to: "Running general purpose queries"

2006 Apr 27
4
GD2 to Make Charts
I''m just getting started with GD2 and have successfully made a few dynamic PNGs. I need to make some fairly detailed line graphs on the fly and I know that GD2 is capable of what I want but I strongly suspect I''m reinventing the wheel badly. Are there gems or other projects that help creating complex charts? I''ve used GDChart in the distant past but I
2006 May 04
3
Rubyonrails.org Website Blocked
Hi Everyone, This is basically an FYI because I don''t think there is much that can be done about it. I work at a DoD lab and up until very recently I had no problems at all getting to rubyonrails.org. All week long I have not been able to visit the site and I finally gave up and submitted a trouble call to our network help desk. I was told that the site was in a class B range
2006 Jan 12
6
Mysql::Error: Lost connection to MySQL server during query
I have been very VERY frustrated for the past week trying to solve a seemingly spurious problem with my Windows XP SP2 box with Ruby 1.8.2/Rails 1.0.0/MySQL 5.0.16 or 4.1.15 (yes, I tried both) installed running against a remote MySQL server that was either 3.23 or 4.1 (4.1.15 to be exact--we finally matched them both up to make sure that wasn''t the problem). So I post it here (as
2007 Jan 19
1
Bug Report: ACL plugin searches wrong directory with shared folders
I've been attempting to get to get Shared Folders and ACL's to work under dovecot 1.0rc17. Unfortunately, I've run into some problems (many have already been mentioned on the list), specifically the problem where folder-specific ACL files are not found (and I will not use Global ACL's due to the 100% probability of cross-namespace mailbox name conflicts). My namespace
2005 Nov 18
2
Migrate Ubuntu Rails App to Fedora?
I developed a small RoR app on my Ubuntu laptop and I just tried to migrate it to my "production" box which is Fedora FC3. I moved the entire rails app. I received this error when I tried to get the first page: [2005-11-17 15:36:00] INFO WEBrick::HTTPServer#start: pid=32546 port=3000 192.168.0.61 - - [17/Nov/2005:15:40:01 EST] "GET /freesql HTTP/1.1" 200 0 - ->
2009 Mar 05
3
Connection Pooling on Rails 2.2.2 (Windows Vista)
Hi, I''m trying to setup rails 2.2.2 pool connections to MySQL by specifying the pool setting with 5 in database.yml but no hope.. It doesn''t work. My rails is running on webrick in the production mode and the webrick is launched by RadRails. Even though I send multiple requests to my app on rails at the same time, it seemed only one connection is shared ( pooled ). I also
2006 Aug 21
2
Dovecot 1.0rc7 quits without notice
Today I switched one of our servers from Courier (deployed 3-4y ago) to DCrc7. Everything seemed very nice (system load dropped significantly). Unfortunately after some time and ~8000 pop3-logins the main DC loop just quit without _any_ notice. Some pop3-login childs still showed up in the processlist, but the main listener on port 110 was gone. The above described scenario has been observed 2
2006 Jun 26
1
Rake + SQL Server + Migrations == Errors. Help?!
Hello all, I''m trying to initialize my migrations against a current database implementation. rake db:schema:dump runs without error. The resulting schema.rb is pasted below, along with my database.yml Can one of you point me in the direction of enlightenment? -- ------------------------------ Apple MacBook. Black. It''s the new White! ------------------------------ Peter
2020 Apr 21
3
Asterisk 13.22.0 under very high load conditions - freezes in H exten and blocks new calls
Hi all I'm running an Asterisk on an Intel XEON E5-2660 virtual with Centos 7 - 32GB RAM. When I approach about 320 channels, I -sometimes- get thousands of these messages suddenly streamed in the CLI / Asterisk log: WARNING[60753][C-00022cb9] channel.c: Exceptionally long voice queue length queuing to Local/xxxxxxxxxx at local-0002dbea;2 WARNING[71993][C-00022dcc] channel.c: Exceptionally
2012 Mar 09
2
iotop :: OSError: Netlink error: Invalid argument (22)
Hi! i have a problem with iotop : root at alien: ~ # iotop Traceback (most recent call last): File "/usr/bin/iotop", line 16, in ? main() File "/usr/lib/python2.4/site-packages/iotop/ui.py", line 567, in main main_loop() File "/usr/lib/python2.4/site-packages/iotop/ui.py", line 557, in <lambda> main_loop = lambda: run_iotop(options) File
2006 Jul 31
1
Pagination of Complex Queries
I''ve created a class method in my model called find_filtered. The intent is that I take various params that the user has submitted, and let the model build the query and return the AR collection, which is exactly what happens. However, now I''d like to paginate the recordset. Everything I''ve been able to find about pagination presumes that you have no pre-existing AR
2006 Mar 02
2
custom sql queries beyond CRUD
Hi, I am just starting of in rails. I am trying to understand the features of rails and I have this burning question. (and search is not available now): Apart from relying on the automatic CRUD sql script produced, is there a way I can create my own sql script ex: with many joins between exixting tables (for reporting ). All I need is to declare the custom query and place the result in a
2008 Dec 21
3
Globbing Files in R
Dear all, For example I want to process set of files. Typically Perl's idiom would be: __BEGIN__ @files = glob("/mydir/*.txt"); foreach my $file (@files) { # process the file } __END__ What's the R's way to do that? - Gundala Viswanath Jakarta - Indonesia
2013 Apr 18
0
Bad password when using "map untrusted to domain"
Greetings samba list, I'm running into an issue when attempting to use "map unknown to domain" on a samba servers bound to my AD domain. When a client maps a share and is not part of the domain, the domain is properly mapped for the user (according to the logs), but the domain controllers report that the password is wrong. I've copied my password out of notepad and pasted it
2006 Jan 11
2
validator to ensure two fields are different?
What validator can I use in a model to ensure that my :username field is different from my :password field? I''ve tried validates_exclusion_of :password, :in =>:username but I get a rails error "an object with the method include? is required must be supplied as the :in option of the configuration hash" Thanks! Gary
2019 Oct 30
2
Dovecot and MySQL aborted connections.
We also spotted these sql connections getting aborted, upon upgrading MySQL from 5.6 to 5.7. (Going back to 5.6 we don't see them!) Turning on mysql general query logging we can see it is Dovecot's mysql connections that inquire about or update quota usage in particular: *** /logs//mysql.log *** 2019-10-30T10:52:22.624690-07:00 2 Connect dovecot at localhost on npomail using
2007 Feb 27
2
Dovecot rc23 and rc24 freeze after authentication
I had our production systems running on rc23, however we ran into problems when the server was under heavy load. Eventually, the server would begin to freeze all imap connection after authentication (according to the logs). A user would connect, authentication would succeed, and then the connection would sit until timing out. No error logs were produced. Upgrading to rc24 did not
2005 Sep 21
0
Basic pagination question
Hi there I have a class method defined in my Product Model, ''featured_items'', which returns a recordset from the products table based on certain find conditions. I simply want to paginate this recordset, not the whole products table, using the paginate helper. After reading the Rails docs, I''m still struggling to work out how, in my ''list'' view, to
2006 Aug 19
7
Impossible to get stable?
I have concluded that it is impossible to get this background process stable. I am out of ideas and could really use some help. Here is what I have: 50 workers, just running an infinite loop that constantly calls save! on a model. Keep in mind this is just for testing purposes. I catch all exceptions and put them in the log. I am tried setting allow_concurrency to true and false. Neither
2019 Oct 30
0
Dovecot and MySQL aborted connections.
> We also spotted these sql connections getting aborted, upon upgrading MySQL from 5.6 to 5.7. (Going back to 5.6 we don't see them!) I have a mailserver running MySQL 5.6.44 which is not very busy that logs these warnings. Another busy one running MySQL 5.6.45 does not log any warnings. MySQL interactive-/wait_timeout is 28800 (8 hours), which is more than enough time to wait for a