Fatal Error: Cannot connect to database, access denied.

[slambridis]

[michiel]

that error indicates there is something wrong with your database connection details.

a Database connection requires four things, and they are very sensitive to errors (just one little typo and it won't work).

- a database host (the name of the server, in many cases "localhost" works, but not always)
- a database "user" the name of the user who can connect to this host
- a database "password" the password to use for the connection
- a database "name" the name of the database to use.

if any of these four are incorrect, you get the error. So, it's best to double, triple or whatever check your settings, and otherwise ask your ISP why it doesn't work. It's possible, although a bit unlikely, that they made a mistake with their permission settings, but you never know.

and no, you did not have to upload the "bin" or "scripts" directories. Just the "lists" one is all you need in a normal situation.

[slambridis]

OK, I got it working, but how do I get rid of the "Warning: In safe mode, not everything will work as expected" from the Admin pages?

[michiel]

there's an option in the config file to switch that off.

[slambridis]

OK, I turned it off in the config file, but it still gives the same message. When I try to process a message it states:

"Your webserver is running in "safe_mode"."

I'm running a shared server off of Media Temple...is this something I have to ask them about?

[michiel]

yes, but if you're in shared hosting, it's unlikely they will switch it off.

that message will remain, even if you switch off the warnings in the config file.

[slambridis]

hmmm...so, basically since i'm on a shared server, then phplist is useless to me because i can't actually send any messages?

i would find that strange considering they pointed me to this.

[michiel]

no, if you're on a shared server or in safe mode, phplist will work fine, but not as nicely as when it hadn't been in safe mode.

[slambridis]

Ah, well allrighty then! One last question for you then (and thank you very much for the quick replies). If my list members are within the phpList app, I don't actually need to create a seperate table in mysql admin, correct? it's auto-generated based upon the list users entered through the phplist admin, yes?

learning like a newbie learns,
s

[michiel]

yes, phplist can handle all your users and you can manage them with the phplist admin interface

[RL]

Hi there, I was looking for the table that my list data(ie first name and e-mail addy) is kept in using PHPmyAdmin, but I can't find it.

I found a table with the the fields 'List Name' in it and another with 'First Name' in it(which is all I require beyond an e-mail addy), but I can't find the table with the actual data of e-mail address and first name together.

I know it is in there because it pulls out the first name using [First Name] in the test e-mails I have been sending. Reason I want to know is because I want to import a bunch of list members via SQL dump, but can't find the table!!. lol

Many thanks for your time.

Cheers,
RL

[RL]

[jessejenifer]

[Hernol]

[jessejenifer]