A Peek on the Leaked Database (Colocrossing)

in #blog10 days ago

The leaked database (virtualizor.sql) has been provided by hacker:

75268f44b60cb2886613b98dab3be15.png

image.png

image.png

image.png

the passwords are hash-ed, hopefully with the "seed"

So, please do change the passwords!

VPS Table

mysql> desc vps;
+-------------------+---------------+------+-----+---------+----------------+
| Field             | Type          | Null | Key | Default | Extra          |
+-------------------+---------------+------+-----+---------+----------------+
| vpsid             | int           | NO   | PRI | NULL    | auto_increment |
| vps_name          | text          | YES  |     | NULL    |                |
| uuid              | varchar(50)   | NO   |     |         |                |
| serid             | int           | NO   |     | 0       |                |
| time              | int           | NO   |     | 0       |                |
| edittime          | int           | NO   |     | 0       |                |
| virt              | varchar(32)   | NO   |     | NULL    |                |
| uid               | int           | NO   | MUL | 0       |                |
| plid              | int           | NO   |     | 0       |                |
| hostname          | text          | YES  |     | NULL    |                |
| osid              | int           | NO   |     | 0       |                |
| os_name           | varchar(255)  | NO   |     |         |                |
| iso               | text          | YES  |     | NULL    |                |
| sec_iso           | text          | YES  |     | NULL    |                |
| boot              | text          | YES  |     | NULL    |                |
| space             | int           | NO   |     | 0       |                |
| inodes            | int           | NO   |     | 0       |                |
| ram               | int           | NO   |     | 0       |                |
| burst             | int           | NO   |     | 0       |                |
| swap              | int           | NO   |     | 0       |                |
| cpu               | int           | NO   |     | 0       |                |
| cores             | int           | NO   |     | 0       |                |
| cpupin            | varchar(150)  | NO   |     | -1      |                |
| cpu_percent       | decimal(10,2) | NO   |     | 0.00    |                |
| bandwidth         | int           | NO   |     | 0       |                |
| network_speed     | int           | NO   |     | 0       |                |
| upload_speed      | int           | NO   |     | 0       |                |
| io                | int           | NO   |     | 0       |                |
| ubc               | text          | YES  |     | NULL    |                |
| acpi              | int           | NO   |     | 0       |                |
| apic              | int           | NO   |     | 0       |                |
| pae               | int           | NO   |     | 0       |                |
| shadow            | int           | NO   |     | 0       |                |
| vnc               | int           | NO   |     | 0       |                |
| vncport           | int           | NO   |     | 0       |                |
| vnc_passwd        | varchar(50)   | NO   |     |         |                |
| hvm               | int           | NO   |     | 0       |                |
| suspended         | int           | NO   |     | 0       |                |
| suspend_reason    | text          | YES  |     | NULL    |                |
| nw_suspended      | text          | YES  |     | NULL    |                |
| rescue            | int           | NO   |     | 0       |                |
| band_suspend      | int           | NO   |     | 0       |                |
| tuntap            | int           | NO   |     | 0       |                |
| ppp               | int           | NO   |     | 0       |                |
| ploop             | int           | NO   |     | 0       |                |
| dns_nameserver    | text          | YES  |     | NULL    |                |
| osreinstall_limit | int           | NO   |     | 0       |                |
| preferences       | text          | YES  |     | NULL    |                |
| nic_type          | varchar(20)   | NO   |     | NULL    |                |
| vif_type          | varchar(10)   | YES  |     | NULL    |                |
| virtio            | tinyint(1)    | YES  |     | NULL    |                |
| pv_on_hvm         | tinyint       | NO   |     | 0       |                |
| disks             | text          | YES  |     | NULL    |                |
| kvm_cache         | varchar(20)   | NO   |     |         |                |
| io_mode           | varchar(20)   | NO   |     |         |                |
| cpu_mode          | varchar(255)  | NO   |     |         |                |
| total_iops_sec    | bigint        | NO   |     | 0       |                |
| read_bytes_sec    | bigint        | NO   |     | 0       |                |
| write_bytes_sec   | bigint        | NO   |     | 0       |                |
| kvm_vga           | int           | NO   |     | 0       |                |
| acceleration      | int           | NO   |     | 0       |                |
| vnc_keymap        | varchar(20)   | NO   |     |         |                |
| routing           | tinyint(1)    | NO   |     | NULL    |                |
| mg                | text          | YES  |     | NULL    |                |
| used_bandwidth    | decimal(12,2) | NO   |     | 0.00    |                |
| cached_disk       | text          | YES  |     | NULL    |                |
| webuzo            | int           | NO   |     | 0       |                |
| disable_ebtables  | int           | NO   |     | 0       |                |
| install_xentools  | int           | NO   |     | 0       |                |
| admin_managed     | int           | NO   |     | 0       |                |
| rdp               | int           | NO   |     | 0       |                |
| topology_sockets  | int           | NO   |     | 0       |                |
| topology_cores    | int           | NO   |     | 0       |                |
| topology_threads  | int           | NO   |     | 0       |                |
| mac               | varchar(20)   | NO   |     |         |                |
| notes             | text          | YES  |     | NULL    |                |
| disable_nw_config | int           | NO   |     | 0       |                |
| locked            | text          | YES  |     | NULL    |                |
| openvz_features   | text          | YES  |     | NULL    |                |
| speed_cap         | text          | YES  |     | NULL    |                |
| numa              | int           | NO   |     | 0       |                |
| bpid              | int           | NO   |     | 0       |                |
| bserid            | int           | NO   |     | 0       |                |
| timezone          | varchar(50)   | YES  |     | NULL    |                |
| ha                | int           | NO   |     | 0       |                |
| load_balancer     | varchar(50)   | NO   |     | 0       |                |
| data              | text          | YES  |     | NULL    |                |
| fwid              | int           | NO   |     | 0       |                |
| admin_fwid        | int           | NO   |     | 0       |                |
| current_resource  | text          | YES  |     | NULL    |                |
| plan_expiry       | int           | NO   |     | 0       |                |
+-------------------+---------------+------+-----+---------+----------------+
91 rows in set (0.05 sec)

