Question

hMailServer,DB's and Joomla! mail function question

Asked by: abrodski

On my previous installation of Joomla! (I installed it with Xampp-Apache-My SQL-Php)...I had mail problems in Joomla...My mail server (on the same IP and PC) was hMailServer,but I installed it with MS SQL (CE) and NOT My SQL db.
Mail server by itself worked fine,but mail functioning inside Joomla! system was messed up or maybe not configured right...
So my 1st question...is it connected and should I go with My SQL next time when I re-install hMailServer?
Also,,,at the same time...could you point me to an article or a video about configuring mail service in Joomla!?  I'm talking about,for instance,when you press on an envelope icon near the article and then there's a mail-forwarding small window appears...Also when I added users in Joomla! in User Manager,I also got error messages related to not configured or not functioning of mail.

This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.

Subscribe now for full access to Experts Exchange and get

Instant Access to this Solution

  • Plus...
  • 30 Day FREE access, no risk, no obligation
  • Collaborate with the world's top tech experts
  • Unlimited access to our exclusive solution database
  • Never be left without tech help again

Subscribe Now

Asked On
2009-07-22 at 09:14:21ID24591584
Topic

Joomla

Participating Experts
1
Points
500
Comments
27

Trusted by hundreds of thousands everyday for fast, accurate and reliable tech support.

  • "The time we save is the biggest benefit of Experts Exchange to Warner Bros. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange." Mike Kapnisakis, Warner Bros.
  • "Our team likes having a resource that is more secure than just using Google and most experts using this service really know their stuff. It's nice to look here first versus using Google." Dayna Sellner, Lockheed Martin
  • "Anytime that I've been stumped with a problem, 9 out of 10 times Experts Exchange has either the accepted solution or an open discussion of the potential solution to the problem." Kenny Red, eBay Inc.

See what Experts Exchange can do for you.

Got a question?

We've got the answer.

Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.

Screenshot of Experts Exchange Knowledgebase

Need individual assistance?

Our experts are ready to help.

If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.

Screenshot of Experts Exchange Knowledgebase

Want to learn from the best?

Read articles from industry experts.

Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.

Screenshot of an Article

Working on a long term project?

Store your work and research.

Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.

Screenshot of Experts Exchange Knowledgebase

Access the answers to your technology questions today.

Subscribe Now

30-day free trial. Register in 60 seconds.

What Makes Experts Exchange Unique?

Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Trusted by the world's most respected brands.

image of each brand's logo

Faithfully serving IT professionals since 1996.

Experts Exchange Logo

Try it out and discover for yourself.

Subscribe Now

30-day free trial. Register in 60 seconds.

Related Solutions

  1. Joomla
    I want to know how to install joomla please let us know from where to get joomla.
  2. Joomla Portability
    Experts, If I develop a dynamic site using Joomla (e.g. joomA.com), how do I port that site to a different domain (e.g. joomB.com) ? Givens for joomA.com: 1) runs on Linux, MySQL, PHP 2) uses one or more DB's How do you backup a Joomla site ? How do you restore a backed u...
  3. Joomla
    I have an error with this Joomla Mynxx theme: Fatal error: Class 'ps_DB' not found in /home/icanget/public_html/modules/mod_rokvirtuemart_scroller/helper.php on line 38 not sure how to fix this problem
  4. Joomla and Apache
    Hello! I successfully installed Joomla 1.5,Php and Apache on XP Pro.I used XAMPP. I used IIS 5.1 Now I disabled the IIS service,obviously.Personally I would prefer IIS,it's easier to use and configure,but from what I heard Joomla works much better with Apache. So should I lea...
  5. Joomla on Apache MWSQL issue
    Ok, heres what i have, I installed a LAMP server on ubuntu 8.10 server. I installed php and Joomla and got the joomla site up and another php shopping site all working fine on this server. my company paid for a web design person to design a joomla site. I got the site today...

