Server :: Mysql For Multiple Websites?
Aug 1, 2011
I currently have a single mysql instance for a couple of websites. Both websites require that the user provide a username.
The thing I just noticed is that two people might choose the same username for both applications. Both of them would have grants to each others' tables, although neither would ever be able to access them, since they can only access through php scripts.
But, I'm now guessing this is not best practice. What does one do? Run multiple instances of mysql for several websites?
View 4 Replies
ADVERTISEMENT
Apr 1, 2010
I have managed to configure AWstats to work from one server to access the log files for multiple websites on multiple servers and even managed to write a little front end php site to access all the different conf files. I want to know if there is a way of combing two conf files for the same site but are on two different servers in a loadbalanced situation. so my conf files look something like: [URL].. I have to monitor bandwidth for our websites and its gets tedious switching between the various conf files for the same site and totaling it up so I was hoping I could combine the output of both conf files on screen using some funky command in the awstats.pl script
View 1 Replies
View Related
Sep 25, 2010
I've currently got a centos server setup in my home. It has 1 website running on it and I am using DynDNS.com's service to access the server. DynDNS works by redirecting a free url to the IP address of your server. I would like to add a second website under a different url. However, I'm not sure how to add a second IP address (which I would then use with DynDNS to create a new url).
View 3 Replies
View Related
Aug 25, 2010
I currently am running 10.04.1 and have successfully setup my home web server to run a single website. My current settings are:
-I have registered the domain name annarrankings.com through godaddy
-A record is - host = @ and points to = 71.114.220.3
-CName is - host = www and points to = @
-on my server I have the site running in /var/www
I've done some research and found that to run multiple websites I need to setup VirtualHost.
-So I created a folder /var/www/annarrankings.com and moved my site to that folder
-Edited Apache2.conf to add the following line
-I then went to /etc/apache2/sites-enabled and copied the default file to a new file called annarrankings.com. Here's the annarrankings.com file after I edited it
-I then created a link in /etc/apache2/sites-enabled to the annarrankings.com file in /etc/apache2/sites-available
-Next I editied /etc/hosts
-When i went to enable the site using a2ensite annarrankings.com I got the following
I figured this was ok since I had already created a symbolic link earlier (a result of trying to following multiple tutorials and ..... videos at once) so I reloaded apache2. I created an index.html file in /var/www/ just for testing purposes and when I load www.annarrankings.com I get the file located in /var/www/ instead of the website located in /var/www/annarrankings.com Do I need to change my A record or CName in godaddy or did I just do this completely wrong?
View 8 Replies
View Related
Jul 9, 2010
I have set up two identical websites and want them to access the same mysql database. I've entered the username/password/db name in the website database.inc file. However, one database works fine and displays correctly, the other just gives a blank page. I've tested apache and it can display a different site (one that does not access any db). So is there a configuration that i'm missing. Do i have identify the two different websites that access the db?
View 7 Replies
View Related
May 8, 2009
I would like to know if I need multiple IPs' to setup two SSL urls on the same Apache server? Two ssl certificates, one IP - is it possible?
View 4 Replies
View Related
Jul 15, 2010
I'm setting up a server on Ubuntu 10.04 for development. It all seems to work nicely, I just have one thing that's bugging me. I have a project in /var/www/portfolio, which is as you may guess my portfolio. Instead of the link http://localhost/portfolio I'd like to use http://portfolio.nl. So I set up a file 'portfolio.nl' under sites-available and a symlink on sites-enabled containing this: To get this to work on my local machine I set up this in /etc/hosts:
[Code]...
View 2 Replies
View Related
Dec 15, 2010
I am trying add three namebased virtual hosts in local apache2 webserver OS ubuntu 10.10. The three sites are :www.site1.eka,www.site2.eka,www.site2.eka
The first I created a file is virtual.conf in conf.d directory its content is :
# we're running multiple virtual hosts.
# NameVirtualHost *:80
Next I created following files in sites-available directory. [URL] is as follows:
#site1.eka (/etc/apache2/sites-available/www.site1.eka)
<VirtualHost *:80>
ServerAdmin webmaster@site1.eka
ServerName www.site1.eka
ServerAlias site1.eka .....
When I visit the [URL] in browser it says server not found.
View 3 Replies
View Related
May 30, 2011
I am trying to create multiple FTP sites on one Linux server (using multiple vsftpd-sitename.conf files) with default port '21'.
Below is the sample vsftpd site configuration,
# cat vsftpd-site1.conf
listen=YES
write_enable=YES
[code]....
I am unable to create above vsftpd site with port '21'. Below is the problem,
# vsftpd vsftpd-site1.conf &
[1] 14448
500 OOPS: could not bind listening IPv4 socket
I wonder, i can able to create above FTP site with another port (example, listen_port=60001 ). In Linux(vsftpd), can i use default ftp port '21' for multiple FTP sites?
View 2 Replies
View Related
Jun 7, 2011
I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:
Code:
the-matrix:~ # mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or
Code:
the-matrix:~ # rcmysql start
Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds
chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory
[Code]...
View 6 Replies
View Related
Jan 12, 2010
I need to find a solution where I can monitor multiple sites at once and know when they go down. There are fraudulent sites (not mine I am in the infosec industry)
I have been playing with Nagios and Zabbix all day with not much luck. I have managed to get both installed and running and researched for hours. I just need to figure out how to add domain names to be monitored and I am stuck. I know you have to do it in the conf files but I cannot get a domain to show up?
View 3 Replies
View Related
Jun 2, 2010
i am using liferay5.2(mysql included in the download pack) on fedora. while liferay is working fine but i cannot connect to mysql.i am getting the error
[
[root@localhost ~]# ln -s /var/lib/mysql/mysql.sock /tmp
[root@localhost ~]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
[code]....
i didnt find the mysql.sock file in the location /var/lib/mysql/mysql.sock. i cannot find the portal-ext.properties file also to make intial settings.
View 9 Replies
View Related
Jun 1, 2010
I have this intra net server project going on and now I moved to 10.04 however there are still some things that I would like to see clarification and instructions on. I am interested to set up multiple parallel websites for my apache server, however I am not sure how to do this exactly. Now I have solid address rivera.wippies.net and port 80 redirecting to my server. What I would like to get done is that I get multiple independent of each other websites for my server I was thinking of making websites like this
/var/www/site1 (which would be as rivera.wippies.net)
/var/www/site2 (which would be as rivera.wippies.net/othersite)
/var/www/site3 (which would be rivera.wippies.net/secondothersite)
etc, so that I have multiple "individual" websties for my server. Requirements would be that each of these websites could have SSL encryption as needed available too, since some of the website could have confidential information.
View 9 Replies
View Related
Nov 18, 2010
I am having no luck configuring ProFTPd on a Debian Lenny production server we use to host our MySQL databases and a few websites. I had originally set it up so I could login and manage our internal sites, but I have the need to allow a few clients in to access their sites that we host. I am trying to root the users in their site directory, which would be "/sites/www.whatever.com/".
It just hit me while typing this. Is it possible to create a user without a shell to prevent login via SSH and set the home folder to /sites/whatever instead of /home/username? That would allow me to continue operating with my current configuration and root them in their site while preventing SSH logins.
View 6 Replies
View Related
Apr 12, 2010
I want to block all websites except desired websites.
View 3 Replies
View Related
Feb 21, 2010
I'll preface this by saying i'm by no means an expert on Linux. A competant beginner at most.We have a dedicated server, the 'resolv.conf' was changed, specifically the domain that was listed (this is the primary domain).I only became aware of this change, when we get into work on Friday and all our sites were down - I attributed this to DNS fault as if I changed my host file (I work on a windows machine) and specifically routed to the domains to the correct IP address, the websites were served fine.I tracked down the resolv.conf change by quizzing a collegue. I then switched the resolv.conf file back to it's original state - luckily a backup was made so I am 100% sure that the current resolv.conf is the correct one.
change was made Friday morning, around 9.30am (UK time). It is now 5.05pm (UK time). The original change was made sometime on Weds afternoon, and the sites stopped serving between Thursday night and Friday morning.Does anyone have any idea how long it should take for the fix to be picked up? Will it be picked up? I just started to think that the change can't be picked up due to some DNS related voodoo.
View 4 Replies
View Related
Jun 17, 2010
I have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.
View 1 Replies
View Related
Aug 25, 2010
I'm having problems connecting to the mysql database on my system. I first noticed this when I was trying to set up the program anymeal. I subsequently tried using MySQL Administrator (mysql-admin), but had no luck. It gives my the following feedback:
Code:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Click the 'Ping' button to see if there is a networking problem. I press the ping button, and it seems to connect.
Code:
View 4 Replies
View Related
Feb 22, 2011
I've been attempting to set up a LAMP for local web development, which meant installing mysql-server. But now have a problem when trying to run mysql, I get:-
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
When trying to downgrade mysql-server I saw that there are dependency problems between the various modules (but can't recall which). But whichever route I truied the results are always the same.
Thought about trying XAMPP but I note that even has it's problems, is there any way I can get a lamp set up on FC14, or must I give it up as a bad job.
Howver, just been trying to again to fix the problems with downgrading mysql and get:-
Error: Package: mysql-server-5.1.55-1.fc14.i686 (@updates)
Requires: mysql(x86-32) = 5.1.55-1.fc14
Removing: mysql-5.1.55-1.fc14.i686 (@updates)
mysql(x86-32) = 5.1.55-1.fc14
View 7 Replies
View Related
Aug 2, 2010
I'm trying to setup wordpress on my server, which of course I need mysql for. I setup a database the other day, which worked perfectly, but I had to start again as I put some information in wrong. Now, I can create a database fine, but when I run
Code:
GRANT ALL ON wordpress.* TO wordpress@localhost IDENTIFIED BY "password";
I get the output:
[code]...
View 13 Replies
View Related
Jun 4, 2009
I have MySQL 5.1.34 and PHP 5.1.6 installed on my system, how do I install php-mysql? Each time I try, it says
mysql-5.0.45-7.el5.i386 from base has depsolving problems
-- > mysql conflicts with mysql-server-community
error: mysql conflicts with mysql-server-community
View 16 Replies
View Related
Jun 18, 2010
I was having issues with MySQL Server and uninstalled it. I still have my databases at /lib/var/mysql.
My question: if I install MySQL Server (same version, 5.1) again, will it delete my databases, or will they still work?
View 1 Replies
View Related
May 23, 2011
How can I really, really remove everything related to mysql / mysql-server. I read and tried all kinds of things, but on every reinstall there is still old mysql stuff there, for example an existing password. Even resetting the password does not help.
Reason of removal: it looks like the mysql setup is really corrupt, so I want to remove, and then do a fresh install. Running Ubuntu 11.04 64-bit
sander@R540:~$ sudo apt-get purge mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
Package mysql-server is not installed,
[Code]....
View 4 Replies
View Related
Jan 30, 2011
I installed mediawiki the other day and went with the default innodb option. However a week later something went wrong. And since I have scripts that nightly backup /var/ I just copied the backup of /var/lib/mysql/wikidb/ (as I've done with MyISAM). Then when I connect the wikidb database. I can see the tables (via "show tables"), but when I do any query with them (check table X, select * from X) I get:
Code:
Table 'wikidb.X' doesn't exist I've since read that can can't just copy the database directory like MyISAM, and there appears to be no way that I can find to restore or fix Innodb, without a dump of the data. And I never got a chance to do a mysqldump of the data. So has anybody got any idea how I can at least view the "page" table from the files I've backed up in /var/lib/mysql/wikidb/ ?
View 1 Replies
View Related
Mar 3, 2009
I just configured a complete Cent OS 5.2 system for use as a web server. I can configure Apache and PHP but MySQl seems to be causing some issues -
[mysqld]
datadir=/var/lib/mysql
socket = /var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
[Code]...
View 16 Replies
View Related
Jul 14, 2010
I am using CentOS5 and installed the MySQL for server during the installation. I can set up and use MySQL databases. But I cannot make it startup everytime the server restarts. And quite a lot of methods need this folder "support-files/mysql.server", while my set up cannot find this. I am wondering if my installation of the MySQL for server is complete or not.
View 4 Replies
View Related
Jun 18, 2011
I have a page which is going to be internationalized, and available in more languages. It contains PHP scripts to load, let's say, current user's data from database and the internationalized content itself, like "Welcome user" message. The problem for me is the fact, that internationalized content is not continual, and it's all over the page mixed with php scripts.
I don't want to use eval(). I've got 2 , they are, however, not good enough. 1. One file per language version, with scripts included - there will be many languages, so there would have to be many files with redundant data. Also if I wanted to change structure of script, I would have to change it in all pages. 2. Load international data from db, while scripts are on the page - not sure about good database structure I mean, how would I get the right content from database? (content would be split into rows, columns, or something?)
View 8 Replies
View Related
Dec 1, 2008
I am writing a script to mine data from my game server logs which are going to mysql. My first question is syslog-ng is sticking $msg into one colum it self, $msg tends to be a long string here are a few examples:
cn name team frag death flags role host.
0 Maik CLA 2 0 0 normal *.70.233.118.
1 lizardncd RVSF -1 3 0 normal
[*.22.247.40] lizardncd fragged Maik.
And they are not always in the same format, How could I parse this data to do something useful, like creating a user stats page with frag counts and flag counts. Should I create a script that runs in a cronjob that parses this data to a new table maybe once a day. Even then the $msg string value is random and I am thinking in terms of awk.
Second. I would like to keep track of what ip's are using what nicknames. Kinda in the sense of and ip associated to a array of names that have been used on that ip address so I can keep track of users. How would this work logically with a mysql db, could a column allow multiple values, then loadable into an array, which then can add, remove, and store to mysql.
View 1 Replies
View Related
Mar 5, 2011
I am using ubuntu and mysql.I have a list of many .sql files, like 1.sql, 2.sql, 3.sql ... 100000.sqlI need to insert them into the database mysql mydb < *.sqlGives me: -bash: *.sql: ambiguous redirect
View 2 Replies
View Related
Jun 7, 2009
I have installed Bind DNS server in Opensuse 11.1 and it was running fine for two weeks. However starting last week it was unable to resolve a lot of internet sites (e.g. opensuse.org). I can say it is working partiallyI tried restart the named service and it worked fine for only about 15 minutes and back to partial condition.All the records in zone files can be resolved. Only some internet websites not able to resolve. The same sites can be resolve with another dns server internally
View 2 Replies
View Related
