0
votes
1answer
89 views

mysql.sock error when deploying with AWS Ubuntu and RDS

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) Rails.root: /opt/deployment.myproject/releases/20140805050704 I've spent the better part of 3 days trying to ...
2
votes
1answer
247 views

Redmine won't start after move

I met trouble with redmine(or ruby configuration) when move from one server to another redmine@dirty:~/www$ ruby script/rails server webrick -e production ...
0
votes
2answers
437 views

Ubuntu, mysql server connection

Hello everybody please ignore my noobness, My problem start from connecting to mysql on ubuntu 12.04 ERROR 2002 (HY000): Can't connect to local MySQL server through socket ...
0
votes
0answers
29 views

connection to apache server switches sockets connection

I have just post a question but I post an other one because the problem is not the one I had in thought when asking the latter. So, I am running some rails app on osx, when I run rails s, everything ...
0
votes
1answer
56 views

How to assess how much a Ruby/MySQL server can keep up?

We've taken over a legacy system that was implemented between 2007-2009 in Ruby and MySQL and since then has had only maintenance work done on it that was necessary to keep it alive. As a result, ...
0
votes
2answers
325 views

Rails: Mysql: Post-server-restart: why do I get “Can't create/write to file '/tmp/#sql_4d2b_0.MYI' errors”?

