configuring .dada_config after migrating / new SQL db

[n0b0daddy]

Hi. I have been trying to migrate Dada Mail to a new server, following the instructions provided.
However, and perhaps this is more of a general web developer (which I am definitely NOT) question, the config file shows the SQL password in an encrypted format. I've changed the other configurations (database name, username, etc) for the new (old, but moved and with different users and passwords) SQL database. How do I encrypt (or view encrypted) the new password for the dada SQL db I've imported to the new server, so I can enter it in to the config file?
Thanks, Andy

[justin]

I'm a little confused, as the SQL password, when you save it in Dada Mail's config, is never encrypted. It may *look* encrypted - but it may simply be made up of very random letters/numbers/symbols.

[n0b0daddy]

hmm... but surely I chose the password at some point? oh, would Dada Mail have created the SQL db and given it a password itself during the installation? Either way, I still need to change it, as the new site has new usernames and passwords, so I'll try just writing the new PW into the config file and see how I get on. Cheers

[justin]

If you used the installer that comes with Dada Mail, you would have configured the SQL password yourself.

If you used something like Simple Scripts, it would have created the password for you - and it could have been very random indeed.

[n0b0daddy]

ah, yes, cheers - I did use Simple Scripts. Still having loads of bother - I've configured everything I'm told to in Config.pm and .dada_config but when I browse to mail.cgi it comes up with:

couldn't tie /home/phant462/public_html/cgi-bin/dada/.dada_files/.lists/mj-phantomail for reading: Inappropriate ioctl for device; If your server recently upgraded software or moved
your lists to a different server, you may need to restore your list settings. Visit http://www.phantomband.co.uk/cgi-bin/da ... tore_lists at mail.cgi line 718

any thoughts??
Cheers,
Andy

[justin]

I've configured everything I'm told to in Config.pm and .dada_config but when I browse to mail.cgi it comes up with:

couldn't tie /home/phant462/public_html/cgi-bin/dada/.dada_files/.lists/mj-phantomail for reading: Inappropriate ioctl for device; If your server recently upgraded software or moved
your lists to a different server, you may need to restore your list settings. Visit http://www.phantomband.co.uk/cgi-bin/da ... tore_lists at mail.cgi line 718

Feel free to include your .dada_config file in its entirety to your reply, but it doesn't seem like you've configured things correctly. This error points to perhaps you're not using the SQL backend at all.

It also sounds like you're doing a pretty manual installation - If you can, I'd suggest just migrating that old SQL database over to your new server, note the server, username and password and use the Dada Mail installation and these directions:

http://dadamailproject.com/support/docu ... l.pod.html

When it asks for your SQL info, try placing the info you have. The installer will probably notice that you already have the correct tables installed and ask you if you want to use those, instead of making new ones.


Also, don't put your .dada_files directory in your cgi-bin, or your public_html directory. It's a security problem.

[n0b0daddy]

OK, I'm about to start from scratch.
I already have the SQL db migrated exactly as it was on the old site, but obviously usernames and passwords aren't migrated with them so I have to create a new user for Dada to be.
Problem is that if I do a new install and, as you say, try pointing the SQL install to the existing db, won't it intall the program with only the list in place, rather than the list plus all of my settings/custom messages & forms/templates?
Also, it will be a newer version.

That stuff was only in cgi-bin as the migrating instructions recommended it.

Would it be easier to just do a new install and import what I need? I'm not sure how to integrate SQL data but I'm sure I can find out.
I'd then need to find out which of the Dada files I need to replace with my old ones...
Any ideas much appreciated.

Andy

[n0b0daddy]

...or, if I could just import/mass subscribe the mailing list (ie without the users having to be inconvenienced with another opt-in loop) and find a way of logging into the Dada admin panel of my old site to copy some data manually, now that the nameservers no longer point there - I can reach the admin login using the IP address of the hosting, (ie http://69.89.22.128/~phantom8/mailingli ... cgi/admin/) but as soon as I submit password, the Dada redirects to where phantomband.co.uk is now pointing. Is there a way of somehow logging in without using that submit button?

[justin]

Problem is that if I do a new install and, as you say, try pointing the SQL install to the existing db, won't it intall the program with only the list in place, rather than the list plus all of my settings/custom messages & forms/templates?

Most everything, except maybe the list template (saved as a separate file) should be saved in the SQL database. Settings, archives, and the mailing list itself, as well as more should be in the SQL database.

Also, it will be a newer version.

Dada Mail will try to detect that and if needed, it'll tell you to use a migration script. The upgrade docs do go over that as well.

Is there a way of somehow logging in without using that submit button?

Change the $PROGRAM_URL of the old Dada Mail to point to that new URL?