midas-research / audino Goto Github PK

What?

Currently, users cannot delete entities like labels, label values, projects, users, datapoints etc.
We should include this feature on dashboard as well as expose it through API.

Hello,

When I deploy Audino on macOS M1 I get the following error:

$ sudo docker-compose -f docker-compose.prod.yml up

Running 0/1
⠇ mysql Pulling 1.7s
no matching manifest for linux/arm64/v8 in the manifest list entries

Is this a problem specific to MacOs M1 platforms?

Thanks

What?

Currently, we don't show the filename in annotation dashboard. We can easily add the same.

What?

We should allow users to delete entities like datapoints, labels, label values, users, projects etc. Whether this has to be a soft-delete or hard-delete is something to be discussed and finalized.

What?

In the current workflow, we don't allow users to signup themselves. This seemed necessary in our workflow as we didn't want random users to sign up and access the tool.

However, this is open for discussion. If you have a use-case, kindly share below.

Hi,
After bringing the services up http://0.0.0.0 says the site can't be reached. Please help me fix this issue.

Command used: docker-compose -f docker-compose.prod.yml up

Starting audino_redis_1 ... done
Starting audino_mysql_1 ... done
Starting audino_frontend_1 ... done
Starting audino_backend_1 ... done
Recreating audino_nginx_1 ... done
Attaching to audino_redis_1, audino_frontend_1, audino_mysql_1, audino_backend_1, audino_nginx_1
mysql_1 | 2020-09-22 16:30:11+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.31-1debian10 started.
mysql_1 | 2020-09-22 16:30:11+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
redis_1 | 1:C 22 Sep 2020 16:30:11.272 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
redis_1 | 1:C 22 Sep 2020 16:30:11.272 # Redis version=5.0.8, bits=64, commit=00000000, modified=0, pid=1, just started
redis_1 | 1:C 22 Sep 2020 16:30:11.272 # Configuration loaded
redis_1 | 1:M 22 Sep 2020 16:30:11.274 * Running mode=standalone, port=6379.
audino_frontend_1 exited with code 0
redis_1 | 1:M 22 Sep 2020 16:30:11.275 # WARNING: The TCP backlog setting of 511 cannot be enforced because /proc/sys/net/core/somaxconn is set to the lower value of 128.
redis_1 | 1:M 22 Sep 2020 16:30:11.275 # Server initialized
redis_1 | 1:M 22 Sep 2020 16:30:11.275 # WARNING overcommit_memory is set to 0! Background save may fail under low memory condition. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect.
backend_1 | Connecting to database
mysql_1 | 2020-09-22 16:30:11+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.31-1debian10 started.
mysql_1 | 2020-09-22T16:30:12.291032Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
mysql_1 | 2020-09-22T16:30:12.293497Z 0 [Note] mysqld (mysqld 5.7.31) starting as process 1 ...
mysql_1 | 2020-09-22T16:30:12.297751Z 0 [Note] InnoDB: PUNCH HOLE support available
mysql_1 | 2020-09-22T16:30:12.297974Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
mysql_1 | 2020-09-22T16:30:12.298175Z 0 [Note] InnoDB: Uses event mutexes
mysql_1 | 2020-09-22T16:30:12.298307Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
mysql_1 | 2020-09-22T16:30:12.298438Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
mysql_1 | 2020-09-22T16:30:12.298567Z 0 [Note] InnoDB: Using Linux native AIO
mysql_1 | 2020-09-22T16:30:12.299886Z 0 [Note] InnoDB: Number of pools: 1
mysql_1 | 2020-09-22T16:30:12.302156Z 0 [Note] InnoDB: Using CPU crc32 instructions
mysql_1 | 2020-09-22T16:30:12.305290Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
mysql_1 | 2020-09-22T16:30:12.320483Z 0 [Note] InnoDB: Completed initialization of buffer pool
mysql_1 | 2020-09-22T16:30:12.325605Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
mysql_1 | 2020-09-22T16:30:12.344124Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
mysql_1 | 2020-09-22T16:30:12.384258Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
mysql_1 | 2020-09-22T16:30:12.384701Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
mysql_1 | 2020-09-22T16:30:12.411574Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
mysql_1 | 2020-09-22T16:30:12.412574Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
mysql_1 | 2020-09-22T16:30:12.412696Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
mysql_1 | 2020-09-22T16:30:12.413252Z 0 [Note] InnoDB: Waiting for purge to start
mysql_1 | 2020-09-22T16:30:12.463639Z 0 [Note] InnoDB: 5.7.31 started; log sequence number 12852515
mysql_1 | 2020-09-22T16:30:12.464479Z 0 [Note] Plugin 'FEDERATED' is disabled.
mysql_1 | 2020-09-22T16:30:12.464863Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
mysql_1 | 2020-09-22T16:30:12.502210Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
mysql_1 | 2020-09-22T16:30:12.502654Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
mysql_1 | 2020-09-22T16:30:12.506530Z 0 [Warning] CA certificate ca.pem is self signed.
mysql_1 | 2020-09-22T16:30:12.507453Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
mysql_1 | 2020-09-22T16:30:12.510383Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
mysql_1 | 2020-09-22T16:30:12.510881Z 0 [Note] IPv6 is available.
mysql_1 | 2020-09-22T16:30:12.511185Z 0 [Note] - '::' resolves to '::';
mysql_1 | 2020-09-22T16:30:12.513471Z 0 [Note] Server socket created on IP: '::'.
mysql_1 | 2020-09-22T16:30:12.516365Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
mysql_1 | 2020-09-22T16:30:12.524127Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200922 16:30:12
mysql_1 | 2020-09-22T16:30:12.562397Z 0 [Note] Event Scheduler: Loaded 0 events
mysql_1 | 2020-09-22T16:30:12.562793Z 0 [Note] Execution of init_file '/mysql/create_database.sql' started.
mysql_1 | 2020-09-22T16:30:12.566627Z 0 [Note] Execution of init_file '/mysql/create_database.sql' ended.
backend_1 | Couldn't connect to MySQL: 0/30
mysql_1 | 2020-09-22T16:30:12.566910Z 0 [Note] mysqld: ready for connections.
mysql_1 | Version: '5.7.31' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL)
backend_1 | Connected to database
backend_1 | Applying new migrations
backend_1 | INFO [alembic.runtime.migration] Context impl MySQLImpl.
backend_1 | INFO [alembic.runtime.migration] Will assume non-transactional DDL.
backend_1 | INFO [alembic.env] No changes in schema detected.
backend_1 | INFO [alembic.runtime.migration] Context impl MySQLImpl.
backend_1 | INFO [alembic.runtime.migration] Will assume non-transactional DDL.
mysql_1 | 2020-09-22T16:30:17.321763Z 3 [Note] Aborted connection 3 to db: 'audino' user: 'audino' host: '192.168.192.4' (Got an error reading communication packets)
backend_1 | Creating account for admin
backend_1 | Error creating admin user
backend_1 | (pymysql.err.IntegrityError) (1062, "Duplicate entry 'admin' for key 'ix_user_username'")
backend_1 | [SQL: INSERT INTO user (username, password, role_id, created_at, last_modified) VALUES (%(username)s, %(password)s, %(role_id)s, now(), now())]
backend_1 | [parameters: {'username': 'admin', 'password': 'pbkdf2:sha256:150000$nZz4O4ZL$da08ee4cd9683e9cdb9a571c60e8670f10801b2bfc207644d5f1ebb68c1cabfd', 'role_id': 1}]
backend_1 | (Background on this error at: http://sqlalche.me/e/gkpj)
backend_1 | Starting flask production server
backend_1 | [uWSGI] getting INI configuration from uwsgi.ini
backend_1 | *** Starting uWSGI 2.0.18 (64bit) on [Tue Sep 22 16:30:19 2020] ***
backend_1 | compiled with version: 9.3.0 on 22 September 2020 09:56:14
backend_1 | os: Linux-4.19.130-boot2docker #1 SMP Mon Jun 29 23:52:55 UTC 2020
backend_1 | nodename: 38262ddbfafa
backend_1 | machine: x86_64
backend_1 | clock source: unix
backend_1 | pcre jit disabled
backend_1 | detected number of CPU cores: 1
backend_1 | current working directory: /app
backend_1 | detected binary path: /usr/local/bin/uwsgi
backend_1 | uWSGI running as root, you can use --uid/--gid/--chroot options
backend_1 | *** WARNING: you are running uWSGI as root !!! (use the --uid flag) ***
backend_1 | your memory page size is 4096 bytes
backend_1 | detected max file descriptor number: 1048576
backend_1 | lock engine: pthread robust mutexes
backend_1 | thunder lock: disabled (you can enable it with --thunder-lock)
backend_1 | uWSGI http bound on 0.0.0.0:5000 fd 4
backend_1 | uwsgi socket 0 bound to TCP address 127.0.0.1:45089 (port auto-assigned) fd 3
backend_1 | uWSGI running as root, you can use --uid/--gid/--chroot options
backend_1 | *** WARNING: you are running uWSGI as root !!! (use the --uid flag) ***
backend_1 | Python version: 3.7.9 (default, Aug 18 2020, 04:02:05) [GCC 9.3.0]
backend_1 | *** Python threads support is disabled. You can enable it with --enable-threads ***
backend_1 | Python main interpreter initialized at 0x55b1984ee100
backend_1 | uWSGI running as root, you can use --uid/--gid/--chroot options
backend_1 | *** WARNING: you are running uWSGI as root !!! (use the --uid flag) ***
backend_1 | your server socket listen backlog is limited to 100 connections
backend_1 | your mercy for graceful operations on workers is 60 seconds
backend_1 | mapped 437424 bytes (427 KB) for 5 cores
backend_1 | *** Operational MODE: preforking ***
backend_1 | WSGI app 0 (mountpoint='') ready in 0 seconds on interpreter 0x55b1984ee100 pid: 12 (default app)
backend_1 | uWSGI running as root, you can use --uid/--gid/--chroot options
backend_1 | *** WARNING: you are running uWSGI as root !!! (use the --uid flag) ***
backend_1 | *** uWSGI is running in multiple interpreter mode ***
backend_1 | spawned uWSGI master process (pid: 12)
backend_1 | spawned uWSGI worker 1 (pid: 13, cores: 1)
backend_1 | spawned uWSGI worker 2 (pid: 14, cores: 1)
backend_1 | spawned uWSGI worker 3 (pid: 15, cores: 1)
backend_1 | spawned uWSGI worker 4 (pid: 16, cores: 1)
backend_1 | spawned uWSGI worker 5 (pid: 17, cores: 1)

What?

Currently, on annotation screen, the user doesn't get notified if the segment was saved or not. We should notify the user once it is saved.

Starting audino_redis_1 ... done
Starting audino_mysql_1 ... done
Starting audino_frontend_1 ... done
Starting audino_backend_1 ... done
Starting audino_nginx_1 ... done
Attaching to audino_redis_1, audino_frontend_1, audino_mysql_1, audino_backend_1, audino_nginx_1
backend_1 | Connecting to database
redis_1 | 1:C 04 Jan 2021 09:22:07.781 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
redis_1 | 1:C 04 Jan 2021 09:22:07.781 # Redis version=5.0.8, bits=64, commit=00000000, modified=0, pid=1, just started
redis_1 | 1:C 04 Jan 2021 09:22:07.781 # Configuration loaded
mysql_1 | 2021-01-04 09:22:07+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.32-1debian10 started.
mysql_1 | 2021-01-04 09:22:08+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
mysql_1 | 2021-01-04 09:22:08+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.32-1debian10 started.
mysql_1 | 2021-01-04 09:22:08+00:00 [Note] [Entrypoint]: Initializing database files
mysql_1 | 2021-01-04T09:22:08.380664Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
mysql_1 | 2021-01-04T09:22:08.383814Z 0 [ERROR] --initialize specified but the data directory has files in it. Aborting.
mysql_1 | 2021-01-04T09:22:08.383986Z 0 [ERROR] Aborting
mysql_1 |
redis_1 | 1:M 04 Jan 2021 09:22:07.788 * Running mode=standalone, port=6379.
redis_1 | 1:M 04 Jan 2021 09:22:07.788 # Server initialized
redis_1 | 1:M 04 Jan 2021 09:22:07.788 # WARNING you have Transparent Huge Pages (THP) support enabled in your kernel. This will create latency and memory usage issues with Redis. To fix this issue run the command 'echo never > /sys/kernel/mm/transparent_hugepage/enabled' as root, and add it to your /etc/rc.local in order to retain the setting after a reboot. Redis must be restarted after THP is disabled.
redis_1 | 1:M 04 Jan 2021 09:22:07.788 * Ready to accept connections
audino_frontend_1 exited with code 0
audino_mysql_1 exited with code 1
backend_1 | Couldn't connect to MySQL: 0/30
backend_1 | Couldn't connect to MySQL: 1/30
backend_1 | Couldn't connect to MySQL: 2/30
^CGracefully stopping... (press Ctrl+C again to force)
Stopping audino_nginx_1 ... done
Stopping audino_backend_1 ... done
Stopping audino_redis_1 ... done

What?

Currently, there is no pagination user, admin, labels and label values dashboard. This is easy to add as it has been implemented on projects dashboard. However, I think we should include searchable tables along with this which makes things complicated. We need to find an appropriate solution for this.

What?

We should add an appropriate license in order to make it accessible to the research community and non-commercial users.

Hi Midas team,

We have successfully installed and deployed the tool, created projects, assigned users , created labels (and their values) assigned to the project. However, when both users (admin or normal) navigate to Projects / Data and click on the audio file under Yet to annotate, the only available section is the preview part. Where is the annotation section?

We deployed the tool on Linux.

Hi,
I try to use Audino, followed by the instructions.
I use: Windows 10, Git and Docker
after running the commands from cmd I got this message:

nginx_1     | 2020/06/15 08:50:56 [emerg] 1#1: host not found in upstream "backend" in /etc/nginx/nginx.conf:52
nginx_1     | nginx: [emerg] host not found in upstream "backend" in /etc/nginx/nginx.conf:52
audino_nginx_1 exited with code 1

This is my docker status:

What I'm doing wrong? Thank you for your help

What?

Currently, API manually throws its own messages and errors. We should move them to werkzeug exceptions.

Hi ,
I have cloned the project and ran it, but when I am trying to execute the example upload I get an invalid syntax problem from the attached python script upload_data.py. Not sure if I am doing something wrong here, I have also tried to send the request via Postman but I am unclear as to how to send a .wav file along with username credentials in the same JSON file.

What?

Currently, most of the assets were one-time drawn and are not editable. To reduce future effort, these assets need to be converted to draw.io for easy editing.

Great work team, really enjoyed audino, using it first hand tells you how it has been geared towards production, especially the data uploading logic is just amazing. Really love what you guys have done I feel just a few features and this would be a really amazing product.

I have seen similar issues requesting CRUD operations for users and data, I would like to add to allow it for projects too. Thank you for your hard work !

I tried to make it work on instance with Amazon Linux 2 AMI. The docker-compose up command seems to get stuck saying :

`

[ec2-user@ip-172-31-58-110 audino]$ docker-compose -f docker-compose.prod.yml up  
audino_mysql_1 is up-to-date
audino_redis_1 is up-to-date
Starting audino_frontend_1 ... 
audino_backend_1 is up-to-date
Starting audino_frontend_1 ... done
Attaching to audino_mysql_1, audino_redis_1, audino_backend_1, audino_nginx_1, audino_frontend_1
backend_1   | Connecting to database
backend_1   | Couldn't connect to MySQL: 0/30
backend_1   | Couldn't connect to MySQL: 1/30
backend_1   | Connected to database
backend_1   | Applying new migrations
backend_1   | INFO  [alembic.runtime.migration] Context impl MySQLImpl.
backend_1   | INFO  [alembic.runtime.migration] Will assume non-transactional DDL.
backend_1   | ERROR [root] Error: Target database is not up to date.
backend_1   | INFO  [alembic.runtime.migration] Context impl MySQLImpl.
backend_1   | INFO  [alembic.runtime.migration] Will assume non-transactional DDL.
backend_1   | INFO  [alembic.runtime.migration] Running upgrade  -> 41629491ef4a, empty message
backend_1   | INFO  [alembic.runtime.migration] Running upgrade 41629491ef4a -> b60bb67d1758, empty message
backend_1   | Creating account for admin
backend_1   | Account created!
backend_1   | Starting flask production server
backend_1   | [uWSGI] getting INI configuration from uwsgi.ini
backend_1   | *** Starting uWSGI 2.0.18 (64bit) on [Sun Aug  9 11:58:28 2020] ***
backend_1   | compiled with version: 9.3.0 on 09 August 2020 11:54:43
backend_1   | os: Linux-4.14.186-146.268.amzn2.x86_64 #1 SMP Tue Jul 14 18:16:52 UTC 2020
backend_1   | nodename: b41de29733b7
backend_1   | machine: x86_64
backend_1   | clock source: unix
backend_1   | pcre jit disabled
backend_1   | detected number of CPU cores: 1
backend_1   | current working directory: /app
backend_1   | detected binary path: /usr/local/bin/uwsgi
backend_1   | uWSGI running as root, you can use --uid/--gid/--chroot options
backend_1   | *** WARNING: you are running uWSGI as root !!! (use the --uid flag) *** 
backend_1   | your memory page size is 4096 bytes
backend_1   | detected max file descriptor number: 1024
backend_1   | lock engine: pthread robust mutexes
backend_1   | thunder lock: disabled (you can enable it with --thunder-lock)
backend_1   | uWSGI http bound on 0.0.0.0:5000 fd 4
backend_1   | uwsgi socket 0 bound to TCP address 127.0.0.1:43559 (port auto-assigned) fd 3
backend_1   | uWSGI running as root, you can use --uid/--gid/--chroot options
backend_1   | *** WARNING: you are running uWSGI as root !!! (use the --uid flag) *** 
backend_1   | Python version: 3.7.8 (default, Aug  4 2020, 05:06:20)  [GCC 9.3.0]
backend_1   | *** Python threads support is disabled. You can enable it with --enable-threads ***
backend_1   | Python main interpreter initialized at 0x5574ed19c100
backend_1   | uWSGI running as root, you can use --uid/--gid/--chroot options
backend_1   | *** WARNING: you are running uWSGI as root !!! (use the --uid flag) *** 
backend_1   | your server socket listen backlog is limited to 100 connections
backend_1   | your mercy for graceful operations on workers is 60 seconds
backend_1   | mapped 437424 bytes (427 KB) for 5 cores
backend_1   | *** Operational MODE: preforking ***
backend_1   | WSGI app 0 (mountpoint='') ready in 0 seconds on interpreter 0x5574ed19c100 pid: 12 (default app)
backend_1   | uWSGI running as root, you can use --uid/--gid/--chroot options
backend_1   | *** WARNING: you are running uWSGI as root !!! (use the --uid flag) *** 
backend_1   | *** uWSGI is running in multiple interpreter mode ***
backend_1   | spawned uWSGI master process (pid: 12)
backend_1   | spawned uWSGI worker 1 (pid: 13, cores: 1)
backend_1   | spawned uWSGI worker 2 (pid: 14, cores: 1)
backend_1   | spawned uWSGI worker 3 (pid: 15, cores: 1)
backend_1   | spawned uWSGI worker 4 (pid: 16, cores: 1)
backend_1   | spawned uWSGI worker 5 (pid: 17, cores: 1)
backend_1   | spawned uWSGI http 1 (pid: 18)
mysql_1     | 2020-08-09 11:58:12+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.31-1debian10 started.
mysql_1     | 2020-08-09 11:58:13+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
mysql_1     | 2020-08-09 11:58:13+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.31-1debian10 started.
mysql_1     | 2020-08-09 11:58:13+00:00 [Note] [Entrypoint]: Initializing database files
mysql_1     | 2020-08-09T11:58:13.354942Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
mysql_1     | 2020-08-09T11:58:13.355001Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
mysql_1     | 2020-08-09T11:58:13.355151Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
mysql_1     | 2020-08-09T11:58:14.197933Z 0 [Warning] InnoDB: New log files created, LSN=45790
mysql_1     | 2020-08-09T11:58:14.453245Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
mysql_1     | 2020-08-09T11:58:14.532855Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 9aea5d4a-da37-11ea-80f0-0242ac130003.
mysql_1     | 2020-08-09T11:58:14.534245Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
mysql_1     | 2020-08-09T11:58:16.449160Z 0 [Warning] CA certificate ca.pem is self signed.
mysql_1     | 2020-08-09T11:58:16.522554Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
mysql_1     | 2020-08-09 11:58:18+00:00 [Note] [Entrypoint]: Database files initialized
mysql_1     | 2020-08-09 11:58:18+00:00 [Note] [Entrypoint]: Starting temporary server
mysql_1     | 2020-08-09 11:58:18+00:00 [Note] [Entrypoint]: Waiting for server startup
mysql_1     | 2020-08-09T11:58:18.500651Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
mysql_1     | 2020-08-09T11:58:18.500695Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
mysql_1     | 2020-08-09T11:58:18.667836Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
mysql_1     | 2020-08-09T11:58:18.672500Z 0 [Note] mysqld (mysqld 5.7.31) starting as process 77 ...
mysql_1     | 2020-08-09T11:58:18.677115Z 0 [Note] InnoDB: PUNCH HOLE support available
mysql_1     | 2020-08-09T11:58:18.677457Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
mysql_1     | 2020-08-09T11:58:18.677765Z 0 [Note] InnoDB: Uses event mutexes
mysql_1     | 2020-08-09T11:58:18.678065Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
mysql_1     | 2020-08-09T11:58:18.678369Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
mysql_1     | 2020-08-09T11:58:18.678655Z 0 [Note] InnoDB: Using Linux native AIO
mysql_1     | 2020-08-09T11:58:18.679170Z 0 [Note] InnoDB: Number of pools: 1
mysql_1     | 2020-08-09T11:58:18.679559Z 0 [Note] InnoDB: Using CPU crc32 instructions
mysql_1     | 2020-08-09T11:58:18.681508Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
mysql_1     | 2020-08-09T11:58:18.690456Z 0 [Note] InnoDB: Completed initialization of buffer pool
mysql_1     | 2020-08-09T11:58:18.696663Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
mysql_1     | 2020-08-09T11:58:18.709633Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
mysql_1     | 2020-08-09T11:58:18.719033Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
mysql_1     | 2020-08-09T11:58:18.719538Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
mysql_1     | 2020-08-09T11:58:18.774176Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
mysql_1     | 2020-08-09T11:58:18.775482Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
mysql_1     | 2020-08-09T11:58:18.775825Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
mysql_1     | 2020-08-09T11:58:18.776402Z 0 [Note] InnoDB: Waiting for purge to start
mysql_1     | 2020-08-09T11:58:18.826915Z 0 [Note] InnoDB: 5.7.31 started; log sequence number 2720539
mysql_1     | 2020-08-09T11:58:18.827701Z 0 [Note] Plugin 'FEDERATED' is disabled.
mysql_1     | 2020-08-09T11:58:18.834192Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
mysql_1     | 2020-08-09T11:58:18.834606Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
mysql_1     | 2020-08-09T11:58:18.835416Z 0 [Warning] CA certificate ca.pem is self signed.
mysql_1     | 2020-08-09T11:58:18.834595Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
mysql_1     | 2020-08-09T11:58:18.837332Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
mysql_1     | 2020-08-09T11:58:18.838152Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200809 11:58:18
mysql_1     | 2020-08-09T11:58:18.839186Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
mysql_1     | 2020-08-09T11:58:18.847622Z 0 [Note] Event Scheduler: Loaded 0 events
mysql_1     | 2020-08-09T11:58:18.848054Z 0 [Note] Execution of init_file '/mysql/create_database.sql' started.
mysql_1     | 2020-08-09T11:58:18.848619Z 0 [Note] Execution of init_file '/mysql/create_database.sql' ended.
mysql_1     | 2020-08-09T11:58:18.848976Z 0 [Note] mysqld: ready for connections.
mysql_1     | Version: '5.7.31'  socket: '/var/run/mysqld/mysqld.sock'  port: 0  MySQL Community Server (GPL)
mysql_1     | 2020-08-09 11:58:19+00:00 [Note] [Entrypoint]: Temporary server started.
mysql_1     | Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
mysql_1     | Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
mysql_1     | Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
mysql_1     | Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
mysql_1     | 2020-08-09 11:58:21+00:00 [Note] [Entrypoint]: Creating database audino
mysql_1     | 2020-08-09 11:58:21+00:00 [Note] [Entrypoint]: Creating user audino
mysql_1     | 2020-08-09 11:58:21+00:00 [Note] [Entrypoint]: Giving user audino access to schema audino
mysql_1     | 
mysql_1     | 2020-08-09 11:58:21+00:00 [Note] [Entrypoint]: Stopping temporary server
mysql_1     | 2020-08-09T11:58:21.333933Z 0 [Note] Giving 0 client threads a chance to die gracefully
mysql_1     | 2020-08-09T11:58:21.334352Z 0 [Note] Shutting down slave threads
mysql_1     | 2020-08-09T11:58:21.334669Z 0 [Note] Forcefully disconnecting 0 remaining clients
mysql_1     | 2020-08-09T11:58:21.334982Z 0 [Note] Event Scheduler: Purging the queue. 0 events
mysql_1     | 2020-08-09T11:58:21.335329Z 0 [Note] Binlog end
mysql_1     | 2020-08-09T11:58:21.336009Z 0 [Note] Shutting down plugin 'ngram'
mysql_1     | 2020-08-09T11:58:21.336333Z 0 [Note] Shutting down plugin 'partition'
mysql_1     | 2020-08-09T11:58:21.336642Z 0 [Note] Shutting down plugin 'BLACKHOLE'
mysql_1     | 2020-08-09T11:58:21.336943Z 0 [Note] Shutting down plugin 'ARCHIVE'
redis_1     | 1:C 09 Aug 2020 11:58:12.799 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
redis_1     | 1:C 09 Aug 2020 11:58:12.799 # Redis version=5.0.8, bits=64, commit=00000000, modified=0, pid=1, just started
redis_1     | 1:C 09 Aug 2020 11:58:12.799 # Configuration loaded
redis_1     | 1:M 09 Aug 2020 11:58:12.801 # You requested maxclients of 10000 requiring at least 10032 max file descriptors.
redis_1     | 1:M 09 Aug 2020 11:58:12.801 # Server can't set maximum open files to 10032 because of OS error: Operation not permitted.
redis_1     | 1:M 09 Aug 2020 11:58:12.801 # Current maximum open files is 4096. maxclients has been reduced to 4064 to compensate for low ulimit. If you need higher maxclients increase 'ulimit -n'.
redis_1     | 1:M 09 Aug 2020 11:58:12.804 * Running mode=standalone, port=6379.
redis_1     | 1:M 09 Aug 2020 11:58:12.804 # WARNING: The TCP backlog setting of 511 cannot be enforced because /proc/sys/net/core/somaxconn is set to the lower value of 128.
redis_1     | 1:M 09 Aug 2020 11:58:12.804 # Server initialized
redis_1     | 1:M 09 Aug 2020 11:58:12.804 # WARNING overcommit_memory is set to 0! Background save may fail under low memory condition. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect.
redis_1     | 1:M 09 Aug 2020 11:58:12.805 # WARNING you have Transparent Huge Pages (THP) support enabled in your kernel. This will create latency and memory usage issues with Redis. To fix this issue run the command 'echo never > /sys/kernel/mm/transparent_hugepage/enabled' as root, and add it to your /etc/rc.local in order to retain the setting after a reboot. Redis must be restarted after THP is disabled.
redis_1     | 1:M 09 Aug 2020 11:58:12.805 * Ready to accept connections
mysql_1     | 2020-08-09T11:58:21.337241Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
mysql_1     | 2020-08-09T11:58:21.337586Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
mysql_1     | 2020-08-09T11:58:21.337890Z 0 [Note] Shutting down plugin 'MyISAM'
mysql_1     | 2020-08-09T11:58:21.338194Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
mysql_1     | 2020-08-09T11:58:21.338494Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
mysql_1     | 2020-08-09T11:58:21.338797Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
mysql_1     | 2020-08-09T11:58:21.339115Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
mysql_1     | 2020-08-09T11:58:21.339408Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
mysql_1     | 2020-08-09T11:58:21.339681Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
mysql_1     | 2020-08-09T11:58:21.339971Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
mysql_1     | 2020-08-09T11:58:21.340240Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
mysql_1     | 2020-08-09T11:58:21.340508Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
mysql_1     | 2020-08-09T11:58:21.340779Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
mysql_1     | 2020-08-09T11:58:21.341080Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
mysql_1     | 2020-08-09T11:58:21.341410Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
mysql_1     | 2020-08-09T11:58:21.341727Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
mysql_1     | 2020-08-09T11:58:21.342029Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
mysql_1     | 2020-08-09T11:58:21.342342Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
mysql_1     | 2020-08-09T11:58:21.342648Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
mysql_1     | 2020-08-09T11:58:21.342950Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
mysql_1     | 2020-08-09T11:58:21.343254Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
mysql_1     | 2020-08-09T11:58:21.343558Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
mysql_1     | 2020-08-09T11:58:21.343864Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
mysql_1     | 2020-08-09T11:58:21.343911Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
mysql_1     | 2020-08-09T11:58:21.343917Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
mysql_1     | 2020-08-09T11:58:21.343920Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
mysql_1     | 2020-08-09T11:58:21.343923Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
mysql_1     | 2020-08-09T11:58:21.343926Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
mysql_1     | 2020-08-09T11:58:21.343929Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
mysql_1     | 2020-08-09T11:58:21.343931Z 0 [Note] Shutting down plugin 'INNODB_CMP'
mysql_1     | 2020-08-09T11:58:21.343934Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
mysql_1     | 2020-08-09T11:58:21.343937Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
mysql_1     | 2020-08-09T11:58:21.343940Z 0 [Note] Shutting down plugin 'INNODB_TRX'
mysql_1     | 2020-08-09T11:58:21.343943Z 0 [Note] Shutting down plugin 'InnoDB'
mysql_1     | 2020-08-09T11:58:21.345112Z 0 [Note] InnoDB: FTS optimize thread exiting.
mysql_1     | 2020-08-09T11:58:21.345259Z 0 [Note] InnoDB: Starting shutdown...
mysql_1     | 2020-08-09T11:58:21.445458Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
mysql_1     | 2020-08-09T11:58:21.446430Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 200809 11:58:21
mysql_1     | 2020-08-09T11:58:22.655873Z 0 [Note] InnoDB: Shutdown completed; log sequence number 12578700
mysql_1     | 2020-08-09T11:58:22.658097Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
mysql_1     | 2020-08-09T11:58:22.658448Z 0 [Note] Shutting down plugin 'MEMORY'
mysql_1     | 2020-08-09T11:58:22.658764Z 0 [Note] Shutting down plugin 'CSV'
mysql_1     | 2020-08-09T11:58:22.659065Z 0 [Note] Shutting down plugin 'sha256_password'
mysql_1     | 2020-08-09T11:58:22.659363Z 0 [Note] Shutting down plugin 'mysql_native_password'
mysql_1     | 2020-08-09T11:58:22.659780Z 0 [Note] Shutting down plugin 'binlog'
mysql_1     | 2020-08-09T11:58:22.660412Z 0 [Note] mysqld: Shutdown complete
mysql_1     | 
mysql_1     | 2020-08-09 11:58:23+00:00 [Note] [Entrypoint]: Temporary server stopped
mysql_1     | 
mysql_1     | 2020-08-09 11:58:23+00:00 [Note] [Entrypoint]: MySQL init process done. Ready for start up.
mysql_1     | 
mysql_1     | 2020-08-09T11:58:23.354834Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
mysql_1     | 2020-08-09T11:58:23.354884Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
mysql_1     | 2020-08-09T11:58:23.523097Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
mysql_1     | 2020-08-09T11:58:23.525639Z 0 [Note] mysqld (mysqld 5.7.31) starting as process 1 ...
mysql_1     | 2020-08-09T11:58:23.530225Z 0 [Note] InnoDB: PUNCH HOLE support available
mysql_1     | 2020-08-09T11:58:23.530573Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
mysql_1     | 2020-08-09T11:58:23.530878Z 0 [Note] InnoDB: Uses event mutexes
mysql_1     | 2020-08-09T11:58:23.531187Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
mysql_1     | 2020-08-09T11:58:23.531489Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
mysql_1     | 2020-08-09T11:58:23.531797Z 0 [Note] InnoDB: Using Linux native AIO
mysql_1     | 2020-08-09T11:58:23.532330Z 0 [Note] InnoDB: Number of pools: 1
mysql_1     | 2020-08-09T11:58:23.532726Z 0 [Note] InnoDB: Using CPU crc32 instructions
mysql_1     | 2020-08-09T11:58:23.534717Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
mysql_1     | 2020-08-09T11:58:23.543772Z 0 [Note] InnoDB: Completed initialization of buffer pool
mysql_1     | 2020-08-09T11:58:23.546492Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
mysql_1     | 2020-08-09T11:58:23.558317Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
mysql_1     | 2020-08-09T11:58:23.567339Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
mysql_1     | 2020-08-09T11:58:23.567908Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
mysql_1     | 2020-08-09T11:58:23.603233Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
mysql_1     | 2020-08-09T11:58:23.604572Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
mysql_1     | 2020-08-09T11:58:23.604899Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
mysql_1     | 2020-08-09T11:58:23.605489Z 0 [Note] InnoDB: Waiting for purge to start
mysql_1     | 2020-08-09T11:58:23.656009Z 0 [Note] InnoDB: 5.7.31 started; log sequence number 12578700
mysql_1     | 2020-08-09T11:58:23.656794Z 0 [Note] Plugin 'FEDERATED' is disabled.
mysql_1     | 2020-08-09T11:58:23.663441Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
mysql_1     | 2020-08-09T11:58:23.663901Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
mysql_1     | 2020-08-09T11:58:23.664707Z 0 [Warning] CA certificate ca.pem is self signed.
mysql_1     | 2020-08-09T11:58:23.663891Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
mysql_1     | 2020-08-09T11:58:23.668497Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200809 11:58:23
mysql_1     | 2020-08-09T11:58:23.668848Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
mysql_1     | 2020-08-09T11:58:23.669589Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
mysql_1     | 2020-08-09T11:58:23.669928Z 0 [Note] IPv6 is available.
mysql_1     | 2020-08-09T11:58:23.670229Z 0 [Note]   - '::' resolves to '::';
mysql_1     | 2020-08-09T11:58:23.670531Z 0 [Note] Server socket created on IP: '::'.
mysql_1     | 2020-08-09T11:58:23.672070Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
mysql_1     | 2020-08-09T11:58:23.681056Z 0 [Note] Event Scheduler: Loaded 0 events
mysql_1     | 2020-08-09T11:58:23.681574Z 0 [Note] Execution of init_file '/mysql/create_database.sql' started.
mysql_1     | 2020-08-09T11:58:23.682169Z 0 [Note] Execution of init_file '/mysql/create_database.sql' ended.
mysql_1     | 2020-08-09T11:58:23.682545Z 0 [Note] mysqld: ready for connections.
mysql_1     | Version: '5.7.31'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server (GPL)
mysql_1     | 2020-08-09T11:58:25.390428Z 3 [Note] Aborted connection 3 to db: 'audino' user: 'audino' host: '172.19.0.4' (Got an error reading communication packets)
mysql_1     | 2020-08-09T11:58:28.049464Z 6 [Note] Aborted connection 6 to db: 'audino' user: 'audino' host: '172.19.0.4' (Got an error reading communication packets)
audino_frontend_1 exited with code 0

`

Hi
Great project and thanks all.
But please add a picture to readme since the user sense your project.
this picture show whole of your project well, however not in readme.
https://github.com/midas-research/audino/blob/master/docs/tutorials/annotation-dashboard.md

best regards

What?

Currently, there is no explicit linting in the project. Need to integrate it and add it to travis.

Hi,
During data upload, a username is mandatory. Once uploaded, the content is only viewable/taggable for this specific user. I was expecting a content to be linked to a project and any user in that project to be able to tag content.
I think that a global view of contents in admin area with the ability to add/remove users and contents would be great.

Otherwise I like your gui except the need to click on the audio segment to display tags (but once you know it, it is no big deal :) ).

