Failed to send message

[wetjet43]

I'm able to log into rc just fine and browse around. I go to compose a new email, and I find that my sender field is blank... maybe it should be, I don't know. anyways, if I send to myself internally, or another email address externally I always get that little pink transparent message telling me "failed to send message" I'm running my own win2000 pro sp4 with apache 2.2.4 , latest php5 and latest hmailserver

Here's my main.inc.php file and the error log


/*
 +-----------------------------------------------------------------------+
 | Main configuration file                        |
 |                                    |
 | This file is part of the RoundCube Webmail client           |
 | Copyright (C) 2005, RoundCube Dev. - Switzerland           |
 | Licensed under the GNU GPL                      |
 |                                    |
 +-----------------------------------------------------------------------+

*/

$rcmail_config = array();


// system error reporting: 1 = log; 2 = report (not implemented yet), 4 = show, 8 = trace
$rcmail_config['debug_level'] = 1;

// enable caching of messages and mailbox data in the local database.
// this is recommended if the IMAP server does not run on the same machine
$rcmail_config['enable_caching'] = FALSE;

// lifetime of message cache
// possible units: s, m, h, d, w
$rcmail_config['message_cache_lifetime'] = '10d';

// automatically create a new RoundCube user when log-in the first time.
// a new user will be created once the IMAP login succeeds.
// set to false if only registered users can use this service
$rcmail_config['auto_create_user'] = TRUE;

// the mail host chosen to perform the log-in
// leave blank to show a textbox at login, give a list of hosts
// to display a pulldown menu or set one host as string.
// To use SSL connection, enter ssl://hostname:993
$rcmail_config['default_host'] = 'localhost';

// TCP port used for IMAP connections
$rcmail_config['default_port'] = 143;

// Automatically add this domain to user names for login
// Only for IMAP servers that require full e-mail addresses for login
// Specify an array with 'host' => 'domain' values to support multiple hosts
$rcmail_config['username_domain'] = '';

// This domain will be used to form e-mail addresses of new users
// Specify an array with 'host' => 'domain' values to support multiple hosts
$rcmail_config['mail_domain'] = '';

// Path to a virtuser table file to resolve user names and e-mail addresses
$rcmail_config['virtuser_file'] = '';

// Query to resolve user names and e-mail addresses from the database
// %u will be replaced with the current username for login.
// The query should select the user's e-mail address as first col
$rcmail_config['virtuser_query'] = '';

// use this host for sending mails.
// to use SSL connection, set ssl://smtp.host.com
// if left blank, the PHP mail() function is used
$rcmail_config['smtp_server'] = 'localhost';

// SMTP port (default is 25; 465 for SSL)
$rcmail_config['smtp_port'] = 25;

// SMTP username (if required) if you use %u as the username RoundCube
// will use the current username for login
$rcmail_config['smtp_user'] = '%u';

// SMTP password (if required) if you use %p as the password RoundCube
// will use the current user's password for login
$rcmail_config['smtp_pass'] = '%p';

// SMTP AUTH type (DIGEST-MD5, CRAM-MD5, LOGIN, PLAIN or empty to use
// best server supported one)
$rcmail_config['smtp_auth_type'] = '';

// Log sent messages
$rcmail_config['smtp_log'] = TRUE;

// these cols are shown in the message list
// available cols are: subject, from, to, cc, replyto, date, size, encoding
$rcmail_config['list_cols'] = array('subject', 'from', 'date', 'size');

// relative path to the skin folder
$rcmail_config['skin_path'] = 'skins/default/';

// use this folder to store temp files (must be writebale for apache user)
$rcmail_config['temp_dir'] = 'temp/';

// use this folder to store log files (must be writebale for apache user)
$rcmail_config['log_dir'] = 'logs/';

// session lifetime in minutes
$rcmail_config['session_lifetime'] = 10;

// check client IP in session athorization
$rcmail_config['ip_check'] = TRUE;

// this key is used to encrypt the users imap password which is stored
// in the session record (and the client cookie if remember password is enabled).
// please provide a string of exactly 24 chars.
$rcmail_config['des_key'] = 'rcmail-!24ByteDESkey*Str';

// the default locale setting
$rcmail_config['locale_string'] = 'en';

// use this format for short date display
$rcmail_config['date_short'] = 'D H:i';

// use this format for detailed date/time formatting
$rcmail_config['date_long'] = 'd.m.Y H:i';

// add this user-agent to message headers when sending
$rcmail_config['useragent'] = 'RoundCube Webmail/0.1b';

// use this name to compose page titles
$rcmail_config['product_name'] = 'RoundCube Webmail';

// only list folders within this path
$rcmail_config['imap_root'] = '';

