NB! This will deploy with using heroku's postgresql, if you need mssql use the manual method, if you need to use your custom postgresql its enough to just change the postgresql URI in the enviroments(Settings->Config Vars).
Before you continue, notice that this nadeko uses Microsoft SQL Server or PostgreSQL. If you are going to use MSSQL then you need to have your own SQL Server since heroku doesn't provide any. And for PostgreSQL you can install free/paid plugin in heroku. Why it uses remote database instead of the built-in SQLite? The answer is because of heroku's ephemeral filesystem.
-
Log(or make account) in heroku dashboard
-
Click on the "New" button in right cornet and select "create new app"
-
Enter unique app name and select region and click "Create app".
-
Select "Overview" tab and click on "Configure Add-ons".
-
In the search bar enter "Heroku Redis" and select plan(free) and install the plugin.
-
Same again but now enter "LogDNA".
-
If you are going to use PostgreSQL, then install the "Heroku Postgres" too. If MSSQL then skip this step.
-
Click on the "Heroku Redis" plugin and after you will be redirected on redis dashboard click "View Credentials..." you will see host, port, user and password. Write them down somewhere, we will need them later.
-
Go back to the main heroku dashboard(click on the app if you are on apps list) go to the "Settings" and add those buildpacks:
https://github.com/challengee/heroku-buildpack-libsodiumhttps://github.com/jonathanong/heroku-buildpack-ffmpeg-latest.githttps://github.com/dubsmash/heroku-buildpack-opus.githttps://github.com/appositum/heroku-buildpack-youtube-dl.githttps://github.com/ScarletKuro/dotnetcore-buildpackv2.1.git
NB! Watch out for extra spaces when copy-pasting.
You have two options here: MSSQL or PostgreSQL.
MSSQL option:
- In credentials.json use following type and connectionstring:
"Type": "sqlserver", "ConnectionString": "Data Source={address to database};Initial Catalog={database name};User ID={username};Password={password}"
PostgreSQL option:
- For using PostgreSQL you need to have "Heroku Postgres" plugin installed on your dyno. Remember that if you are using free plan you have only 10000 rows available.
- In credentials.json use following type and connectionstring:
"Type": "pgsql", "ConnectionString": "Host={address to database};Port={port};Database={database name};Username={username};Password={password};SSL Mode=Require;Trust Server Certificate=true;Maximum Pool Size=20;Keepalive=60"
Only edit the parameters in {} brackets, don't touch the rest if you don't know what you are doing.
NB! If you are using a domain name to connect to database take a note that some domain names may require a www prefix and some doesn't to connect to the database. For example my college SQL Server needs a www before the domain name and the gearhost's doesn't as well as heroku postgresql.
To connect to your database I recommend to use Database.NET it's a light tool and supports connection for both MSSQL and PostgreSQL databases.
-
On my github go to to the release and download the heroku-nadeko-1.9-release.zip(not the Source code or anything else)
-
Extract the zip archive in a folder
-
Edit the credentials.json the explanation is located here. But we will need to edit the RedisOptions as well. {Host}:{Port}, name={User}, password={Password} replace them with credentials from Heroku Redis Dasboard(remove the {} brackets).
And the ConnectionString and Type for Database as well, look at the "Setting Up The Database" section.
-
Save
Open Your PC terminal and type those commands:
cd <directory to the nadekobot where you extracted the archieve>heroku loginand enter your heroku credentialsgit initheroku git:remote -a <heroku app name>git add .git commit -am "init"git push heroku master
After the installation is done go to he application dashboard and click "Configure Dynos" click the edit button and toggle the dyno then "Config" button.
Now you can go to the LogDNA and view logs of your nadeko and look what it's doing
FIN.
