Configuring Server To Handle Both MySQL And MS Access Databases
Since I have never worked on the server end of things I had a quick question for all you web hosting gurus.
Is it possible to have PHP installed on ONE single server and still have the ability for the server to work with both MS Access AND MySQL at the same time?
I would think YES, but I am being told by our server branch at my current job that this is not the case. They claim there is no way for the server on one machine to be able to handle both types of databases. Are they right?
If they are wrong and it is possible to have one server run both type of databases, what steps would be necessary to set up the server to handle both types? Do we need to tweak the php.ini file or is there another method of allowing the server the ability to work with both MySQL and MS Access.
Sorry if this question seems stupid or odd, as I said, I have minimal experience on the server end but I am confident that a server can handle both.
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
MS Access Databases On Server
My question is regarding Microsoft Access Databases and ASP.NET. I know that you need SQL server installed so that your website can communicate with any sql databases in use. Do you need Microsoft Access installed on a server where you accessing a MS Access Database?
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
How To Check Which Mysql Databases Cause Server Load
How can i check (using SSH) which databases/users cause server load to mysql ? I've tried "mysqladmin proc stat" but it shows just the current. How can i get stats of the last 24 hours for example ? I've also seen slow connections stats. What is the command to check more detailed report of the slow connections; which databases caused it etc', in the last 24 hours for example as well.
View Replies!
View Related
Configuring Php/mysql On IIS Server
I have setup php and mysql on a windows IIS 6 server. php has installed fine and works but I have 2 problems 1. When i browse to http://localhost i get a 403 error but when browsing to http://localhost/index.php it works fine. It makes me think that the server does not know what extension to default to when doing a directory listing 2. I have phpmyadmin installed and the cfg file is set to do a 'config' authentication. That works but everytime i go to submit a form to create a new database or anything i get prompted with an HTTP user/pass. I'm not sure if this is a phpmyadmin issue or a php configuration issue
View Replies!
View Related
How To Restore Mysql Databases From /var/lib/mysql/user_database/ Files Only
I recently had a harddrive failure and luckliy I can still access certain directories on this failed drive. I can still access the /var/lib/mysql/ directory which holds all the users databases and have backed all these up separately using tar. Now what I need to know is how do you restore these database files to another server? I tried simply untar'ing one of these to the new servers /var/lib/mysql/ direcotry and it stuffed Mysql up - it went offline. I had to get a cpanel tech to bring Mysql back online. how can I get these database files to fully work on a new server?
View Replies!
View Related
Visualizing MySQL Databases
I've recently been asked to do a lot of data extraction from a state that has about 20 databases, each with between 10 and 100 tables. I often find myself diagramming things out on paper to try to visualize how everything works together. I wondered if there's a tool that would "draw" the tables, columns, and relationships? I hesitate to say this, but almost like how MS Access does it, but that runs on Linux and does MySQL. Is there such a thing? I know about phpMyAdmin and MySQL's Query Browser, but it's not what I'm looking for.
View Replies!
View Related
Is There A Way To Search Through MySQL Databases
I am running a dedicated server with Debian, and I installed a community sofware that has a lot of mySQL entries, many of which need to be changed to fit my needs However, it is very hard to know exactly where each value I need to change is stored. Is there a way to search all database tables for a specific value? For example, one thing that is stored in the database is the site's title displayed in the browser's title bar. The sofware does not give me the option to change it, so I have to find where it is located in the database and change it myself, but it would be extremely time comsuming to check all tables one by one for any occurences of the current title.
View Replies!
View Related
Are My MySQL Databases Hosed
My HD was failing. So ServerBeach quickly set me up with a fresh box with the dying drive installed as a secondary drive. (nice job guys) I'm able to mount the secondary drive and browse/copy the files... but when I get to the most important files of all, the database binaries, my /var/lib dir looks like this: Code: [root@rosemary v2]# ls -l /mnt/dying/var/lib/ total 68 ... .... -rw-r--r-- 1 root root 2171 Sep 14 03:02 logrotate.status drwxrwsr-x 6 root 41 4096 Oct 12 2005 mailman drwxr-xr-x 2 root root 4096 Oct 12 2005 misc ?--------- ? ? ? ? ? mysql drwxr-xr-x 4 root root 4096 Oct 12 2005 nfs drwxr-xr-x 2 ntp ntp 4096 Sep 14 10:31 ntp ... ... And if I try to cd into the dir, I get this: Code: [root@rosemary v2]# cd /mnt/dying/var/lib/mysql -bash: cd: /mnt/dying/var/lib/mysql: Input/output error I really *really* need this data! Am I just totally S.O.L. ?
View Replies!
View Related
Backup MySQL Databases On PC
I host with hostgator and I was wondering if there are any software programs or services, or even something in my cpanel that can automatically grab my MySQL databases and everything on my server and make a backup on my personal PC? I know I can manually do this, but I would like something that automatically does it once a week or something to insure my clients data is always backed up.
View Replies!
View Related
Backup And Restore Mysql Databases
I have a corrupted VPS, and have some mysql databases on it. I want to backup databases and restore them on the new server. Cpanel service is down on the vps and I cannot transfer accts. Is it possible to do so ? 1- Zip or Tar the username folder in /home dir. 2- zip or tar the database name in /var/lib/mysql folder Either by SSH or File manager trough HyperVM Then transfer files some where safe... When vps is rebuilt, restore the archives and databases to the folders I have backed up before rebuilt. There are also some accounts on a terminated vps that there is only an image of the vps available so, I only can tar files using a jailed shell account, move to the new vps and untar them. how to do it and avoid database problems.
View Replies!
View Related
MySQL Backup Multiple Databases
My site is databases driven and runs on around 15 mySQL databases. Im wanting to download a local copy of these databases daily, however, if i try and back them up via cPanel (on a WHM VPS) they give me blank files. Each databases is around 55mb and growing. I can back them up one by one via phpmyadmin, it just takes around 5 minutes per database. Meaning around 40 minutes per night.. Is there any solution for having a script downloading them automatically so i can download them via ftp? I've tried [url].htm but it gives me blank files.
View Replies!
View Related
Backup MySQL Databases By Cron
how to backup MySQL databases by cron and have the backups sent to you by email, or have them uploaded by FTP. It is based on a script I found at another website though I can confirm it is fully working. Change the commented variables in the following file and save it as backup.sh: Code: #!/bin/sh # This script will backup one or more mySQL databases # and then optionally email them and/or FTP them # This script will create a different backup file for each database by day of the week # i.e. 1-dbname1.sql.gz for database=dbname1 on Monday (day=1) # This is a trick so that you never have more than 7 days worth of backups on your FTP server. # as the weeks rotate, the files from the same day of the prev week are overwritten. #/bin/sh /home/user/directory/scriptname.sh > /dev/null ############################################################ #===> site-specific variables - customize for your site # List all of the MySQL databases that you want to backup in here, # each seperated by a space # If not run by root, only one db per script instance databases="mydbname" # Directory where you want the backup files to be placed backupdir=/home/mydomain/backups # MySQL dump command, use the full path name here mysqldumpcmd=/usr/bin/mysqldump # MySQL Username and password userpassword=" --user=myuser --password=mypasswd" # MySQL dump options dumpoptions=" --quick --add-drop-table --add-locks --extended-insert --lock-tables" # Unix Commands gzip=/bin/gzip uuencode=/usr/bin/uuencode mail=/bin/mail # Send Backup? Would you like the backup emailed to you? # Set to "y" if you do sendbackup="n" subject="mySQL Backup" mailto="me@mydomain.com" #===> site-specific variables for FTP ftpbackup="y" ftpserver="myftpserver.com" ftpuser="myftpuser" ftppasswd="myftppasswd" # If you are keeping the backups in a subdir to your FTP root ftpdir="forums" #===> END site-specific variables - customize for your site ############################################################ # Get the Day of the Week (0-6) # This allows to save one backup for each day of the week # Just alter the date command if you want to use a timestamp DOW=`date +%w` # Create our backup directory if not already there mkdir -p ${backupdir} if [ ! -d ${backupdir} ] then echo "Not a directory: ${backupdir}" exit 1 fi # Dump all of our databases echo "Dumping MySQL Databases" for database in $databases do $mysqldumpcmd $userpassword $dumpoptions $database > ${backupdir}/${DOW}-${database}.sql done # Compress all of our backup files echo "Compressing Dump Files" for database in $databases do rm -f ${backupdir}/${DOW}-${database}.sql.gz $gzip ${backupdir}/${DOW}-${database}.sql done # Send the backups via email if [ $sendbackup = "y" ] then for database in $databases do $uuencode ${backupdir}/${DOW}-${database}.sql.gz > ${backupdir}/${database}.sql.gz.uu $mail -s "$subject : $database" $mailto < ${backupdir}/${DOW}-${database}.sql.gz.uu done fi # FTP it to the off-site server echo "FTP file to $ftpserver FTP server" if [ $ftpbackup = "y" ] then for database in $databases do echo "==> ${backupdir}/${DOW}-${database}.sql.gz" ftp -n $ftpserver <<EOF user $ftpuser $ftppasswd bin prompt cd $ftpdir lcd ${backupdir} put ${DOW}-${database}.sql.gz quit EOF done fi # And we're done ls -l ${backupdir} echo "Dump Complete!" exit Upload backup.sh to your server, to any directory you want. A directory which is not web-accessible will stop your login information being seen by just anyone . You should chmod the file to 777: Code: chmod 777 backup.sh If you uploaded this file from a Windows machine you will need to convert the file to Unix format. You should run the following command by SSH in the appropriate directory: Code: dos2unix backup.sh If you don't have dos2unix installed, you can install it using yum if you have that: Code: yum install dos2unix If you don't have yum, get it here. You may want to test the script at this point to make sure it's doing what you want it to. Change to the appropriate directory and run this command: Code: ./backup.sh Once you're happy with it, enter it into the crontab to run daily (or whenever you want). Cron jobs vary a lot depending on the configuration of your system, so check Google for how to do it on your system. The command you will need to run by cron is: Code: /path/to/file/backup.sh
View Replies!
View Related
Configuring PHP To Work With MySql
I'm using Windows XP and installed Apache, PHP 5 and MySql 5. They were all working before, but recently I had to format my hard drive. Fortunately, I had an image of my computer created from before but MySql was not installed when that image was created. After deploying that image, everything seems to be working fine. The server is running and PHP scripts are executing as well. But I can't seem to have MySql to work. I've followed many tutorials online, but have no luck. I have edited the php.ini file to point to the correct directory that holds the extentions or dll's. I also enabled the following: extension=php_mbstring.dll extension=php_mysqli.dll extension=php_mysql.dll I already tested to see if MySql was correctly installed by using the command line client and it seems to be installed. I was able to log in and see the default databases created. But when I run the following php script <? phpinfo() ?> I don't see the MySql section anywhere and that's why I'm assuming that PHP is not currently working with MySql for me. However, interestingly, I do see the "mbstring" section, which I assume should show only if MySql is working with PHP. But nothing else related to MySql info shows up. I've attached part of the screen shot if it helps you.
View Replies!
View Related
MYSQL Gives Access Error After Server Move
I can't find any straight answers when searching Google. I've been stuck in a what has become a nightmare server move for about 2 weeks now. After finally getting a mysql.sock issue fixed I can get the MYSQL dbs over to the new server but it appears that their permissions need to be changed. Is there a way to handle this from the root level? I have roughly 120 dbs to process I am moving from a VPS to a dedicated server - both have root access.
View Replies!
View Related
How To Configure Mysql To Hold Your Databases On Another Partition On Hard Drive
I have a server that is running linux with cpanel and I am running out of space on a partition. I was getting this error: Drive Warning: /dev/sda3 (/var) is 83% full I looked in the folder and went to /var/lib/mysql and noticed that I have about 6 databases that are a little over 1 GB each. The sda3 partition only has a capacity for 9.9 GB and I was suggested to configure mysql to hold my databases on another partition that has more space..
View Replies!
View Related
Configuring MySQL/Apache To Run A Larger Website More Efficiently
I'm running a comic site on a dedicated linux box that has weekly releases. When a new release comes out I'll typically get 4000-5000 unique hits an hour. The problems started when I set up a MySQL download logging system, that would query and display the file names when the user loads the site, and update +1 when they download a comic. Yesterday after a release, the site became very slow to access, and after about 20 seconds you'd connect and be able to browse freely at nice speeds but if you went idle you'd have to wait about 20 seconds to connect again. The other domains on the server were running fine, and I could access my whm fine as well, the server load was 0.10 or lower. I'm assuming there's a max connection limit somewhere either on the mysql or apache side that's restricting the site from handling the load it's getting. I've poked around google and researched it a bit but couldn't really find much. I don't have an enormous amount of time to invest in this because it's just a hobby so I'd appreciate any help one of you could offer!
View Replies!
View Related
Can The Server Handle It
Dedicated machine with 750GB HD x2, 16GB Ram, Dual Opteron 2212 Dual Core Processors, we are on a 100mbps burstable. Im wondering how many vps i can load into this machine efficiently, any ideas on this?
View Replies!
View Related
Configuring A New Server
Actually my DSL provide me 1024 kbps of Internet Access. I am wanna connect computers to that network and rent the pc in my own country. Here the features of that I have: - 2 Desktop PC ready for connect. - 1 router with 4 lan Port. - 1 Dynamic ip - 1024 kbps of Internet connection. the desktop pc will be configuring with Centos 4.x and I wanna install on it a control panel like directadmin. Here the issues: - How I can configure 2 statics ip for each desktop pc? - The desktop pc will be connected every one in the same router? - How I can know how will be the rendiment with 1024 kbps?
View Replies!
View Related
How Many SQL Server Databases Your Site Uses
I would like to build a personal website powered by a content management system and I'm wondering: How many SQL Server databases a site requires? At the Godaddy.com site, the plans for Windows offer one, two or three SQL databases and at least 10 MySQL databases. The integration with MySQL is easy?
View Replies!
View Related
What Type Of Server To Handle
I have a client that asked me to educate myself about web hosting and make a recommendation to him about where he should be. He currently has a shared hosting server at Network Solutions and finds unexplained slow downs and disk corruption reports in his forums DB unacceptable. I'm glad I found this site-lots of good info but nothing like throwing up some stats and seeing what people recommend. The client told me he wanted to move to a dedicated server but I'm thinking a VPS might do the trick. Especially if upgraded with dedicated Core as well as RAM such as wiredtree is offering. Looking for a managed, Unix based server that in a typical month serves 100k unique visitors 230k page views 500Gb of downloads But needs to be easily upgradeable to handle his expected traffic levels in the next year of monthly visits in the order of: 250k unique visitors 600k page views 1.1Tb of throughput As far as features: *Currently they use about 15 gigs of disk space. Some of that is inefficient disk management but the bulk is them supporting previous software releases. *needs to be fully managed *US datacenter with all the features you guys would expect to have as far as backbone access, security, power backups, etc.. *Backups by provider. Let's say 5 gigs worth since the old software versions don't really need to be backed up.(I'll recommend his own backups as well) *Either plesk or cpanel *15 minute hardware SLA is what the client is asking for but i'd like to present some comparisons to 1 hour SLA companies to see how much he'd save. And finally, i tried to search for the answer to this but the keywords kept bringing up lots of hits without good info. The client sells software so the bandwidth needed is pretty consistent until they release a new version. Then it skyrockets to the point they may have 1500 people trying to download a 50Meg file simultaneously. What is the right way to handle that? Use a CDN or negotiate with the hosting provider to provide burstable bandwidth as needed. As a side note while looking at many offerings I was most surprised that bandwidth seems to sold in large chunks with overage costs hidden.
View Replies!
View Related
Configuring Second Dedicated Server
I provide webhosting services (mycompany.com) to clients and I need some help regarding setting up my second server. Till the domain name resolves, new clients are given the temporary url mycompany.com/~accountname where the A record of mycompany.com points to the main server i.p. of the first server I am in process of setting up my second dedicated server. mycompany.com/~accountname will not work on the second server as the I.P. of mycompany.com points to the first server. How do I setup my company's url on the second server so that clients can access their accounts by mycompany.com/~accountname? How do you setup accounts on both servers under mycompany.com.
View Replies!
View Related
How To Handle DNS With A Dedicated Server?
I use zoneedit to point my domain to the server, and a few times their servers don't respond for a few minutes that causes my site to be unaccessible. I was wondering if there was any better way of doing this? Please give me suggestions on what to do to have proper dns.
View Replies!
View Related
Too High Server Load, How To Handle
if upgrading to that new server that I'll mention will probably solve my problems. Whatever help you can provide would be greatly appreciated. Below are the details: In the GMT evenings and nights my current server gets so loaded that every page load takes 10 - 30 seconds. Even the pure html pages will be so slow to load. It seems that after a certain treshold it just suddenly becomes that much slower. Not much middleground there. I have high MaxClients and ServerLimit values now and the error log doesn't say that they are exceeded anymore but that didn't help enough. I have a high traffic website that is using latest version of apache (2.2.x) with the prefork MPM and apache is optimized, PHP 5.2.5 and APC 3.0.15. I get 160,000 - 210,000 pageloads per day. 32,000 - 45,000 visits per day. Most of its pages are PHP but shouldn't be too CPU or databes intensive. Mysql isn't used and I mostly used sharedmem (php's shm functions) for databases. 2 semaphores are quite heavily used but that can't explain how a few more users would make the server serve pages so much slower. Swap usage is practically 0 and CPU user % usage is like 1 - 2 % and CPU system % is also about the same even during peak times. However the Average Load or whatever that "top" reports is 6 - 9. My current server scecs: 1 GB Ram, Pentium D 3 ghz, CentOS 5 32bit fully updated. I load all pictures and even the stylesheet from a secondary server by using href="$secondaryserverIP..." in the html code, so the main server practically just serves the pages. My new server will have apache with the worker MPM and latest versions of every software. Also its specs are: 2 GB of RAM, Intel Dual Core Xeon 2.40GHz, CentOS 5.1 32bit fully updated. I have a sophisticated netstat based ddos script that is an improved version of DDoS Deflate and while some of these slowdowns seem to have been caused by attacks that it then was able to defend me from, most of them are not. I am even protected from users who constantly have 7+ connections to my site and if someone has a way too high number of connections, the script won't even check if it constantly has it and the script just bans that user outright. It probably is banning a bunch of innocent proxy users too but that is a small price to pay.
View Replies!
View Related
Configuring A Dedicated Download Server
I have a server with the following specs: Intel Core2Duo 6550 2x2 GB DDR2 RAM 2x500GB 15,000 RPM SCSI drives Fedora Core 7 It's on a FDC Servers 1gbit connection with a 100mbit guarantee, their largest plan. I've used this plan (though with another server) before to push 241mbit/sec so there should be plenty of bandwidth. The downloads will be anywhere from a few megabytes to CD sized downloads so there might be quite a bit of large files, mostly files will be around 20-50 megabytes though. Basically I'd like a sort of rapidshare setup with two types of members, premium and non-premium. Non-premium members should be limited to a certain speed across all connections but not necessarily limited to one connection only since Asia and Europe traffic have a hard time getting really good speeds without using several connections. But I'd still like to be able to limit them at 4 connections or so, premium members should just be limited at some other value, that part shouldn't be the problem. Currently I can limit the speed through the php script that checks if a user is premium but that limit only works per connection and not across all connections. I'm looking for a software configuration setup, httpd etc. Hardware upgrade suggestions are also welcome for the future. So far I'm thinking setting up two virtual hosts, one for premium and one for non-premium and then use mod_limitipconn.c. But maybe there's a better way without using apache?
View Replies!
View Related
Configuring A Record Type On 2 Server
we have 2 server on the first server we have setting 2 account myaccont.com and my1.myaccount.com are 2 difference account Now, on the second server, we must config account my2.myaccount.com -- On the second server we have config my2.myaccount.com as account On the first server we have modify dns of domain myaccount.com with my2.myaccount.com 14400 IN A xx.xx.xxx.xx where xx is ip of second server -- Seems work but there is any problem For example ping to www.my2.myaccount.com give error, ping to my2.myaccount.com is ok.. Why?
View Replies!
View Related
How Many CS-Source Players This Server Could Handle
how many players you would estimate the following server could handle running Counter-Strike Source dedicated Server? Dell PowerEdge 1550 1U Rackmount Server 1Ghz P3 Processor - 1GB RAM 2X36Gb U160 SCSI Hard Drives in RAID1 for redundancy Windows 2000 server Network connectivity is 100mbit in a London DC. Of course its not possible to give a 100% accurate figure however i would like a rough estimate prior to me purchasing this machine.
View Replies!
View Related
How To Find Out If A Server Can't Handle All The Incomming Traffic
what the max number of hits is a quard core server with RAID disk system can handle, it is running on a Linux with separated MySQL server? The host says there are no restrictions on the bandwith, but somehow it is strange we always only have MAX 300 users online (24/7/365) now I wonder if it just is that way or if some users might be denied access from time to time when they try to enter some of the websites hosted on the server ? Maybe you know a monitoring service or something that can tell if this is an issue.
View Replies!
View Related
Server To Handle 100s Of New Domain Names
We are setting up 100s of new domain names every day. We are only hosting a simple blog, in fact with our current setup we are on a HostGator Reseller account and we are just using one account meaning one single cPanel account. We have a script that automatically runs when people sign up for our service, this script sets up an addon domain on that same single cPanel account with the same document root. Our modified wordpress blog simply looks at the HTTP_HOST in the config file and opens a separate database tables for every new domain name. The problem we are running into is not the bandwidth usage, nor storage space. But simply the mass addon domains. The cPanel adddomain.html script seems to be getting ran so many times it is overloading the web server. So I have read about some other people here WHT that are starting to use a new server software that uses a lot less server resources then WHM and cPanel. So I am wondering what hosting companies can provide that sort of a server. Specifically: Storage: A couple hundred GB Bandwidth: 1000s of GB Server software to run PHP scripts and mySQL databases Ability to create 1000s of addon domains every day. Does this need to be an array of servers? We are ready to get moving on a deal now.
View Replies!
View Related
MySQL DB Access Allowed? Are There Any?
For window hosting are there any that offers sql db external access without ip limit? I've seriously requested thought the forums and actually signed up with few but all of em are either offered it but not anymore(security issue) or not even offering at all. If you have any experience with hosting company that actually does offer sql db external access please share please! vps nor dedicated servers are not my choice unfortunatley and i don't think there's any free hosting that offers this. 99% freehostings use localhost
View Replies!
View Related
Mysql Access Denied
I've setup a mysql user and assigned a password for it. When I try logging in to it with Quote: mysql -u USERNAME -p and then providing the password I get an error: Quote: ERROR 1045 (28000): Access denied for user 'USERNAME'@'localhost' (using password: YES) I don't have trouble logging in as root and when I check the user table there, the password assigned to the user is same as the value the mysql function PASSWORD gives me. Really driving me nuts here, why is it telling me the password is wrong when it's not? I've tried: Restarting mysql setting new password changing username Using mysql server 5.1.34
View Replies!
View Related
Mysql Account Access
I run a shared hosting OS:centos with whm/cpanel and would like to restrict access to mysql database example: username:user1 created database:user1_db1,user1_db2 etc.. and can only access his own databases so user2 can't access user1_db1.db2 etc.. and user1 can't access user2_db1,db2 etc..
View Replies!
View Related
Allow Remote Mysql Access
I have a Ubuntu Lamp server setup in my building which is used for development purposes. So I also have phpmyadmin setup and am using a Mysql Query browser and Mysql Administrator desktop programs to administor the database on the server. However I am not able to connect to the server from my desktop. I am able to login to my myphpadmin but not able to login via the Mysql Query Browser program. Hopwing someone can help. I have read about port forwarding and also read a post about editing the my.cnf file on the server and changing the Bind-Address= 127.0.0.1 to the actual hostname but before I start editing the actual configuration files on the server I want to see if their is another way as I am worried that if I change the me.conf file that the phpmyadmin may stop working?
View Replies!
View Related
Configuring Mail Features Of Windows Server 2003
Please pardon the "newbie" nature of this post. (Due to circumstances outside my control, I've had management of a Windows Server 2003 VPS thrust upon me, and I'm feeling like a fish out of water!) I have finally abandoned any hope of getting phpmailer to work with Joomla 1.0.13, so I've decided to configure the POP3/SMTP features of my server so that I can use Joomla's SMTP mail service. (Joomla's SMTP option is limited to port 25 and cannot use ssl.) Anyway, I've tried to set up my POP3 and SMTP services, but I must be doing something wrong. I have both services set up with my registered domain name -- and a check of the DNS in the SMTP setup comes back OK. However, if I try to use my domain name as my SMTP and POP servers in Outlook Express, the program times out while "looking for host." If I enter "localhost" or my IP address (numeric) as my mail servers, I get a dialog box asking me to log in. However, when I try to log in -- using my administrator name & password -- it doesn't work. I should probably stress that I'm using SERVER 2003, not an EXCHANGE server for this. I have need for one, whole mailbox to make my stupid contact form work, which is why I'm doing this in the first place. If this doesn't work, I'm going to create my own contact form in html, throw it into a joomla content page, and use the phpmailer script to send it manually. Not ideal, as it will always go to the same mailbox, but I'm getting to the point where I DON'T CARE ANYMORE!
View Replies!
View Related
Dedicated Server To Handle Website With 16000 UV/day
My current website now have 16k unique visitor/day. Last time I was host my website in HostGator shared plan, and it can't handle any more. Maybe for the first time, I won't looking for superb server, but will be try small specification. Slow but sure, I will upgrade it based on my website's growth. about price, specs that can handle my website, and the provider.
View Replies!
View Related
How To Secure Access To MySQL Database
What can I do to secure access to my MySQL database to stop it from getting compromised from hackers? Is there any way I can restrict access to the MySQL database to my IP only? The database is for an IPB 2.3.4 forum and the username/password are stored in a conf_global.php file that is CHMODed 0444.
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
Virtual Private Server (VPS) To Handle Community Forum
Past shared hosting deals we been trying out sucks. We are a community forum that just started but know we will grow a big database in the future. We want to prepare now and have no problems. It's a LOCAL Radio-Control (R/C) forum. What VPS Host would you guys recommend that handles forums well? So far, I broke down to WiredTree.com.
View Replies!
View Related
Configuring Your Server To Survive The Digg / Slashdot / Web2.0 Effect
I learned the hard way last year when my website (on GoDaddy shared hosting) made the front page of Digg. GoDaddy suspended my account in a hurry (and didn't bother to inform me, but that's another story). I'm planning to get a VPS account with SLHost to prepare for future traffic growth. How should I configure the server to best handle a huge spike in traffic? From what I can gather, there are a number of factors: - Max HTTP connections (MaxClients in Apache) - Max number of open file handles allowed (a kernel thing) - Virtuozzo allowed TCP connections This post at webhostingtalk.com/showthread.php?p=4552677#post4552677 by Josh at SLHost outlines the defaults for their VPS servers: Quote: Are you referring to HTTP connections or other? By default, the MaxClients setting is at 256 clients and would need a recompile if you want more. The number of open files allowed is set to 1024 by default and can be raised. There are also Virtuozzo allowed TCP connections, which is set at 1200 and we've noticed that anything more than that should either be on an Enterprise VPS package or low end dedicated server at least. Should I do any tweaking to the defaults if I want to survive another Digg onslaught?
View Replies!
View Related
|
TRACKER
