How to initialize mysql database, when exec kratos serve?

[wang-sy]

Version

• kratos: kratos_0.8.1-alpha.1-linux_64bit
• mysql: 5.7.36-0
• os: ubuntu0.18.04.1 (WSL2)

What happend

One sentence summary: When run kratos serve with mysql dsn, it prompts Table'kratos.networks' doesn't exist.

What should I do? Is there any document can point out my mistake?

when i run kratos serve --config="/home/wangsaiyu/go/src/github.com/ory/kratos/contrib/quickstart/kratos/email-password/kratos.yml", I got:

# wangsaiyu @ SaiyuWangPC in ~ [17:01:17] 
$ kratos serve --config="/home/wangsaiyu/go/src/github.com/ory/kratos/contrib/quickstart/kratos/email-password/kratos.yml"
INFO[2021-12-18T17:01:25+08:00] No tracer configured - skipping tracing setup  audience=application service_name=Ory Kratos service_version=v0.8.1-alpha.1
DEBU[2021-12-18T17:01:25+08:00] Connecting to SQL Database                    audience=application connMaxLifetime=0s idlePool=4 pool=20 service_name=Ory Kratos service_version=v0.8.1-alpha.1
WARN[2021-12-18T17:01:25+08:00] Unable to determine network, retrying.        audience=application error=map[debug: message:Error 1146: Table 'kratos.networks' doesn't exist: Unable to locate the table reason: status:Internal Server Error status_code:500] service_name=Ory Kratos service_version=v0.8.1-alpha.1

......

And after running this, no table have been created in the database.

Is mysql-service and account kratos ok?

Yes, they are ok. I can login by:

# wangsaiyu @ SaiyuWangPC in ~ [17:23:01] C:130
$ mysql -ukratos -p123456
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.

I can also select kratos database, and create table, or do any other operations.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| kratos             |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.00 sec)

mysql> use kratos;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

mysql> CREATE TABLE foobar(id INT(8));
Query OK, 0 rows affected (0.04 sec)

mysql> SHOW TABLES;
+------------------+
| Tables_in_kratos |
+------------------+
| foobar           |
+------------------+
1 row in set (0.00 sec)

So I think mysql is healthy, and account kratos in dsn is useable.

my kratos.yml

version: v0.8.1-alpha.1

dsn: mysql://kratos:123456@tcp(localhost:3306)/kratos?max_conns=20&max_idle_conns=4

serve:
  public:
    base_url: http://0.0.0.0:4433/
    cors:
      enabled: true
  admin:
    base_url: http://0.0.0.0:4434/

selfservice:
  default_browser_return_url: http://localhost:4455/
  whitelisted_return_urls:
    - http://localhost:4455/

  methods:
    password:
      enabled: true

  flows:
    error:
      ui_url: http://localhost:4455/error

    settings:
      ui_url: http://localhost:4455/settings
      privileged_session_max_age: 15m

    recovery:
      enabled: true
      ui_url: http://localhost:4455/recovery

    verification:
      enabled: true
      ui_url: http://localhost:4455/verification
      after:
        default_browser_return_url: http://localhost:4455/

    logout:
      after:
        default_browser_return_url: http://localhost:4455/login

    login:
      ui_url: http://localhost:4455/login
      lifespan: 10m

    registration:
      lifespan: 10m
      ui_url: http://localhost:4455/registration
      after:
        password:
          hooks:
            -
              hook: session

log:
  level: debug
  format: text
  leak_sensitive_values: true


identity:
  default_schema_url: file:///home/wangsaiyu/go/src/github.com/ory/kratos/contrib/quickstart/kratos/email-password/identity.schema.json

courier:
  smtp:
    connection_uri: smtps://test:test@mailslurper:1025/?skip_ssl_verify=true

[aeneasr]

You need to run „kratos migrate sql“ to run migrations! See „kratos help migrate sql“.

[wang-sy]

thanks, I have successfully run.

[wang-sy]

Init Kratos Database

export DSN="mysql://kratos:123456@tcp(localhost:3306)/kratos"

kratos migrate sql -e