Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Unable to query the database, check your Ampache config (after first run) #112

Open
gerroon opened this issue Nov 15, 2023 · 6 comments
Open

Unable to query the database, check your Ampache config (after first run) #112

gerroon opened this issue Nov 15, 2023 · 6 comments

Comments

@gerroon
Copy link

gerroon commented Nov 15, 2023 •
edited

Debian Testing, Docker compose

/install.php


Error

The following error has occurred, you will be automatically redirected in 10 seconds.
Error Messages:

Unable to query the database, check your Ampache config




docker-compose up
Starting ampache ... done
Attaching to ampache
ampache    | => Using an existing volume of MySQL
ampache    | 2023-11-15 00:50:55,667 INFO Set uid to user 0 succeeded
ampache    | 2023-11-15 00:50:56,173 INFO supervisord started with pid 1
ampache    | 2023-11-15 00:50:57,175 INFO spawned: 'apache2' with pid 8
ampache    | 2023-11-15 00:50:57,255 INFO spawned: 'cron' with pid 9
ampache    | 2023-11-15 00:50:57,257 INFO spawned: 'inotifywait' with pid 10
ampache    | 2023-11-15 00:50:57,259 INFO spawned: 'mysql' with pid 11
ampache    | 2023-11-15 00:50:58,260 INFO success: apache2 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
ampache    | 2023-11-15 00:50:58,260 INFO success: cron entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
ampache    | 2023-11-15 00:50:58,260 INFO success: inotifywait entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
ampache    | 2023-11-15 00:50:58,260 INFO success: mysql entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)

mysql settings in the config

web_path = "/ampache/public"

;#########################################################
; Database                                               #
;#########################################################

database_hostname = "localhost"

;database_port = 3306

database_name = "ampache"

database_username = "admin"

database_password = "RANDOM_PASSWORD_FROM_THE_FIRS_DOCKER_RUN"

docker compose

cat docker-compose.yml
version: '3'

services:
  ampache:
    image: ampache/ampache:latest
    container_name: ampache
    restart: unless-stopped
    ports:
      - 4411:80
    volumes:
      - /media/ampache/config:/var/www/config
      - ./data/log:/var/log/ampache
      - /media:/media
      - /media/ampache/mysql_ampache:/var/lib/mysql
@gerroon gerroon changed the title Unable to query the database, check your Ampache config Unable to query the database, check your Ampache config (after first run) Nov 15, 2023
@lachlan-00
Copy link
Member

That error looks like it occurs after the database can connect.

It tries to list the users table and fails if it can't. does the database ampache exist?

@gerroon
Copy link
Author

gerroon commented Nov 15, 2023 •
edited

That is really the first run, not sure how this should be set up. According to the default config, the default database is already called "ampache" I was never able to get to the default Ampache setup page.

This is the mysql folder for the Docker container.

 ls -alh
total 109M
drwxrwxrwx 1 messagebus root   260 Nov 14 19:00 .
-rw-rw---- 1 messagebus fuse  408K Nov 14 19:00 aria_log.00000001
-rw-rw---- 1 messagebus fuse    52 Nov 14 19:00 aria_log_control
-rw-rw---- 1 messagebus fuse   910 Nov 14 19:00 ib_buffer_pool
-rw-rw---- 1 messagebus fuse   12M Nov 14 18:46 ibdata1
-rw-rw---- 1 messagebus fuse   96M Nov 14 18:46 ib_logfile0
-rw-rw---- 1 messagebus fuse     0 Nov 14 18:47 multi-master.info
drwx------ 1 messagebus fuse  2.7K Nov 14 18:38 mysql
-rw-r--r-- 1 root       root    15 Nov 14 18:46 mysql_upgrade_info
drwx------ 1 messagebus fuse    12 Nov 14 18:38 performance_schema
drwx------ 1 messagebus fuse  6.4K Nov 14 18:44 sys
drwx------ 1 messagebus fuse    12 Nov 14 18:45 test

@lachlan-00
Copy link
Member

Sounds to me like you're connecting to the server without doing install first.

We don't forcibly install the database in case you already have something / data set up. so if you delete the config you can go through the install process.

