Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 292
  • Last Modified:

Is SQL installed?

Hi,

I have access to a University server, and am interested in knowing if they have SQL installed or not.  I can't seem to find anyone that knows for sure.  I've heard rumors that they have it installed but don't tell people because they don't want to have to provide support.

If it is true that they have it installed, but don't provide support, what would I need to be able to use the SQL capabilities?


I do know basic SQL commands, and this is for a legitimate University purpose.


Thank you all,

Kanan
0
1-WireWorld_net
Asked:
1-WireWorld_net
  • 2
  • 2
1 Solution
 
yuzhCommented:
You need to ask the sys adm in your University, most of the sys adm doesn't like student to
play around with their system (incuding me). Your sys adm will help you,if you have a valid
reason.
0
 
1-WireWorld_netAuthor Commented:
Yes, I understand that they don't want a student "playing arround" with there system.  However, I don't intend on "playing" with it.  I work for the University.

All I am interested in knowing is if it is installed.  And if it is installed how I can use it.

I would ask the sys admin, but like I said, they don't want to provide support.


Is there anyone else who can answer my question?


Thank you,
Kanan
0
 
yuzhCommented:
I'm a sys adm for a university myself, if you ask your sys adm, he/she
should be able to tell you if it is install and tell you how to use it.
(sys adm should help you setup the ENV variables to use SQL.
0
 
wesly_chenCommented:
Hi,

   Which SQL you are talking about? MySQL or PostgreSQL?
Just do
ps -auxww | grep -i sql
to see if the sql daemon is running on that machine or not.
Then you can tell where is the sql daemon path.

   If the SQL is installed but not running, then the only way is go through the sys admin since only
they can start the daemon.

   
0
 
1-WireWorld_netAuthor Commented:
This is the output from the server:


ucsub> ps -auxww | grep -i sql
langinho  3592  0.0  0.1 1008  808 pts/3    S 14:01:51  0:00 grep -i sql
ucsub> ps -auxww | grep -i apache
nobody   16980  0.1  0.4 9840 7280 ?        S 10:42:05  0:14 /usr/local/apache_2.0.49/bin/httpd -k start -DSSL
langinho  3613  0.0  0.1 1008  808 pts/3    S 14:02:05  0:00 grep -i apache
root       693  0.0  0.3 6928 4432 ?        S   Apr 15  0:00 /usr/local/apache_2.0.49/bin/httpd -k start -DSSL
ucsub>

So it looks like there is no SQL server running, I ran the ps line again with apache, just to make sure that it wasn't running just for my username.


Thanks Wesly_Chen,
Kanan
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now