Install problems

[Nonsense]

I just grabbed the latest nightly build and installed it on my server-space.
Everything seems fine until I tried to log in.
The page goes blank and in Safari it claims that it has lost contact with the server.
There is no error log either.

Here is my config:

Code Select Expand

$rcmail_config = array();

$rcmail_config['db_dsnw'] = 'mysql://username:pass@localhost/database';

$rcmail_config['db_dsnr'] = '';

$rcmail_config['db_backend'] = 'db';

$rcmail_config['db_max_length'] = 512000; // 500K

$rcmail_config['db_persistent'] = TRUE;

$rcmail_config['db_table_users'] = 'rc_users';

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

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

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

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

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

$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


Code Select Expand

$rcmail_config = array();

$rcmail_config['debug_level'] = 4;

$rcmail_config['enable_caching'] = TRUE;

$rcmail_config['message_cache_lifetime'] = '60d';

$rcmail_config['auto_create_user'] = TRUE;

$rcmail_config['default_host'] = 'imap.mydomain.com';

$rcmail_config['default_port'] = 25;

$rcmail_config['username_domain'] = 'mydomain.com';

$rcmail_config['mail_domain'] = 'mydomain.com';

$rcmail_config['virtuser_file'] = '';

$rcmail_config['virtuser_query'] = '';

$rcmail_config['smtp_server'] = 'customer-smtp.suplier.com';

$rcmail_config['smtp_port'] = 25;

$rcmail_config['smtp_user'] = '%u';

$rcmail_config['smtp_pass'] = '%p';

$rcmail_config['smtp_auth_type'] = '';

$rcmail_config['smtp_log'] = TRUE;

$rcmail_config['list_cols'] = array('subject', 'from', 'date', 'size');

$rcmail_config['skin_path'] = 'skins/default/';

$rcmail_config['temp_dir'] = 'temp/';

$rcmail_config['log_dir'] = 'logs/';

$rcmail_config['session_lifetime'] = 30;

$rcmail_config['ip_check'] = TRUE;

$rcmail_config['des_key'] = 'rcmail-cryptKey';

$rcmail_config['locale_string'] = 'en';

$rcmail_config['date_short'] = 'D H:i';

$rcmail_config['date_long'] = 'd/m/Y H:i';

$rcmail_config['useragent'] = 'RoundCube Webmail/0.1b';

$rcmail_config['product_name'] = 'RoundCube Webmail';

$rcmail_config['imap_root'] = '';

$rcmail_config['drafts_mbox'] = 'Drafts';

$rcmail_config['junk_mbox'] = 'Junk';

$rcmail_config['sent_mbox'] = 'Sent';

$rcmail_config['trash_mbox'] = 'Trash';

$rcmail_config['default_imap_folders'] = array('INBOX', 'Drafts', 'Sent', 'Junk', 'Trash');

$rcmail_config['protect_default_folders'] = TRUE;

$rcmail_config['skip_deleted'] = FALSE;

$rcmail_config['read_when_deleted'] = TRUE;

$rcmail_config['flag_for_deletion'] = TRUE;

$rcmail_config['enable_spellcheck'] = TRUE;

$rcmail_config['spellcheck_uri'] = '';

$rcmail_config['spellcheck_languages'] = NULL;

$rcmail_config['generic_message_footer'] = '';

$rcmail_config['mail_header_delimiter'] = NULL;

$rcmail_config['javascript_config'] = array('read_when_deleted', 'flag_for_deletion');

$rcmail_config['include_host_config'] = FALSE;

$rcmail_config['pagesize'] = 40;

$rcmail_config['timezone'] = 1;

$rcmail_config['dst_active'] = TRUE;

$rcmail_config['prefer_html'] = TRUE;

$rcmail_config['prettydate'] = TRUE;

$rcmail_config['message_sort_col'] = 'date';

$rcmail_config['message_sort_order'] = 'DESC';

$rcmail_config['draft_autosave'] = 300;

// end of config file


Code Select Expand

-- RoundCube Webmail initial database structure
-- Version 0.1-beta2
--

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

--
-- Table structure for table `cache`
--

CREATE TABLE `rc_cache` (
 `cache_id` int(10) unsigned NOT NULL auto_increment,
 `user_id` int(10) unsigned NOT NULL default '0',
 `session_id` varchar(40) default NULL,
 `cache_key` varchar(128) NOT NULL default '',
 `created` datetime NOT NULL default '0000-00-00 00:00:00',
 `data` longtext NOT NULL,
 PRIMARY KEY (`cache_id`),
 KEY `user_id` (`user_id`),
 KEY `cache_key` (`cache_key`),
 KEY `session_id` (`session_id`)
);

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

--
-- Table structure for table `contacts`
--

CREATE TABLE `rc_contacts` (
 `contact_id` int(10) unsigned NOT NULL auto_increment,
 `user_id` int(10) unsigned NOT NULL default '0',
 `changed` datetime NOT NULL default '0000-00-00 00:00:00',
 `del` tinyint(1) NOT NULL default '0',
 `name` varchar(128) NOT NULL default '',
 `email` varchar(128) NOT NULL default '',
 `firstname` varchar(128) NOT NULL default '',
 `surname` varchar(128) NOT NULL default '',
 `vcard` text NOT NULL,
 PRIMARY KEY (`contact_id`),
 KEY `user_id` (`user_id`)
);

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

--
-- Table structure for table `identities`
--

