Author Topic: Help Plz (Cant even install the script)  (Read 6959 times)

Offline rudeboyb8

  • Jr. Member
  • **
  • Posts: 12
Help Plz (Cant even install the script)
« on: August 31, 2006, 11:19:43 AM »
okay i did what i think needed doing, but now all i see is a blank page, i removed the htacess and still nothing, can someone install it for me?

and btw im on cpanel latest version if that matters and using mysql.
 
 Report to moderator  195.93.21.103
 

Offline mark_ccom

  • Newbie
  • *
  • Posts: 6
Re: Help Plz (Cant even install the script)
« Reply #1 on: September 01, 2006, 09:18:20 AM »
first off, up your debug level to 4, this is found in the main config file. You can then debug the message it brings back.

Offline rudeboyb8

  • Jr. Member
  • **
  • Posts: 12
Re: Help Plz (Cant even install the script)
« Reply #2 on: September 01, 2006, 10:17:02 AM »
DB Error in /home/advo1208/public_html/cubemail/program/include/rcube_db.inc (455): DB Error: no such table Query: SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed FROM session WHERE sess_id='fe6f0f44d205a7b41e60440517171a76' [nativecode=1146 ** Table 'advo1208_roundcubemail.session' doesn't exist]

Fatal error: Call to a member function on a non-object in /home/advo1208/public_html/cubemail/program/include/rcube_db.inc on line 343



now what?

Offline mark_ccom

  • Newbie
  • *
  • Posts: 6
Re: Help Plz (Cant even install the script)
« Reply #3 on: September 01, 2006, 10:34:44 AM »
Check you db config, check it again, and then check your database to make sure everything was created correctly, make sure you havent made any typo's.

Offline rudeboyb8

  • Jr. Member
  • **
  • Posts: 12
Re: Help Plz (Cant even install the script)
« Reply #4 on: September 01, 2006, 02:55:38 PM »
cant see anything wrong....




Domain:http://advoor.net/cubemail


dm.inc.php code
Code: [Select]
<?php

/*
 +-----------------------------------------------------------------------+
 | 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://advo1208_rcm:rcm@localhost/advo1208_rcm';
// 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

// 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
?>



main.inc.php code
Code: [Select]

/*
 +-----------------------------------------------------------------------+
 | 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'] = 4;

// 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'] = '10w';

// 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'] = 'imap.advoor.net/cubemail';

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

// 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'] = 'advoor.net';

// 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'] = 'smtp.advoor.net';

// 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;

// 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'] = 'CubeMail';

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

// 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
$rcmail_config['default_imap_folders'] = array('INBOX', 'Drafts', 'Sent', 'Junk', 'Trash');

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

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

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

// 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
$rcmail_config['mail_header_delimiter'] = "\r\n";

// 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);
 */


/***** 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;

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

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

// end of config file
?>

Offline simplistsims

  • Jr. Member
  • **
  • Posts: 66
Re: Help Plz (Cant even install the script)
« Reply #5 on: September 02, 2006, 05:34:41 PM »
change this in main.inc.php
$rcmail_config['default_host'] = 'imap.advoor.net/cubemail';

to

$rcmail_config['default_host'] = 'imap.advoor.net';

or

$rcmail_config['default_host'] = 'mail.advoor.net';

have you also done the SQL query in your database for roundcube?
Duca Duca Duca Duca - Dr. Evil *Say it fast*

Offline rudeboyb8

  • Jr. Member
  • **
  • Posts: 12
Re: Help Plz (Cant even install the script)
« Reply #6 on: September 03, 2006, 12:12:49 PM »
^^ okay, and whats the SWL query?

Offline rudeboyb8

  • Jr. Member
  • **
  • Posts: 12
Re: Help Plz (Cant even install the script)
« Reply #7 on: September 03, 2006, 12:16:07 PM »
it said something about executing the file bt i didn kno what that ment

Offline simplistsims

  • Jr. Member
  • **
  • Posts: 66
Re: Help Plz (Cant even install the script)
« Reply #8 on: September 03, 2006, 02:13:35 PM »
theres a file in the roundcube file you downlaoded which has the extension .SQL this has to be inserted into your databse via phpmyadmin found in cpanel in the mysql databses section at the bottom. When your there select the database you want roundcube to use from the drop down menu. when thats all loaded to the right click the SQL tab at the top. then copy the content of mysql_inital.sql into the box provided and click ok. If all goes to plan it should say its successful.

Good Luck

~Sean
Duca Duca Duca Duca - Dr. Evil *Say it fast*

Offline rudeboyb8

  • Jr. Member
  • **
  • Posts: 12
Re: Help Plz (Cant even install the script)
« Reply #9 on: September 03, 2006, 05:15:34 PM »
you rock man! working

Offline rudeboyb8

  • Jr. Member
  • **
  • Posts: 12
Re: Help Plz (Cant even install the script)
« Reply #10 on: September 03, 2006, 05:22:00 PM »
another problem: IMAP Error: Could not connect to imap.advoor.net at port 143: Success


comes at the top, and is there a defult Amdin u/n and pass?

Offline simplistsims

  • Jr. Member
  • **
  • Posts: 66
Re: Help Plz (Cant even install the script)
« Reply #11 on: September 03, 2006, 05:37:02 PM »
if it does use the admin u/n and pw try ure cpanel login and password
Duca Duca Duca Duca - Dr. Evil *Say it fast*

Offline rudeboyb8

  • Jr. Member
  • **
  • Posts: 12
Re: Help Plz (Cant even install the script)
« Reply #12 on: September 04, 2006, 10:38:10 AM »
sorry neva understood that.

whats with the error im getting?

Offline simplistsims

  • Jr. Member
  • **
  • Posts: 66
Re: Help Plz (Cant even install the script)
« Reply #13 on: September 04, 2006, 12:17:37 PM »
try changing imap.advoor.net in your main.inc.php to mail.advoor.net
Duca Duca Duca Duca - Dr. Evil *Say it fast*

Offline rudeboyb8

  • Jr. Member
  • **
  • Posts: 12
Re: Help Plz (Cant even install the script)
« Reply #14 on: September 04, 2006, 12:51:19 PM »
fink its sorted.

newayz the cpanel u/n n pass didnt work.

and anova fing hw can i find ut the "database host" and the "cpanel ip" (the Automatic Sign-Up Plugin)