Hi folks,
Previously I mistakenly ran; $ mysql -u roundcube -p roundcube < /var/www/roundcubemail-0.1/SQL/mysql.initial.sql
Now I need to correct it without success;
$ mysql -u roundcube -p roundcube < /var/www/roundcube/SQL/mysql.initial.sql Enter password: ERROR 1050 (42S01) at line 11: Table 'cache' already exists
Please advise how to force run the command. Or is there any other way? TIA
B.R. Stephen L
Send instant messages to your online friends http://uk.messenger.yahoo.com _______________________________________________ List info: http://lists.roundcube.net/users/
Stephen Liu wrote:
Hi folks,
Previously I mistakenly ran; $ mysql -u roundcube -p roundcube < /var/www/roundcubemail-0.1/SQL/mysql.initial.sql
Now I need to correct it without success;
$ mysql -u roundcube -p roundcube < /var/www/roundcube/SQL/mysql.initial.sql Enter password: ERROR 1050 (42S01) at line 11: Table 'cache' already exists
Please advise how to force run the command. Or is there any other way? TIA
Do something like this
mysql -u roundcube -p roundcube
show tables; -- to list the existing tables drop database roundcube; -- if you want to start from scratch
--- "Dennis P. Nikolaenko" dennis@nikolaenko.ru wrote:
Stephen Liu wrote:
Hi folks,
Previously I mistakenly ran; $ mysql -u roundcube -p roundcube < /var/www/roundcubemail-0.1/SQL/mysql.initial.sql
Now I need to correct it without success;
$ mysql -u roundcube -p roundcube < /var/www/roundcube/SQL/mysql.initial.sql Enter password: ERROR 1050 (42S01) at line 11: Table 'cache' already exists
Please advise how to force run the command. Or is there any other
way?
TIA
Do something like this
mysql -u roundcube -p roundcube
show tables; -- to list the existing tables drop database roundcube; -- if you want to start from scratch
Hi Dennis,
mysql> show tables; +---------------------+ | Tables_in_roundcube | +---------------------+ | cache | | contacts | | identities | | messages | | session | | users | +---------------------+
B.R. Stephen L
Send instant messages to your online friends http://uk.messenger.yahoo.com _______________________________________________ List info: http://lists.roundcube.net/users/
Stephen Liu wrote:
--- "Dennis P. Nikolaenko" dennis@nikolaenko.ru wrote:
Stephen Liu wrote:
Hi folks,
Previously I mistakenly ran; $ mysql -u roundcube -p roundcube < /var/www/roundcubemail-0.1/SQL/mysql.initial.sql
Now I need to correct it without success;
$ mysql -u roundcube -p roundcube < /var/www/roundcube/SQL/mysql.initial.sql Enter password: ERROR 1050 (42S01) at line 11: Table 'cache' already exists
Please advise how to force run the command. Or is there any other
way?
TIA
Do something like this
mysql -u roundcube -p roundcube
show tables; -- to list the existing tables drop database roundcube; -- if you want to start from scratch
Hi Dennis,
mysql> show tables; +---------------------+ | Tables_in_roundcube | +---------------------+ | cache | | contacts | | identities | | messages | | session | | users | +---------------------+
B.R. Stephen L
You have got all the required tables in "roundcube" database. Why do you need to "force" mysql.initial.sql?
--- "Dennis P. Nikolaenko" dennis@nikolaenko.ru wrote:
Stephen Liu wrote:
--- "Dennis P. Nikolaenko" dennis@nikolaenko.ru wrote:
Stephen Liu wrote:
Hi folks,
Previously I mistakenly ran; $ mysql -u roundcube -p roundcube < /var/www/roundcubemail-0.1/SQL/mysql.initial.sql
Now I need to correct it without success;
$ mysql -u roundcube -p roundcube < /var/www/roundcube/SQL/mysql.initial.sql Enter password: ERROR 1050 (42S01) at line 11: Table 'cache' already exists
Please advise how to force run the command. Or is there any
other
way?
TIA
Do something like this
mysql -u roundcube -p roundcube
show tables; -- to list the existing tables drop database roundcube; -- if you want to start from scratch
Hi Dennis,
mysql> show tables; +---------------------+ | Tables_in_roundcube | +---------------------+ | cache | | contacts | | identities | | messages | | session | | users | +---------------------+
B.R. Stephen L
You have got all the required tables in "roundcube" database. Why do you need to "force" mysql.initial.sql?
Because I can't start roundcube on browser.
http://domain.com/mail File 404 Not Found.
I'm now investing the cause of problem. I adjust the name of "roundcube". Before some in "roundcude", "roundcubemail", "roundcubemail;-0.1". The new path of mysql.initial.sql should be on /var/www/roundcube/SQL/mysql.initial.sql
Thanks
B.R. Stephen L
Send instant messages to your online friends http://uk.messenger.yahoo.com _______________________________________________ List info: http://lists.roundcube.net/users/
Stephen Liu wrote:
--- "Dennis P. Nikolaenko" dennis@nikolaenko.ru wrote:
Stephen Liu wrote:
--- "Dennis P. Nikolaenko" dennis@nikolaenko.ru wrote:
Stephen Liu wrote:
Hi folks,
Previously I mistakenly ran; $ mysql -u roundcube -p roundcube < /var/www/roundcubemail-0.1/SQL/mysql.initial.sql
Now I need to correct it without success;
$ mysql -u roundcube -p roundcube < /var/www/roundcube/SQL/mysql.initial.sql Enter password: ERROR 1050 (42S01) at line 11: Table 'cache' already exists
Please advise how to force run the command. Or is there any
other
way?
TIA
Do something like this
mysql -u roundcube -p roundcube
show tables; -- to list the existing tables drop database roundcube; -- if you want to start from scratch
Hi Dennis,
mysql> show tables; +---------------------+ | Tables_in_roundcube | +---------------------+ | cache | | contacts | | identities | | messages | | session | | users | +---------------------+
B.R. Stephen L
You have got all the required tables in "roundcube" database. Why do you need to "force" mysql.initial.sql?
Because I can't start roundcube on browser.
http://domain.com/mail File 404 Not Found.
If get 404 error it means that something wrong with web server.
Try http://domain.com/mail/index.php, if it is still 404 error, then something wrong with web server config.
--- "Dennis P. Nikolaenko" dennis@nikolaenko.ru wrote:
Stephen Liu wrote:
- snip -
Do something like this
mysql -u roundcube -p roundcube
show tables; -- to list the existing tables drop database roundcube; -- if you want to start from scratch
Hi Dennis,
mysql> show tables; +---------------------+ | Tables_in_roundcube | +---------------------+ | cache | | contacts | | identities | | messages | | session | | users | +---------------------+
B.R. Stephen L
You have got all the required tables in "roundcube" database. Why
do
you need to "force" mysql.initial.sql?
Because I can't start roundcube on browser.
http://domain.com/mail File 404 Not Found.
If get 404 error it means that something wrong with web server.
Try http://domain.com/mail/index.php, if it is still 404 error, then something wrong with web server config.
Still 404 error
I'm running lighttpd webserver. It is working.
http://domain.com Index of / Name Last Modified Size Type Parent Directory/ - Directory lighttpd/1.4.13
Where shall I check? How to fix the problem? TIA
B.R. Stephen L
Send instant messages to your online friends http://uk.messenger.yahoo.com _______________________________________________ List info: http://lists.roundcube.net/users/
Stephen Liu wrote:
--- "Dennis P. Nikolaenko" dennis@nikolaenko.ru wrote:
Stephen Liu wrote:
- snip -
>
>
>
Do something like thismysql -u roundcube -p roundcube
show tables; -- to list the existing tables drop database roundcube; -- if you want to start from scratch
Hi Dennis,
mysql> show tables; +---------------------+ | Tables_in_roundcube | +---------------------+ | cache | | contacts | | identities | | messages | | session | | users | +---------------------+
B.R. Stephen L
You have got all the required tables in "roundcube" database. Why
do
you need to "force" mysql.initial.sql?
Because I can't start roundcube on browser.
http://domain.com/mail File 404 Not Found.
If get 404 error it means that something wrong with web server.
Try http://domain.com/mail/index.php, if it is still 404 error, then something wrong with web server config.
Still 404 error
I'm running lighttpd webserver. It is working.
Post your whole lighttpd.conf.
--- "Dennis P. Nikolaenko" dennis@nikolaenko.ru wrote:
Stephen Liu wrote:
--- "Dennis P. Nikolaenko" dennis@nikolaenko.ru wrote:
Stephen Liu wrote:
- snip -
>>
>>
>>
> Do something like this > > mysql -u roundcube -p roundcube > > show tables; -- to list the existing tables > drop database roundcube; -- if you want to start from scratch >
>
>Hi Dennis,
mysql> show tables; +---------------------+ | Tables_in_roundcube | +---------------------+ | cache | | contacts | | identities | | messages | | session | | users | +---------------------+
B.R. Stephen L
You have got all the required tables in "roundcube" database.
Why
do
you need to "force" mysql.initial.sql?
Because I can't start roundcube on browser.
http://domain.com/mail File 404 Not Found.
If get 404 error it means that something wrong with web server.
Try http://domain.com/mail/index.php, if it is still 404 error,
then
something wrong with web server config.
Still 404 error
I'm running lighttpd webserver. It is working.
Post your whole lighttpd.conf.
$ cat /etc/lighttpd/lighttpd.conf # Debian lighttpd configuration file #
############ Options you really have to take care of ####################
server.modules = ( "mod_access", "mod_alias", "mod_accesslog", # "mod_rewrite", # "mod_redirect", # "mod_status", # "mod_evhost", # "mod_compress", # "mod_usertrack", # "mod_rrdtool", # "mod_webdav", # "mod_expire", # "mod_flv_streaming", # "mod_evasive" )
## a static document-root, for virtual-hosting take look at the ## server.virtual-* options server.document-root = "/var/www/"
## where to send error-messages to server.errorlog = "/var/log/lighttpd/error.log"
## files to check for if .../ is requested index-file.names = ( "index.php", "index.html", "index.htm", "default.htm" )
#### accesslog module accesslog.filename = "/var/log/lighttpd/access.log"
## deny access the file-extensions # of the document-root url.access-deny = ( "~", ".inc" )
######### Options that are good to be but not neccesary to be changed #######
## to help the rc.scripts server.pid-file = "/var/run/lighttpd.pid"
#server.errorfile-prefix = "/var/www/"
## virtual directory listings dir-listing.encoding = "utf-8" server.dir-listing = "enable"
## send unhandled HTTP-header headers to error-log #debug.dump-unknown-headers = "enable"
server.username = "www-data"
## change uid to <uid> (default: don't care) server.groupname = "www-data"
#### rrdtool # rrdtool.binary = "/usr/bin/rrdtool" # rrdtool.db-name = "/var/www/lighttpd.rrd"
#### handle Debian Policy Manual, Section 11.5. urls #### and by default allow them only from localhost
$HTTP["remoteip"] =~ "127.0.0.1" { alias.url += ( # "/doc/" => "/usr/share/doc/", # "/images/" => "/usr/share/images/" "/mail/" => "/var/www/roundcube/" ) $HTTP["url"] =~ "^/doc/|^/images/" { dir-listing.activate = "enable" } }
#### external configuration files ## mimetype mapping include_shell "/usr/share/lighttpd/create-mime.assign.pl"
## load enabled configuration files, ## read /etc/lighttpd/conf-available/README first include_shell "/usr/share/lighttpd/include-conf-enabled.pl"
- end *
B.R. Stephen L
Send instant messages to your online friends http://uk.messenger.yahoo.com _______________________________________________ List info: http://lists.roundcube.net/users/
-
Dennis P. Nikolaenko -
Stephen Liu