About The Cpanel

I am in the process of setting up my first VPS to host a website that I have been working on. By profession, I am a programmer, so I know nothing of Linux or web hosting!!

Thanks to lots of help on here this weekend, I finally learned how to access my VPS using SSH. (That only took a day or two to learn!) And my first command-line task was learning how to copy a file to another folder while maintaining the original modified date. (That only took another half-day!)

Whew!

So the next thing that I need to do is set up MySQL on my VPS...


My VPS runs on CentOS 6, and it also comes with cPanel, but since astrogeek and Miati were persistent in explaining why it is better to do things via the command-line versus using a GUI, I figured I would check things out...

My cPanel comes with some "wizard" that supposedly sets up a MySQL database for you, but whenever I see "wizard" I tend to run!

Advanced Support for my web host said that I should definitely use cPanel to create my database and create the users, because if I did it using phpMyAdmin it would supposedly mess things up as cPanel wouldn't recognize things?

(BTW, I requested MySQL Root access this morning, but I do not have Root access to my VPS - by choice for now!)


Questions:
1.) Should I listen to my web host and use the cPanel wizard to create a new MySQL database?


2.) If I decide to bypass cPanel, how exactly would I use my MacBook to talk to my VPS and do MySQL stuff over command-line?

FWIW, I developed my entire database using phpMyAdmin in MAMP on my MacBook. When I created my original database in development, I used phpMyAdmin's GUI. And then for everything else (e.g. create table, indexes, queries, etc.), I hand-wrote the SQL in TextEdit and then ran it in phpMyAdmin.

But I have no clue how to do any of this on my VPS!!


3.) How would I use the command-line to create a new database and set up groups and users for MySQL?


4.) If I did things by command-line, is it true that I would break cPanel?


I have been working on my website for the last 3 years, and it is ready to "go live", but I am discovering that setting up my VPS properly - and with lots of security - and getting things like PHP and MySQL set up is a very daunting task!!!



Sincerely,


Rob

Hello Guys,

I set up a mail server in a LINUX environment using iRedMail.The users can only send and receive e-mail throughout the local network, not from the Internet. I would like to know the steps to follow for the configuration. Also i want the windows users to be able to send and receive e-mails through that mail server.
Thanks to help...

Hi Forks,

I have centOS installed on VM & cpanel is installed,
Now i can see that /usr partition got full.

i.e. Output of df -h
root@linux [/]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/hda2 18G 661M 16G 4% /
/dev/hda8 59G 4.3G 52G 8% /home
/dev/hda7 996M 431M 514M 46% /tmp
/dev/hda5 7.8G 7.2G 220M 98% /usr <-- FULL
/dev/hda3 7.8G 1.5G 5.9G 21% /var
/dev/hda1 190M 21M 160M 12% /boot
tmpfs 1005M 0 1005M 0% /dev/shm

But if i check under /usr it's shows only 4.9G,

root@linux [/]# du -sch /usr/
4.8G /usr/
4.8G total

wheres other size utilized?, Please let me know if any other detail is require.

Thanks

I congifured postfix,dovecot and squirrelmail in my server. Now I am able to send mail from my webmail ( squirrelmail ) to my office email address, while I am trying to reply for that mail I didnt face any error. Mail logs also show that mail has been deleivered. But I didnt get any emails in my inbox, all the folders except inbox( sent, trash and drafts) were working fine. But I dont know what is the issue with inbox. I have checked all the configuration files.
I am using Ubuntu 12.04.5 LTS .any one have idea about this issue?

Dear all,

I recently installed, for the first time, Linux to my Lenovo X220 .
First impression is good, everything is running smooth so far :-)
I do though have ran into a wall when trying to integrate my company Outlook calendar into Thunderbird Mail.
Ubuntu 14.04 and Thunderbird 1:31.6.0 is what I have.
In our company we do use shared Outlook calendar to track and update many events on daily bases and I'm the only Linux user and would hate to give up making this work on my end. Now updating my entries via mobile phone and Ipad..
Any simple solution to this to work on my Laptop? ;-)

I am running linux mint from a live usb loaded with unetbootin for windows. It works with my wireless logitech USB mouse, but the touchpad itself is unresponsive. Keyboard including FN keys are indeed working. I am on an asus EEEPC netbook. I tried making sure the touchpad was turned on vai the function keys. I have also checked in system settings the touchpad is enabled. Any solutions anyone?

Hi,

We are using Solaris 10 as sendmail gateway. We have just migrated our DNS recently. Now when a mail is sent, the system returned the following message:

# cat /etc/hosts | mailx -v <name>@<domain name>
<domain name>: Name server timeout
<name>@<domain name>... Transient parse error -- message queued for future delivery
<name>@<domain name>... queued

# mailq
/var/spool/mqueue is empty
Total requests: 0

