Roundcube Community Forum

Release Support => Pending Issues => Topic started by: Nickza1 on October 28, 2006, 01:50:27 PM

Title: SERVICE CURRENTLY NOT AVAILABLE!
Post by: Nickza1 on October 28, 2006, 01:50:27 PM
Sorry... i really tried my best to not post a message on this, as there are about 20 different ones already, but nothing on those could help me...

Yes, i have an error after installation: SERVICE CURRENTLY NOT AVAILABLE!

Error No. 1f4)

i have setup the db, and mysql is working, and the server is a unix...

DB Settings:
Hostname:    uname.dns-systems.net
Username:    uname_mail
Database Name:    uname_mail
Password:    pwd

I dont know what else to try... i have tried about 50 combinations of: 'mysql://uname:pwd@localhost/uname'

PLEASE help me!
Title: Re: SERVICE CURRENTLY NOT AVAILABLE!
Post by: daashag on October 28, 2006, 03:51:01 PM
Your not making a connection to your database.
Can you connect using the command mysql -u databaseUsername -p databaseUsernamePassword
Title: Re: SERVICE CURRENTLY NOT AVAILABLE!
Post by: Nickza1 on October 28, 2006, 04:19:57 PM
Dont understand...

tell me what to try... I do not know mysql or php very well... ihad rc setup on another server, but for some reason i cannot get this new version to work on a different server...
the previous server was on on cpanel... i dont really know what this new one, as my host has implemented new servers...

i setup joomla! so the mysql and php definatly works... that much i do know...
Title: Re: SERVICE CURRENTLY NOT AVAILABLE!
Post by: daashag on October 28, 2006, 04:26:16 PM
mysql -u uname_mail -p pwd

Title: Re: SERVICE CURRENTLY NOT AVAILABLE!
Post by: Nickza1 on October 28, 2006, 04:27:57 PM
dont understand, sorry...

must i put that line somewhere?
Title: Re: SERVICE CURRENTLY NOT AVAILABLE!
Post by: daashag on October 28, 2006, 04:29:50 PM
do you have shell access
Title: Re: SERVICE CURRENTLY NOT AVAILABLE!
Post by: Nickza1 on October 28, 2006, 04:31:32 PM
okay... i really dont know what your talking about...

sorry for my ignorance... i am trying to learn....
talk to me like a complete idiot...

sorry, and thanks for your patience
Title: Re: SERVICE CURRENTLY NOT AVAILABLE!
Post by: daashag on October 28, 2006, 04:32:11 PM
how do you access your server
Title: Re: SERVICE CURRENTLY NOT AVAILABLE!
Post by: Nickza1 on October 28, 2006, 04:32:40 PM
ftp and a control panel...
Title: Re: SERVICE CURRENTLY NOT AVAILABLE!
Post by: daashag on October 28, 2006, 04:43:41 PM
Those are commands you can use from the command line of your server.

If this is correct:

DB Settings:
Hostname:   uname.dns-systems.net
Username:  uname_mail
Database Name:  uname_mail
Password:    pwd

Then this the line you need.

$rcmail_config['db_dsnw'] = 'mysql://uname_mail:pwd@your.domainname.com/uname_mail';

Title: Re: SERVICE CURRENTLY NOT AVAILABLE!
Post by: Nickza1 on October 28, 2006, 04:48:12 PM
i know, but i have tried that, plus a million different combination of it...
Title: Re: SERVICE CURRENTLY NOT AVAILABLE!
Post by: daashag on October 28, 2006, 04:54:34 PM
How did you create the database and how did you populate it?
Title: Re: SERVICE CURRENTLY NOT AVAILABLE!
Post by: Nickza1 on October 28, 2006, 04:58:59 PM
i created a db using the client panel/control panel. it has phpmyadmin, and a place where i can create a db, which i did....

i then edit the config file, with the line above, putting the db settings in, and i get this problem.... i also tried variations of the line, and nothing....

