Mailtrain (v1) unlisted from app store

[jdaviescoates]

@girish said in Mailtrain (v1) unlisted from app store:

mautic

When I looked a Mautic I found it tool complex for my needs. Didn't seem to be obvious/ easy to just quickly use it to set-up a mailing list.

[luckow]

@jdaviescoates give Listmonk a chance.

[marcusquinn]

EspoCRM can do similar, too.

[girish]

@marcusquinn interesting, I didn't know it can run campaigns and manage lists!

[marcusquinn]

@girish Yeah, TBH you can do so much more with it, it's a full low-code business app development platform.

The things you're looking for are Campaigns, Target Lists, Email Templates. It also tracks email opens and clicks.

We've developed it a lot for internal use, you can pretty-much run a full business experience on it. Much faster that Odoo to work with, too.

[jordanurbs]

I'm having trouble finding the username for my Mailtrain account that I used for an email list a few years ago. I'd like the list back now but I can't login.

Any tips for finding that list of email addresses in the app terminal?

[marcusquinn]

@jordanurbs I asked ChatGPT for you, and it says:

Given that I can't directly assist with this due to privacy and security reasons, here's a general way you could try to recover your data:

If you don't have the necessary permissions or if you're not comfortable working with databases, it would be a good idea to get the assistance of an IT professional. Missteps in the following steps could potentially cause data loss.

1. Access the terminal for the Mailtrain app on Cloudron: You should be able to access the terminal for the Mailtrain application from within the Cloudron dashboard. Navigate to the relevant app and click on the "Console" or "Terminal" button.

2. Locate the database: Mailtrain stores its data in a MySQL or MariaDB database. You should be able to find details on the database used, including its name and authentication details, in the app's configuration file.

3. Access the database: Once you have the database name and authentication details, you can use the mysql command-line tool to interact with the database. The command to access the database will look something like this:

   mysql -u USERNAME -p DATABASE_NAME
   

   Replace USERNAME and DATABASE_NAME with your actual database username and name. You will be prompted to enter the database password.

4. Find your data: You will now be in the MySQL/MariaDB shell and you can issue SQL commands to interact with your data. You can use a command like the following to list all the tables in the database:

   show tables;
   

   You will need to look for a table that likely contains user information, such as users or admins.

5. Retrieve your username: Once you have identified the correct table, you can issue a SQL query to retrieve your username. The query might look like this:

   SELECT username FROM users;
   

   This command will display all the usernames in the users table. You should be able to identify yours from the list.

If you can't remember your password, you likely won't be able to retrieve it since it's probably stored as a hashed value for security reasons. You would need to reset it.

Remember that this is a general process and it might be different depending on your specific setup. Always be careful when working with live databases to prevent any data loss.

It would also be a good idea to contact Cloudron or Mailtrain support for help in recovering your account. They might be able to assist you without you needing to directly interact with the database.

[jordanurbs]

@marcusquinn hey thanks, I totally forgot about ChatGPT! It's giving me mysql command lessons as we speak. Cheers.

[girish]

If you open a web terminal , there is a MySQL button on the top which will paste the mysql command . Just press enter and you should have a connection to run SQL queries.

[marcusquinn]

@girish That is a super handy feature!