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?
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?
After the upgrade of our Plesk installation from 9.5x to 11.5.30Everything works ok (sites,sites with databases, Plesk etc)but when I go to Home>Tools & Settings> Backup Manager.I see errors on every daily backup I have on schedule:
The backup Plesk_Daily_Full_Backup_1407060112.tar has completed with warnings. (View the details) Close this message
Error:mysql "myuser_drupal"
Unable to define superuser password for mysql server on localhost
Error:mysql "myuser_drupal"
Unable to get list of db servers (ErrorCode: 1, STDOUT.
Error:mysql "myuser_wp_eng"
Unable to define superuser password for mysql server on localhost
mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/thesymbi/public_html/includes/class_core.php on line 274
I get this around 50 times a day!
I am fed up!
Somehow when customers add a new MySQL database they can select a Local MySQL server. It turns out this is the MySQL instance running on the CP server, can I somehow hide this server from the list?
View 1 Replies View RelatedI 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?
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?
I have a problem with connection to MySQL database over PHP.
If I define host address '127.0.0.1' works well. Problem occurs if host address is 'localhost'.
How to allow both 'localhost' and '127.0.0.1'?
I have windows server 2012 and Plesk v12.0.18 #30 - I noticed speed problem.
When I try to connect to mySQL with:
$conn = new mysqli('localhost', 'joomla_***', '*****', 'joomla_test');
Connection takes 1 second!!!When I try to connect with '127.0.0.1' instead of 'localhost' connection takes 0,009 seconds.
1. I tried solution to add line '127.0.0.1 localhost' to c:windowssystem32driversetshosts - but no luck.
2. I tried to edit C:Program Files (x86)ParallelsPleskMySQLDatamy.ini - adding lines
bind-address=127.0.0.1
skip-name-resolve
then restarted mySql but 1 second lag time on connection was still there.
3. I even tried to disable IPv6 but still no luck
I guess all users windows windows server 2012 has the same problem??!?!...
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.
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?
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
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 ..............
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 0 Replies View RelatedI am really thinking of upgrade my dedi server, but since its from a IDE disk to a SATA, I can´t move the IDE to the new system.
Is there a way to backup the server disk to your
local computer? FTP ?
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?
I have a question if it is possible to use my local server as database storage and even some uploaded files. I am planning to host my website even in a shared hosting server provided that I could used my local server as data storage.
View 2 Replies View RelatedI 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 4 Replies View RelatedI 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?
I found a socket available other than 80 which would not allow me to use. I set it in the conf file as 1800 and then go to apache/bin directory and load httpd.exe. When I go to the browser, I have to type in http://localhost:1800 for it to work once. If I close the browser and try again, or I try a php file, it says it can't find localhost. I have to stop httpd.exe and reload, then it will work once.
Do I have to find a way to use socket 80 for it to work?
I'm trying to set up a SMTP server on my local machine.. can i do this with a windows OS using apcahe?
View 3 Replies View RelatedWhen 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.
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?
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?