// store draft message is this mailbox
// leave blank if draft messages should not be stored
$rcmail_config['drafts_mbox'] = 'Drafts';

// store spam messages in this mailbox
$rcmail_config['junk_mbox'] = 'Junk';

// store sent message is this mailbox
// leave blank if sent messages should not be stored
$rcmail_config['sent_mbox'] = 'Sent';

// move messages to this folder when deleting them
// leave blank if they should be deleted directly
$rcmail_config['trash_mbox'] = 'Trash';

// display these folders separately in the mailbox list.
// these folders will automatically be created if they do not exist
$rcmail_config['default_imap_folders'] = array('INBOX', 'Drafts', 'Sent', 'Junk', 'Trash');

// protect the default folders from renames, deletes, and subscription changes
$rcmail_config['protect_default_folders'] = TRUE;

// Set TRUE if deleted messages should not be displayed
// This will make the application run slower
$rcmail_config['skip_deleted'] = FALSE;

// Set true to Mark deleted messages as read as well as deleted
// False means that a message's read status is not affected by marking it as deleted
$rcmail_config['read_when_deleted'] = TRUE;

// When a Trash folder is not present and a message is deleted, flag
// the message for deletion rather than deleting it immediately. Setting this to
// false causes deleted messages to be permanantly removed if there is no Trash folder
$rcmail_config['flag_for_deletion'] = TRUE;

// Make use of the built-in spell checker. It is based on GoogieSpell
// which means that the message content will be sent to Google in order to check spelling
$rcmail_config['enable_spellcheck'] = TRUE;

// path to a text file which will be added to each sent message
// paths are relative to the RoundCube root folder
$rcmail_config['generic_message_footer'] = '';

// this string is used as a delimiter for message headers when sending
// leave empty for auto-detection
$rcmail_config['mail_header_delimiter'] = NULL;

// in order to enable public ldap search, create a config array
// like the Verisign example below. if you would like to test,
// simply uncomment the Verisign example.
/**
 * example config for Verisign directory
 *
 * $rcmail_config['ldap_public']['Verisign'] = array('hosts'     => array('directory.verisign.com'),
 *                          'port'     => 389,
 *                          'base_dn'    => '',
 *                          'search_fields' => array('Email' => 'mail', 'Name' => 'cn'),
 *                          'name_field'  => 'cn',
 *                          'mail_field'  => 'mail',
 *                          'scope'     => 'sub',
 *                          'fuzzy_search' => 0);
 */

// try to load host-specific configuration
$rcmail_config['include_host_config'] = FALSE;


/***** these settings can be overwritten by user's preferences *****/

// show up to X items in list view
$rcmail_config['pagesize'] = 40;

// use this timezone to display date/time
$rcmail_config['timezone'] = 1;

// daylight savings are On
$rcmail_config['dst_active'] = TRUE;

// prefer displaying HTML messages
$rcmail_config['prefer_html'] = TRUE;

// show pretty dates as standard
$rcmail_config['prettydate'] = TRUE;

// default sort col
$rcmail_config['message_sort_col'] = 'date';

// default sort order
$rcmail_config['message_sort_order'] = 'DESC';

// list of configuration option names that need to be available in Javascript.
$rcmail_config['javascript_config'] = array('read_when_deleted', 'flag_for_deletion');


// end of config file
?>



==================

error logs

[31-Jan-2007 22:18:30 -0800] SMTP Error: SMTP error: No From address has been provided
 in E:\Program Files\Apache Software Foundation\Apache2.2\htdocs\program\steps\mail\sendmail.inc on line 253

====================

didnt know I had to configure the sendmail.inc file....

[wetjet43]

I've tried rebuilding the mysql database. no go. I tried the multiple smpt auth methods in the rcmail_config['smtp_auth_type'] and still no go. Looks like I have to go back to squirrel mail for the time being. I really like round cube too! oh well.  

[daashag]

I had the same problem but I was on a linux box. My problem existed in the database as the identities table for the rc I was running contained vcard field which the database didn't. So I used the latest database and just imported my data into it.

[wetjet43]

What do you mean you used the latest database? How exactly did you fix this? I'm using mysql 5. I'm kinda stumped on what you mean by latest database. Aren't we suppose to create the database in mysql, or whatever version of sql, then import the sql tables into it that comes with rc?

[daashag]

I basically created a new database by using the mysql.initial.sql that comes with svn release. I then imported the data from the old database into the new one. Are you able to manually add a sender? My sender box wasn't getting auto-populated and I could not add a sender.

[wetjet43]

My sender box is not getting auto-populated either, even after the svn patch and wiping the old database and creating a new db with the new mysql.initial.sql file. Where exactly are the user id's stored? I cant find mine anywhere. How do you add one manually? Aren't they suppose to be added automatically?

