*What steps will reproduce the problem?* 1. Set config to use sql for storage (I also have mod_auth_sql for authentication) 2. Delay startup of MySQL server on boot. 3. Reboot. *What is the expected output? What do you see instead?* Prosody should retry connection to MySQL if it fails initially. *What version of the product are you using? On what operating system?* 0.9.1 under Ubuntu 14.01 *Please provide any additional information below.* Discussed this on IRC. Adding `require("socket").sleep(20);` to config solved the issue for me.

Hi, thanks for the report and sorry for the delay in processing it. This is a problem I've been looking at solving in our new SQL code in 0.10. I've modified the title because it affects both MySQL and PostgreSQL too.

• owner MattJ
• title SQL storage fails to load while database not available
• tags Milestone-0.10 Status-Accepted

mod_storage_sql2 in 0.10 should deal with this situation now and attempt to connect when needed. Also see #417 and #268

• tag Status-Fixed