Free Tech Articles

  1. WARNING: 5 Reasons why you should NEVER fix a computer for free.
    It is in our nature to love the puzzle. We are obsessed. The lot of us. We love puzzles. We love the challenge. We thrive on finding the answer. We hate disarray. It bothers us deep in our soul. W...
  2. SCCM OSD Basic troubleshooting
    SCCM 2007 OSD is a fantastic way to deploy operating systems, however, like most things SCCM issues can sometimes be difficult to resolve due to the sheer volume of logs to sift through and the dispe...
  3. Migrate Small Business Server 2003 to Exchange 2010 and Windows 2008 R2
    This guide is intended to provide step by step instructions on how to migrate from Small Business Server 2003 to Windows 2008 R2 with Exchange 2010. For this migration to work you will need the fo...
  4. Create a Win7 Gadget
    This article shows you how to create a simple "Gadget" -- a sort of mini-application supported by Windows 7 and Vista. Gadgets can be dropped anywhere on the desktop to provide instant information, ...
  5. Outlook continually prompting for username and password
    There have been a lot of questions recently regarding Outlook prompting for a username and password whilst using Exchange 2007. There are a few reasons why this would happen and I will try to cover t...
  6. Backup Exchange 2010 Information Store using Windows Backup
    There seems to be quite a lot of confusion around the ability to backup Exchange 2010 using the built in Windows Backup feature. This stems from the omission of this feature prior to Exchange 2007 s...

Cloud Class Webinars

  1. Avoiding Bugs in Microsoft Access
    Alison Balter takes and in-depth look at avoiding bugs in Access. In this webinar you will learn about using the immediate window to debug your applications, invoking the debugger, using breakpoints to troubleshoot, stepping through code, setting the next statement to execute, ...
  2. Top 10 Best New Features in Visio 2010
    Scott Helmers gives live demonstrations of the top 10 new features in Visio 2010. This webinar will teach you how to create compelling diagrams by adding shapes to the page with a single click, linking the shapes in a diagram to data in Excel (or SQL Server, or SharePoint), ...
  3. IT Consultant Business Secrets Revealed
    Michael Munger, Experts Exchange tech pro and IT consultant, pulls back the curtain on his very successful businesses and answers question on every IT consultant and business owner should know about. He shares secrets on what he did to solve the 5 most common problems in IT, ...
  4. Disaster Recovery and Business Continuity
    Quest CTO, Mike Billon, gives an overview of the steps involved in building a dunamic disaster recovery plan. Through case studies and an examination of software/hardware tooles for monitoring and testing, you'll gain a better understandin of where you are, where you want ...
  5. Organize Your Visio Diagrams with Containers and Lists
    Scott Helmers uses cross functional flowcharts, wireframe diagrams, data graphic legends and seating charts to teach you: how to ustilize all three new structured diagram components in Visio 2010, the best practices for organizeing shapes in previous version of Visio, how to organize ...
  6. How to Us Objects, Properties, Events and Methods in Microsoft Access
    Alison Dalter gives an in-depbth look at objects, properties, events and methods in Microsoft Access. In this webinar you will learn about using the object browser, referring to objects, working with properties and methods, working with object variables, understanding the ...

Join the Community

Give a Little. Get a Lot.

Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.

Join the Community

Answers

 

by: ou_doberPosted on 2009-07-22 at 09:36:19ID: 24916990

abrodski,

As to your first question, I would suggest using MySQL for the re-install of hMailServer rather than MSSQL.  This reduces the database applications running on your XP workstation.

I could not find a video, but I did find a great article on configuring Joomla mail on a XP workstation.

http://forum.joomla.org/viewtopic.php?f=34&t=169462

Note:  When putting in the SMTPServer, either put in localhost or 127.0.0.1 to refer to itself.

The errors that you are geeting is because the mail service is not configured correctly for the article with envelope (email option) and the user manager.

Also, are you using hMailServer for users or as a smtp service to send mail?  There are better option if you are not managing user mailboxes and only want to send email from the workstation.  

XP has the capability to install "Default SMTP Virtual  Server". You can find it if you
go into "Computer Management" under Services and Applications -> Internet
Information Services -> Default SMTP Virtual Server  You might have to right click on "Default SMTP Virtual Server" select  "Properties", then the "Access" tab.  Click on the "Relay..." button and  change the selection to "All except the list below"
.  This will prevent the XP from being a relay server.

 

by: ou_doberPosted on 2009-07-22 at 09:49:02ID: 24917103

Addtional info on hMailServer:

http://www.hmailserver.com/documentation/?page=basic_configuration