What?

Currently, users cannot reset password. This is an easy feature to add where we create a settings page and allow users to change passwords. We should also add this feature in tutorials.

What?

Currently, there is no testing in the project. We should perform robust testing across the project for identifying bugs and fixing them.

What?

Currently, user has to extract annotations directly from database. We should provide a download option on frontend itself.

Hi, your software is great but it seems the delete capability is missing for many items (such as users, projects and audios).

We were thinking about labeling things like chorus and guitar solo's and the like using audino. Do you have any support for that?

HI Midas team,
I uploaded a long audio ~20-25 mins the audio in UI didn't load fully, it only loaded upto 2-3 mins. I was working on Chrome and I checked the Developper Tools console for the browser and got the below error

I tried clearing up the cache and also switched to a different browser but I am getting the same error.

Any advice would be highly appreciated.

Thanks in advance

Hi MIDAS team,

Awesome work making this! I have a quick query on usage/working of the "For review" tab. I see that whenever a file is uploaded, no other user can access it except the user it is uploaded for. After annotating, The overall labelled file can be downloaded, but they cannot approved by on the UI (In the dashboard under projects).

Ideally, an annotation approver needs to go through the transcription/labels, and approve them for multiple transcribers/annotators. Is there a way to have any approver look at the annotation done on audio? Is there a way another user can review the annotations? am I missing something?