User Table

mysql> desc users;
+------------------+---------------+------+-----+---------+----------------+
| Field            | Type          | Null | Key | Default | Extra          |
+------------------+---------------+------+-----+---------+----------------+
| uid              | int           | NO   | PRI | NULL    | auto_increment |
| password         | varchar(50)   | NO   |     |         |                |
| email            | varchar(255)  | NO   | MUL |         |                |
| type             | int           | NO   |     | 0       |                |
| aclid            | int           | NO   |     | 0       |                |
| pid              | int           | NO   |     | 0       |                |
| uplid            | int           | NO   |     | 0       |                |
| inhouse_billing  | tinyint       | NO   |     | 0       |                |
| cur_bal          | decimal(10,2) | NO   |     | 0.00    |                |
| cur_usage        | decimal(10,2) | NO   |     | 0.00    |                |
| cur_invoices     | decimal(10,2) | NO   |     | 0.00    |                |
| max_cost         | int           | NO   |     | 0       |                |
| num_vs           | int           | NO   |     | 0       |                |
| num_users        | int           | NO   |     | 0       |                |
| space            | int           | NO   |     | 0       |                |
| ram              | int           | NO   |     | 0       |                |
| burst            | int           | NO   |     | 0       |                |
| bandwidth        | int           | NO   |     | 0       |                |
| cpu              | int           | NO   |     | 0       |                |
| cores            | int           | NO   |     | 0       |                |
| cpu_percent      | int           | NO   |     | 0       |                |
| num_cores        | int           | NO   |     | 0       |                |
| num_ipv4         | int           | NO   |     | 0       |                |
| num_ip_int       | int           | NO   |     | 0       |                |
| num_ipv6         | int           | NO   |     | 0       |                |
| num_ipv6_subnet  | int           | NO   |     | 0       |                |
| allowed_virts    | varchar(255)  | NO   |     |         |                |
| network_speed    | int           | NO   |     | 0       |                |
| upload_speed     | int           | NO   |     | 0       |                |
| openvz           | tinyint       | NO   |     | 0       |                |
| xen              | tinyint       | NO   |     | 0       |                |
| xenhvm           | tinyint       | NO   |     | 0       |                |
| kvm              | tinyint       | NO   |     | 0       |                |
| sg               | text          | YES  |     | NULL    |                |
| mg               | text          | YES  |     | NULL    |                |
| preferences      | text          | YES  |     | NULL    |                |
| dnsplid          | int           | NO   |     | NULL    |                |
| act_status       | tinyint       | NO   |     | 1       |                |
| activation_code  | varchar(100)  | NO   |     |         |                |
| date_created     | int           | NO   |     | 0       |                |
| service_period   | int           | NO   |     | 0       |                |
| band_suspend     | int           | NO   |     | 0       |                |
| billing_warn     | text          | YES  |     | NULL    |                |
| suspended        | text          | YES  |     | NULL    |                |
| foreign_uid      | int           | YES  |     | 0       |                |
| webuzo_prem_apps | tinyint       | NO   |     | 0       |                |
| space_per_vm     | int           | NO   |     | 0       |                |
| total_iops_sec   | bigint        | NO   |     | 0       |                |
| read_bytes_sec   | bigint        | NO   |     | 0       |                |
| write_bytes_sec  | bigint        | NO   |     | 0       |                |
| kyc_status       | int           | NO   |     | 0       |                |
| kyc_details      | text          | YES  |     | NULL    |                |
| kyc_last_done    | int           | NO   |     | 0       |                |
| kyc_settings     | text          | YES  |     | NULL    |                |
+------------------+---------------+------+-----+---------+----------------+
54 rows in set (0.02 sec)

Steem to the Moon🚀!