I tried to stop/start sendmail but no luck to solve the problem.

Any pointer is appreciated. Thanks in advance.

So, I'm new here. Was thrown into the deepend (read: shallow pool) of linux administration of a few centos 6.5 servers in October, and I've been pretty slow on the uptake. Years of Windows administration and desktop support will do that I guess.

So we have qmail on our prod servers that send out messages for our webapps. Postfix failed last night on a prod server, and it occurred to me that it's happened a few times since I've started, and instead of waiting for clients to tell us, I should be more proactive. I came up with/begged/borrowed/stole a quick script to check to see if postscript was running, and if it was, restart it, and contact us. This was to be run from jenkins.

Quote:
if (( $(ps -ef | grep -v grep | grep postfix | wc -l) > 0 ))
then echo 'Mail is up.'
else echo 'Mail is down! Attempting to restart service...'
service postfix restart
fi
The question was then raised about an unresponsive process (zombies!), and I figured it might be a better idea to use postqueue -q, or mailq to either see a Mailbox is empty, or look for fatal if postfix is off or unresponsive. This is where I ran out of coffee and went over the deep end.

To get this to work, I thought it would be a good idea to run two scripts. One to check if the mail queue is empty, and if not, send up a flag. The next was to run a few minutes later to check and see if the mail queue was throwing up a fatal error, and if it was, throw up a second flag, which sent out an email from jenkins. Incidentally, if the mailqueue were clogged, this would also trigger an alert. Our mailqueue doesn't get a lot of traffic.

First command. Returns then and else statement without issue.
Quote:
if ((mailq | grep 'empty') < 0 ); then echo 'Mail is up.'; else echo 'Mail queue is not empty. Please check mail server'; fi
Second one... Not so much.
Quote:
if (mailq | grep 'fatal') < 1; then echo 'Mail is up.'; else echo 'Mail queue is not empty. Please check mail server'; fi
You can probably suss out what I'm trying to do here, even though I'm not doing it right. Any ideas? I know this is newbie stuff, and I appreciate your taking the time to read this people.

I searched the forums for my title and I am not finding exactly what I am looking for. I am not using a program to send mail, such as Thunderbird or whatever. I simply want to be able to send mail from my Ubuntu 14.04 DESKTOP version for logging. I use a program called Logwatch (used alot in RHEL or CentOS) to monitor the server itself. The program sends mail to the root user account on the machine, which I can check and see, and within the program conf file, I can add an external email address, but it never sends.

I'm familiar with the SMTP concept of sending mail, outgoing mail server authentication, etc. I don't care to run this box as an SMTP server, but I understand that I need some sort of SMTP or MTA program to send mail into the real world. I tried Postfix but couldn't get that to work, and the Logwatch program wants to use sendmail, so I installed that but I am having the same issue. I am sure it is a step I am missing.

I also can't figure out how to get the 'mail' cmd from Terminal to work. I use this command:
Code:

mail -s "test" | /usr/sbin/mail myemail@domain.com

it follows through the subject, CC, body, but when I try to hit either . or CTRL-D, it never sends the email, in fact is does nothing.

I also tried sendmail with this command:
Code:

sendmail -v my@email.com < /dev/null

I was just trying to send a test email. It logs into my SMTP mail server, which I already configured, and it tells me to type out the mail, then end with a "." by itself on a single line. I try this and it just sits there.

I am missing SOMETHING when trying to actually send the mail. I can get it written with subject and body, connected, but it never sends and I am probably missing a / or something.

I did find and follow these instructions, but it still isn't working with sendmail. If I need to go back to Postfix, I can do that, I don't honestly care what I use, I just want some programs such as Logwatch to be able to email me.
http://stackoverflow.com/questions/1...mail-on-ubuntu

Hi All,
We have qmail server running on RHEL6.5. We have already made sure that our server is not acting as an open relay with the help of http://mxtoolbox.com/diagnostic.aspx.
But still anyone can telnet to our domain and send fake emails to anybody@ourdomain.com. For example Code:

telnet mail.ourdomain.com 25
helo mail.ourdomain.com
mail from: unknown@anyname.com
rcpt to: anyemailid@ourdomain.com
data
from: "Any Unknow name" <unknown@anyname.com>
to: "Some user Name" <anyemailid@ourdomain.com>
subject: Testing MTA with telnet

Hi,
This way anybody can fool us.

Regards,

.
quit

So can anybody pls help me to prevent this. I meant to say, we should not block port 25, instead it should verify whether or not "from email id" is exist in our domain, if it is exist then it should ask for the password also or if it is not exist then also it should not take us to next step. Because as per above example anybody can fool us as the mail is coming from outside but it is just from our domain to our domain without any authentication!!!
Expecting your kind help to block sending mails in this way.