Hi. I cloned the project. builded for production and now project is up.

I can Upload data with no segmentation but When using segmentation
I use what you said in tutorial for uploading data with my own proper API KEY :
API_KEY=6640ff26f31e4c20a14af4c2ff1992cb python3 upload_data.py --username admin --is_marked_for_review True --audio_file OSR_us_000_0010_8k.wav --host localhost --port 5000 --segmentations '[ { "annotations": { "testing this": { "values": [ "4", "5" ] } }, "end_time": 7.7407, "start_time": 3.8604, "transcription": "Sample transcription data" }, { "end_time": 17.7407, "start_time": 13.8604, "transcription": "Sample transcription data" }]'
I get this error :

raise ConnectionError(e, request=request) requests.exceptions.ConnectionError: HTTPConnectionPool(host='localhost', port=5000): Max retries exceeded with url: /api/data (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x7f8499b6fb00>: Failed to establish a new connection: [Errno 111] Connection refused',))

To see full Log :
Creating datapoint Traceback (most recent call last): File "/usr/lib/python3/dist-packages/urllib3/connection.py", line 141, in _new_conn (self.host, self.port), self.timeout, **extra_kw) File "/usr/lib/python3/dist-packages/urllib3/util/connection.py", line 83, in create_connection raise err File "/usr/lib/python3/dist-packages/urllib3/util/connection.py", line 73, in create_connection sock.connect(sa) ConnectionRefusedError: [Errno 111] Connection refused During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/usr/lib/python3/dist-packages/urllib3/connectionpool.py", line 601, in urlopen chunked=chunked) File "/usr/lib/python3/dist-packages/urllib3/connectionpool.py", line 357, in _make_request conn.request(method, url, **httplib_request_kw) File "/usr/lib/python3.6/http/client.py", line 1264, in request self._send_request(method, url, body, headers, encode_chunked) File "/usr/lib/python3.6/http/client.py", line 1310, in _send_request self.endheaders(body, encode_chunked=encode_chunked) File "/usr/lib/python3.6/http/client.py", line 1259, in endheaders self._send_output(message_body, encode_chunked=encode_chunked) File "/usr/lib/python3.6/http/client.py", line 1038, in _send_output self.send(msg) File "/usr/lib/python3.6/http/client.py", line 976, in send self.connect() File "/usr/lib/python3/dist-packages/urllib3/connection.py", line 166, in connect conn = self._new_conn() File "/usr/lib/python3/dist-packages/urllib3/connection.py", line 150, in _new_conn self, "Failed to establish a new connection: %s" % e) urllib3.exceptions.NewConnectionError: <urllib3.connection.HTTPConnection object at 0x7f8499b6fb00>: Failed to establish a new connection: [Errno 111] Connection refused During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/usr/local/lib/python3.6/dist-packages/requests/adapters.py", line 449, in send timeout=timeout File "/usr/lib/python3/dist-packages/urllib3/connectionpool.py", line 639, in urlopen _stacktrace=sys.exc_info()[2]) File "/usr/lib/python3/dist-packages/urllib3/util/retry.py", line 398, in increment raise MaxRetryError(_pool, url, error or ResponseError(cause)) urllib3.exceptions.MaxRetryError: HTTPConnectionPool(host='localhost', port=5000): Max retries exceeded with url: /api/data (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x7f8499b6fb00>: Failed to establish a new connection: [Errno 111] Connection refused',)) During handling of the above exception, another exception occurred: Traceback (most recent call last): File "upload_data.py", line 73, in <module> f"http://{args.host}:{args.port}/api/data", files=file, data=values, headers=headers File "/usr/local/lib/python3.6/dist-packages/requests/api.py", line 116, in post return request('post', url, data=data, json=json, **kwargs) File "/usr/local/lib/python3.6/dist-packages/requests/api.py", line 60, in request return session.request(method=method, url=url, **kwargs) File "/usr/local/lib/python3.6/dist-packages/requests/sessions.py", line 533, in request resp = self.send(prep, **send_kwargs) File "/usr/local/lib/python3.6/dist-packages/requests/sessions.py", line 646, in send r = adapter.send(request, **kwargs) File "/usr/local/lib/python3.6/dist-packages/requests/adapters.py", line 516, in send raise ConnectionError(e, request=request) requests.exceptions.ConnectionError: HTTPConnectionPool(host='localhost', port=5000): Max retries exceeded with url: /api/data (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x7f8499b6fb00>: Failed to establish a new connection: [Errno 111] Connection refused',))