Specifying SMTP relayer
Some internet service providers (the people that offer you the internet connection) block outgoing traffic on port 25. Since outgoing traffic on port 25 is required for email to work properly, you either need to convince your ISP to open up port 25 for you (if it's not open), or you need to configure hMailServer to forward all email through your ISP's email server.
 To determine whether port 25 is blocked, try typing telnet mail.hmailserver.com 25 on your command line. If you can connect, port 25 is not blocked; if you can't, port 25 is blocked.
 If you configure your ISP's email server as SMTP relayer, hMailServer will deliver all outgoing email to your ISP's email server, which in turn will deliver it to the correct destination. Since it's almost always possible to send email through your ISP's email server, this is a workaround if port 25 is blocked. Start hMailAdmin
In the tree to the left, go to Settings -> Protocols -> SMTP
To the right, the SMTP settings are now shown. Click on the Delivery of e-mail tab.
In the SMTP Relayer field, enter the host name of your ISP's email server, along with your credentials on that server in case it demands authentication.
Save your changes

Please note that you should never specify localhost, 127.0.0.1, or your own hostname as the SMTP Relayer, since that would mean that hMailServer would try to forward messages to itself. That would result in an infinite loop. Also, you should leave this field empty if your ISP is not blocking port 25.


This sounds to me that it does not like to be relay server for itself.  You might look into this further.

ou_dober

 

by: ou_doberPosted on 2009-07-22 at 09:59:29ID: 24917208

FYI - hMailServer install its own MySQL package to run if you choose to use that option in the install process.  See these for details.

Instructions for MySQL

http://www.hmailserver.com/forum/viewtopic.php?f=6&t=15057&p=85385&hilit=install+to+existing+mysql#p85385

Installing XAMPP over existing hMail and MySQL?

http://www.hmailserver.com/forum/viewtopic.php?f=7&t=14735&p=83933&hilit=install+to+existing+mysql#p83933

 

by: ou_doberPosted on 2009-07-22 at 10:09:28ID: 24917299

Installing XAMPP, hMailServer, and DynamicDNS

http://www.hmailserver.com/forum/viewtopic.php?t=10067

 

by: abrodskiPosted on 2009-07-22 at 11:06:17ID: 24917839

I only use hMailServer for myself...but I like it,so I'd prefer to keep it if possible...
My ISP doesn't block anything,so I don't quite understand why should I bother with relaying when I have a perfectly fine mail server?

 

by: abrodskiPosted on 2009-07-22 at 11:10:08ID: 24917879

http://forum.joomla.org/viewtopic.php?f=34&t=169462

this article you gave me is also about relaying and ISP...and I want to AVOID ISP whenever possible :-)

 

by: ou_doberPosted on 2009-07-22 at 11:11:01ID: 24917889

No, relaying is required to be open to receive smtp/emails from applications such as Joomla.  If it is not open, it will error out.

 

by: abrodskiPosted on 2009-07-22 at 11:11:04ID: 24917892

though....if the worst comes to worst...relaying is better than nothing,I guess...but I'll keep it as a last option

 

by: ou_doberPosted on 2009-07-22 at 11:12:07ID: 24917903

As in the email:

Note:  When putting in the SMTPServer, either put in localhost or 127.0.0.1 to refer to itself.

That was noted added by me to have it point at itself rather than an ISP.

 

by: ou_doberPosted on 2009-07-22 at 11:18:10ID: 24917959

A relay for a mail server is basically a listening port for smtp traffic.  When the relay is open, smtp services can be from local or remote servers as they can than transmit smtp traffic to the mail server to be properly forwarded to its final destination.  If the relay is off, servers can not utilize smtp because the server will not allow traffic to come in and be forwarded.

See this for more info.

http://en.wikipedia.org/wiki/Simple_Mail_Transfer_Protocol

http://en.wikipedia.org/wiki/Open_mail_relay

 

by: abrodskiPosted on 2009-07-22 at 11:21:39ID: 24918000

So Joomla requires relaying for its mail functions,but why would I need my ISP if I have my own mail server?

 

by: abrodskiPosted on 2009-07-22 at 11:31:00ID: 24918112

that guy with video tutorials talk about DYNAMIC DNS....I don't need that...I have everything static and it used to work fine,except misconfigured mail in Joomla!

 

by: abrodskiPosted on 2009-07-22 at 11:32:55ID: 24918137

we're going nowhere like that...I guess I'll try and see what happens...

 

