Local Mysql Server Name, IP Or Localhost
I am using localhost as mysql server name on my config file. then, when I enter [url], the address will automatically change to[url]that obviously getting error. when I change the mysql server name from localhost to the server public IP, everything seems ok.
My sql is 4.1.x with php 4.4.7, is that any way I may use localhost instead of IP?
or is there any potential danger using IP?
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Can't Connect To MySQL Server On 'localhost' (10055)
Do you guys know anything about this? My server works perfectly with INSERT, UPDATE, DELETE for mysql. but after like 12 hours later, my application crashes and I get this "Can't connect to MySQL server on 'localhost' (10055)" and I would have to restart my applications and everything will be working perfectly. Do you guys have any idea why this happen? I do have a lot of connections coming in and out of my server. Would that mean anything?
View Replies!
View Related
Installed MySQL In /usr/local/mysql But Error In /var/lib/mysql
I installed the MySQL binary packages in /usr/local/mysql/ after removing the MySQL RPM package. MySQL is functioning when I executed /usr/local/mysql/bin/safe_mysqld. I reinstalled MySQL before I installed PHP. When I used a PHP script to access a MySQL database, it outputs an error: Code: Warning: mysqli::mysqli() [function.mysqli-mysqli]: (HY000/2002): can't connect to local mysql server through socket /var/lib/mysql/mysql.sock in index.php on line 2 However, I installed MySQL in /usr/local/mysql, not in /var/lib/mysql. How do I fix MySQL?
View Replies!
View Related
Fast MySql Access- Localhost
I've been using Dreamhost for years and they're very good, but their MySql databases are quite slow. Then I moved to ServInt with a VPS, and my MySql is on localhost instead of on a different server. WOW! It's so fast! However, now I'm trying to find a shared hosting package that has fast MySQL service. I'm not sure if the requirement is that it's on localhost but it sure doesn't hurt. Is there anyone who is familiar of a good solid shared hosting package with fast MySQL service?
View Replies!
View Related
"Can't Connect To Local MySQL Server" + "IPS Driver Error"
During peak times (especially weekends) many of my site's users have been reporting intermittent 'IPS Driver Errors' in the forums and the following error in the coppermine gallery: Quote: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11) (The forums and the gallery are the main parts of the site). I'm assuming that the site is having problems handling the number of users trying to connect to SQL. I tried increasing the max_connections and max_user_connections settings in my.cnf but it doesn't seem to have made a significant difference. What do I need to do to fix this? Would I need to upgrade my server specs or is it something to do with the server settings? my server specs: AMD Dual/Dual Opteron 270 with 4GB RAM.
View Replies!
View Related
My MySQL "localhost" Not Resolving
My CMS was working fine until today. Today, suddenly it won't resolve "localhost" of my MySQL correctly..so a hack was implemented and instead of "localhost" a loopbackaddress was hardcoded into configuration file of the cms. Now it works fine again. Any ideas as to what could be the problem here? Also, could this have some other consequences I should be aware of?
View Replies!
View Related
Error Connecting To IMAP Server: Localhost
i'm on Linux dedicated box -DirectAdmin panel I use Squirrelmail to se my e-mail. When i try to log inn and read mail i get this message: Error connecting to IMAP server: localhost. Where can i change this...... Squirrelmail SquirrelMail version 1.4.17 By the SquirrelMail Project Team ERROR Error connecting to IMAP server: localhost. 111 : Connection refused webmail ERROR (2): fsockopen() [function.fsockopen]: unable to connect to localhost:110 (Connection refused) (/var/www/html/webmail/inc/class.uebimiau_mail.php:80) RoundCube Webmail Connection to Imap server failed Read on another forum, that this can solve the problem /etc/rc.d/init.d/imaps restart /etc/rc.d/init.d/imap restart -bash: /etc/rc.d/init.d/imaps: No such file or directory -bash: /etc/rc.d/init.d/imap: No such file or directory telnet localhost 143 for imap or 993 for imap over ssl Usage: telnet [-8] [-E] [-K] [-L] [-X atype] [-a] [-d] [-e char] [-k realm] [-l user] [-f/-F] [-n tracefile] [-r] [-x] [host-name [port]] Also Xinetd restart don't help [root@server etc]# /etc/rc.d/init.d/xinetd restart Stopping xinetd: [ OK ] Starting xinetd: [ OK ] Looks like that Imap isn't installed ? Correct me if i'm wrong ..............
View Replies!
View Related
Mail Server & Webmail In Localhost
I want to run a local Mail Server + Webmail Client (opensource. I googled and I found hmailserver[server] and Roundcube [webmail]. the problem that i can't config any of them How have an other alternative for mail server or a solution
View Replies!
View Related
Localhost Server With Mail Server
I would like to set up a localhost server with a mail server too, I usually use uniform server as I find it very easy to get up and running and carry around with me, are there any better solutions, I have found it difficult to get a mail server running on the uniform server. or maybe there are distributions that come with mail server ready built in?
View Replies!
View Related
Local To Live...sql Server
I have been working on an online shop locally from my machine, using Visual Web Developer and SQL server. This is working fine, but now its at the stage were i need to show a client. In order to do this i need to upload it to our servers. What i cant get my head round is the connection to the sql server, do i need to upload this too, or can i somehow point the connection string to the sql server sitting on my local machine... Is it easier just to upload an sql server? how would i go about this?
View Replies!
View Related
Different Local Remote Server Types
I cannot find a suitable forum for this query so here goes on this one! I am doing a charity site as a voluntary exercise. They currently host with Eclipse who have the Zeus server (site developed in Frontpage). This is not an open source server. Thing is, what are the issues of say developing on my loacal machine (apache or IIS5) and having the remote being Zeus. I use Dreamweaver 8 for developing. I would of thought this does not matter as the server technology is transparent and down to configuration files. The directory structure both ends can be the same. Am I right to go ahead and not worry about this?
View Replies!
View Related
Can't Access My Local Web Server By Its External IP
I have a local web server that I want to make available outside of my local network of two computers. I configured NAT at my router, configured the firewall. I Typed the external IP and got nothing, while I still was able to access my web server by typing "localhost", I tried both IIS and Apache, but what is interesting is that fact that the other people can access my web server via that external IP, I just cannot access it from my local network.
View Replies!
View Related
Unable To Connect To Local Httpd Server.
When i go to my website or any page under the domain it's just white. Blank nothing, nada. "Failed to receive status information from Apache. Unable to connect to local httpd server." This error message appears when i click on "apache status". Is this because of the network issue? Or is it because of something I did myself? I did a google search and came up on some solution, I did them and nothing.
View Replies!
View Related
Connecting To Local Server With Virtual Machines
How do you go about setting up virtual machines so that they can see sites hosted on the host machine? I've got Virtual PC 2007 and the disk image that MS supply for testing IE6 on Vista machines and I'm having trouble accessing my local Apache server (set up with XAMPP). Until recently I was able to set the XP VM's LAN settings to use a proxy server with the IP address of the host machine, but I got migrated to ADSL2+ yesterday by my ISP and now that's no longer working. To access my sites locally, I set up httpd.conf like this: PHP Code: <VirtualHost *:80> DocumentRoot "C:PathToFolder" ServerName siteName.local</VirtualHost><Directory "C:PathToFolder"> Options FollowSymLinks AllowOverride None Order allow,deny Allow from all</Directory> and then in Windows hosts file I add 127.0.0.1 siteName.local. So what's the best way of getting the host and VMs to talk to each other?
View Replies!
View Related
Updating Access Databases On Local Web Server
I am using Windows XP Pro, and since I updated to Internet Explorer 7 I am having problems getting web sites to work on my PC in Internet Explorer using the local IIS web server. These web sites are using ASP and Access databases. The two errors I get are: Operation must use an updateable query. or Cannot modify the design of table 'TABLE_NAME'. It is in a read-only database. (they are not read only!) Does anyone know how I can get this working so I can test my web sites locally before uploading them to the live sites?
View Replies!
View Related
Vietnamese Localhost
I am a Vietnamese girl and a new member. I'd just like to ask anybody knows about vietnamese localhost? I use appserv, but it does not have vietnamese language, so if I'd like to submit categories, etc. in Vietnamese into my phpmyadmin, it does not work. Only languages are okay, like: English, Deutsch, French, Spain, .... but there are no Vietnamese language. What should I do? We write with latin characters, but there are apostrophes which appserv cannot read. Does it happen to any Vietnamese here in forum? how can write a text in Vietnamese language into phpmyadmin,
View Replies!
View Related
DSL + Localhost
A friend of me would like to setup a local server with my DSL. The problem is the IP address keeps changing and he does not want to purchase a static IP. The script needs to detect the IP address and then email it to the admin over here daily.
View Replies!
View Related
127.0.0.1 Works But Not Localhost
I just installed wamp here on my laptop to set up a developer machine for my website. I am used to going into the browser and just typing in "localhost" and having it bring up the test website. I'm sure there is probably something wrong with the configuration of the wamp files because it works for 127.0.0.1.
View Replies!
View Related
How Associate 127.0.0.1 To Localhost
I've installed WampServer on my Windows Vista machine. Haven't used it for a while but now for some reason I can't access http://localhost, firefox tells me, "Firefox can't establish a connection to the server at localhost.". I can access WampServer via [url]and the main WampServer default page appears. Apache version : 2.2.8 PHP : 5.2.6 MySql : 5.0.51b Which file(s) do I need to edit in order to associate localhost to 127.0.0.1
View Replies!
View Related
Limit Access To Localhost
I have a win2003 server running some apps in the 'default web site' I have just installed PHP on the 'default web site' and I want to use it to run some admin jobs. BUT I do not want the PHP scripts to be accessible over the internet, they should only run from local machine. Is it possible to set it up so that the files can be executed only by localhost?
View Replies!
View Related
Accessing Blog On Localhost
I installed Wordpress on a local install of Apache so that I can play around with it and get my design down before I put it on the web. I can get to the admin and do everything, but I can't actually get to the site. I had an index.html in my htdocs directory, which was deleted, but now when I go to localhost, it just shows the directory.
View Replies!
View Related
Configuring Subdomains In Apache On A Localhost
I'm currently trying to configure apache 2 to handle subdomains. This is on a local machine (not tied to any domain names) and I'm only doing it to research how the final structure of a site 'could' be setup. Basically I have a single install of Apache 2 running. The outcome eventually should be to have specific sub domains that all point to the same document root as the actual domain name. So eventually I will have: http://www.mydomain.com http://subdomain1.mydomain.com http://subdomain2.mydomain.com with both subdomains showing the content at mydomain.com (there is reasoning behind this but I'm not gonna go into that). I have apache setup as follows: NameVirtualHost *:80 <VirtualHost *:80> ServerName daneastley DocumentRoot "C:/Program Files/Apache Group/Apache2/htdocs" </VirtualHost> <VirtualHost *:80> ServerName subdomain1.daneastley DocumentRoot "C:/Program Files/Apache Group/Apache2/htdocs" </VirtualHost> <VirtualHost *:80> ServerName subdomain2.daneastley DocumentRoot "C:/Program Files/Apache Group/Apache2/htdocs" </VirtualHost> Now on my local machine, only the top one works - the subdomains dont. if I add the following into my hosts file in windows, they all work: 127.0.0.1 daneastley 127.0.0.1 subdomain1.daneastley 127.0.0.1 subdomain2.daneastley the problem being, that I wish to test this enviroment on the local network. How would I go about having every computer being able to access this? I'm assuming it comes down to DNS stuff.
View Replies!
View Related
Malicious Mail Sent Out Via MailEnable On Localhost
we received a report of a malicious mail being sent from our servers. Problem is that the sender and recipients are not hosted with us. What I'm trying to find out is how the mail got sent out. The ME logs shows that the connection was made from 127.0.0.1 to the smtp service, but that's it. We don't run mail services (pop3/imap/webmail) on the web servers, if that helps any. Have run out of ideas after sifting thru lots of logs (was trying to find if anyone called an application to send the mail and attachments out), but came up empty.
View Replies!
View Related
Unable To Connect Localhost(10061)
I am stuck in re-installing mysql server..... Everything I have removed even mysql service give reboot the machine but still not able to complete the installation. At the end I receive error " Can't connect to Mysql server with LocalHost (10061) By the way if port 3306 is not enabled in firewall can this issue be occurred because of this?
View Replies!
View Related
Bluescreen On Win XP Accessing Localhost
I just installed IIS on my Windows XP machine and any time I access localhost I get a bluescreen and my computer will restart. I have tried to uninstall IIS, reboot, re-install, reboot then try accessing localhost and that does not fix anything. This is on an almost fresh install of Windows. (The computer is only 1 week old)
View Replies!
View Related
Sendmail Sends From Localhost.localdomain No Matter What I Try
I have these lines in sendmail.mc and I've compiled the sendmail.cf with them: LOCAL_DOMAIN(`freesexdoor.com')dnl MASQUERADE_AS(`freesexdoor.com')dnl FEATURE(masquerade_envelope)dnl MASQUERADE_DOMAIN(localhost)dnl MASQUERADE_DOMAIN(localhost.localdomain)dnl I have the users daemon, freesexd and root in the trusted_users file. I have restarted sendmail (using service sendmail restart). I have the domains: server.freesexdoor.com, freesexdoor.com and mail.freesexdoor.com in the sendmail's local_hosts file. In Apache 2's httpd.conf, I have this: php_admin_value sendmail_path '/usr/sbin/sendmail -t -i -f freesexd [at} freesexdoor.com' Yet when I sent an e-mail with php to advertising [at} freesexdoor.com, I got these headers in the e-mail, which don't look good to a spam filter: Received: from localhost.localdomain (IS-3293 [127.0.0.1]) by localhost.localdomain (8.13.8/8.13.8) with ESMTP id Received: (from daemon@localhost) by localhost.localdomain (8.13.8/8.13.8/Submit) id Message-Id: <200712180935.lBI9ZrRs005480@localhost.localdomain> Additionally hotmail rejects my e-mails and it is obvious why. (My OpenSPF record is fine btw and on my former server I was able to send e-mails with it fine.) Naturally I want something like "freesexdoor.com" to replace "localhost.localdomain" in those header lines. So how can I get this working? The OS is CentOS 5 by the way.
View Replies!
View Related
Access Denied For User 'root'@'localhost
I'm getting the error after running [root@server ~]# mysqladmin processlist Quote: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' I'm running plesk on FC4. Not too sure why it says failed or denied, as I'm root?
View Replies!
View Related
MS Virtual PC - How To Access My Localhost (Apache) Subdomains On Guest OS?
I've just downloaded Microsoft Virtual PC and the Internet Explorer 6 Application Compatibility VPC Image containing an XP installation for testing sites with IE6 [url]. Everything works fine, I chose VPC Shared Networking (NAT) and I can access the internet from the VPC as well as my Apache development server which runs on the host OS (Win XP) by going to the host's IP address which is [url] in my case. And here I have 2 problems: 1. I want to access [url]on VPC just by typing [url]. I added the following line to the hosts file: 192.168.52.141 localhost But this doesn't work. Interestingly, any name other than localhost works fine, for example: 192.168.52.141 localhost.localhost or 192.168.52.141 local This is not a major problem but I'd prefer localhost. Any ideas how to do that? 2. And the more important issue: on my host OS I have some development sites which I have set up to be accessed by subdomains, for example [url], in httpd.conf: Code: <VirtualHost 127.0.0.3> ServerName perfekt.localhost DocumentRoot C:wwwperfekt DirectoryIndex index.php index.html </VirtualHost> and in hosts file: Code: 127.0.0.3 perfekt perfekt.localhost And now I want to access this site from my VPC too by using subdomains like this! How can I do that? The address 127.0.0.3 seems to be local to the OS and VPC can't see it. I have tried setting other IP addesses in httpd.conf but nothing outside the 127.x.x.x range works on either OS. I suppose I need to make each of my sites to be seen under a different IP from the outside network so that VPC (which is "outside" the host OS) can access them - then I just set up the appropriate subdomain names in VPC hosts file -
View Replies!
View Related
DirectAdmin - Access Denied For User 'apache'@'localhost' (using Password: NO)
I get the following error when let my site connect to my database: Access denied for user 'apache'@'localhost' (using password: NO) But when im running lil test script which connect to my localhost with the same passwords and it gives the status 'Connection OK' (im running on admin account, made a MySQL account with DA) Code: <?php $link = mysql_connect('localhost','admin_removed','removed'); if (!$link) { die('Could not connect to MySQL: ' . mysql_error()); } echo 'Connection OK'; mysql_close($link); ?>
View Replies!
View Related
Installed Apache Can Access Via LAN IP + Localhost But WAN IP Doesnt Work
I'm on windows vista. I've got an SDSL line into the house with a dedicated IP 62.etc. I've then got a Prestige 791R and all PC's plugged in to that. I've also got a wireless router for my Wii set up. Basically I've set up this DHCP thingy to start at 192.etc.3 and the Wireless router is at 192.etc.1 and the Prestige is at 192.etc.2 my pc is at 192.etc.9 This is about where my knowledge stops unfortunately. I have installed apache as the most basic default install I think you can and it seems to be working absolutely fine. I'm assuming I could also install PHP and MySQL etc and wouldn't have too much of a problem, however, my friend cannot seem to access the environment from the WAN IP and when I type in my WAN IP I get the prestige router's control panel. I read somewhere that I needed to forward port 80, now I can 'open' ports in the prestige control panel but I did try opening port 80 in the control panel and pointing it to my LAN IP (92.etc.9) but it didn't seem to work. I'm at a bit of a loss so if anyone could point me in the right direction I would be most grateful, just to clarify: //localhost loads the html file 100% //192.etc.9 loads the html file 100% //62.WANIP internally loads my prestige routers control panel //62.WANIP externally does not load a page (cannot be found) If you need any more info just let me know and I'll get it.
View Replies!
View Related
MySQL Error : MySQL Server Has Gone Away
I keep getting this error : MySQL Error : MySQL server has gone away How do I fix it? my.cnf contents Quote: [mysqld] safe-show-database old_passwords back_log = 75 skip-innodb max_connections = 800 key_buffer = 48M myisam_sort_buffer_size = 64M join_buffer_size = 1M read_buffer_size = 1M sort_buffer_size = 2M table_cache = 3000 thread_cache_size = 128 wait_timeout = 90 connect_timeout = 30 tmp_table_size = 128M max_heap_table_size = 64M max_allowed_packet = 256M net_buffer_length = 16384 max_connect_errors = 10 thread_concurrency = 4 read_rnd_buffer_size = 786432 bulk_insert_buffer_size = 8M query_cache_limit = 3M query_cache_size = 48M query_cache_type = 1 query_prealloc_size = 262144 query_alloc_block_size = 65536 transaction_alloc_block_size = 8192 transaction_prealloc_size = 4096 default-storage-engine = MyISAM max_user_connections = 500 [mysqld_safe] nice = -5 open_files_limit = 8192 [mysqldump] quick max_allowed_packet = 16M [myisamchk] key_buffer = 64M sort_buffer = 64M read_buffer = 16M write_buffer = 16M [mysqlhotcopy] interactive-timeout
View Replies!
View Related
ERROR 1045 (28000): Access Denied For User 'root'@'localhost' (using Password: NO)
Im trying to setup a mysql server on my centos vps server. Ive installed mysql server and done chkconfig and the mysql server has started. My problems start when i want to set a mysql root password. Quote: mysqladmin -u root password yourrootsqlpassword mysqladmin -h server1.example.com -u root password yourrootsqlpassword I get an error "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)" Which i totally dont understand because why would it want a password when im trying to set the password?
View Replies!
View Related
ERROR 1044 (42000) At Line 21: Access Denied For User 'umar_cs'@'localhost' To Data
in ssh i try create new database root@server1 [~]# mysql -uumar_cs -ppassword umar_cs </home/umar/public_html/localhost.sql it is show direct ERROR 1044 (42000) at line 21: Access denied for user 'umar_cs'@'localhost' to database 'umar_cs' i try from script same message i think maybe the problem from the size in this file /etc/my.conf set-variable = max_connections=500 i change to set-variable = max_connections=500M and restart mysql and i try create same problem!
View Replies!
View Related
Rc.local
in my rc.local i've got it so a program starts up automatically, this works when i restart my machine but the machine has also been crashing randomly (something which i haven't tracked down the source of yet) and when it goes up after this the program isn't started. Could this relate to my crashing problem or would it be something else that isn't configured right?
View Replies!
View Related
Local Or International
am now registered my domain with a local person who's name is ABT in india.. but their service was not good and am planning to change the hosting space to yahoo or other cheap web space provider... how to do it... whether the ABT peoples help with this part...
View Replies!
View Related
Eth1 For Local IP
I have problem on eth1 for local IP. Eth0 is public IP behind Firewall, and eth1 is local IP for backup and for database. Every time eth1 is on, eth0 cannot be reached by ssh and http, although still can be pinged. Eth1 is also IPMI BMC port, and automatically got IP from DHCP LAN for web-based IPMI access, and the IPMI cannot be turned off. Motherboard is Tyan B7002.
View Replies!
View Related
Local To Live
have only done static html sites in the past, but am ready to branch out and learn php and mysql. I have watched numerous video tutorials on php,mysql, dreamweaver cs3, and how they all work together. I have followed all the steps on the tutorials and the website works great on my local testing server, but how in the world do I get it to work live on the internet! This is probably a very stupid question but I am at the point of not caring about looking stupid. I just want to know what Im missing/ doing wrong. The website is hosted with GoDaddy, (and the domain is registered with them as well).Am I supposed to have something set up there or a different server? I have tried using ftp to transfer all files over to the domain but when I visit the domain, the php pages do not work.
View Replies!
View Related
How To Change VZ SSL To "localhost.localdomain"
I'm planning to buy a high end VPS for reselling as a whole. Does any one know how to change the VZ SSL to localhost.localdomain as shown in the attachment? I asked many providers and non of them like to change this. I got one provider willing to change this for me but he's not very sure how. Someone told me that "Ask your provider to study how VZPP is handled by apache in the service container and they should find his way through" I'm already aware that this should be done from the main hardware node not from the clients VPS itself.
View Replies!
View Related
SwitzerLand Local Peering
I have a client who needs a very special configuration. We are trying to find a data center or server provider in Switzerland who can only broadcast there ip in Switzerland only. So any attack or anyone trying to access that ip outside Switzerland will not get even close to it...
View Replies!
View Related
Local Php.ini
I run multiple domains/sites on my linux server. I know there is a php.ini files that comes with the php installation package. But I have heard that there is a way to create a local php.ini file for each domain. Does anyone knows how to create local php.ini files for each domain. Is there a special setting i need to do to make it run?
View Replies!
View Related
Opening Up Local Access
I have a script running on my server that has access via port 1031, but I would like to block access to it from the public, and instead allow access only through a php proxy script on my server which will connect to port 1031 via 127.0.0.1 (i.e. 127.0.0.1:1031) So some may be thinking why? Currently users gain access by heading to mydomain.com:1031 . However I would now like to include adverts along side the script (but can't physically make adjustments to the script as the company that made the script has vanished of earth) So the only way I can think of doing this, is by having the adverts in an Frame next to the proxy script. So does opening up access via 127.0.0.1 just for this case, give me security problems?
View Replies!
View Related
To Prevent Local Hack
I try to enhance my server security and prevent local hack but it seem useless. I tried to chmod home/user/public_html to 711; disable functions; enable php open_basedir. I can stop some popular shell such as c99shell.php but server can be hacked local. Anyway to prevent it completely?
View Replies!
View Related
|
TRACKER