What?

Currently, project has a temporary name and no favicon. Need to include it once things are decided.

Hi Midas,

Whenever we try to upload the sample audio provided "OSR_us_000_0010_8k.wav" with --Segmentation argument , a Connection error pops up. Refused to establish connection. Below is the log knowing that WITHOUT Segmentation the command executes successfully.

root@srv1:~/audino/audino/examples/upload_data# API_KEY=acc5012b4ec6493888082678eb58bc29 python3 upload_data.py --username admin --is_marked_for_review True --audio_file OSR_us_000_0010_8k.wav --host localhost --port 5000 --segmentations '[ { "annotations": { "testing this": { "values": [ "4", "5" ] } }, "end_time": 7.7407, "start_time": 3.8604, "transcription": "Sample transcription data" }, { "end_time": 17.7407, "start_time": 13.8604, "transcription": "Sample transcription data" }]'
Creating datapoint
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/urllib3/connection.py", line 144, in _new_conn
(self.host, self.port), self.timeout, **extra_kw)
File "/usr/lib/python3/dist-packages/urllib3/util/connection.py", line 83, in create_connection
raise err
File "/usr/lib/python3/dist-packages/urllib3/util/connection.py", line 73, in create_connection
sock.connect(sa)
ConnectionRefusedError: [Errno 111] Connection refused

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/urllib3/connectionpool.py", line 601, in urlopen
chunked=chunked)
File "/usr/lib/python3/dist-packages/urllib3/connectionpool.py", line 357, in _make_request
conn.request(method, url, **httplib_request_kw)
File "/usr/lib/python3.6/http/client.py", line 1281, in request
self._send_request(method, url, body, headers, encode_chunked)
File "/usr/lib/python3.6/http/client.py", line 1327, in _send_request
self.endheaders(body, encode_chunked=encode_chunked)
File "/usr/lib/python3.6/http/client.py", line 1276, in endheaders
self._send_output(message_body, encode_chunked=encode_chunked)
File "/usr/lib/python3.6/http/client.py", line 1042, in _send_output
self.send(msg)
File "/usr/lib/python3.6/http/client.py", line 980, in send
self.connect()
File "/usr/lib/python3/dist-packages/urllib3/connection.py", line 169, in connect
conn = self._new_conn()
File "/usr/lib/python3/dist-packages/urllib3/connection.py", line 153, in _new_conn
self, "Failed to establish a new connection: %s" % e)
urllib3.exceptions.NewConnectionError: <urllib3.connection.HTTPConnection object at 0x7fd6b16d75c0>: Failed to establish a new connection: [Errno 111] Connection refused

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/requests/adapters.py", line 440, in send
timeout=timeout
File "/usr/lib/python3/dist-packages/urllib3/connectionpool.py", line 639, in urlopen
_stacktrace=sys.exc_info()[2])
File "/usr/lib/python3/dist-packages/urllib3/util/retry.py", line 398, in increment
raise MaxRetryError(_pool, url, error or ResponseError(cause))
urllib3.exceptions.MaxRetryError: HTTPConnectionPool(host='localhost', port=5000): Max retries exceeded with url: /api/data (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x7fd6b16d75c0>: Failed to establish a new connection: [Errno 111] Connection refused',))

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "upload_data.py", line 73, in
f"http://{args.host}:{args.port}/api/data", files=file, data=values, headers=headers
File "/usr/lib/python3/dist-packages/requests/api.py", line 112, in post
return request('post', url, data=data, json=json, **kwargs)
File "/usr/lib/python3/dist-packages/requests/api.py", line 58, in request
return session.request(method=method, url=url, **kwargs)
File "/usr/lib/python3/dist-packages/requests/sessions.py", line 520, in request
resp = self.send(prep, **send_kwargs)
File "/usr/lib/python3/dist-packages/requests/sessions.py", line 630, in send
r = adapter.send(request, **kwargs)
File "/usr/lib/python3/dist-packages/requests/adapters.py", line 508, in send
raise ConnectionError(e, request=request)
requests.exceptions.ConnectionError: HTTPConnectionPool(host='localhost', port=5000): Max retries exceeded with url: /api/data (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x7fd6b16d75c0>: Failed to establish a new connection: [Errno 111] Connection refused',))
root@srv1:~/audino/audino/examples/upload_data#

What?

Currently, a user can upload only audio and its meta information to a project. We wish to allow annotations to be uploaded along with audios. The request can be of the same format used by annotation download.

We should also validate the annotation labels with the labels and values created for the project.

I ran docker-compose -f docker-compose.prod.yml up with 7000 port for nginx instead of 80 as it was being used by some other process.
I get welcome to nginx page instead of audino dasboard.
and my console output as below,

Creating network "audino_default" with the default driver
Creating network "audino_backend-network" with the default driver
Creating network "audino_frontend-network" with the default driver
Creating audino_mysql_1 ... done
Creating audino_frontend_1 ... done
Creating audino_redis_1 ... done
Creating audino_backend_1 ... done
Creating audino_nginx_1 ... done
Attaching to audino_frontend_1, audino_redis_1, audino_mysql_1, audino_backend_1, audino_nginx_1
backend_1 | Connecting to database
backend_1 | Connected to database
redis_1 | 1:C 16 Jun 2020 04:41:38.290 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
redis_1 | 1:C 16 Jun 2020 04:41:38.290 # Redis version=5.0.8, bits=64, commit=00000000, modified=0, pid=1, just started
redis_1 | 1:C 16 Jun 2020 04:41:38.290 # Configuration loaded
redis_1 | 1:M 16 Jun 2020 04:41:38.291 * Running mode=standalone, port=6379.
redis_1 | 1:M 16 Jun 2020 04:41:38.291 # WARNING: The TCP backlog setting of 511 cannot be enforced because /proc/sys/net/core/somaxconn is set to the lower value of 128.
redis_1 | 1:M 16 Jun 2020 04:41:38.291 # Server initialized
redis_1 | 1:M 16 Jun 2020 04:41:38.291 # WARNING overcommit_memory is set to 0! Background save may fail under low memory condition. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect.
redis_1 | 1:M 16 Jun 2020 04:41:38.291 # WARNING you have Transparent Huge Pages (THP) support enabled in your kernel. This will create latency and memory usage issues with Redis. To fix this issue run the command 'echo never > /sys/kernel/mm/transparent_hugepage/enabled' as root, and add it to your /etc/rc.local in order to retain the setting after a reboot. Redis must be restarted after THP is disabled.
redis_1 | 1:M 16 Jun 2020 04:41:38.291 * Ready to accept connections
mysql_1 | 2020-06-16 04:41:39+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.30-1debian10 started.
backend_1 | Applying new migrations
mysql_1 | 2020-06-16 04:41:39+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
backend_1 | INFO [alembic.runtime.migration] Context impl MySQLImpl.
backend_1 | INFO [alembic.runtime.migration] Will assume non-transactional DDL.
mysql_1 | 2020-06-16 04:41:39+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.30-1debian10 started.
audino_frontend_1 exited with code 0
mysql_1 | 2020-06-16T04:41:39.414481Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
mysql_1 | 2020-06-16T04:41:39.415488Z 0 [Note] mysqld (mysqld 5.7.30) starting as process 1 ...
backend_1 | INFO [alembic.env] No changes in schema detected.
backend_1 | INFO [alembic.runtime.migration] Context impl MySQLImpl.
backend_1 | INFO [alembic.runtime.migration] Will assume non-transactional DDL.
backend_1 | Creating account for admin
backend_1 | Error creating admin user
backend_1 | (pymysql.err.IntegrityError) (1062, "Duplicate entry 'admin' for key 'ix_user_username'")
backend_1 | [SQL: INSERT INTO user (username, password, role_id, created_at, last_modified) VALUES (%(username)s, %(password)s, %(role_id)s, now(), now())]
backend_1 | [parameters: {'username': 'admin', 'password': 'pbkdf2:sha256:150000$nY5qCd1e$40793583a890c1364d76ec695f07de11734df7eaf3b200aacf54dc578cbac13f', 'role_id': 1}]
backend_1 | (Background on this error at: http://sqlalche.me/e/gkpj)
mysql_1 | 2020-06-16T04:41:39.417760Z 0 [Note] InnoDB: PUNCH HOLE support available
mysql_1 | 2020-06-16T04:41:39.417770Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
mysql_1 | 2020-06-16T04:41:39.417772Z 0 [Note] InnoDB: Uses event mutexes
mysql_1 | 2020-06-16T04:41:39.417789Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
mysql_1 | 2020-06-16T04:41:39.417791Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
mysql_1 | 2020-06-16T04:41:39.417793Z 0 [Note] InnoDB: Using Linux native AIO
mysql_1 | 2020-06-16T04:41:39.418010Z 0 [Note] InnoDB: Number of pools: 1
backend_1 | Starting flask production server
mysql_1 | 2020-06-16T04:41:39.418093Z 0 [Note] InnoDB: Using CPU crc32 instructions
mysql_1 | 2020-06-16T04:41:39.419253Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
backend_1 | [uWSGI] getting INI configuration from uwsgi.ini
mysql_1 | 2020-06-16T04:41:39.426966Z 0 [Note] InnoDB: Completed initialization of buffer pool
backend_1 | *** Starting uWSGI 2.0.18 (64bit) on [Tue Jun 16 04:41:43 2020] ***
backend_1 | compiled with version: 9.3.0 on 15 June 2020 07:12:27
backend_1 | os: Linux-4.15.0-99-generic #10016.04.1-Ubuntu SMP Wed Apr 22 23:56:30 UTC 2020
backend_1 | nodename: 339a28d27448
backend_1 | machine: x86_64
backend_1 | clock source: unix
backend_1 | pcre jit disabled
backend_1 | detected number of CPU cores: 8
backend_1 | current working directory: /app
backend_1 | detected binary path: /usr/local/bin/uwsgi
backend_1 | uWSGI running as root, you can use --uid/--gid/--chroot options
backend_1 | *** WARNING: you are running uWSGI as root !!! (use the --uid flag) ***
backend_1 | your memory page size is 4096 bytes
backend_1 | detected max file descriptor number: 1048576
backend_1 | lock engine: pthread robust mutexes
mysql_1 | 2020-06-16T04:41:39.428352Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
mysql_1 | 2020-06-16T04:41:39.439611Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
backend_1 | thunder lock: disabled (you can enable it with --thunder-lock)
mysql_1 | 2020-06-16T04:41:39.608243Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
mysql_1 | 2020-06-16T04:41:39.608377Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
backend_1 | uWSGI http bound on 0.0.0.0:5000 fd 4
mysql_1 | 2020-06-16T04:41:39.875168Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
backend_1 | uwsgi socket 0 bound to TCP address 127.0.0.1:41919 (port auto-assigned) fd 3
backend_1 | uWSGI running as root, you can use --uid/--gid/--chroot options
backend_1 | *** WARNING: you are running uWSGI as root !!! (use the --uid flag) ***
mysql_1 | 2020-06-16T04:41:39.877303Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
mysql_1 | 2020-06-16T04:41:39.877339Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
backend_1 | Python version: 3.7.7 (default, Jun 3 2020, 19:58:28) [GCC 9.3.0]
mysql_1 | 2020-06-16T04:41:39.878517Z 0 [Note] InnoDB: Waiting for purge to start
backend_1 | *** Python threads support is disabled. You can enable it with --enable-threads ***
backend_1 | Python main interpreter initialized at 0x560cb4372120
backend_1 | uWSGI running as root, you can use --uid/--gid/--chroot options
backend_1 | *** WARNING: you are running uWSGI as root !!! (use the --uid flag) ***
backend_1 | your server socket listen backlog is limited to 100 connections
backend_1 | your mercy for graceful operations on workers is 60 seconds
mysql_1 | 2020-06-16T04:41:39.928769Z 0 [Note] InnoDB: 5.7.30 started; log sequence number 12762037
mysql_1 | 2020-06-16T04:41:39.929238Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
mysql_1 | 2020-06-16T04:41:39.929779Z 0 [Note] Plugin 'FEDERATED' is disabled.
backend_1 | mapped 437424 bytes (427 KB) for 5 cores
mysql_1 | 2020-06-16T04:41:39.934353Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200616 4:41:39
mysql_1 | 2020-06-16T04:41:39.937027Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
mysql_1 | 2020-06-16T04:41:39.937035Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
backend_1 | *** Operational MODE: preforking ***
mysql_1 | 2020-06-16T04:41:39.937482Z 0 [Warning] CA certificate ca.pem is self signed.
mysql_1 | 2020-06-16T04:41:39.937499Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
mysql_1 | 2020-06-16T04:41:39.937777Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
mysql_1 | 2020-06-16T04:41:39.937795Z 0 [Note] IPv6 is available.
mysql_1 | 2020-06-16T04:41:39.937801Z 0 [Note] - '::' resolves to '::';
mysql_1 | 2020-06-16T04:41:39.937808Z 0 [Note] Server socket created on IP: '::'.
backend_1 | WSGI app 0 (mountpoint='') ready in 1 seconds on interpreter 0x560cb4372120 pid: 13 (default app)
backend_1 | uWSGI running as root, you can use --uid/--gid/--chroot options
backend_1 | *** WARNING: you are running uWSGI as root !!! (use the --uid flag) ***
backend_1 | *** uWSGI is running in multiple interpreter mode ***
backend_1 | spawned uWSGI master process (pid: 13)
mysql_1 | 2020-06-16T04:41:40.008325Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
mysql_1 | 2020-06-16T04:41:40.017389Z 0 [Note] Event Scheduler: Loaded 0 events
backend_1 | spawned uWSGI worker 1 (pid: 14, cores: 1)
mysql_1 | 2020-06-16T04:41:40.017512Z 0 [Note] Execution of init_file '/mysql/create_database.sql' started.
backend_1 | spawned uWSGI worker 2 (pid: 15, cores: 1)
backend_1 | spawned uWSGI worker 3 (pid: 16, cores: 1)
mysql_1 | 2020-06-16T04:41:40.017795Z 0 [Note] Execution of init_file '/mysql/create_database.sql' ended.
mysql_1 | 2020-06-16T04:41:40.017861Z 0 [Note] mysqld: ready for connections.
mysql_1 | Version: '5.7.30' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL)
mysql_1 | 2020-06-16T04:41:42.198729Z 3 [Note] Aborted connection 3 to db: 'audino' user: 'audino' host: '172.30.0.4' (Got an error reading communication packets)
mysql_1 | 2020-06-16T04:41:43.798001Z 6 [Note] Aborted connection 6 to db: 'audino' user: 'audino' host: '172.30.0.4' (Got an error reading communication packets)
backend_1 | spawned uWSGI worker 4 (pid: 17, cores: 1)
backend_1 | spawned uWSGI worker 5 (pid: 18, cores: 1)
backend_1 | spawned uWSGI http 1 (pid: 19)
audino_nginx_1 exited with code 0
audino_backend_1 exited with code 137
mysql_1 | 2020-06-16T04:54:36.250373Z 0 [Note] Giving 0 client threads a chance to die gracefully
mysql_1 | 2020-06-16T04:54:36.250431Z 0 [Note] Shutting down slave threads
mysql_1 | 2020-06-16T04:54:36.250443Z 0 [Note] Forcefully disconnecting 0 remaining clients
mysql_1 | 2020-06-16T04:54:36.250454Z 0 [Note] Event Scheduler: Purging the queue. 0 events
mysql_1 | 2020-06-16T04:54:36.250572Z 0 [Note] Binlog end
mysql_1 | 2020-06-16T04:54:36.253728Z 0 [Note] Shutting down plugin 'ngram'
mysql_1 | 2020-06-16T04:54:36.253759Z 0 [Note] Shutting down plugin 'partition'
mysql_1 | 2020-06-16T04:54:36.253768Z 0 [Note] Shutting down plugin 'BLACKHOLE'
mysql_1 | 2020-06-16T04:54:36.253777Z 0 [Note] Shutting down plugin 'ARCHIVE'
mysql_1 | 2020-06-16T04:54:36.253783Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
mysql_1 | 2020-06-16T04:54:36.253849Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
mysql_1 | 2020-06-16T04:54:36.253867Z 0 [Note] Shutting down plugin 'MyISAM'
mysql_1 | 2020-06-16T04:54:36.253890Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
mysql_1 | 2020-06-16T04:54:36.253908Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
mysql_1 | 2020-06-16T04:54:36.253918Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
mysql_1 | 2020-06-16T04:54:36.253928Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
mysql_1 | 2020-06-16T04:54:36.253938Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
mysql_1 | 2020-06-16T04:54:36.253947Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
mysql_1 | 2020-06-16T04:54:36.253956Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
mysql_1 | 2020-06-16T04:54:36.253965Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
mysql_1 | 2020-06-16T04:54:36.253976Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
mysql_1 | 2020-06-16T04:54:36.253987Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
mysql_1 | 2020-06-16T04:54:36.253997Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
mysql_1 | 2020-06-16T04:54:36.254007Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
mysql_1 | 2020-06-16T04:54:36.254017Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
mysql_1 | 2020-06-16T04:54:36.254027Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
mysql_1 | 2020-06-16T04:54:36.254036Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
mysql_1 | 2020-06-16T04:54:36.254045Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
mysql_1 | 2020-06-16T04:54:36.254055Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
mysql_1 | 2020-06-16T04:54:36.254065Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
mysql_1 | 2020-06-16T04:54:36.254075Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
mysql_1 | 2020-06-16T04:54:36.254086Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
mysql_1 | 2020-06-16T04:54:36.254095Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
mysql_1 | 2020-06-16T04:54:36.254106Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
mysql_1 | 2020-06-16T04:54:36.254117Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
mysql_1 | 2020-06-16T04:54:36.254127Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
mysql_1 | 2020-06-16T04:54:36.254137Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
mysql_1 | 2020-06-16T04:54:36.254147Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
mysql_1 | 2020-06-16T04:54:36.254158Z 0 [Note] Shutting down plugin 'INNODB_CMP'
mysql_1 | 2020-06-16T04:54:36.254168Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
mysql_1 | 2020-06-16T04:54:36.254177Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
mysql_1 | 2020-06-16T04:54:36.254188Z 0 [Note] Shutting down plugin 'INNODB_TRX'
mysql_1 | 2020-06-16T04:54:36.254198Z 0 [Note] Shutting down plugin 'InnoDB'
mysql_1 | 2020-06-16T04:54:36.254305Z 0 [Note] InnoDB: FTS optimize thread exiting.
mysql_1 | 2020-06-16T04:54:36.254482Z 0 [Note] InnoDB: Starting shutdown...
redis_1 | 1:signal-handler (1592283276) Received SIGTERM scheduling shutdown...
redis_1 | 1:M 16 Jun 2020 04:54:36.349 # User requested shutdown...
redis_1 | 1:M 16 Jun 2020 04:54:36.349 # Redis is now ready to exit, bye bye...
mysql_1 | 2020-06-16T04:54:36.354992Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
mysql_1 | 2020-06-16T04:54:36.355656Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 200616 4:54:36
audino_redis_1 exited with code 0
mysql_1 | 2020-06-16T04:54:37.434187Z 0 [Note] InnoDB: Shutdown completed; log sequence number 12762388
mysql_1 | 2020-06-16T04:54:37.435575Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
mysql_1 | 2020-06-16T04:54:37.435599Z 0 [Note] Shutting down plugin 'MEMORY'
mysql_1 | 2020-06-16T04:54:37.435602Z 0 [Note] Shutting down plugin 'CSV'
mysql_1 | 2020-06-16T04:54:37.435605Z 0 [Note] Shutting down plugin 'sha256_password'
mysql_1 | 2020-06-16T04:54:37.435607Z 0 [Note] Shutting down plugin 'mysql_native_password'
mysql_1 | 2020-06-16T04:54:37.435688Z 0 [Note] Shutting down plugin 'binlog'
mysql_1 | 2020-06-16T04:54:37.436572Z 0 [Note] mysqld: Shutdown complete
mysql_1 |
audino_mysql_1 exited with code 0
anushree@tellinux008:/Documents/MC/TASK1/audino$ docker-compose -f docker-compose.prod.yml up
Creating network "audino_default" with the default driver
Creating network "audino_backend-network" with the default driver
Creating network "audino_frontend-network" with the default driver
Creating audino_redis_1 ... done
Creating audino_frontend_1 ... done
Creating audino_mysql_1 ... done
Creating audino_backend_1 ... done
Creating audino_nginx_1 ... done
Attaching to audino_frontend_1, audino_redis_1, audino_mysql_1, audino_backend_1, audino_nginx_1
backend_1 | Connecting to database
backend_1 | Connected to database
backend_1 | Applying new migrations
backend_1 | INFO [alembic.runtime.migration] Context impl MySQLImpl.
backend_1 | INFO [alembic.runtime.migration] Will assume non-transactional DDL.
backend_1 | INFO [alembic.env] No changes in schema detected.
audino_frontend_1 exited with code 0
mysql_1 | 2020-06-16 04:58:24+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.30-1debian10 started.
backend_1 | INFO [alembic.runtime.migration] Context impl MySQLImpl.
backend_1 | INFO [alembic.runtime.migration] Will assume non-transactional DDL.
backend_1 | Creating account for admin
backend_1 | Error creating admin user
backend_1 | (pymysql.err.IntegrityError) (1062, "Duplicate entry 'admin' for key 'ix_user_username'")
backend_1 | [SQL: INSERT INTO user (username, password, role_id, created_at, last_modified) VALUES (%(username)s, %(password)s, %(role_id)s, now(), now())]
backend_1 | [parameters: {'username': 'admin', 'password': 'pbkdf2:sha256:150000$QqaVhJ4N$f3512574b4b1f0bd04a4ff63e8befebb313e8c5aa76e79aa6abcfcd391215210', 'role_id': 1}]
backend_1 | (Background on this error at: http://sqlalche.me/e/gkpj)
mysql_1 | 2020-06-16 04:58:24+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
redis_1 | 1:C 16 Jun 2020 04:58:23.530 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
redis_1 | 1:C 16 Jun 2020 04:58:23.530 # Redis version=5.0.8, bits=64, commit=00000000, modified=0, pid=1, just started
redis_1 | 1:C 16 Jun 2020 04:58:23.530 # Configuration loaded
mysql_1 | 2020-06-16 04:58:24+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.30-1debian10 started.
backend_1 | Starting flask production server
mysql_1 | 2020-06-16T04:58:24.634653Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
mysql_1 | 2020-06-16T04:58:24.635666Z 0 [Note] mysqld (mysqld 5.7.30) starting as process 1 ...
mysql_1 | 2020-06-16T04:58:24.637808Z 0 [Note] InnoDB: PUNCH HOLE support available
mysql_1 | 2020-06-16T04:58:24.637817Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
mysql_1 | 2020-06-16T04:58:24.637834Z 0 [Note] InnoDB: Uses event mutexes
mysql_1 | 2020-06-16T04:58:24.637837Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
mysql_1 | 2020-06-16T04:58:24.637838Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
mysql_1 | 2020-06-16T04:58:24.637840Z 0 [Note] InnoDB: Using Linux native AIO
redis_1 | 1:M 16 Jun 2020 04:58:23.531 * Running mode=standalone, port=6379.
backend_1 | [uWSGI] getting INI configuration from uwsgi.ini
backend_1 | *** Starting uWSGI 2.0.18 (64bit) on [Tue Jun 16 04:58:29 2020] ***
backend_1 | compiled with version: 9.3.0 on 15 June 2020 07:12:27
backend_1 | os: Linux-4.15.0-99-generic #100~16.04.1-Ubuntu SMP Wed Apr 22 23:56:30 UTC 2020
backend_1 | nodename: 51b97d95cf3d
backend_1 | machine: x86_64
backend_1 | clock source: unix
backend_1 | pcre jit disabled
backend_1 | detected number of CPU cores: 8
backend_1 | current working directory: /app
backend_1 | detected binary path: /usr/local/bin/uwsgi
backend_1 | uWSGI running as root, you can use --uid/--gid/--chroot options
backend_1 | *** WARNING: you are running uWSGI as root !!! (use the --uid flag) ***
backend_1 | your memory page size is 4096 bytes
backend_1 | detected max file descriptor number: 1048576
backend_1 | lock engine: pthread robust mutexes
redis_1 | 1:M 16 Jun 2020 04:58:23.531 # WARNING: The TCP backlog setting of 511 cannot be enforced because /proc/sys/net/core/somaxconn is set to the lower value of 128.
backend_1 | thunder lock: disabled (you can enable it with --thunder-lock)
redis_1 | 1:M 16 Jun 2020 04:58:23.531 # Server initialized
mysql_1 | 2020-06-16T04:58:24.638053Z 0 [Note] InnoDB: Number of pools: 1
backend_1 | uWSGI http bound on 0.0.0.0:5000 fd 4
backend_1 | uwsgi socket 0 bound to TCP address 127.0.0.1:42615 (port auto-assigned) fd 3
backend_1 | uWSGI running as root, you can use --uid/--gid/--chroot options
backend_1 | *** WARNING: you are running uWSGI as root !!! (use the --uid flag) ***
redis_1 | 1:M 16 Jun 2020 04:58:23.531 # WARNING overcommit_memory is set to 0! Background save may fail under low memory condition. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect.
redis_1 | 1:M 16 Jun 2020 04:58:23.531 # WARNING you have Transparent Huge Pages (THP) support enabled in your kernel. This will create latency and memory usage issues with Redis. To fix this issue run the command 'echo never > /sys/kernel/mm/transparent_hugepage/enabled' as root, and add it to your /etc/rc.local in order to retain the setting after a reboot. Redis must be restarted after THP is disabled.
redis_1 | 1:M 16 Jun 2020 04:58:23.531 * Ready to accept connections
backend_1 | Python version: 3.7.7 (default, Jun 3 2020, 19:58:28) [GCC 9.3.0]
mysql_1 | 2020-06-16T04:58:24.638135Z 0 [Note] InnoDB: Using CPU crc32 instructions
backend_1 | *** Python threads support is disabled. You can enable it with --enable-threads ***
backend_1 | Python main interpreter initialized at 0x55d3a87f5120
backend_1 | uWSGI running as root, you can use --uid/--gid/--chroot options
backend_1 | *** WARNING: you are running uWSGI as root !!! (use the --uid flag) ***
backend_1 | your server socket listen backlog is limited to 100 connections
backend_1 | your mercy for graceful operations on workers is 60 seconds
backend_1 | mapped 437424 bytes (427 KB) for 5 cores
mysql_1 | 2020-06-16T04:58:24.639279Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
backend_1 | *** Operational MODE: preforking ***
mysql_1 | 2020-06-16T04:58:24.647154Z 0 [Note] InnoDB: Completed initialization of buffer pool
mysql_1 | 2020-06-16T04:58:24.648619Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
backend_1 | WSGI app 0 (mountpoint='') ready in 0 seconds on interpreter 0x55d3a87f5120 pid: 12 (default app)
backend_1 | uWSGI running as root, you can use --uid/--gid/--chroot options
backend_1 | *** WARNING: you are running uWSGI as root !!! (use the --uid flag) ***
backend_1 | *** uWSGI is running in multiple interpreter mode ***
backend_1 | spawned uWSGI master process (pid: 12)
backend_1 | spawned uWSGI worker 1 (pid: 13, cores: 1)
mysql_1 | 2020-06-16T04:58:24.659872Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
backend_1 | spawned uWSGI worker 2 (pid: 14, cores: 1)
mysql_1 | 2020-06-16T04:58:24.770185Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
mysql_1 | 2020-06-16T04:58:24.770338Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
backend_1 | spawned uWSGI worker 3 (pid: 15, cores: 1)
backend_1 | spawned uWSGI worker 4 (pid: 16, cores: 1)
mysql_1 | 2020-06-16T04:58:24.987938Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
backend_1 | spawned uWSGI worker 5 (pid: 17, cores: 1)
mysql_1 | 2020-06-16T04:58:24.989861Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
mysql_1 | 2020-06-16T04:58:24.989891Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
backend_1 | spawned uWSGI http 1 (pid: 18)
mysql_1 | 2020-06-16T04:58:24.990602Z 0 [Note] InnoDB: Waiting for purge to start
mysql_1 | 2020-06-16T04:58:25.041009Z 0 [Note] InnoDB: 5.7.30 started; log sequence number 12762388
mysql_1 | 2020-06-16T04:58:25.041490Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
mysql_1 | 2020-06-16T04:58:25.042072Z 0 [Note] Plugin 'FEDERATED' is disabled.
mysql_1 | 2020-06-16T04:58:25.047035Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200616 4:58:25
mysql_1 | 2020-06-16T04:58:25.058773Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
mysql_1 | 2020-06-16T04:58:25.058805Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
mysql_1 | 2020-06-16T04:58:25.061015Z 0 [Warning] CA certificate ca.pem is self signed.
mysql_1 | 2020-06-16T04:58:25.061103Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
mysql_1 | 2020-06-16T04:58:25.062364Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
mysql_1 | 2020-06-16T04:58:25.062435Z 0 [Note] IPv6 is available.
mysql_1 | 2020-06-16T04:58:25.062463Z 0 [Note] - '::' resolves to '::';
mysql_1 | 2020-06-16T04:58:25.062495Z 0 [Note] Server socket created on IP: '::'.
mysql_1 | 2020-06-16T04:58:25.248089Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
mysql_1 | 2020-06-16T04:58:25.253209Z 0 [Note] Event Scheduler: Loaded 0 events
mysql_1 | 2020-06-16T04:58:25.253356Z 0 [Note] Execution of init_file '/mysql/create_database.sql' started.
mysql_1 | 2020-06-16T04:58:25.253575Z 0 [Note] Execution of init_file '/mysql/create_database.sql' ended.
mysql_1 | 2020-06-16T04:58:25.253627Z 0 [Note] mysqld: ready for connections.
mysql_1 | Version: '5.7.30' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL)
mysql_1 | 2020-06-16T04:58:27.336815Z 3 [Note] Aborted connection 3 to db: 'audino' user: 'audino' host: '192.168.16.4' (Got an error reading communication packets)
mysql_1 | 2020-06-16T04:58:29.118351Z 6 [Note] Aborted connection 6 to db: 'audino' user: 'audino' host: '192.168.16.4' (Got an error reading communication packets)

What?

Currently, the tool was developed keeping desktop in mind. Given the use-case of annotating on the go, we should optimize the frontend for mobile as much as possible.

What?

Currently, the user has to return to the project dashboard to choose next data point. We should allow the user to move to next datapoint through the annotation dashboard.

We are unable to bring up the services.
PS. We are just a group of high school students with very limited knowledge on this field. Please kindly use easy words for explanation. Thank you

Hi Team,

As of now, in the UI, I was not able to find any user management system i.e. after creating a user we can only change its role i.e. from user to admin or vice-versa apart from that things like change username, change password, or delete users etc is not feasible.

Please correct me if I am wrong, and if not present, I will highly appreciate if you could provide these simple features.

Thanks in advance

When uploading data, marked_review is always False.

There seems to be a typo in backend/route/data.py line 45 should be
is_marked_for_review = bool(request.form.get("marked_review", False))
or
upload_data/upload_data.py and docs/tutorials/upload-data.md
should be corrected with is_marked_for_review instead of marked_review
or am I wrong ?

What?

Once a component is updated, if the user moves to previous screen, the application requires two clicks. A workaround is needed for this.

Running docker compose on the dev backend, getting a crash.

git clone https://github.com/midas-research/audino.git
cd audino/
ln -s docker-compose.dev.yml docker-compose.yml
docker-compose build
docker-compose up

jump into the backend
docker exec -it audino_backend_1 bash

ps xauf

root       680 13.0  0.2 206424 53664 ?        Sl   Dec29  69:06  \_ /app/backend/venv/bin/python3 /app/backend/venv/bin/flask run --host=0.0.0.0 --port=5000

strace -f -p 680 -s 999

[pid   680] stat("/app/backend/venv/lib/python3.7/site-packages/click/types.py",  <unfinished ...>
[pid  1984] <... futex resumed> )       = 0
[pid  1984] getpid()                    = 680
[pid  1984] write(2, "[2020-12-30 07:02:20,543] ERROR in app: 'str' object has no attribute 'decode'\n", 79) = 79
[pid  1984] ioctl(6, FIONBIO, [0])      = 0
[pid  1984] sendto(6, "\t\0\0\0\3ROLLBACK", 13, 0, NULL, 0) = 13
[pid   680] <... stat resumed> {st_mode=S_IFREG|0777, st_size=25045, ...}) = 0
[pid  1984] ioctl(6, FIONBIO, [0] <unfinished ...>
[pid   680] stat("/app/backend/venv/lib/python3.7/site-packages/click/types.py",  <unfinished ...>
[pid  1984] <... ioctl resumed> )       = 0
[pid  1984] recvfrom(6, "\7\0\0\1\0\0\0\0\0\0\0", 8192, 0, NULL, NULL) = 11
[pid  1984] ioctl(6, FIONBIO, [0])      = 0
[pid  1984] getpid()                    = 680
[pid  1984] write(2, "172.19.0.3 - - [30/Dec/2020 07:02:20] \"POST /auth/login HTTP/1.1\" 500 -\n", 72) = 72
[pid  1984] sendto(5, "HTTP/1.0 500 INTERNAL SERVER ERROR\r\n", 36, 0, NULL, 0 <unfinished ...>
[pid   680] <... stat resumed> {st_mode=S_IFREG|0777, st_size=25045, ...}) = 0
[pid  1984] <... sendto resumed> )      = 36
[pid   680] stat("/app/backend/venv/lib/python3.7/site-packages/click/decorators.py",  <unfinished ...>
[pid  1984] sendto(5, "Content-Type: application/json\r\nContent-Length: 52\r\nServer: Werkzeug/0.16.0 Python/3.7.9\r\nDate: Wed, 30 Dec 2020 07:02:20 GMT\r\n\r\n", 129, 0, NULL, 0) = 129
[pid  1984] sendto(5, "{\n  \"code\": 500, \n  \"message\": \"An error occured\"\n}\n", 52, 0, NULL, 0) = 52
[pid  1984] shutdown(5, SHUT_WR)        = 0
[pid  1984] close(5)                    = 0
[pid  1984] madvise(0x7f62cc763000, 8368128, MADV_DONTNEED) = 0
[pid   680] <... stat resumed> {st_mode=S_IFREG|0777, st_size=11215, ...}) = 0
[pid  1984] exit(0)                     = ?
[pid   680] stat("/app/backend/venv/lib/python3.7/site-packages/click/decorators.py",  <unfinished ...>

What?

Currently, we expose a rest endpoint /api/data to create and upload new datapoints. This requires user to programmatically upload all data points. This also allows users to manipulate and preprocess data points beforehand.

Although this works, we should allow users to upload zip files containing audios and required params. This requires a standardized file containing all meta information.

Everything is working well. uploading data and others

But now when I upload data with my segments(or without ) I can't get any Button or textarea to Write MY ANNOTATION

As you see. there is no tool to annotate.

While running "sudo docker-compose -f docker-compose.prod.yml up", I had the following error :

mysql_1 | 2023-09-08T08:54:15.042298Z 0 [Note] mysqld: ready for connections.
mysql_1 | Version: '5.7.43' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL)
backend_1 | Couldn't connect to MySQL: 0/30
backend_1 | Couldn't connect to MySQL: 1/30
backend_1 | Couldn't connect to MySQL: 2/30
backend_1 | Couldn't connect to MySQL: 3/30
backend_1 | Couldn't connect to MySQL: 4/30
backend_1 | Couldn't connect to MySQL: 5/30
backend_1 | Couldn't connect to MySQL: 6/30
backend_1 | Couldn't connect to MySQL: 7/30
backend_1 | Couldn't connect to MySQL: 8/30
backend_1 | Couldn't connect to MySQL: 9/30
backend_1 | Couldn't connect to MySQL: 10/30
backend_1 | Couldn't connect to MySQL: 11/30
backend_1 | Couldn't connect to MySQL: 12/30
backend_1 | Couldn't connect to MySQL: 13/30
backend_1 | Couldn't connect to MySQL: 14/30
backend_1 | Couldn't connect to MySQL: 15/30
backend_1 | Couldn't connect to MySQL: 16/30
backend_1 | Couldn't connect to MySQL: 17/30
backend_1 | Couldn't connect to MySQL: 18/30
backend_1 | Couldn't connect to MySQL: 19/30
backend_1 | Couldn't connect to MySQL: 20/30
backend_1 | Couldn't connect to MySQL: 21/30
backend_1 | Couldn't connect to MySQL: 22/30
backend_1 | Couldn't connect to MySQL: 23/30
backend_1 | Couldn't connect to MySQL: 24/30
backend_1 | Couldn't connect to MySQL: 25/30
backend_1 | Couldn't connect to MySQL: 26/30
backend_1 | Couldn't connect to MySQL: 27/30
backend_1 | Couldn't connect to MySQL: 28/30
backend_1 | Couldn't connect to MySQL: 29/30
backend_1 | Error connecting to database
audino_backend_1 exited with code 1

Anyone had this issue, how could I solve this? Thanks !

Hi MIDAS team,

Awesome work making this!.after i created projects and labels;but when i find the data pages. i can't find the labels.

but i find labels api data。

what can i fix it bugs?

Hi
I have tried to use --is_marked_for_review False in order to disable is_marked_for_review by default when uploading data. But the is_marked_for_review box is still checked.

Hi, thanks for the great tool! I really love it.
I am trying to label our research data and i found that the audio files from mine could not be displayed after uploading. While the example audio file could always be displayed correctly.
I try to change the duration or sampling rate of my data and the example audio. turns out that the example audio could always work but none of mine could be played or displayed.
Are there any specific requirements for the uplpded audios?

What?

Currently, CI is not integrated since the project is private. Once open-sourced, we should integrate Travis, Code Coverage and other services.

Hello, I don't know how to upload new data points. Your project is running on a cloud server and wants to upload new data points. What should I do? Do I directly execute the test script you gave? If I want to upload new data points in batches? Newcomers kneel for answers

when run docker-compose -f docker-compose.dev.yml up， I get follow error：

/usr/lib/python2.7/site-packages/paramiko/transport.py:33: CryptographyDeprecationWarning: Python 2 is no longer supported by the Python core team. Support for it is now deprecated in cryptography, and will be removed in the next release.
  from cryptography.hazmat.backends import default_backend
Starting audino_mysql_1 ... done
Starting audino_redis_1 ... done
Starting audino_backend_1 ... done
Starting audino_frontend_1 ... done
Attaching to audino_redis_1, audino_mysql_1, audino_backend_1, audino_frontend_1
mysql_1     | 2023-05-25 05:46:49+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.36-1debian10 started.
mysql_1     | 2023-05-25 05:46:49+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
mysql_1     | 2023-05-25 05:46:49+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.36-1debian10 started.
mysql_1     | 2023-05-25T05:46:49.950882Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
mysql_1     | 2023-05-25T05:46:49.953466Z 0 [Note] mysqld (mysqld 5.7.36) starting as process 1 ...
mysql_1     | 2023-05-25T05:46:49.962552Z 0 [Note] InnoDB: PUNCH HOLE support available
mysql_1     | 2023-05-25T05:46:49.962589Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
mysql_1     | 2023-05-25T05:46:49.962593Z 0 [Note] InnoDB: Uses event mutexes
mysql_1     | 2023-05-25T05:46:49.962596Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
mysql_1     | 2023-05-25T05:46:49.962600Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
mysql_1     | 2023-05-25T05:46:49.962609Z 0 [Note] InnoDB: Using Linux native AIO
mysql_1     | 2023-05-25T05:46:49.963601Z 0 [Note] InnoDB: Number of pools: 1
mysql_1     | 2023-05-25T05:46:49.963968Z 0 [Note] InnoDB: Using CPU crc32 instructions
mysql_1     | 2023-05-25T05:46:49.966656Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
mysql_1     | 2023-05-25T05:46:49.980324Z 0 [Note] InnoDB: Completed initialization of buffer pool
mysql_1     | 2023-05-25T05:46:49.983714Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
mysql_1     | 2023-05-25T05:46:50.017720Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
mysql_1     | 2023-05-25T05:46:50.070728Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
mysql_1     | 2023-05-25T05:46:50.070828Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
mysql_1     | 2023-05-25T05:46:50.117963Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
mysql_1     | 2023-05-25T05:46:50.118870Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
mysql_1     | 2023-05-25T05:46:50.118887Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
mysql_1     | 2023-05-25T05:46:50.119775Z 0 [Note] InnoDB: Waiting for purge to start
mysql_1     | 2023-05-25T05:46:50.170289Z 0 [Note] InnoDB: 5.7.36 started; log sequence number 12659754
mysql_1     | 2023-05-25T05:46:50.170726Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
mysql_1     | 2023-05-25T05:46:50.171612Z 0 [Note] Plugin 'FEDERATED' is disabled.
mysql_1     | 2023-05-25T05:46:50.197593Z 0 [Note] InnoDB: Buffer pool(s) load completed at 230525  5:46:50
mysql_1     | 2023-05-25T05:46:50.210731Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
mysql_1     | 2023-05-25T05:46:50.210909Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
mysql_1     | 2023-05-25T05:46:50.210915Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
mysql_1     | 2023-05-25T05:46:50.210920Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
mysql_1     | 2023-05-25T05:46:50.214311Z 0 [Warning] CA certificate ca.pem is self signed.
mysql_1     | 2023-05-25T05:46:50.214368Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
mysql_1     | 2023-05-25T05:46:50.215478Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
mysql_1     | 2023-05-25T05:46:50.215654Z 0 [Note] IPv6 is available.
mysql_1     | 2023-05-25T05:46:50.215675Z 0 [Note]   - '::' resolves to '::';
mysql_1     | 2023-05-25T05:46:50.215702Z 0 [Note] Server socket created on IP: '::'.
mysql_1     | 2023-05-25T05:46:50.217535Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
mysql_1     | 2023-05-25T05:46:50.250927Z 0 [Note] Event Scheduler: Loaded 0 events
mysql_1     | 2023-05-25T05:46:50.251120Z 0 [Note] Execution of init_file '/mysql/create_database.sql' started.
mysql_1     | 2023-05-25T05:46:50.254389Z 0 [Note] Execution of init_file '/mysql/create_database.sql' ended.
mysql_1     | 2023-05-25T05:46:50.254460Z 0 [Note] mysqld: ready for connections.
mysql_1     | Version: '5.7.36'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server (GPL)
backend_1   | Activating environment
backend_1   | Installing dependencies
redis_1     | 1:C 25 May 2023 05:46:49.222 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
redis_1     | 1:C 25 May 2023 05:46:49.222 # Redis version=5.0.8, bits=64, commit=00000000, modified=0, pid=1, just started
redis_1     | 1:C 25 May 2023 05:46:49.222 # Configuration loaded
redis_1     | 1:M 25 May 2023 05:46:49.233 * Running mode=standalone, port=6379.
redis_1     | 1:M 25 May 2023 05:46:49.233 # WARNING: The TCP backlog setting of 511 cannot be enforced because /proc/sys/net/core/somaxconn is set to the lower value of 128.
redis_1     | 1:M 25 May 2023 05:46:49.233 # Server initialized
redis_1     | 1:M 25 May 2023 05:46:49.233 # WARNING overcommit_memory is set to 0! Background save may fail under low memory condition. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect.
redis_1     | 1:M 25 May 2023 05:46:49.233 # WARNING you have Transparent Huge Pages (THP) support enabled in your kernel. This will create latency and memory usage issues with Redis. To fix this issue run the command 'echo never > /sys/kernel/mm/transparent_hugepage/enabled' as root, and add it to your /etc/rc.local in order to retain the setting after a reboot. Redis must be restarted after THP is disabled.
redis_1     | 1:M 25 May 2023 05:46:49.237 * Ready to accept connections
backend_1   | WARNING: Retrying (Retry(total=4, connect=None, read=None, redirect=None, status=None)) after connection broken by 'NewConnectionError('<pip._vendor.urllib3.connection.VerifiedHTTPSConnection object at 0x7fa8e562a8d0>: Failed to establish a new connection: [Errno -3] Temporary failure in name resolution')': /simple/alembic/
backend_1   | WARNING: Retrying (Retry(total=3, connect=None, read=None, redirect=None, status=None)) after connection broken by 'NewConnectionError('<pip._vendor.urllib3.connection.VerifiedHTTPSConnection object at 0x7fa8e562e210>: Failed to establish a new connection: [Errno -3] Temporary failure in name resolution')': /simple/alembic/
backend_1   | WARNING: Retrying (Retry(total=2, connect=None, read=None, redirect=None, status=None)) after connection broken by 'NewConnectionError('<pip._vendor.urllib3.connection.VerifiedHTTPSConnection object at 0x7fa8e562e410>: Failed to establish a new connection: [Errno -3] Temporary failure in name resolution')': /simple/alembic/
backend_1   | WARNING: Retrying (Retry(total=1, connect=None, read=None, redirect=None, status=None)) after connection broken by 'NewConnectionError('<pip._vendor.urllib3.connection.VerifiedHTTPSConnection object at 0x7fa8e562e9d0>: Failed to establish a new connection: [Errno -3] Temporary failure in name resolution')': /simple/alembic/
backend_1   | WARNING: Retrying (Retry(total=0, connect=None, read=None, redirect=None, status=None)) after connection broken by 'NewConnectionError('<pip._vendor.urllib3.connection.VerifiedHTTPSConnection object at 0x7fa8e56132d0>: Failed to establish a new connection: [Errno -3] Temporary failure in name resolution')': /simple/alembic/
backend_1   | ERROR: Could not find a version that satisfies the requirement alembic==1.2.1 (from -r /app/backend/requirements.txt (line 1)) (from versions: none)
backend_1   | ERROR: No matching distribution found for alembic==1.2.1 (from -r /app/backend/requirements.txt (line 1))
audino_backend_1 exited with code 1

Hi,

I tried to deploy audino behind a reverse proxy (nginx proxypass) with no luck. Your backend is based upon flask and there is a tweak to allow reverseproxy through the use of proxyfix or a custom class (reverseproxied).

What?

Currently, the setup only creates an admin user. We should also create a sample project to make it easier for users to explore the project.