by: abrodskiPosted on 2009-07-22 at 11:42:57ID: 24918238

I will install Xampp with My SQL in it and on top I will install hMailServer and I'll choose to use My SQL db and not MS SQL (CE) and see if mail server works...if it does-I would install Joomla!
As per relaying...the question still stands...WHY I cannot use MY OWN web server and need my ISP's?

 

by: ou_doberPosted on 2009-07-22 at 11:58:00ID: 24918395

abrodski,

 It looks like I am confusing you more than helping you so lets try to break this down.  You want to run Joomla on XP. You want to use the email feature of Joomla.  You have decided that you want to use hMailServer for your SMTP service. I am assuming you are using Joomla 1.5 and not 1.0. Here is the order of what you need to do:

  • Install XP OS 
  • Update XP OS 
  • Install XAMPP 
  • Note MySQL admin id and pw for future use 
  • Install hMailServer > Select custom > do external Database Server > put in local ip or local hostname to point to XAMPP install for database creation. 
  • Enter MySQL database admin id and pw.  (You may have to create a database manually before proceeding with this step in phpmyadmin.) 
  • Complete hMailServer install. 
  • Open hMailServer and go to configuration 
  • Setup SMTP Relayer to receive SMTP traffic from other applications. http://www.hmailserver.com/documentation/?page=basic_configuration 
  • Create a email account (i.e. webadmin@abrodski.com) 
  • Note id and password for future use.
     
  • Close hMailServer 
  • Read Installation Guide for Joomla. http://help.joomla.org/content/category/15/99/132/
     
  • Create empty web site in Apache for Joomla installation 
  • Browse to empty web site to test connectivity.
     
  • Create empty database for Joomla installation in MySQL 
  • Unzip Joomla package install to a holding folder 
  • Copy all of unzipped joomla package to empty web site root folder. 
  • Browse to empty web site to start Joomla installation wizard 
  • Complete steps in Joomla browser setup. http://help.joomla.org/content/view/39/132/ 
  • Rename or delete installation sub-folder under website root folder.  I always rename to ok-installation in case I need to read the logs. 
  • Go the web site home page to test. 
  • Go the admin home page and log in.  
     
  • If default password is being used, click on the admin user id in the right column, change password, click on apply for the change to take affect. 
  • Go to Site menu / Global Configuration) and then click the Mail tab to configure you mail to point at hMailServer. http://forum.joomla.org/viewtopic.php?f=34&t=169462 
  • When you get the Mailer field - change this to SMTP Server.
     
  • If you want to use SMTP authentication, check the box and put in the email account information you created earlier. If you are not using SMTP authentication, just leave blank
     
  • Under SMTP host, put localhost or local IP for the XP machine. 
  • Click the apply button to save and close. 
  • Test email.
     

 

by: abrodskiPosted on 2009-07-22 at 12:21:51ID: 24918638

yes...my Joomla! is 1.5

 

by: abrodskiPosted on 2009-07-22 at 12:23:55ID: 24918656

wait a minute...I think My SQL uses root and not admin...also I create a separate db for Joomla and call it joomladb and I create a joomlauser.Also I set a password for root (since its w/out one by default)

 

by: abrodskiPosted on 2009-07-22 at 12:24:23ID: 24918661

well,probably by admin-you meant-root...

 

by: abrodskiPosted on 2009-07-22 at 12:25:40ID: 24918673

"put in local ip or local hostname"... you're talking about localhost or 127.0.0.1 ?

 

by: abrodskiPosted on 2009-07-22 at 12:27:44ID: 24918686

so BEFORE I bother with installing hMailServer I have to create a db in Php MyAdmin and call it,say, "mail" ?
same way I create a joomladb database,right?

 

by: abrodskiPosted on 2009-07-22 at 12:29:56ID: 24918706

OK...one step at the time....I already have updated XP Pro SP3 (Eng.) up and running fine,so what I'm gonna do is install Xampp (incl. Php-Apache-My SQL-FileZilla)...Well,I turn off the FTP,since I don't have a hosting as of yet...

 

by: ou_doberPosted on 2009-07-22 at 12:37:03ID: 24918775

abrodski:             "put in local ip or local hostname"... you're talking about localhost or 127.0.0.1 ?

Yes

 