I get ErrorCode: 2 which I assume is ENOENT (No such file or directory). Here are the full details (from my stackoverflow post, which was closed by the powers-that-be as being of limited interest. ...
0
votes
1answer
83 views

Ruby on Rails production environment having SQL issues

I'm rather new to rails applications, and their respective deployment procedures. I've been having some issues with an application that I plan to run on my server, in the production environemt. The ...
0
votes
0answers
622 views

Error:'Incorrect MySQL client library version' while 'rake db:migrate'

D:\Users\mbiradar\Rails-API\rest_api\config>rake db:migrate (in D:/Users/mbiradar/Rails-API/rest_api) rake aborted! Incorrect MySQL client library version! This gem was compiled for 6.0.0 but the ...
1
vote
0answers
67 views

How to create a Capistrano task to import a backup from production into local development db?

I'm trying to do something with a Capistrano task that is similar to the heroku db:pull functionality if you are familiar with it. I have a remote server. On that server I have a bunch of backups in ...
1
vote
2answers
122 views

Server down at 23:26 every night

We are having a big problem with our sites stability the last couple of weeks and after endless hours of troubleshooting I don't get anywhere. So I turn to you dear community. Setup: 2 x VPS servers ...
1
vote
2answers
692 views

mysql2 gem not installing on CentOS 5.3

I'm trying to get the gem mysql2 installed on centOS5.3 but resulting in a conflict to mysql55. Sometimes (not always) I can install mysql55 and mysql55-server but after that I need to install ...
0
votes
1answer
653 views

Reset Linode root password

I've recently been put in charge of a Ubuntu server in the Linode platform. This webserver is running a production Rails application with a MySQL database. I need to ssh into it to download a copy ...
1
vote
1answer
60 views

Unclear with understanding of “cloud” services [closed]

I run a RoR/MySQL/Apache stack currently on a slicehost slice. We are coming out of beta within the next few weeks and im concerned with the scalability of the slice, in case we get big. Ive been ...
0
votes
2answers
213 views

Curious about my database server setup

I'm a web developer by day but I haven't had as much server administration experience as I'd like. I'm working on some side projects which are hosted on a 512mb linode server. The main app that I'm ...
1
vote
1answer
200 views

MySQL on a dedicated server vs increasing RAM on server with MySQL + Rails app

I'm running into scaling issues with a Rails app running on top of MySQL. I'm using memcached and have lots of indexes. I'm also starting to increase values for certain my.cnf settings like ...
0
votes
1answer
104 views

rubystack with existing MySQL

I want to install redmine, so i found convenient to try installing first bitnami RubyStack locally, however i do not want it to use its default mysql server, but i want it to use my already installed ...
0
votes
1answer
556 views

directory not owned by the 'mysql' or '_mysql' user

I have recently installed MSQL for a Rails App. After some tinkering, I have an error starting mysql now that reads as follows: Warning: The /usr/local/mysql/data directory is not owned by the ...
0
votes
1answer
436 views

Adding Listen 3050 to /etc/apache2/ports.conf causes mysql to crash

I am trying to set up a staging server on a VM on my local PC. Ubuntu 10.4.2 LTS 64 bit server is installed. I have another VM on the same machine running as a full time server, so I set-up ...
2
votes
2answers
369 views

Setting up a Production Server for Rails

I am currently installing Ubuntu Server 10.04 in a virtual machine and I am going to run my web app in it so I can see how it runs, etc in a 'production' environment. What software should be ...
0
votes
1answer
202 views

Increasing the number of simultaneous request to mysql shows down rails website performance

Recently we changed app server of our rails website from mongrel to passenger [with REE and Rails 2.3.8]. The production setup has 6 machines pointing to a single mysql server and a memcache server. ...
1
vote
1answer
222 views

How can I trace performance problems in an Ubuntu / Apache / MySQL / Rails + Passenger stack?

I have performance issues with a Rails stack that is running Apache 2.2.9, MySQL 5.1, Passenger 2.2.9 and Rails 2.3.8 (ruby 1.8.7-p72) on an Ubuntu 8.04 server. How can I trace performance issues in ...
0
votes
2answers
538 views

Convert string to xml in shell script?

I have written a script which is fetching data from database. Now I want to enhance that script to create a xml file with data which is return by database. How may i convert that string to xml file ...
0
votes
1answer
146 views

Nginx PHP MySQL ROR setup on Ubuntu Server

How would I go about installing and setting up nginx, PHP, MySQL and RoR on a Ubuntu Server 10.04.2 machine? I have been through a few tutorials but have never found one which integrates ruby on ...
1
vote
2answers
1k views

SASL (Postfix) authentication with MySQL and Blowfish pre-encrypted passwords

I have a Rails app with the Devise authentication gem running user registration and login. I want to use the db table that Devise populates when a user registers as the table that Postfix uses to ...
0
votes
3answers
170 views

Recommended way to Investigating server performance issues

I have a linux server box that runs the following stack: apache 2.2.9 passenger 2.2.8 rails 2.3.8 MySQL 5.1 Recently we've encountered some machine performance issues, where the entire server ...
0
votes
1answer
396 views

Sphinx cannot be found on your system (OSX)

I recently installed sphinx, mysql etc. and everything works fine as well. However, I always get the message: Sphinx cannot be found on your system. You may need to configure the following ...
0
votes
1answer
196 views

What is the best way to detect how/where server latency occurs?

I'm managing a small social media site, and its been for the past few days experiencing intermittent server lags. The site will choke loading a page, and moments later, the same page will have no ...
1
vote
1answer
602 views

redmine load_default_data failure

im having trouble setting up the default data environment in redmine + mysql. this is the error im getting. i think i have correctly set up the database and user so that this step should work. all ...
1
vote
2answers
435 views

New to Ruby on Rails, having socket trouble with MySQL (on Mac OS X)

This is my first question on serverfault, although I have used stackoverflow before. I am in a Ruby on Rails class over this summer and need to get RoR running ASAP. I used MacPorts to install Ruby, ...
0
votes
2answers
360 views

Installing Wordpress in Rails /public - missing mysql extension

I'm trying to install Wordpress in my Rails /public folder. I get the following error message: 'Your PHP installation appears to be missing the MySQL extension which is required by WordPress.' PHP ...
0
votes
2answers
2k views

No such file or directory - /var/run/mysqld/mysqld.sock

I tried to migrate a 5 year old ruby on rails application onto a new server with Ubuntu 8.04, Apache 2 and MySQL 5. The application failed to run. When I looked in the error logs, I noticed ...
1
vote
1answer
413 views

Mysql out of disk space

I have just finished developing a rails app which has a mysql db as a backend. The app is meant for high traffic and will store lots of information. I am planning to set up my own web server and host ...
3
votes
3answers
2k views

Installing Redmine on an NSlu2-Linux Device (QNAP)

I would like to run redmine on my NSlu2 NAS Server (QNAP) with an arm processor. I installed ipkg and so on everything runs well. Trying to install redmine I need to install ruby-on-rails. The ...
0
votes
2answers
608 views

How should I deploy my Rails application on a VPS for quick scalability?

I created a web application using NGINX, Rails, and MySQL. Currently they are all running on a single VPS (Slicehost). I've followed best practices and maintained a very minimal ...
1
vote
1answer
542 views

How to install mysql gem under OS X

When installing the ruby mysql gem by doing: sudo gem install mysql Subsequent rails migrations still fail, with a message like: $ rake db:migrate (in /Users/guy/code/project) rake aborted! ...
2
votes
4answers
854 views

How to scale down for low memory server?

I'm having problem with one of my Rails applications, that runs on 365MB VPS, which seems to be not very much. When there are more than 3-5 users at the same time it runs out of memory and starts to ...
0
votes
1answer
521 views

Fixed a problem on a Rails/Mysql app, how to prevent it happening again?

I'm looking after a rails app running Passenger, and MySQL, on a VPS running Ubuntu Intrepid and earlier this morning, the webserver stopped being able to connect to the server. My exception notifier ...
1
vote
1answer
758 views

RubyGem issue with mysql

I'm a little confused... I have Rails 2.3.2 running on my server after upgrading from 2.1.1 I get the following error on my mongrel clusters when they try to start: Exception `Gem::LoadError' at ...
11
votes
3answers
2k views

MySQL replication across geographically separate servers

My organisation has been looking into how to spread our servers around geographically while keeping backups very up to date, and ideally spreading the load. The initial thing I have in mind is Rails ...