Title: Re: SERVICE CURRENTLY NOT AVAILABLE!
Post by: daashag on October 28, 2006, 05:02:13 PM
What control panel are you using?
Title: Re: SERVICE CURRENTLY NOT AVAILABLE!
Post by: Nickza1 on October 28, 2006, 05:03:21 PM
cp15 i think...
Title: Re: SERVICE CURRENTLY NOT AVAILABLE!
Post by: daashag on October 28, 2006, 05:04:02 PM
cpanel?
Title: Re: SERVICE CURRENTLY NOT AVAILABLE!
Post by: Nickza1 on October 29, 2006, 02:27:46 AM
i dont think so....
Title: Re: SERVICE CURRENTLY NOT AVAILABLE!
Post by: Nickza1 on October 29, 2006, 02:32:30 AM
could someone PLEASE help me with this..
Title: Re: SERVICE CURRENTLY NOT AVAILABLE!
Post by: seansan on October 29, 2006, 05:17:38 AM
Did you run the initial.sql file / contents in the phpmyadmin -> SQL window to create the tables in your database?
Title: Re: SERVICE CURRENTLY NOT AVAILABLE!
Post by: daashag on October 29, 2006, 07:16:48 AM
The error your getting means your not making a connection to the database which can be caused by several different things.

1 Your connection string is wrong, either your parameters don't match the database you setup and/or your syntax is wrong.
2 You didn't setup your database correctly and/or user privileges to the database. Double check in phpmyadmin that the database exist and the user you setup has all privileges to the database.
3 Your domain name does not resolve or your using the wrong parameters in your connection string.  You can check to see if your domain name is resolving by typing from a command prompt:
nslookup your.domain.com

backend://username:password@domain.com/database


backend = type of database you are using  (I believe that is mysql)
username = username of the user that you gave access to database created for RC - lets call it rc_user
password = password of the that user - lets call it rcpasswd
domain.com = your domain (if your email address is john@foo.com then foo.com would be your domain) you might be able to use localhost instead of domain name
database = the name of the database you setup for RC - lets call itrc_database

hence your connection string would be -
$rcmail_config['db_dsnw'] = 'mysql://rc_user:rcpasswd@foo.com/rc_database';
Title: Re: SERVICE CURRENTLY NOT AVAILABLE!
Post by: getz515 on December 29, 2006, 11:28:30 PM
I seem to be having this problem. I've read almost 20 different ways to do it, and I still get nothing. I used phpMyAdmin to create the tables. I've looked at the privileges, and for that table (i called it "email") it has the priviledges as Privileges=ALL PRIVILEGES grant=YES Table-specific privileges=YES. Now my string is as follows: (XXXXXX = substituting my accutal password)

Code: [Select]
$rcmail_config['db_dsnw'] = 'mysql://getz515:XXXXXX@localhost/email';
I've also tried changing "localhost" to "domain.com" (my accutal domain), I've tried changing "domain.com" to "mysql.domain.com", I've tried changing the chmod of db.inc.php from 600 to 644, I've tried doing "yroot_getz515" and "yroot_email", I've tried adding a port after localhost, such as; localhost:3307 (with my accutal domain too). I also understand that this all means that it's having problems connecting to the database, just don't know how to go about fixing it.

Please help, thanks,
Jose
Title: Re: SERVICE CURRENTLY NOT AVAILABLE!
Post by: llumeao on January 06, 2007, 03:16:47 PM
Hi,

I have the very same problem, and I am certain the information I gave in my config file are correct
(I have other PHP/MySQL-based software installed on my site and they use the same db)

I have executed the mysql.initial.sql in phpMyAdmin and it completed successfully.

@daashag: some of the instructions you give can be misleading :
When you say that 'domain.com' is 'your domain', what do you really mean ?
In my settings, I supposed 'domain.com' was the name of the MySQL server (and it is completely different from the domain name of my web site or my e-mail address).
Is it correct ?

Regards

Guillaume
Title: Re: SERVICE CURRENTLY NOT AVAILABLE!
Post by: llumeao on January 06, 2007, 04:39:46 PM
Well, I inserted a backtrace display in 'bugs.inc' and I gathered that the error is not related to database connection at all.
In my case, it is raised in function 'parse_template' in 'main.inc'

It would have helped if the error message "Error loading template" had been displayed clearly instead of "Error no 1f4"

Actually my problem was related to an aborted FTP transfer : folder 'skins' was missing on the server.

Guillaume
Title: Re: SERVICE CURRENTLY NOT AVAILABLE!
Post by: getz515 on October 05, 2007, 10:20:52 PM
This is great support btw. ;)
Title: Re: SERVICE CURRENTLY NOT AVAILABLE!
Post by: hcl on October 19, 2007, 03:15:53 AM
Quote from: Nickza1
Sorry... i really tried my best to not post a message on this, as there are about 20 different ones already, but nothing on those could help me...

Yes, i have an error after installation: SERVICE CURRENTLY NOT AVAILABLE!

--
Hi llumeao,

check permission directory 'skin' 'program' 'config' and other directory.