wobbily_col's questions

I want to be able to copy a mysqdump from a remote server to my local machine.

I had a script to do this, but our operations guys have now changed the server permissions and it doesn't work.

So before I could SSH from my machine login as root and supply a password and connect to mysql, so I had a command in a Perl script like so :

sshpass -p root_password ssh root@$servername  mysqldump $database_name > $mysqldump_location

Anyway, permissions have changed and I can't login using root from my local machine.

Now I need to

• login to the remote server with a deploy user.
• Once I am logged in, I need to use su - to get the root user
• Now I can execute the mysqldump command (the deploy user gets an access denied message)

I want to have a script or command that I can execute from my local machine and have it go through the steps - log in as deploy, switch to root, create a mysql dump and copy it to my local machine.

What is the best way to go about that? Is it possible with SSH tunnels? Or is a scripted option better (how do you script multiple logins)?

I am migrating our app from a cloud server at Rackspace t a dedicated server.

I want to bring the application down for ~5 minutes to copy the data from the cloud server to the dedicated server, so I don't want requests going to the old server after I have copied the data.

I want to point our DNS record at the new server, but the TTL was set to 24 hours. I have changed it to 300 seconds. Do I need to wait the 24 hours before updating the ip that domain points to / copying the data?

I am in the process of migrating to a new server and I am having a number of issues due to user accounts not being present (for example nginx seems to be running under nginx user on the new system www-data on the old system).

Is there an easy way to get all the user / group account information. (Ideally I would like to script the creation of new accounts with Ansible if that makes any difference).

I am working my way through the RUNNING.txt file for installing Tomcat.

It says:

(3.1) Set CATALINA_HOME (required) and CATALINA_BASE (optional)

The CATALINA_HOME environment variable should be set to the location of the
root directory of the "binary" distribution of Tomcat.

So I know I can do

export CATALINA_HOME=/usr/local/tomcat

But that will be gone next time I reboot the machine.

Should I put these in the root accounts .bashrc or .bash_profile or somewhere else?

I have updated my Postgres install from 8.4 to 9.3.

Now when I log onto the server with the initial command

 sudo -u postgres psql template1

I get the following error

psql (8.4.18, server 9.3.5)
WARNING: psql version 8.4, server version 9.3.
         Some psql features might not work.
Type "help" for help.

What package do I need to install / upgrade to get psql to 9.4 version? (On red hat 6)

I am a developer and I am discussing with my sysadmin how to backup the MySQL database we are using.

The previous sysadmin told me he had started backing up the database, but the new guy, who isn't as experienced is offering to help me develop a script.

First of all is it normal that the developer is expected to be responsible for the database backups? Every other place I have worked, the sysadmin has taken care of it, leavening me to do development.

So at the moment I have a Perl script that calls a mysql-dump, and backs it up along with the code. Now for some reason the backups in the middle of the nighht fail, and create a truncated version of the database. I developed this as a temporary solution, and when I needed it a couple of weeks ago, the backup had failed. For this reason I would prefer that the sysadmin takes responsibility, as I have code to develop, and don't need to be checking cron job outputs every day.

So what is a reliable way of backing up the database every hour, and getting a warning if the backup fails.

I am trying to install the python pandas package in a virtualenv using pip.

On my development machine it installed correctly, but now I am trying on the server, it gets so far then it seems to get stuck:

 warnings.warn(LapackSrcNotFoundError.__doc__)
/apps/PYTHON/2.7.3/lib/python2.7/distutils/dist.py:267: UserWarning: Unknown distribution option: 'define_macros'
  warnings.warn(msg)
non-existing path in 'numpy/distutils': 'site.cfg'
non-existing path in 'numpy/lib': 'benchmarks'
Could not locate executable gfortran
Could not locate executable f95
Found executable /apps/modules/wrappers/fortran/ifort

Top shows ifort running at 46% cpu.

Is there any way I can tell if this is working correctly (can I check files it is updating for example), or if it is stuck in a loop?

It has been running for 40 minutes so far.