Setting Up Free Email Service And Storing Mails In MySQL
Feb 14, 2007
I have a busy dating website with 30 000 registered users and ~200-600 users online all the time. I would like to offer free email with ~10 MB mailbox to all users.
I have an idea to use scripts provided by b1gmail.de. Its similar to Hivemail or Socketmail. It uses only one POP3 catch-all mailbox and stores all emails in MySQL database, including attachments.
My worries are about MySQL. If I have 30 000 users and each user has some 5000 messages in his/her mailbox:
30 000 x 5 000 = 150 000000
That's 150 million rows in one table!
I know, not all users will have 50000 messages in their mailboxes, but the number of users increases about +2000/month.
I can't imaggine how long time will need MySQL to find messages for each user in the table with 150 000000 rows.
I don't know - maybe it's not a problem at all. I just never had such large tables and I don't know if it's possible at all.
Another problem: I have Fedora Core 2 installed and even don't know yet if it supports files larger than 2 GB.
Maybe it's better to set-up normal POP3 mailboxes for all users instead of using one catch-all box and storing data in MySQL?
do not post warnings about spammers. In the beginning I'll provide email addresses only to "gold" members. I opened this thread because I don't want to set-up a system which will hang after a couple of months because MySQL will not be able to handle it or I will have other unknown problems.
*My computer is a computer of a 500 computers network within our company.
* i have been given a STATIC local intranet ip 192.168.10.168 assigned by our IT department via their router.
* i have the internet facility provided through the above mentioned intranet for which i get a dynamic ip ex: 188.54.208.205, 176.44.107.21
* i have installed WAMP server.
my current project for the company i am doing should be able to access via internet in addition to the local access. local access is the primary access method. so now i have installed a free dns service like dyndns. at the setup of that, i have choosen a free subdomain ex: my.freedns.com they offer. then i assigned the ip ex:188.54.208.205. also installed their desktop client for monitoring ip changes auto updates.
Now the problem is : when i hit my.freedns.com the page displaying is of our internet service provider. not of my project homepage . How can i fix so when i issue above subdomain it will show my webserver default page?Â
Email on server working fine, I can send mails from webmaster@xxx.com to any email only forums like VB don't send emails to hotmail & yahoo ! but emails from forums arrive to emails like webmaster@xxx.com
I have a bare minimal server which I want to move WHMCS over to. However, how do I setup e-mails so I can setill PIPE them into the system? The e-mail server would be hosted on the main server still.
I am having a problem setting mails on Thunderbird.i did exactly as you said in the documentation but still receive an error for sending an email (incoming email is good).i used full email address as username.domainname.tld as Incoming/Outgoing server address.
port 25 and 143 but still seem that i can't send emails.via web-mail i can , but via Thunderbird on my local PC i can't.I have a dedicated windows server with plesk 11.0.9
We have a community website and would like to integrate a messenger service into it so users can IM each other, preferably having audo and video capability.
There are a couple of providers like userplane and toksta that offer them for free. but wanted to know if there are any others that you know of as I would like to compare features and select the most reliable.
One of my customers asked me if is possible technically to offer free email services.
Since he's going to launch a big portal he want to offer such things later, for all users.
Now, there are problems as: a) if there is any possibility to compress emails similar with GMAIL or YahooMail or so, because i can't imagine the email is uncompressed
b) how can be handled email boxes over multiple (mail ?) servers if the HDD space needed would be larger than for one server HDD ?
I use Pingdom "Pro" (or whatever the paid version is to be branded as), and I think it is fantastic. It is yet to let us down or misinform us. It'll be interesting to see whether we see quality dilution from the inevitable rush of freebie accounts.
I'm currently trying to setup a personal web hosting service for my friends where they get an area of web space, etc, for them to use. Basically, a free web hosting service, etc with PHP, and all possible.
Does anyone know how I could go about setting this service up? ( If I were to get a HostGator/webspace account, etc)
I just want an expert opinion if what I am doing should be considered to be secure (or if there is a more secure way to do what I am doing). I made our hotel's online reservation system and it stores the guests' credit card information.
The card is encrypted using AES (MCRYPT_RIJNDAEL_128) and the key that is used to encrypt/decrypt must be entered from the client side in order to log in. It is not stored on the server. So that my employees do not have to enter it every time they want to log in, it is stored in a cookie on their computer or entered manually if the cookie is deleted. When logged in, I have the key stored in a _SESSION variable in a subdirectory of that account's home directory and have the following attributes (for example):
I have a client who specializes in providing training for high-end CAD/CAM applications. They have training modules (currently in .ppt format mostly) that they want to store securely on the server and give out access only to approved customers. Additionally, they want to ensure that these training modules never fall into the hands of their competitors- that is, no downloads.
Does anyone have experience with this kind of thing? Based on their requirements, a few possible solutions come to mind:
1.) Put the training modules in a subdomain that is password protected. Additionally, encrypt the traffic with SSL etc. However, this doesn't solve the problem of users being able to download the files and do what they want with them. Also, it isn't possible to view .ppt files online in a browser, as far as I know.
2.) Use a solution similar to what Lynda.com has. They have an entire online library of training videos that are available 24x7, but customers can only view it, not download it. I think they use some solutions from Adobe to make this possible.
I can't believe the hours of BS I had to go through with Godaddy hosting to get a subdomain to work. Their online "help" is horrible, incorrect, and incomplete.
For people who may have this problem, here's what I had to go through:
You can go into "Domain Management" and "Add a Subdomain" and have it point to a specific directory. Fine. That's all well and good, but that in itself does nothing and their help implies that's all you have to do and you're set, boom you have a subdomain. Not so fast.
You have to go into your "DNS Manager" and add a CNAME record with the same name as your subdomain and have it point to @. So apparently you have to change the DNS first so web browsers recognize the subdomain and get redirected to your host, then the domain management "subdomain rule" kicks in and it knows to go to a certain directory.
The funny part is the customer cervice person knew none of this. He kept insisting I had to add an A record, obviously just reading from a script. And even if I did have to mess with my DNS settings to enable my subdomain why wasn't this in the "help" on your website? Unbelieveable.
I have a domain name from godaddy and recently got a host plan in hostgator.
As this is the first time I use hosting, it is very confusing how to set it up properly. So far what I figured out and was able to set is the DNS in godaddy and the add-on domain in hostgator.
So now I was able to point 'MyDomain' to direct to 'hostgatorDomain/MyFolder/' (names just for example).
The problem is that masking is not turned on and who ever clicks 'MyDomain' will get to the right location, but the address will change to 'hostgatorDomain/MyFolder/'.
Does anyone know if there is a company or a program that would allow me to setup free email for users using my domain name? Say if I wanted to be my own gmail or hotmail - maybe on a much smaller scale at first?
I want a Email Plugin for cPanel that can tell me how many email is sent (per user) and some other usefull info.
i have CMQ (Configserver Mail Qeue) but i have seen another free plugin on a server that i can not remember the name of the Plugin and i just remember that there was something like A-SAT in its name.
Most of our fraudulent transactions come via sign-ups with free email accounts such as yahoo, gmail and hotmail. Is anyone aware of a system which will prevent customers using these email addresses (or other free ones) for hosting plan sign-ups?
I have a contact form using .php to forward the contents of the form to my email-ad, but turns out, that something i cant do with my free hosting plan.
i was wondering if anyone knew any services (free) that allow mail forwarding where i can host my .php script together with all associated files and simply link to them from my site?
that would be great! thanks!
(not sure where exactly this post belongs, but it's got something to do with my hosting so im posting it here. if any mods think it should be somewhere else, just move it to where you feel it is appropriate )
I am trying to find the best economical solution regarding my email address but I need some advice pls.
I have a very small package with asmallorange and I have set up one of my business email in it. I didn't calculate that this business email could take so much space. I have some assistants which work in other places. One of my problems is these asistants who need to access this address too, are not allowed to access any free email provider like gmail, yahoo at their work computers because of their work policy. So I can't do forwarding and I need to have this email address under my domain.
I am thinking of these options:
1) Get more space . This will become expensive for me.
2) use a dedicated email service under my domain name. I have no experience here and I wonder if using a gmail service under my domain will be blocked for my collaborators.
3) change host ( I am afraid to lose my data and my website database).
