When I connect to a mysql server via a client, it seems to create two new TCP connections each time, for example doing:
$ netstat -a |grep mysql
# tcp4 0 0 lmy.att.64710 ec2-54-00.mysql ESTABLISHED
# tcp4 0 0 lmy.att.64705 ec2-54-00.mysql ESTABLISHED
What does it need the two TCP connections for, and why wouldn't it just create a single one?
I need to set up a mysql client on CentOS, and usually do this with:
[pd@l01 ~]$ yum install mysql
You need to be root to perform this command.
However, I don't have root and I cannot sudo. is it possible for me to install mysql for the local user only (without sudo/root) or is this something where I need additional permission/access in order to do anything?
For reference:
$ cat /etc/redhat-release
CentOS Linux release 7.8.2003 (Core)
$ yum --version
3.4.3
Installed: rpm-4.11.3-43.el7.x86_64 at 2020-06-29 20:50
Built : CentOS BuildSystem <http://bugs.centos.org> at 2020-04-01
...
In using the uname command the following three options gives me the same output:
ubuntu@ip-172:~/asm/asm$ uname -p
# x86_64
ubuntu@ip-172:~/asm/asm$ uname -i
# x86_64
ubuntu@ip-172:~/asm/asm$ uname -m
x86_64
Are the -m, -i, and -p options essentially the same thing, are what is the difference between them? From the man:
-m, --machine
-p, --processor print the processor type (non-portable)
-i, --hardware-platform print the hardware platform (non-portable)
I have an AWS ubuntu server. Let's call the Key File "root-key.pem".
Let's suppose (for this example) that I have ten employees and we add a new employee every month and we let go of an existing employee every month. What would be the suggested way to enable users to access the server with admin credentials? They would need to be able to run sudo or have something like root privileges to be able to modify databases, ports, push/pull to git, etc.
The 'easiest' way to do this would be to give everyone access to the "root-key.pem" file, but then whenever an employee is let go, we would need to create a new file and then make sure all existing employees have access to it (and perhaps any down time where a developer may not have access to it, or be waiting on it, etc.).
The preferred way I think would be to create a user for each person (sudo adduser travis) and then add them to the sudoers file and add their pem key to .ssh/authorized_keys. This is the path I tried to implement. It works in that it gives the user access to the server and they can run sudo, however it's a nightmare when people are trying to push/pull to git (GitHub).
What would be the best way to accomplish #2? Or is this a very difficult item to implement, and #1, though it is a bit sloppier and inconvenient when someone is let go, is the preferred way to go for all but very large organizations?
I had a bunch of files in /tmp that I cleared up by doing $ rm -rf ./tmp/*. However, I'm still unable to 'clear' that information, even after a reset. Here is what I have now:
$ cd Av-bash: cannot create temp file for here-document: No space left on device
$ df -i
df: no file systems processed
I should have roughly 400GB free space on this machine. How can I clear up this space, what do I need to do so that I can create temp files once again? And why isn't df -i returning anything?
The distribution I'm using is:
Linux version 3.13.0-29-generic (buildd@toyol) (gcc version 4.8.2 (Ubuntu 4.8.2-19ubuntu1) ) #53-Ubuntu SMP Wed Jun 4 21:00:20 UTC 2014
I have the following two profiles for a basic SELECT STATEMENT:
select count(*) from mturk_completion;
Here are the two profiles:
# My Local machine, using a local db
Status Duration
starting 0.000045
checking permissions 0.000006
Opening tables 0.000015
init 0.000011
System lock 0.000006
optimizing 0.000004
statistics 0.000011
preparing 0.000009
executing 0.000002
Sending data 0.034015 ########
end 0.000012
query end 0.000006
closing tables 0.000011
freeing items 0.000036
cleaning up 0.000010
And then here it is on my AWS ec2 large instance using an RDS mysql db:
starting 0.000068
checking permissions 0.000016
Opening tables 0.000028
init 0.000024
System lock 0.000018
optimizing 0.000015
statistics 0.000022
preparing 0.000022
executing 0.000012
Sending data 0.446171 #########
end 0.000036
query end 0.000018
closing tables 0.000023
freeing items 0.00009
cleaning up 0.000013
Most of the numbers are comparable except the Sending data part is more than ten times slower on the RDS instance!! What could account for that, and how would I fix this?
Here is the RDS instance information:
I am trying to figure out how to diagnose a mysql connection issue.
Two questions here:
I am trying to run webdriver, but I keep getting the following error:
[ec2-user@ip-172-30-0-41 ~]$ sudo ./chromedriver
./chromedriver: error while loading shared libraries:
libgconf-2.so.4: cannot open shared object file: No such file or directory
Is there a way to yum this missing dependencies? Or what seems to be the issue here? This is using the Amazon Linux AMI 2014.09.1 (HVM) Distribution.
I would like to import a local file into my remote mysql database, which is residing on ec2. How would I accomplish the following:
$ ssh -i ~/.ssh/my_key.pem user@ip
$ mysql -u root localhost [ remote database ] < ~/dump.sql [ local file ]
Is there a way to do this with -L? How would I do this with one command here?
I need to find all .pem files on my system. Would the following do this?
sudo find / -type f -name *.pem
If not, how would I write a find command to find every file of the sort?
The computer I am using was re-imaged and I do not have a copy of my pem file to access the server. I generated a new pem. What do I need to do to be able to log in to me ec2 server now?
What is the difference between a 302 and 303 response?
http://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html
Are these interchangeable or why would one be used over the other? Could you please provide a use case of when one would be used (and the other would not) ?
With Amazon's EC2, to assign an IP address I create an "Elastic IP", however it seems to just give me a static IP address. What is the difference between a static IP and an elastic IP? Or is it the same and just part of AWS's branding?
Is there a way to find the number of users that are currently logged into a Django site running on Linux? I need to restart the server and I want to make sure there are 'few enough' people that it won't be too much a hassle.
I have a shared hosting account at http://shared.webfactional.com/.
I have another website at www.example.com. I want to be able to go to www.shared.example.com/ and load the stuff from my shared hosting account. I do not mean a url redirection, as the end url will be at www.shared.example.com. What do I need to do in the DNS A or CNAME records to get the shared hosting account on this specific domain extension with the new-site string prepended?
I have the following URL which displays a normal static website: www.example.com. This site is hoted on Amazon.
I want to make all urls starting with www.example.com/redirect to redirect to another hosting account that I have. Note that I also want the host to be at the above domain (i.e., it is not a re-direct to another url here).
If this account is located at 1.23.345.678. What do I need to change in the .htaccess file in order to do this redirect?
I have access to the console panel for EC2. There exists one key pair (created by someone prior).
I created a second key-pair, and then tried to SSH in to the ec2 instance. This is what happens:
PREMIEREs-Mac-Pro:.ssh Premier_032$ ssh -i ~/.ssh/david.pem [email protected]
Permission denied (publickey).
What do I need to do in order to SSH to EC2 here, and is ubuntu the correct username (I also tried root, which didn't work either).
I am using EC2 as the live production server, and I am using git for source control. Currently, when I push changes to the site, I have a bash script that runs & pulls the most recent changes from git, and restarts the server. This causes the site to be down for about ten seconds while this is happening.
I would like to be able to push changes and keep the site live. (My initial thought would be to fire up an additional EC2 instance with the existing code while these changes are being pushed to the server that is being updated.) What are some ways to accomplish keeping the site live while pushing changes?
I want to be able to allow users created through IAM to be able to view one bucket in the management console. Furthermore, I want to restrict it to a folder within the bucket, such that the permissions would be:
S3 Console access for my-bucket/folder/*
How would I do this using the policy generator? I currently have:
{
"Statement": [
{
"Effect": "Allow",
"Action": "s3:*",
"Resource": "*"
}
]
}
However, when I modify the Resource location -- arn:aws:s3:::my-bucket/folder -- it prevents the user from being able to use the console at all. Is this possible to do and what do I need to do to be able to fix this?