Is SQL installed?

Posted on 2005-04-14
Last Modified: 2013-12-16

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,

Question by:1-WireWorld_net
    LVL 38

    Expert Comment

    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

    Author Comment

    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,
    LVL 38

    Expert Comment

    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.
    LVL 38

    Accepted Solution


       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.


    Author Comment

    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

    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,

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    rdate is a Linux command and the network time protocol for immediate date and time setup from another machine. The clocks are synchronized by entering rdate with the -s switch (command without switch just checks the time but does not set anything). …
    I am a long time windows user and for me it is normal to have spaces in directory and file names. Changing to Linux I found myself frustrated when I moved my windows data over to my new Linux computer. The problem occurs when at the command line.…
    Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
    Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now