CREATE TABLE `rc_identities` (
 `identity_id` int(10) unsigned NOT NULL auto_increment,
 `user_id` int(10) unsigned NOT NULL default '0',
 `del` tinyint(1) NOT NULL default '0',
 `standard` tinyint(1) NOT NULL default '0',
 `name` varchar(128) NOT NULL default '',
 `organization` varchar(128) NOT NULL default '',
 `email` varchar(128) NOT NULL default '',
 `reply-to` varchar(128) NOT NULL default '',
 `bcc` varchar(128) NOT NULL default '',
 `signature` text NOT NULL,
 PRIMARY KEY (`identity_id`),
 KEY `user_id` (`user_id`)
);

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

--
-- Table structure for table `session`
--

CREATE TABLE `rc_session` (
 `sess_id` varchar(40) NOT NULL default '',
 `created` datetime NOT NULL default '0000-00-00 00:00:00',
 `changed` datetime NOT NULL default '0000-00-00 00:00:00',
 `ip` VARCHAR(15) NOT NULL default '',
 `vars` text NOT NULL,
 PRIMARY KEY (`sess_id`)
);

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

--
-- Table structure for table `users`
--

CREATE TABLE `rc_users` (
 `user_id` int(10) unsigned NOT NULL auto_increment,
 `username` varchar(128) NOT NULL default '',
 `mail_host` varchar(128) NOT NULL default '',
 `alias` varchar(128) NOT NULL default '',
 `created` datetime NOT NULL default '0000-00-00 00:00:00',
 `last_login` datetime NOT NULL default '0000-00-00 00:00:00',
 `language` varchar(5) NOT NULL default 'en',
 `preferences` text NOT NULL default '',
 PRIMARY KEY (`user_id`)
);

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

--
-- Table structure for table `messages`
--

CREATE TABLE `rc_messages` (
 `message_id` int(11) unsigned NOT NULL auto_increment,
 `user_id` int(11) unsigned NOT NULL default '0',
 `del` tinyint(1) NOT NULL default '0',
 `cache_key` varchar(128) NOT NULL default '',
 `created` datetime NOT NULL default '0000-00-00 00:00:00',
 `idx` int(11) unsigned NOT NULL default '0',
 `uid` int(11) unsigned NOT NULL default '0',
 `subject` varchar(255) NOT NULL default '',
 `from` varchar(255) NOT NULL default '',
 `to` varchar(255) NOT NULL default '',
 `cc` varchar(255) NOT NULL default '',
 `date` datetime NOT NULL default '0000-00-00 00:00:00',
 `size` int(11) unsigned NOT NULL default '0',
 `headers` text NOT NULL,
 `structure` text,
 PRIMARY KEY (`message_id`),
 KEY `user_id` (`user_id`),
 KEY `idx` (`idx`),
 KEY `uid` (`uid`),
 UNIQUE `uniqueness` (`cache_key`, `uid`)
);



My server-provider is using PHP 4.4.4 / PHP 5.1.5 and MySQL 4.0.24.
I changed the mysql.initial.sql
so that the tables correspond to the config-file. I even tried not changing the table names and it still doesn't get me anywhere.
And checked with the server-provider that the SMTP and IMAP settings are correct.

I tried the latest stable release as well, but the same thing happens.


Help!

[Nonsense]

Come on!

Someone PLEASE answer!

I checked my tables and php what more can I do?

I get the login-page but when I try to login the page goes blank.

[toxygen]

if i can give you an advice:

try to run mysql.initial.sql without changing the values.
it seems it has problem with database, so try default setup

[Nonsense]

I did that. No go.

[toxygen]

what does apache (or any other web server) logs say?

[Nonsense]

Can't really say since I'm on a hosted account

[daashag]

Do you get the login page, or is just blank to begin with?

[Nonsense]

I get the login page. And if I try to login without password I get a error message.
But if I try to login using whatever name and password I get a blank page and a time out.

[daashag]

First make sure your connectivity to your database is good by following this guide.
http://roundcubeforum.net/forum/index.php?topic=798.0


Can you connect to you mail servers through a client?

[Nonsense]

First make sure your connectivity to your database is good by following this guide.
http://roundcubeforum.net/forum/index.php?topic=798.0

I tried to follow it as far as I could, but since I'm only hosted I cannot make a dedicated database for roundcube, so I have to use the existing one, and I can't use the terminal to access mysql.
So far I have used FTP and phpMyAdmin.

Can you connect to you mail servers through a client?

Yes and no. My hosting company (one.com) has Squirell-mail pre-installed, but I can't access their settings since I do not have admin rights to the server.

[daashag]

The first thing is to get database connectivity. Can you create a database in phpmyadmin.

Did they give you smtp and imap servers to connect to?

[Nonsense]

Yes no problems there.

I created the tables in phpMyAdmin by running initial.mysql.sql

the settings for my imap is:
imap.mydomain.xxx
port: 25

And for smtp:
customer-smtp.suplier.com
port: 25

[daashag]

Can you create a database?

[Nonsense]

Well, I can't create a database, but I can use the one that has been given to me.

[daashag]

Sounds like you can connect to the database but not to the mail server. I have had similar problems so I try to go step by step.
If your getting a login page I assume your database is setup and your connecting.
Try connecting to your imap server using telnet.
command - telnet your.imap.server 143  should get a connect to your server
         

also make sure your.imap.server resolves to some IP
command nslookup your.imap.server    should resolve

If you can connect I would try using the the defaults in main.inc.php. You should get a third field on your login page to put your imap server in. Try connecting that way.