If you want to manually install from the cli you can as well but the web installer should be easier

@gerroon
Copy link
Author

gerroon commented Nov 15, 2023 •
edited

Well, when I do a totally fresh install, it crashes (or I think so) and I loose connection to the docker container during the database setup. So I repeat the step without the database creation (skip) because I see that it creates the ampache mysql folder with the tables, then I go ahead with the config creation, this is what I see at the end.

I did these types of setup thousands times using Docker so I am really not sure why this is not working here.

During the database creation the page times out, I have a proxy running so it hits the proxy page since the page is not accessible

image

image

Here you can see it creates the ampache databases


ls -alh
total 8.7M
drwx------ 1 messagebus fuse 7.4K Nov 15 12:15 .
drwxrwxrwx 1 messagebus root  318 Nov 15 11:55 ..
-rw-rw---- 1 messagebus fuse 4.8K Nov 15 12:13 access_list.frm
-rw-rw---- 1 messagebus fuse 128K Nov 15 11:55 access_list.ibd
-rw-rw---- 1 messagebus fuse 3.6K Nov 15 11:56 album_disk.frm
-rw-rw---- 1 messagebus fuse    0 Nov 15 11:56 album_disk.MYD
-rw-rw---- 1 messagebus fuse 1.0K Nov 15 11:56 album_disk.MYI
-rw-rw---- 1 messagebus fuse 8.7K Nov 15 12:14 album.frm
-rw-rw---- 1 messagebus fuse 224K Nov 15 12:12 album.ibd
-rw-rw---- 1 messagebus fuse 3.0K Nov 15 11:56 album_map.frm
-rw-rw---- 1 messagebus fuse    0 Nov 15 11:56 album_map.MYD
-rw-rw---- 1 messagebus fuse 1.0K Nov 15 11:56 album_map.MYI
-rw-rw---- 1 messagebus fuse 3.8K Nov 15 12:14 artist.frm
-rw-rw---- 1 messagebus fuse  96K Nov 15 12:13 artist.ibd
-rw-rw---- 1 messagebus fuse 3.0K Nov 15 11:57 artist_map.frm
-rw-rw---- 1 messagebus fuse    0 Nov 15 11:57 artist_map.MYD
-rw-rw---- 1 messagebus fuse 1.0K Nov 15 11:57 artist_map.MYI
-rw-rw---- 1 messagebus fuse 2.3K Nov 15 12:14 bookmark.frm
-rw-rw---- 1 messagebus fuse  64K Nov 15 11:57 bookmark.ibd
-rw-rw---- 1 messagebus fuse 2.5K Nov 15 12:14 broadcast.frm
-rw-rw---- 1 messagebus fuse  64K Nov 15 11:57 broadcast.ibd
-rw-rw---- 1 messagebus fuse 1.2K Nov 15 11:57 cache_object_count.frm
-rw-rw---- 1 messagebus fuse  64K Nov 15 11:57 cache_object_count.ibd
-rw-rw---- 1 messagebus fuse 1.2K Nov 15 11:57 cache_object_count_run.frm
-rw-rw---- 1 messagebus fuse  64K Nov 15 11:57 cache_object_count_run.ibd
-rw-rw---- 1 messagebus fuse 2.0K Nov 15 11:57 catalog_filter_group.frm
-rw-rw---- 1 messagebus fuse  80K Nov 15 11:57 catalog_filter_group.ibd
-rw-rw---- 1 messagebus fuse  989 Nov 15 11:57 catalog_filter_group_map.frm
-rw-rw---- 1 messagebus fuse  64K Nov 15 11:57 catalog_filter_group_map.ibd
-rw-rw---- 1 messagebus fuse 5.6K Nov 15 11:57 catalog.frm
-rw-rw---- 1 messagebus fuse  80K Nov 15 11:57 catalog.ibd
-rw-rw---- 1 messagebus fuse 2.0K Nov 15 11:58 catalog_local.frm
-rw-rw---- 1 messagebus fuse  64K Nov 15 11:58 catalog_local.ibd
-rw-rw---- 1 messagebus fuse 1.5K Nov 15 11:58 catalog_map.frm
-rw-rw---- 1 messagebus fuse  96K Nov 15 11:58 catalog_map.ibd
-rw-rw---- 1 messagebus fuse 3.4K Nov 15 11:58 catalog_remote.frm
-rw-rw---- 1 messagebus fuse  64K Nov 15 11:58 catalog_remote.ibd
-rw-rw---- 1 messagebus fuse  979 Nov 15 11:58 clip.frm
-rw-rw---- 1 messagebus fuse  64K Nov 15 11:58 clip.ibd
-rw-rw---- 1 messagebus fuse  959 Nov 15 11:58 daap_session.frm
-rw-rw---- 1 messagebus fuse  64K Nov 15 11:59 daap_session.ibd
-rw-rw---- 1 messagebus fuse   67 Nov 15 12:13 db.opt
-rw-rw---- 1 messagebus fuse  19K Nov 15 11:59 deleted_podcast_episode.frm
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:00 deleted_podcast_episode.ibd
-rw-rw---- 1 messagebus fuse  19K Nov 15 12:00 deleted_song.frm
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:00 deleted_song.ibd
-rw-rw---- 1 messagebus fuse  19K Nov 15 12:00 deleted_video.frm
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:00 deleted_video.ibd
-rw-rw---- 1 messagebus fuse 2.3K Nov 15 12:00 democratic.frm
-rw-rw---- 1 messagebus fuse  96K Nov 15 12:00 democratic.ibd
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:12 FTS_000000000000005a_00000000000000ca_INDEX_1.ibd
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:12 FTS_000000000000005a_00000000000000ca_INDEX_2.ibd
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:12 FTS_000000000000005a_00000000000000ca_INDEX_3.ibd
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:12 FTS_000000000000005a_00000000000000ca_INDEX_4.ibd
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:12 FTS_000000000000005a_00000000000000ca_INDEX_5.ibd
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:12 FTS_000000000000005a_00000000000000ca_INDEX_6.ibd
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:12 FTS_000000000000005a_BEING_DELETED_CACHE.ibd
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:12 FTS_000000000000005a_BEING_DELETED.ibd
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:12 FTS_000000000000005a_CONFIG.ibd
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:12 FTS_000000000000005a_DELETED_CACHE.ibd
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:12 FTS_000000000000005a_DELETED.ibd
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:13 FTS_0000000000000066_00000000000000d9_INDEX_1.ibd
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:13 FTS_0000000000000066_00000000000000d9_INDEX_2.ibd
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:13 FTS_0000000000000066_00000000000000d9_INDEX_3.ibd
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:13 FTS_0000000000000066_00000000000000d9_INDEX_4.ibd
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:13 FTS_0000000000000066_00000000000000d9_INDEX_5.ibd
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:13 FTS_0000000000000066_00000000000000d9_INDEX_6.ibd
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:13 FTS_0000000000000066_BEING_DELETED_CACHE.ibd
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:13 FTS_0000000000000066_BEING_DELETED.ibd
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:13 FTS_0000000000000066_CONFIG.ibd
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:13 FTS_0000000000000066_DELETED_CACHE.ibd
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:13 FTS_0000000000000066_DELETED.ibd
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:13 FTS_0000000000000072_00000000000000f0_INDEX_1.ibd
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:13 FTS_0000000000000072_00000000000000f0_INDEX_2.ibd
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:13 FTS_0000000000000072_00000000000000f0_INDEX_3.ibd
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:13 FTS_0000000000000072_00000000000000f0_INDEX_4.ibd
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:13 FTS_0000000000000072_00000000000000f0_INDEX_5.ibd
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:13 FTS_0000000000000072_00000000000000f0_INDEX_6.ibd
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:13 FTS_0000000000000072_BEING_DELETED_CACHE.ibd
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:13 FTS_0000000000000072_BEING_DELETED.ibd
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:13 FTS_0000000000000072_CONFIG.ibd
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:13 FTS_0000000000000072_DELETED_CACHE.ibd
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:13 FTS_0000000000000072_DELETED.ibd
-rw-rw---- 1 messagebus fuse 2.8K Nov 15 12:00 image.frm
-rw-rw---- 1 messagebus fuse  96K Nov 15 12:00 image.ibd
-rw-rw---- 1 messagebus fuse 3.7K Nov 15 12:00 ip_history.frm
-rw-rw---- 1 messagebus fuse 112K Nov 15 12:00 ip_history.ibd
-rw-rw---- 1 messagebus fuse 1.5K Nov 15 12:01 label_asso.frm
-rw-rw---- 1 messagebus fuse  80K Nov 15 12:01 label_asso.ibd
-rw-rw---- 1 messagebus fuse 4.6K Nov 15 12:01 label.frm
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:01 label.ibd
-rw-rw---- 1 messagebus fuse 3.4K Nov 15 12:01 license.frm
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:02 license.ibd
-rw-rw---- 1 messagebus fuse  20K Nov 15 12:02 live_stream.frm
-rw-rw---- 1 messagebus fuse 112K Nov 15 12:02 live_stream.ibd
-rw-rw---- 1 messagebus fuse 3.5K Nov 15 12:02 localplay_httpq.frm
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:02 localplay_httpq.ibd
-rw-rw---- 1 messagebus fuse 3.5K Nov 15 12:02 localplay_mpd.frm
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:02 localplay_mpd.ibd
-rw-rw---- 1 messagebus fuse 2.5K Nov 15 12:02 metadata_field.frm
-rw-rw---- 1 messagebus fuse  80K Nov 15 12:02 metadata_field.ibd
-rw-rw---- 1 messagebus fuse 3.7K Nov 15 12:02 metadata.frm
-rw-rw---- 1 messagebus fuse 144K Nov 15 12:02 metadata.ibd
-rw-rw---- 1 messagebus fuse 2.5K Nov 15 12:02 movie.frm
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:02 movie.ibd
-rw-rw---- 1 messagebus fuse 2.5K Nov 15 12:02 now_playing.frm
-rw-rw---- 1 messagebus fuse  80K Nov 15 12:02 now_playing.ibd
-rw-rw---- 1 messagebus fuse 7.6K Nov 15 12:02 object_count.frm
-rw-rw---- 1 messagebus fuse 224K Nov 15 12:03 object_count.ibd
-rw-rw---- 1 messagebus fuse 3.0K Nov 15 12:03 personal_video.frm
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:03 personal_video.ibd
-rw-rw---- 1 messagebus fuse 2.3K Nov 15 12:03 player_control.frm
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:03 player_control.ibd
-rw-rw---- 1 messagebus fuse 1.6K Nov 15 12:04 playlist_data.frm
-rw-rw---- 1 messagebus fuse  80K Nov 15 12:04 playlist_data.ibd
-rw-rw---- 1 messagebus fuse 3.0K Nov 15 12:03 playlist.frm
-rw-rw---- 1 messagebus fuse  96K Nov 15 12:03 playlist.ibd
-rw-rw---- 1 messagebus fuse  54K Nov 15 12:04 podcast_episode.frm
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:04 podcast_episode.ibd
-rw-rw---- 1 messagebus fuse  37K Nov 15 12:04 podcast.frm
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:04 podcast.ibd
-rw-rw---- 1 messagebus fuse 6.4K Nov 15 12:04 preference.frm
-rw-rw---- 1 messagebus fuse 112K Nov 15 12:04 preference.ibd
-rw-rw---- 1 messagebus fuse 2.1K Nov 15 12:04 rating.frm
-rw-rw---- 1 messagebus fuse  96K Nov 15 12:04 rating.ibd
-rw-rw---- 1 messagebus fuse 1.1K Nov 15 12:04 recommendation.frm
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:04 recommendation.ibd
-rw-rw---- 1 messagebus fuse 3.2K Nov 15 12:04 recommendation_item.frm
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:04 recommendation_item.ibd
-rw-rw---- 1 messagebus fuse 2.6K Nov 15 12:04 search.frm
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:04 search.ibd
-rw-rw---- 1 messagebus fuse 5.6K Nov 15 12:04 session.frm
-rw-rw---- 1 messagebus fuse  96K Nov 15 12:05 session.ibd
-rw-rw---- 1 messagebus fuse 1.5K Nov 15 12:05 session_remember.frm
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:05 session_remember.ibd
-rw-rw---- 1 messagebus fuse 2.5K Nov 15 12:05 session_stream.frm
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:05 session_stream.ibd
-rw-rw---- 1 messagebus fuse 3.5K Nov 15 12:05 share.frm
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:05 share.ibd
-rw-rw---- 1 messagebus fuse 3.4K Nov 15 12:06 song_data.frm
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:06 song_data.ibd
-rw-rw---- 1 messagebus fuse  25K Nov 15 12:13 song.frm
-rw-rw---- 1 messagebus fuse 224K Nov 15 12:13 song.ibd
-rw-rw---- 1 messagebus fuse 4.2K Nov 15 12:06 song_preview.frm
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:06 song_preview.ibd
-rw-rw---- 1 messagebus fuse 6.6K Nov 15 12:06 stream_playlist.frm
-rw-rw---- 1 messagebus fuse  80K Nov 15 12:06 stream_playlist.ibd
-rw-rw---- 1 messagebus fuse 2.2K Nov 15 12:06 tag.frm
-rw-rw---- 1 messagebus fuse  96K Nov 15 12:06 tag.ibd
-rw-rw---- 1 messagebus fuse 1.6K Nov 15 12:06 tag_map.frm
-rw-rw---- 1 messagebus fuse  80K Nov 15 12:06 tag_map.ibd
-rw-rw---- 1 messagebus fuse 1.5K Nov 15 12:07 tag_merge.frm
-rw-rw---- 1 messagebus fuse  80K Nov 15 12:07 tag_merge.ibd
-rw-rw---- 1 messagebus fuse 1.4K Nov 15 12:07 tmp_browse.frm
-rw-rw---- 1 messagebus fuse    0 Nov 15 12:07 tmp_browse.MYD
-rw-rw---- 1 messagebus fuse 2.0K Nov 15 12:07 tmp_browse.MYI
-rw-rw---- 1 messagebus fuse 1.6K Nov 15 12:07 tmp_playlist_data.frm
-rw-rw---- 1 messagebus fuse  80K Nov 15 12:07 tmp_playlist_data.ibd
-rw-rw---- 1 messagebus fuse 3.0K Nov 15 12:07 tmp_playlist.frm
-rw-rw---- 1 messagebus fuse  96K Nov 15 12:07 tmp_playlist.ibd
-rw-rw---- 1 messagebus fuse 2.4K Nov 15 12:08 tvshow_episode.frm
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:08 tvshow_episode.ibd
-rw-rw---- 1 messagebus fuse 2.5K Nov 15 12:07 tvshow.frm
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:07 tvshow.ibd
-rw-rw---- 1 messagebus fuse  988 Nov 15 12:08 tvshow_season.frm
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:08 tvshow_season.ibd
-rw-rw---- 1 messagebus fuse 2.5K Nov 15 12:08 update_info.frm
-rw-rw---- 1 messagebus fuse  80K Nov 15 12:08 update_info.ibd
-rw-rw---- 1 messagebus fuse 1.3K Nov 15 12:09 user_activity.frm
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:09 user_activity.ibd
-rw-rw---- 1 messagebus fuse 3.5K Nov 15 12:09 user_data.frm
-rw-rw---- 1 messagebus fuse 112K Nov 15 12:09 user_data.ibd
-rw-rw---- 1 messagebus fuse 2.1K Nov 15 12:10 user_flag.frm
-rw-rw---- 1 messagebus fuse  96K Nov 15 12:10 user_flag.ibd
-rw-rw---- 1 messagebus fuse 1.1K Nov 15 12:10 user_follower.frm
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:10 user_follower.ibd
-rw-rw---- 1 messagebus fuse 8.3K Nov 15 12:08 user.frm
-rw-rw---- 1 messagebus fuse  80K Nov 15 12:08 user.ibd
-rw-rw---- 1 messagebus fuse 3.6K Nov 15 12:10 user_playlist.frm
-rw-rw---- 1 messagebus fuse 112K Nov 15 12:10 user_playlist.ibd
-rw-rw---- 1 messagebus fuse 2.5K Nov 15 12:10 user_preference.frm
-rw-rw---- 1 messagebus fuse  96K Nov 15 12:10 user_preference.ibd
-rw-rw---- 1 messagebus fuse 1.4K Nov 15 12:10 user_pvmsg.frm
-rw-rw---- 1 messagebus fuse  64K Nov 15 12:11 user_pvmsg.ibd
-rw-rw---- 1 messagebus fuse 3.7K Nov 15 12:11 user_shout.frm
-rw-rw---- 1 messagebus fuse 112K Nov 15 12:11 user_shout.ibd
-rw-rw---- 1 messagebus fuse 2.7K Nov 15 12:11 user_vote.frm
-rw-rw---- 1 messagebus fuse 112K Nov 15 12:11 user_vote.ibd
-rw-rw---- 1 messagebus fuse  24K Nov 15 12:12 video.frm
-rw-rw---- 1 messagebus fuse 144K Nov 15 12:12 video.ibd
-rw-rw---- 1 messagebus fuse 2.8K Nov 15 12:12 wanted.frm
-rw-rw---- 1 messagebus fuse  80K Nov 15 12:12 wanted.ibd

