darken:~# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1110 to server version: 4.0.24_Debian-10sarge2-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> create database roundcubemail;
mysql> grant all on roundcubemail.* to roundcube@localhost identified by 'mypassword';
Query OK, 0 rows affected (0.04 sec)
mysql> use roundcubemail;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> \. mysql.initial.sql
Query OK, 0 rows affected (0.04 sec)
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.02 sec)
mysql>
Bye
mysql> show databases;
+---------------+
| Database |
+---------------+
| roundcubemail |
+---------------+
1 row in set (0.26 sec)
mysql> use roundcubemail;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+-------------------------+
| Tables_in_roundcubemail |
+-------------------------+
| cache |
| contacts |
| identities |
| messages |
| session |
| users |
+-------------------------+
6 rows in set (0.00 sec)
mysql>
darken:~# su - postgres
postgres@darken:~$ cd /home/www/mail/SQL
postgres@darken:~$ createuser -A -D -P roundcube
Enter password for new user:
Enter it again:
CREATE USER
postgres@darken:~$
postgres@darken:~$ createdb -O roundcube roundcubemail
CREATE DATABASE
postgres@darken:~$
postgres@darken:~$ psql -U roundcube --password -d roundcubemail
Password:
Welcome to psql 7.4.7, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
roundcubemail=> \i postgres.initial.sql
CREATE SEQUENCE
psql:postgres.initial.sql:26: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "users_pkey" for table "users"
CREATE TABLE
psql:postgres.initial.sql:41: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "session_pkey" for table "session"
CREATE TABLE
CREATE SEQUENCE
psql:postgres.initial.sql:74: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "identities_pkey" for table "identities"
CREATE TABLE
CREATE SEQUENCE
psql:postgres.initial.sql:105: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "contacts_pkey" for table "contacts"
CREATE TABLE
CREATE SEQUENCE
psql:postgres.initial.sql:132: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "cache_pkey" for table "cache"
CREATE TABLE
CREATE SEQUENCE
psql:postgres.initial.sql:168: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "messages_pkey" for table "messages"
CREATE TABLE
psql:postgres.initial.sql:170: NOTICE: ALTER TABLE / ADD UNIQUE will create implicit index "messages_cache_key_key" for table "messages"
ALTER TABLE
roundcubemail=# \q
postgres@darken:/home/www/mail/SQL$
[22-Oct-2006 01:08:19 +0200] DB Error: DB Error: no such database in /home/www/mail/roundcubemail/program/include/rcube_db.inc on line 105
phpinfo();
?>
The browser you're using is
Your browser's capabilities are:
I get a blank screen after I make login... how can I fix it?
Yesterday it was working fine and today when I go to see the mail, after login I get the blank screen always.
Thks in advance.