by: ou_doberPosted on 2009-07-22 at 12:37:26ID: 24918779

abrodski:             well,probably by admin-you meant-root...

yes

 

by: abrodskiPosted on 2009-07-22 at 12:38:48ID: 24918788

Ok...installed Xampp...strangely enough I got an error -something about port 80 being used or open,so Apache won't work,but actually XAMPP Control Panel shows Apache as working...also I stopped FileZilla...
Is there a way to make sure Apache is installed OK?

 

by: ou_doberPosted on 2009-07-22 at 12:40:01ID: 24918801

We are jumping pretty deep here.  If acceptable, please apply points for the the question and the other and than break up the questions you just posted separately to isolate and manage better.  I think we are kinda getting out of scope with the original question.  These threads are to also help others in the future rather than have an inevitable thread with tons of Q&A.

:)


ou_dober

 

by: ou_doberPosted on 2009-07-22 at 12:41:40ID: 24918816

http://httpd.apache.org/docs/1.3/windows.html#test

Testing Apache for     Windows      
If you have trouble starting Apache please use the following     steps to isolate the problem. This applies if you started     Apache using the "Start Apache as a console app" shortcut from     the Start menu and the Apache console window closes immediately     (or unexpectedly) or if you have trouble starting Apache as a     service.      
Run the "Command Prompt" from the Start Menu - Programs     list. Change to the folder to which you installed Apache, type     the command apache, and read the error message. Then review the     error.log file for configuration mistakes. If you accepted the     defaults when you installed Apache, the commands would be:   c:
 cd "\program files\apache group\apache"
 apache
 Wait for Apache to exit, or press Ctrl+C
 more <logs\error.log
     
After looking at the error.log you will probably have a good     chance of working out what went wrong and be able to fix the     problem and try again. If you are unable to work it out then     please follow the guidelines for assistance     at the top of this document or in the FAQ. Many users discover that     the nature of the httpd.conf file is easier to manage and audit     than page after page of configuration dialog boxes.      
After starting Apache running (either in a console window or     as a service) it will be listening to port 80 (unless you     changed the Port, Listen or     BindAddress directives in the configuration     files). To connect to the server and access the default page,     launch a browser and enter this URL:   http://localhost/
     
This should respond with a welcome page, and a link to the     Apache manual. If nothing happens or you get an error, look in     the error.log file in the logs     directory. If your host isn't connected to the net, you may     have to use this URL:   http://127.0.0.1/
     
Once your basic installation is working, you should     configure it properly by editing the files in the     conf directory.      
Because Apache CANNOT share the same port with     another TCP/IP application, you may need to stop or uninstall     certain services first. These include (but are not limited to)     other web servers, and firewall products such as BlackIce. If     you can only start Apache with these services disabled,     reconfigure either Apache or the other product so that they do     not listen on the same TCP/IP ports. You may find the Windows     "netstat -an" command useful in finding out what ports are in     use.

 

by: abrodskiPosted on 2009-07-22 at 12:56:24ID: 24918971

Ok...I set up a password for root account of My SQL and also I created a password for XAMPP directory access...Then I went to PhpMyAdmin and there I created a joomlauser and joomla db.
So now what? should I create a mail database same way?

20120131-EE-VQP-002

3 Ways to Join

30-Day Free Trial

The Experts

98% positive feedback on 31,087 answers since March 2000. angeliii is a Microsoft Most Valuable Professional for his work with MS SQL Server & Develoment.

He has also proven his knowledge of Visual Basic Programming, PHP Scripting and Oracle Databases.

The Experts

97% positive feedback on 10,752 answers since July 2000. lrmoore has more than 18 years experience in the networking industry.

The six-time Mircosoft MVPs specialties include firewalls, virtual private networking, and network management.

Testimonials

"...and excellent source for support... Kind of like having your very own IT dept." Electriciansnet

Testimonials

"I was apprehensive at signing up at first. However... it has already made my life as an IT administrator much easier." JaCrews

Testimonials

"WOW! You guys have great, active, and knowledgeable people on here." moore50

Business Clients

Business Clients

In the Press

"If you’ve got a question... Experts Exchange can supply an answer.”

In the Press

"...an invaluable aid for both IT professionals and those who require tech support."

In the Press

"where IT professionals provide quick answers on just about any topic"

Business Account Plans

Loading Advertisement...