Here after I go back to setup and skip the database section since it already creates them but crashes during the setup/

image

And this is really I have in the Docker terminal, it is not clear if the mysql is there or not

ampache    | The latest information about MariaDB is available at https://mariadb.org/.
ampache    |
ampache    | Consider joining MariaDB's strong and vibrant community:
ampache    | https://mariadb.org/get-involved/
ampache    |
ampache    | => Done!
ampache    | 231115 17:52:34 mysqld_safe Logging to syslog.
ampache    | 231115 17:52:35 mysqld_safe Starting mariadbd daemon with databases from /var/lib/mysql
ampache    | => Waiting for confirmation of MySQL service startup
ampache    | => Creating MySQL admin user with random password
ampache    | => Done!
ampache    | ========================================================================
ampache    | You can now connect to this MySQL Server using:
ampache    |
ampache    |     mysql -uadmin -pxxxxxxxxxxxxx -h<host> -P<port>
ampache    |
ampache    | Please remember to change the above password as soon as possible!
ampache    | MySQL user 'root' has no password but only allows local connections
ampache    | ========================================================================
ampache    | 2023-11-15 17:53:26,157 INFO Set uid to user 0 succeeded
ampache    | 2023-11-15 17:53:26,852 INFO supervisord started with pid 1
ampache    | 2023-11-15 17:53:28,052 INFO spawned: 'apache2' with pid 193
ampache    | 2023-11-15 17:53:28,055 INFO spawned: 'cron' with pid 194
ampache    | 2023-11-15 17:53:28,057 INFO spawned: 'inotifywait' with pid 195
ampache    | 2023-11-15 17:53:28,060 INFO spawned: 'mysql' with pid 196
ampache    | 2023-11-15 17:53:29,062 INFO success: apache2 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
ampache    | 2023-11-15 17:53:29,062 INFO success: cron entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
ampache    | 2023-11-15 17:53:29,062 INFO success: inotifywait entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
ampache    | 2023-11-15 17:53:29,062 INFO success: mysql entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)

Here you can see it can't connect to the database, this is after I go back to the database page after the initial database page timed out (pasted at the top already)

image

@gerroon
Copy link
Author

gerroon commented Nov 15, 2023

Ok. After multiple tries, somehow I was able to install it, but again with all these broken steps, basically everytime I got a unaccisble page I tried to go the next step without repeating previous steps, and I also waited a bit between the steps.

@lachlan-00
Copy link
Member

i'll try and replicate from your compose file something must be weird with that.

while i get to that from docker cli you can manually install the database and add an admin user. (i think /var/www/html/ is the path but check that)

this installs the data and tables

php /var/www/html/bin/installer install -f -U admin -P $DATABASEPASSWORD -H localhost -u admin -p $DATABASEPASSWORD -d ampache

after install you can add an admin user from cli

php /var/www/html/bin/cli admin:addUser admin -p $AMPACHEPASSWORD -e admin@ampache.dev -l 100

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@lachlan-00 @gerroon