Base EASY
mysql> show tables;
+----------------+
| Tables_in_easy |
+----------------+
| batchftp |
| cell |
| collect |
| compta |
| dialup |
| domain |
| domain_back |
| domrr |
|
fp
|
| handle |
| mbox |
| mysql |
| redirect |
| redirect_bis |
| sites |
| ssl
|
| tarif |
| whitelist |
+----------------+
mysql> desc domain;
+--------------+-----------------------------------------------------------------------------------------------------------------------------+------+-----+-------------------+----------------+
| Field |
Type
| Null | Key |
Default |
Extra |
+--------------+-----------------------------------------------------------------------------------------------------------------------------+------+-----+-------------------+----------------+
| compta_id | int(10)
unsigned
| NO | MUL |
0
|
|
| domain_id | int(10)
unsigned
| NO | PRI |
NULL
| auto_increment |
| domain |
varchar(255)
| YES | UNI |
NULL
|
|
| passwd |
varchar(16)
| NO |
|
|
|
| max_mbox | smallint(5)
unsigned
| NO | |
0
|
|
| mailquota | smallint(5)
unsigned
| NO | |
0
|
|
| max_wwwquota | smallint(5)
unsigned
| NO | |
0
|
|
| handle |
varchar(255)
| NO |
|
|
|
| status |
enum('Active','Suspended','Deleted','Private')
| NO | MUL |
Active
|
|
| lastupdate |
timestamp
| NO | | CURRENT_TIMESTAMP
|
|
| max_shell |
enum('','sh','csh','zsh','tcsh','bash','php','disabled')
| YES | |
NULL
|
|
| max_mysql | smallint(5)
unsigned
| NO | |
0
|
|
| manage |
set('mail','web','visp','list','sharedssl','real','htdig','daily_7','monthly_12','weekly_5','antivirus','nodns','weekly_1')
| YES | |
mail,web
|
|
| max_scol | smallint(5)
unsigned
| YES | |
0
|
|
| max_real |
enum('0','5','25')
| NO | |
0
|
|
| mysql_server | smallint(5)
unsigned
| NO | |
1
|
|
| clarabase_id | int(10)
unsigned
| YES | |
NULL
|
|
| default_mbox |
varchar(64)
| NO |
|
|
|
| max_fp | smallint(5)
unsigned
| NO | |
10
|
|
| max_ssl | smallint(5)
unsigned
| YES | |
0
|
|
| eb_version |
enum('eb_2000','eb_2004')
| NO | |
eb_2000
|
|
+--------------+-----------------------------------------------------------------------------------------------------------------------------+------+-----+-------------------+----------------+
21 rows in set (0.00 sec)
mysql> desc domrr;
+-----------+--------------------------------------------------------------+------+-----+---------+----------------+
| Field |
Type
| Null | Key | Default |
Extra |
+-----------+--------------------------------------------------------------+------+-----+---------+----------------+
| domain_id | int(10)
unsigned
| NO | MUL | 0
|
|
| domrr_id | int(10)
unsigned
| NO | PRI | NULL | auto_increment |
| name |
varchar(255)
| NO | MUL
|
|
|
| class |
varchar(255)
| NO |
|
|
|
| value |
varchar(255)
| NO |
|
|
|
| ttl | int(10)
unsigned
| YES | | NULL
|
|
| defaut |
enum('mail','web','base','extra','real','mysql','antivirus') |
YES | | NULL
|
|
+-----------+--------------------------------------------------------------+------+-----+---------+----------------+
7 rows in set (0.01 sec)
mysql> desc mbox;
+-----------+------------------------------------------------+------+-----+--------------+----------------+
| Field |
Type
| Null | Key | Default |
Extra |
+-----------+------------------------------------------------+------+-----+--------------+----------------+
| domain_id | int(10)
unsigned
| NO | MUL |
0
|
|
| mbox_id | int(10)
unsigned
| NO | PRI |
NULL | auto_increment |
| mbox |
varchar(150)
| NO | MUL
|
|
|
| passwd |
varchar(16)
| NO |
|
|
|
| alias |
varchar(150)
| NO | MUL
|
|
|
| status |
enum('Active','Suspended','Deleted','Private') | NO | MUL |
Active
|
|
| migrated | enum('Not
migrated','Migrating','Migrated') | YES
| | Not migrated
|
|
+-----------+------------------------------------------------+------+-----+--------------+----------------+
7 rows in set (0.00 sec)
mysql> desc mysql;
+-----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| Field |
Type
| Null | Key | Default |
Extra |
+-----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| domain_id | int(10)
unsigned
| NO | |
0
|
|
| mysql_id | int(10)
unsigned
| NO | PRI | NULL | auto_increment |
| user |
varchar(16)
| NO | UNI
|
|
|
| passwd |
varchar(16)
| NO |
|
|
|
| status |
enum('Active','Suspended','Deleted','Private')
| NO | MUL | Active
|
|
| server |
enum('mysql1.co.fr.clara.net','mysql2.co.fr.clara.net','mysql3.co.fr.clara.net','mysql4.co.fr.clara.net','mysql6.co.fr.clara.net','mysql5.co.fr.clara.net','mysql.co.fr.clara.net')
| YES | | NULL
|
|
+-----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
6 rows in set (0.00 sec)
mysql> desc redirect;
+-------------+------------------------------------------------+------+-----+-----------+----------------+
| Field |
Type
| Null | Key | Default |
Extra |
+-------------+------------------------------------------------+------+-----+-----------+----------------+
| domain_id | int(10)
unsigned
| NO | |
0
|
|
| redirect_id | int(10)
unsigned
| NO | PRI | NULL |
auto_increment |
| host |
varchar(100)
| YES | UNI | NULL
|
|
| target |
varchar(255)
| NO |
|
|
|
| flag |
enum('Recursive','Absolute')
| NO | | Recursive
|
|
| status |
enum('Active','Suspended','Deleted','Private') | NO
| | Active
|
|
+-------------+------------------------------------------------+------+-----+-----------+----------------+
6 rows in set (0.00 sec)
-----------------------------------
mysql> select * from domain where domain_id="17151"\G
*************************** 1. row ***************************
compta_id: 7482
domain_id: 17151
domain: blaxeen.com
passwd: P3Special73
max_mbox: 20
mailquota: 0
max_wwwquota: 2000
handle:
status: Active
lastupdate: 2008-12-30 15:29:17
max_shell: bash
max_mysql: 9
manage: web,real,htdig,antivirus
max_scol: 2
max_real: 5
mysql_server: 1
clarabase_id: 0
default_mbox:
max_fp: 10
max_ssl: 0
eb_version: eb_2004
1 row in set (0.01 sec)
mysql> select * from domrr where domain_id="17151";
+-----------+----------+-----------+-------+-----------------------------+------+--------+
| domain_id | domrr_id | name | class |
value
| ttl | defaut |
+-----------+----------+-----------+-------+-----------------------------+------+--------+
| 17151 | 566251 |
* |
A |
212.43.241.106
| NULL | web |
| 17151 | 566250 |
@ |
A |
212.43.241.106
| NULL | web |
| 17151 | 579241 |
@ |
MX | 10
ASPMX.L.GOOGLE.COM. | NULL |
NULL |
| 17151 | 579242 |
@ |
MX | 20 ALT1.ASPMX.L.GOOGLE.COM. | NULL |
NULL |
| 17151 | 579243 |
@ |
MX | 20 ALT2.ASPMX.L.GOOGLE.COM. | NULL |
NULL |
| 17151 | 579244 |
@ |
MX | 30 ASPMX2.GOOGLEMAIL.COM. | NULL |
NULL |
| 17151 | 579245 |
@ |
MX | 30 ASPMX3.GOOGLEMAIL.COM. | NULL |
NULL |
| 17151 | 579247 |
@ |
MX | 30 ASPMX5.GOOGLEMAIL.COM. | NULL |
NULL |
| 17151 | 579246 |
@ |
MX | 40 ASPMX4.GOOGLEMAIL.COM. | NULL |
NULL |
| 17151 | 579249 |
@ |
MX | 50
mx3.fr.clara.net. | NULL |
NULL |
| 17151 | 97273 |
@ |
NS |
ns3.fr.clara.net.
| NULL | base |
| 17151 | 97274 |
@ |
NS |
ns4.fr.clara.net.
| NULL | base |
| 17151 | 97276 |
admin | CNAME |
www.fr.clara.net.
| NULL | extra |
| 17151 | 529586 | calvados |
A |
212.43.246.8
| NULL | NULL |
| 17151 | 147180 |
defkone | CNAME |
vftp.easy.fr.clara.net. | NULL |
NULL |
| 17151 | 566253 |
ftp | CNAME |
ftp.easy.fr.clara.net. | NULL |
web |
| 17151 | 579252 |
gmail | CNAME |
ghs.google.com.
| NULL | NULL |
| 17151 | 572760 |
heure | A |
212.43.246.8
| 3600 | NULL |
| 17151 | 560745 |
imap | CNAME |
imap.fr.clara.net.
| NULL | NULL |
| 17151 | 148469 |
jos | CNAME |
vftp.easy.fr.clara.net. | NULL |
NULL |
| 17151 | 568862 | ldskldkls |
A |
212.43.232.68
| NULL | NULL |
| 17151 | 478848 |
myhome1 | A |
212.43.241.15
| NULL | NULL |
| 17151 | 478856 | myhome10 |
A |
212.43.241.165
| NULL | NULL |
| 17151 | 478857 | myhome11 |
A |
212.43.241.175
| NULL | NULL |
| 17151 | 478858 | myhome12 |
A |
212.43.241.185
| NULL | NULL |
| 17151 | 478859 | myhome13 |
A |
212.43.241.195
| NULL | NULL |
| 17151 | 550187 | myhome14 |
A |
212.43.241.215
| NULL | NULL |
| 17151 | 550188 | myhome15 |
A |
212.43.241.225
| NULL | NULL |
| 17151 | 478849 |
myhome3 | A |
212.43.241.25
| NULL | NULL |
| 17151 | 478850 |
myhome4 | A |
212.43.241.45
| NULL | NULL |
| 17151 | 478851 |
myhome5 | A |
212.43.241.55
| NULL | NULL |
| 17151 | 478852 |
myhome6 | A |
212.43.241.65
| NULL | NULL |
| 17151 | 478853 |
myhome7 | A |
212.43.241.75
| NULL | NULL |
| 17151 | 478854 |
myhome8 | A |
212.43.241.85
| NULL | NULL |
| 17151 | 478855 |
myhome9 | A |
212.43.241.155
| NULL | NULL |
| 17151 | 103524 |
mysql | CNAME |
mysql1.co.fr.clara.net. | NULL | mysql |
| 17151 | 109022 |
real | CNAME |
real.fr.clara.net.
| NULL | real |
| 17151 | 147007 |
share | CNAME |
vftp.easy.fr.clara.net. | NULL |
NULL |
| 17151 | 566254 |
telnet | CNAME |
telnet.easy.fr.clara.net. | NULL | web |
| 17151 | 566252 |
www | CNAME |
easy-2004.fr.clara.net. | NULL |
web |
| 17151 | 566255 |
www2000 | A |
212.43.241.105
| NULL | NULL |
| 17151 | 558914 |
www2004 | A |
212.43.241.106
| NULL | NULL |
+-----------+----------+-----------+-------+-----------------------------+------+--------+
42 rows in set (0.00 sec)
mysql> select * from mbox where domain_id="17151";
+-----------+-----------+-------------------------+-----------+----------------------+--------+--------------+
| domain_id | mbox_id |
mbox
| passwd |
alias
| status | migrated |
+-----------+-----------+-------------------------+-----------+----------------------+--------+--------------+
| 17151 | 100020236 |
eaeaea@blaxeen.com
| |
zaz@blaxeen.com | Active | Not migrated |
| 17151 | 100019116 |
dzdzdada@blaxeen.com | zazaze
|
| Active | Not migrated |
| 17151 | 241978 |
vente@blaxeen.com
| |
ben@blaxeen.com | Active | Not migrated |
| 17151 | 259098 |
share@blaxeen.com |
sh4r3
|
| Active | Not migrated |
| 17151 | 100023714 |
azert@blaxeen.com | dsdqdqsds
|
| Active | Not migrated |
| 17151 | 100020221 | azerrttyyuy@blaxeen.com
| |
zrzearze@blaxeen.com | Active | Not migrated |
+-----------+-----------+-------------------------+-----------+----------------------+--------+--------------+
6 rows in set (0.00 sec)
mysql> select * from mysql where domain_id="17151";
+-----------+----------+------------+-------------+--------+------------------------+
| domain_id | mysql_id | user |
passwd | status |
server
|
+-----------+----------+------------+-------------+--------+------------------------+
| 17151 | 945 |
ben01 |
bensql | Active | mysql1.co.fr.clara.net
|
| 17151 | 1183 |
cgpictures | artways4764 | Active | mysql1.co.fr.clara.net |
| 17151 | 3842 |
workben | workben | Active |
mysql1.co.fr.clara.net |
| 17151 | 7707 |
bensql2 | bensql22 | Active |
mysql2.co.fr.clara.net |
| 17151 | 10376 |
ben555 | bensql |
Active | mysql5.co.fr.clara.net |
| 17151 | 10395 |
bencinq | bensql |
Active | mysql5.co.fr.clara.net |
+-----------+----------+------------+-------------+--------+------------------------+
6 rows in set (0.01 sec)
mysql> select * from redirect where domain_id="17151";
+-----------+-------------+---------------------+--------------------------------------+-----------+--------+
| domain_id | redirect_id |
host
|
target
| flag | status |
+-----------+-------------+---------------------+--------------------------------------+-----------+--------+
| 17151 |
54564 | blaxeen.com |
http://www.blaxeen.com
| Recursive | Active |
| 17151 |
65391 | mail.blaxeen.com |
http://mail.google.com/a/blaxeen.com | Recursive | Active |
| 17151 |
27287 | pma.blaxeen.com |
https://monssl.com/pma.blaxeen.com | Recursive | Active |
| 17151 |
61736 | myhome1.blaxeen.com |
http://www.google.fr
| Recursive | Active |
+-----------+-------------+---------------------+--------------------------------------+-----------+--------+
4 rows in set (0.04 sec)