[daashag]

A new user should be created when when you log into RC. Look at your database to see if a user is created when you login. I use phpmyadmin to administer my databases. You might want to check the rights on your database for the user that the used in the db.inc.php

[wetjet43]

here is my db.inc.php.... modified with no personal info. my database name is rc in mysql.
I use SQLyog to modify mysql databases. works pretty good for me.

--------------------------


/*
 +-----------------------------------------------------------------------+
 | Configuration file for database access                |
 |                                    |
 | This file is part of the RoundCube Webmail client           |
 | Copyright (C) 2005, RoundCube Dev. - Switzerland           |
 | Licensed under the GNU GPL                      |
 |                                    |
 +-----------------------------------------------------------------------+

*/

$rcmail_config = array();

// PEAR database DSN for read/write operations
// format is db_provider://user:password@host/databse
// currentyl suported db_providers: mysql, sqlite

$rcmail_config['db_dsnw'] = 'mysql://rc:*****@localhost/rc';
// postgres example: 'pgsql://roundcube:pass@localhost/roundcubemail';
// sqlite example: 'sqlite://./sqlite.db?mode=0646';

// PEAR database DSN for read only operations (if empty write database will be used)
// useful for database replication
$rcmail_config['db_dsnr'] = '';

// database backend to use (only db or mdb2 are supported)
$rcmail_config['db_backend'] = 'db';

// maximum length of a query in bytes
$rcmail_config['db_max_length'] = 512000; // 500K

// use persistent db-connections
$rcmail_config['db_persistent'] = TRUE;


// you can define specific table names used to store webmail data
$rcmail_config['db_table_users'] = 'users';

$rcmail_config['db_table_identities'] = 'identities';

$rcmail_config['db_table_contacts'] = 'contacts';

$rcmail_config['db_table_session'] = 'session';

$rcmail_config['db_table_cache'] = 'cache';

$rcmail_config['db_table_messages'] = 'messages';


// you can define specific sequence names used in PostgreSQL
$rcmail_config['db_sequence_users'] = 'user_ids';

$rcmail_config['db_sequence_identities'] = 'identity_ids';

$rcmail_config['db_sequence_contacts'] = 'contact_ids';

$rcmail_config['db_sequence_cache'] = 'cache_ids';

$rcmail_config['db_sequence_messages'] = 'message_ids';


// end db config file
?>

-----------------------------------


Other than specifying my mysql db, the password and the host name, what more is there to modify?

[wetjet43]

Thank you for all of your help by the way!  

[daashag]

Check your identities table in the rc database to see if a users are being created. For example if you login with the user "joe" there should be and entry "joe" in your identities table. Also make sure the user rc has all permissions on the database rc.

[wetjet43]

I made the user rc a superuser with all rights to make sure I wasn't forgetting any permissions.
And no, there aren't any users in the identities table. Can you point me to somewhere to add them manually, or give a brief explanation? I think they would go in identities table, then indexes, then.... I have 2 columns under identities/indexes, 1 named "identity_id, PRIMARY" and another called "user_id, user_id". Do I put the user names in one of those columns, or do I make new columns for each user I want to login?

[wetjet43]

DOH! I went to the identities options in my email account in the rc web gui, and it had no idents, so I added one and tried to send, my sender field is auto populating, and still no go!

But I do get a different error message now!

[02-Feb-2007 07:29:13 -0800] DB Error: DB Error: unknown error Query: INSERT INTO identities (user_id, del, standard, name, email) VALUES (1, 0, 1, '', '**my email removed**') [nativecode=1364 ** Field 'signature' doesn't have a default value] in E:\Program Files\Apache Software Foundation\Apache2.2\htdocs\program\include\rcube_db.inc on line 501

[02-Feb-2007 07:30:10 -0800] SMTP Error: SMTP error: Authentication failure: Invalid response code received from server

I'll play more....

[wetjet43]

WOOHOO!!! It works! I had to restart all of my mysql, hmailserver services and restart apache, then the error logs went away. Also, mysql database still is not listing any users, but I guess that's cause I added one manually in my RC account while logged into the web gui as myself. That's kinda lame that I have to do that. I plan on deploying RC to an entire elementary school and all of it's staff. Hopefully there will be a new version of RC before march 07!

Thank you so much for all the help!

[tabashir]

I found this problem occurred when I updated from the tarball to the svn version. I had to run the mysql.update scripts in the SQL folder as in the tarball version there are some missing columns that the svn version needs. This did not initially run correctly (from memory it adds a constraint to the table that existing data does not conform with) so I also had to remove all entries from the "messages" table (truncate table). Ran the updates and all is fine.