Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: How to check for MYSQL on server?  (Read 7036 times)

0 Members and 1 Guest are viewing this topic.

sb73542

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
How to check for MYSQL on server?
« on: November 04, 2003, 03:56:18 am »

Hi, I was wondering if there is an easy script or something to check to see MYSQL is installed on my web host's server.  (Besides calling customer support  :) )  Thanks!
Logged

hyperion

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Posts: 1317
  • - retired -
How to check for MYSQL on server?
« Reply #1 on: November 04, 2003, 04:09:02 am »

Your host will have to provide you with a database, so you will have to call them anyway.
Logged
"Then, Fletch," that bright creature said to him, and the voice was very kind, "let's begin with level flight . . . ."

-Richard Bach, Jonathan Livingston Seagull

(http://www.mozilla.org/products/firefox/buttons/getfirefox_small.png)

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
How to check for MYSQL on server?
« Reply #2 on: November 04, 2003, 08:00:15 am »

you can find out wether PHP running on your webspace has mySQL support by creating a file with
Code: [Select]
<?php
phpinfo
();
?>
in it. Save it on your server (e.g. as phpinfo.php) and run it in your browser ( http://yourdomain.com/phpinfo.php ). If it shows something like
Quote
mysql
MySQL Support enabled
Active Persistent Links  0  
Active Links  0  
Client API version  4.0.16  
MYSQL_MODULE_TYPE  external  
MYSQL_SOCKET  /var/lib/mysql/mysql.sock  
MYSQL_INCLUDE  -I/usr/include/mysql  
MYSQL_LIBS  -L/usr/lib -lmysqlclient  
in it then your webspace has mySQL.support.
This doesn't necesarily mean you have a mySQL-database! But as hyperion wrote, it's little use to know there is a mySQL database as long as you don't have the login credentials for the database (database name, username, password) - which only your webhost can tell you. But don't be alarmed - if you had mySQL, they would have told you - as it's a feature webhosts boast with when signing up for a contract.

GauGau
Logged

moorey

  • VIP
  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 404
How to check for MYSQL on server?
« Reply #3 on: November 04, 2003, 08:04:33 am »

Or the nmap utility :wink:

MySQL typically uses port 3306.
Logged

azrael

  • Coppermine newbie
  • Offline Offline
  • Posts: 7
How to check for MYSQL on server?
« Reply #4 on: November 04, 2003, 02:24:17 pm »

Just a word of caution on the nmap thing, many ISP's have a zero
tolerance policy for portscans of their servers, so if you plan to do so,
send them a mail (in which you could ask them directly anyway ;) ).

---
Azrael
Logged

moorey

  • VIP
  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 404
How to check for MYSQL on server?
« Reply #5 on: November 04, 2003, 03:33:55 pm »

It was more of a FYI kind of thing.. :) Another way to find out is just to telnet to port 3306.. but really that's way off topic, I apologise for that. I digress.

Obviously the best solution as suggested by many was just to ask; there's no fail in that - it's the simplest.
Logged

sb73542

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
How to check for MYSQL on server?
« Reply #6 on: November 04, 2003, 10:34:58 pm »

Thanks for all the help!  It's actually a bit of a pride issue for me... I just started modifying a web site for a company that hasn't updated their site in a LONG time.  They've had the hosting account for years, with little documentation. I had to call three times already to verify different things, I guess I was hoping to avoid another call.   :wink:   FYI, I'm trying to decide between Menalto Gallery or Coppermine for the "Products" gallery page, which is a major focus of the site redesign.
Logged
Pages: [1]   Go Up
 

Page created in 0.02 seconds with 20 queries.