MySQL And PGSQL And Hostname Question
i would like the thoughts of some folks with more experience
than i have.
i want to learn pgsql. i have some vb and msaccess experience and
would like to learn how to use php and pgsql to develop some nice
website / application functionality.
however, i'm not sure the hurdle of relatively miniscule documentation
and tutorials is worth the effort. i'm now thinking i should just use
mysql to start and, if the need really arises, move over to pgsql.
i'm busy with a lot of stuff right now - regular job, starting a
business, developing a web site for the business, learning graphics
programs, living life, blah, blah, blah.
what is your opinion? go with the better documented db and develop
more quickly but have to possibly switch over later when time may be
more available and retain my hair or bite the bullet and go with
pgsql?
differing opinions are appreciated and encouraged so i can evaluate
them based on my own set of values.
also i am trying to set up localhost as my url so my hardcoded links
work on my local win98 machine (actual webserve is linux).
host.sam is as follows...
127.0.0.1 localhost www.easyautodeals.com
my apache httpd.conf file shows the following for ServerName:
ServerName www.easyautodeals.com
however, when i type easyautodeals into my web browser, i go straight
to my actual web server and not to my "localhost" location.
View Complete Forum Thread with Replies
Related Forum Messages:
My Dad Wants PHP & MySQL Or PgSQL Hosting
To my surprise last month, my dad wanted to start dabbling in PHP and MySQL or pgSQL. I've been helping him out a bit. He's into athletic medicine and wants to have a website to help athletes and physical therapists improve performance. His current web hosting provider -- Earthlink -- doesn't give him anything but PHP 3.0.x. I want to get him at least on PHP 4.2.x (or better) along with either MySQL or PostgreSQL (pgSQL) support. I've done some googling on this, but I wanted real user opinions on cost, customer support, uptime, etc. At this point he's just looking at something that suits him somewhere between hobbyist and early sole proprietorship strength. Shared web hosting would suit him fine. Cost might be an issue for him initially. He's going to need some sort of simplistic web interface to be able to create databases, tables, and user accounts.
View Replies !
--with-pgsql=WHERE?
I need an installation with Postgres support, and was happy to find in my phpinfo that there was a --with-pgsql=shared option in the config line. but I still got "call to undefined function: pgsql_connect (4.3.11) So I figured whatev, I'll put a new installation (PHP5, in fact), but I always fail config with: Cannot find libpq-fe.h. Please specify correct Postgresql installation path 'course i looked in my handy old webmin to see where Postgres might be... tried various paths I found in various places --with-pgsql=/var/lib/pgsql/ --with-pgsql=/usr/share/pgsql --with-pgsql=/usr/bin/psql obviously not a lib, but getting desparate...
View Replies !
PHP Installation With Pgsql
I got PostgreSQL installed and now I'm trying to get PHP installed too. I do ./configure --with-pgsql and everything works fine. But when I do make, I get this error: ext/mysql/libmysql/my_lib.o(.text+0x37a): In function `my_dir': /home/marc/extract/php-4.3.1/ext/mysql/libmysql/my_lib.c:169: undefined reference to `errno' ext/mysql/libmysql/my_lib.o(.text+0x546): In function `my_stat': /home/marc/extract/php-4.3.1/ext/mysql/libmysql/my_lib.c:588: undefined reference to `errno' ext/mysql/libmysql/my_tempnam.o(.text+0x79):/home/marc/extract/php-4.3.1/ext/mysql/libmysql/my_tempnam.c:108: more undefined references to `errno' follow collect2: ld returned 1 exit status make: *** [sapi/cgi/php] Error 1 I need php installed soon. I don't know what is causing this error to occur.
View Replies !
Hosting PHP And PGSQL DB
Can anyone recommend somewhere that offers cheap or even free web hosting for PHP scripting with a PGSQL database? I am looking to build a small website with some images and dynamic content, such as a forum/message board and wondered what it would cost me for this? I used to use themooseisloose for hosting (one-off payment of £2.77 GBP), but have been alerted that have gone bust (at some point at the end of last year). I've have googled, but was just wondering if anyone had any positive experiences of hosts that will allow this setup mentioned cheaply.
View Replies !
Error Management : Php-pgsql.
My goal : obtain the error message if the connection fail. ## my code : <?php $cnxString = "host=localhost port=5432 dbname=toto user=atlante password=aiThoo3g"; $pgsql_conn = pg_connect($cnxString, PGSQL_CONNECT_FORCE_NEW); if ($pgsql_conn) { print "Connexion réussie à : " . pg_host($pgsql_conn) . "<br/> "; } else { echo pg_last_notice($pgsql_conn); exit; } ?> ## if «php_value display_errors 1» the screen result is this one : Warning: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: FATAL: la base de données «toto» n'existe pas in /home/willou/public_html/atlanpolis/wwws/tools/checkdb.php on line 5 Warning: pg_last_notice() expects parameter 1 to be resource, boolean given in /home/willou/public_html/atlanpolis/wwws/tools/checkdb.php on line 10 ## If not, i haven't got any result. The message just appears in my logs The return of pg_connect not seems to be an connection resource when the connection fails.
View Replies !
Pgsql Socket Timeout
I am encountering a problem with PHP5 and postgresql on a fedora core 3 box. I have a database driven report application written in PHP5 on a remote server. This application allows a user to submit a sql statement created by php based on user input parameters to the postgresql server. The application works great as long as the database server can return the result set within what appears to be 2 minutes. If the query takes longer than two minutes to execute the database server will eventually finish the work *but* no rows of data appear on the web page. I am thinking that the network socket connection between the php engine and the postgresql database server gets dropped after two minutes and that is way the results never arrive at the php page. If you think this might be a plausible explanation can you provide some assistance as to how I can go about adressing this problem?
View Replies !
Ubuntu Php4-pgsql
I found some strange kind of mild install bug when installing Ubuntu 5.04 php4-pgsql module (the module that connects PHP4 to PostgreSQL). You may encounter the error: Call to undefined function: pg_connect() No amount of using Synaptic Package Manager would fix this for me. The solution was all at command line under 'root' account: $ apt-get update $ apt-get install php4-pgsql $ /etc/init.d/postgresql restart $ /etc/init.d/apache2 restart
View Replies !
IP And Hostname Comparing
Anyone who can help me with a IP thingie? I want to compare a IP adress with a IP "String" with wildcards (*) like 127.0.0.1 equals to 127.*.*.* and 255.255.255.0 equals *.255.255.0 I want the wildcards to work in all the places eg. *.*.*.* will equal all Ip adresses. And it would also be great if someone could help me with a regex or something that can help me to compare hostnames. like *.no equals every hostname that ends with .no and some*.no wil equal every hostname that begins with some and ends with.
View Replies !
Explode Hostname?
If i wanted to see if a hostname contained the words "austin.rr.com" (The austin, tx road runner network) $ip = $_SERVER['REMOTE_ADDR']; $host = gethostbyaddr($ip); Now, i cant really explode this and find out if austin.rr.com is in this by using a . b/c the hostname will be like .. cpe-70.114.32.4-austin.rr.com And im not exactly sure of the delimiter to use for explode, so is their another way i could find out if host contained austin.rr.com?
View Replies !
Verifying Hostname
I am writing a CMS that can be used on multiple sites with one back end right now. I am working on my function to verify and get the hostname from the URL. Some of our domains though look like any of these: PHP Code: function get_hostname($hostname) {     // Check the url for a newton     $find_newton = preg_match('^(sb[A-z0-9]{9})^', $hostname);     // If the newton exists cut it and recreate url     if ($find_newton == 1) {         $true_host =  preg_replace('^(sb[A-z0-9]{9}).+|members.|^', '', $hostname);     } else {         $find_www_host = preg_match('|www.|', $hostname);         $find_members_host = preg_match('|members.|', $hostname);         if ($find_www_host==1) {             $true_host =  preg_replace('|www.|', '', $hostname);         } else if ($find_members_host==1).......
View Replies !
Irritating Warning On ->PEAR->DB->PGSQL
I am getting following message from pear. I am running RedHat 8.0, PostgreSQL is 7.3.2 PHP Version 4.2.2 and pear:db 1.6.5. Warning: pg_errormessage(): supplied argument is not a valid PostgreSQL link resource in /usr/share/pear/DB/pgsql.php on line 449 Any idea.
View Replies !
Get Hostname Of Domain Alias
Relatively new with PHP, so forgive me if this is a trivial question. I have a site hosted with PHP. I'm thinking of getting another hostname and alias it to this host. What I'd then like to do is have a PHP file (i.e., index.php) that reads a variable from the request that tells me which hostname is being served. I can then change the title and whatnot of the returning HTML, depending on which hostname was used. For example: <?php $HOSTNM = ??? if ( $HOSTNM == 'abcefg.com' ) $TITLE = 'ABCDEFG' else $TITLE = 'HIJKLM' etc... ?>
View Replies !
Bad Request (Invalid Hostname)
I was just testing some code: <?php session_start(); $_SESSION['views'] = 1; // store session data echo "Pageviews = ". $_SESSION['views']; //retrieve data ?> And for some unknown reason I keep getting the error: Bad Request (Invalid Hostname) Can somebody Give me an Idea on Why the Heck This is happening?
View Replies !
Populate The HOSTNAME Drop Down Box
I have a PHP page that has a bunch of drop down boxes that ask for a start date and hour, an end date and hour and a hostname. Well, everything thus far has been OK because I didn't really have to use any dynamic content, until now. I would like to populate the HOSTNAME drop down box to read from MySQL database. The problem is that the data is stored as such: Code:
View Replies !
Captuing Remote Hostname
What is the best way to capture the hostname of the remote computer. I have managed to get the IP of the remote computer but I am after the hostname. I have enable hostname lookups in apache enabled and i cannot remember where to look in PHP manual.
View Replies !
How To Get Server Unique Canonical Hostname?
Is it possible to use PHP to get the server's canonical hostname? I don't need/want the virtualhost name.. I need the actual server canonical hostname. For example, if you vist this phpinfo() output, the first line that is displayed is something like this: Code:
View Replies !
PGSQL 7.4.8 PHP 4.3.4 & Apache 2.0.49 Segmentation Fault With Client Certs
Having an issue that is specific to PHP compiled with PGSQL support with versions noted in subject line. I understand that there are many variables to consider here but believe I have narrowed down the Apache Client Cert failures to my PHP/PGSQL build. 1. Apache PHP without PGSQL works as expected using client certificates 2. Apache PHP with PGSQL works fine with standard SSL connections 3 Apache PHP with PGSQL fails with client certificates - no output other than Segmentation faults in the apache error logs as follows: [Wed Nov 30 23:26:57 2005] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec2).... I also performed same tests on another instance of Apache/PHP/PGSQL which was version 2.0.54 of apache and PHP/PGSQL versions same as subject line with same exact results. Any ideas as to the source of this problem and suggestions for tests/fixes are greatly appreciated. There are no errors in any of the logs other than what I have included so it's very difficult to see what is wrong. All I know for sure is that I am able to reproduce the results on more than one machine.
View Replies !
Emailing, 550 Not Local Host , Not A Gateway
Don't know if this is new news, old news or no news. Every time I tried to email with my php/mysql combo I would receive a email back from the system administrator with about 5 of the addresses listed with a message like this: 550 not local host <hostname>, not a gateway Tried all the php fixes, ISP technical support, checked for port 25 blocking and domain host support no dice. These were/are all good host names. Turned out that in typing in and/or importing addresses some (Those being rejected) were typed in capitol letters. As soon as they were converted to all lowercase the problem went away. I posted this because you have saved my a** so many times I can't count them. Why it worked I do not know but it worked.
View Replies !
Sending Username And Password With Hostname In Socket Programming With Php
I am sending the code below.i have not specifies the host name.i want to send command to server and get the response from it.but it doesnt work.when i connect with the telnet using ssh to remote machine it works. i type telnet hostname->username->password and then i can login to the remote machine.how can i send hostname with username and password to remote machine in france <?php $cmnd= "abc"; $host="...."; $port="12345"; $socket = socket_create(AF_INET, SOCK_STREAM, SOL_TCP) ; socket_connect($socket,$host,$port) ; socket_write($socket, $cmnd) ; $ser_messegeg=socket_read ($socket, 1024); echo $ser_messege; socket_close($socket) ; } ?>
View Replies !
PHP And MySQL: How To Properly Call A Stored Procedure With Output Parameters From PHP - Mysql, Mysqli, Or PDO
I am currently using PHP 5 and MySQL 5, both on Fedora Core 5. I am unable to call a MySQL stored procedure that returns output parameters using mysql, mysqli, or PDO. I'm having a hell of a time with it... The following comes from phpinfo(): PHP Version: 5.1.2 mysql Client API version: 5.0.18 mysqli Client API version: 5.0.18 PDO Driver for MySQL, client library version: 5.0.18 MySQL version, from running SELECT version(); = 5.0.18 Here's the procedure I've created in MySQL: CREATE PROCEDURE testproc(OUT p_testvar varchar(50)) BEGIN SET p_testvar = 'HELLO WORLD!' END [color=blue] >From the MySQL Command Line, I can do the following:[/color] mysql> call testproc(@a); Query OK, 0 rows affected (0.00 sec) mysql> select @a; +--------------+ | @a | +--------------+ | HELLO WORLD! | +--------------+ 1 row in set (0.00 sec)
View Replies !
Warning: Mysql_connect() [function.mysql-connect]: Lost Connection To MySQL Server
I've set up a test server on an Ubuntu system. I installed and configured Apache, PHP and MySQL however, whenever I try to connect to a MySQL database I get this error: PHP Code: Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 in /var/www/index.php on line 8 Lost connection to MySQL server at 'reading initial communication packet', system error: 111 Does anyone know what is causing this and how I can solve the problem?
View Replies !
Create A Multi Table Database In MySQL And Write To And Retrieve Information Using MySQL.
I am trying to create a multi table database in MySQL and write to and retrieve information using MySQL. I am able to insert and call data easily enough going into one table, but I am having problems with connecting tables and using the idea of normalization. I am starting simple with an online registration for alumni of an association. My first table in a database is called alumni and it stores there e-mail address, first and last name and year of graduation. Code:
View Replies !
MySQL Error - Supplied Argument Is Not A Valid MySQL-Link Resource
I am getting the error Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/server7/public_html/71/arranholloway/database4.php on line 7 I tested my code on local computer and there were no problems, the error message only appeared when I loaded it onto my web hosters server. I'm new to PHP so its probably something simple but any help would be appreciated.
View Replies !
Connection With MySQL. Navicat - CANNOT CONNECT TO MYSQL SERVER ON LOCALHOST
I am new in PHP & MYSQL. I installed PHP & MYSQL properly. To easy operate for MYSQL I installed Navicat and it installed properly. But when I am going to test the connection between MYSQL & Navicate the error message showing CANNOT CONNECT TO MYSQL SERVER ON LOCALHOST (10022) it should mention that my connection name = localhost, Ip = localhost,port = 3306 , user name = root in Navicat.
View Replies !
PHP Saying Error In Mysql Syntax, But Written My Mysql Query Browser!
I have a basic db that I access with MySQL query browser. Everything seems fine to me but I am using this db as part of a php shopping basket and when I try to add an item I get: Notice: Query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '>function.extract]: First argument should be an array in functions.inc.php on line 31 Notice: Undefined variable: price in functions.inc.php on line 36 Notice: Undefined variable: price in functions.inc.php on line 39 Notice: Undefined variable: total in unctions.inc.php on line 39 I'm assuming the last three are caused by this problem as price should be passed to the cart, and total is worked out using it. However although I know mySQL code it was the MySQL query browser that actually generated the code and I cannot see a way to view or debug the code. The db has one table in it which is made up of id, name, subname, desc, and price. The code in the php file that is being referred to is:
View Replies !
MySQL Pro Certified Server Versus MySQL Community Edition
Does anyone have any experience with this? I'm trying to see if the service provided with the "MySQL Network with MySQL Pro Certified Server" version is worth the costs involved. I'm making a real estate website that's basically going to be a listing service. You can do searches on the listings for free, and it costs to add your listing. Our listings are only going to be active for 30 days, and we really don't expect to have more than maybe a thousand or so listings at a time tops. I'm just wondering if this is something that should be manageable for me, even though I really don't have any prior DBA experience. I've played around with phpMyAdmin for a bit, so I know how to backup/replace/repair/etc., and am just wondering if this is enough. Any thoughts?
View Replies !
Automatic Scheduled MySQL Backup (MySQL Dump)
Is it possible to configure a UNIX/LINUX server to do a MySQL Dump for a database on an automatic schedule and then to email the dump file to me (the administrator)? I want to be able to have my database automatically backed up every week and emailed to me for storage purposes without any action on my part.
View Replies !
PHP/MySQL: Using PHP To Probe MySQL Db And Send An Email Automatically
Let's say you have a login feature on your site... and a user forgets their password which is stored along side their email address in a MySQL database. Is it possible to use PHP to automatically send the password to that email address upon request? If so, please provide a detailed solution. If not, can Java be used in some way to accomplish this?
View Replies !
--with-mysql ? Php-4.4.2 With Mysql Install In Special Directory
I'm trying to link php-4.4.2 with mysql install in special directory, like /usr/newsystem/mysql, but whatever options I try, php always gets linked to version in /usr/local/lib. I've tried several options: --with-mysql=/usr/newsystem/mysql --with-mysql-dir=/usr/newsystem/mysql --with-mysql-lib=/usr/newsystem/mysql --with-mysql-lib-dir=/usr/newsystem/mysql ....but none of them work, CLI is always build against /usr/local/lib/ libraries.
View Replies !
Create A Sequence In MySQL, With Mysql Variable?
This might be fairly easy to do and I think I've seen the code before, but I haven't seen many good examples of this. Of course Pear::DB probably uses this code in some of its API, probably in dealing with auto-increment indexes and prepared statements. Maybe I'm off base here, but I'm looking for something like this: (psuedo-code) Of course the seq table only needs 1 row holding id, which is updated. select id from tbl; // get result resouce and do fetch, store value in $myid set @myvar = $myid + 1; // can php send to MySQL with a query? ( never seen this ) update myseq set id=@myvar // send this statement through in a update/query // for use in PHP code $newSeqVal = $myid +1
View Replies !
And Mysql - Connect Remotely To A Mysql Database.
I am trying to connect remotely to a mysql database. here is the code: <?php # FileName="Connection_php_mysql.htm" # Type="MYSQL" # HTTP="true" $hostname_myDB = "http://db195.perfora.net"; $database_myDB = "dbname"; $username_myDB = "username"; $password_myDB = "password"; $myDB = mysql_pconnect($hostname_myDB, $username_myDB, $password_myDB) or trigger_error(mysql_error(),E_USER_ERROR); ?> here is the error: Warning: mysql_pconnect(): Unknown MySQL Server Host 'db195.perfora.net' (1) in /oldhome/WWW/wingsofthedawn.org/htdocs/final/Connections/myDB.php on line 9
View Replies !
Copy And Paste On MySQL To MySQL Database
Would there be any issues if i literary Copy and Paste a mysql db from one server to another mysql db server? When i say "copy and paste" is just like tranferring one word doc from one pc to another pc. I tried the copy and paste already and the new server had recognize the DB i had pasted. I just want to confirm if there would be issues doing it so.. Or should i use Mysql.com Migration toolkit?
View Replies !
Mysql Update - Grab The Value Count From Mysql
I'm trying to grab the value count from mysql and add one to it. This is very simple, but I"m still completely lost! here is the code: require("connect.php"); $result = mysql_query("SELECT fav_count FROM favs WHERE page_id = $page"); $result++; mysql_query("UPDATE favs SET fav_count = $result WHERE page_id = $page"); echo "Thank you for telling us you like this!<br />Please wait..."; echo "<META HTTP-EQUIV=Refresh CONTENT="2; URL=link.php">"; Any help is greatly appreciated!
View Replies !
Php/Mysql- Uploading Mysql Database
I've set up a basic database using Mysql (just creating a web blog I followed a tutorial) and then started writing the php code for interacting with the database. how do I put the Mysql database onto the the web server where I have server space (the server I use is just some company that I pay €100 a year for). I need the php file to get the data from the Mysql database...
View Replies !
Problem Getting PHP To Recognize MySQL, Using PHP 4.3.7 And MySQL 4.0.20
I have both PHP 4.0( RPM) installed and MySQL 4.0.20 installed with the mysqld daemon up and running. But when I look at the output of phpinfo() , I do not see it there, which is worrisome and so I tried to recompile PHP and do ./configure with the --with-mysql=path but I don't really know where my mysql's header files should be , is there any way to find that out by using any of the mysql commands? I did try to do ./configure for PHP4 without any parameters and when I looked at the output, I do see that PHP seems to recognize that mySQL is there : .... checking for MSSQL support via FreeTDS... no checking for MySQL support... yes checking for specified location of the MySQL UNIX socket... no checking for MySQL UNIX socket location... /var/lib/mysql/mysql.sock checking for inline... (cached) inline ..... Hence, why is that when I do phpinfo() , mySQL still doesn't show up? I suspect that mysql isn't working correctly with php, because if I use the mysql_connect() function in my php, I get the error "Fatal error: Call to undefined function: mysql_connect() " and yet it DOES seem like PHP recognizes mysql is there. That "unable to recognize mysql_connect function" error comes up after installing PHP using ./configure with or without any parameters.
View Replies !
Seeking Resources On Mysql, Not Mysql.com
I'm looking for some resources that can aid me in getting deeper into php/mysql. I am presently looking at a syntax that lets me check a mysql row for one particular value, using sql. Then I look for a sql based solution to get a column name based on the above value. Last I need to update that row, actually NULL that particular field in that particular row. I've been reading mysql.com the function list all afternoon, nothing found that might make it able for me to write those statements in question. So now I better expand and seek new sources, google.com didn't give me much while searching the groups.
View Replies !
Migrate Old Mysql DB To New Mysql Server
I am trying to migrate our old mysql DB to another new mysql server using AB: MySQL Migration Tool. The migration has some problem. One of the tables from the old DB had a column defined Datatype as DATE. However, when I do migration. The migration informs me that " The following error occured while transfering data from log Cannot convert value '0000-00-00' from column 13 to TIMESTAMP." I believe the migration forces to convert the datatype into timestamp. The work around i can do on this is to change the datatype of the column on the old DB into Timestamp. However, I don't want that. I want to retain the DATE datatype.
View Replies !
Mysql 3.5 And Mysql 4.1 Data Insert
I am not able to insert data in mysql 4.1 by using same php script i used for mysql 3.5 . only id field and date field which are not VARCHAR get inserted but not VARCHAR PLease help here is my insert statement Code:
View Replies !
Socket '/var/db/mysql/mysql.sock' (2)
I'm just uploading a site to a new hosting company, and i get this error socket '/var/db/mysql/mysql.sock' (2) I know my script is sound as it runs fine local and on my usual server, from googling it, it appears that it may be an problem server side, can anyone help?
View Replies !
5 / MySQL Connect - '/tmp/mysql.sock'
I've installed php5 and phpMyAdmin (MySQL) via synaptics. Both seem to work fine on their own, but when running a php mysql_connect I get a socket error (see below). I have included as much information as think will be relevent. Code:
View Replies !
Could Not Connect To MySQL: Can't Connect To Local MySQL Server Through Socket
To connect to a MySQL database, hosted on my machine, an iMAC G5 with OS 10.4, I am using the following code: $dbc = mysql_connect ('localhost', 'guestuser', �') OR die ('Could not connect to MySQL: '.mysql_error() ); However, I receive an error message: Could not connect to MySQL: Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2). MySQL server is running, and user name/password are valid.
View Replies !
Connect To MySQL - Can't Connect To Local MySQL Server Through Socket
I've finished coding php, run it localhost and uploaded to my Apache server with Linux OS. However, I'm seemingly unable to connect to mysql at the server side. and received the following message: Could not connect to database: Can't connect to local MySQL server through socket '/tmp/mysql.sock'(111) What's this message abt? I tried to get into MySQL without php on the server. and received the same message at the console.
View Replies !
|
TRACKER
