I just downloaded the trial version and I've uploaded amember files to my webhosting Finished the first step however on step two... i am getting this message. Cannot connect to mysql (Can't connect to local MySQL server through socket '/usr/local/mysql-5.0/data/mysql.sock' (2)) why is that?
Did you enter you mysql database name and user/password details etc. correctly? Have you even created a MySql database?
You should not have to change anything on a fresh install as the wizard should take care of it for you. The errors you are getting are indicative of either no Db existing or no communication to the Db server. Do you have any other apps that use MySQL installed? You may want to double check their configuration. Some considerations: 1) You have an existing MySQL database created (not just access to MySQL, but a database (empty or not) previously created. (what is your Db name?) 2) You have the correct name of the MySQL server (or localhost if applicable) (what is your server name?)
skippybosco, I do have have a MYSQL thing for my wordpress blog however I created a new one for amember and I don't why it would be conflicting with each other... what should I do? Is there a video tutorial that would help me step by step? This is not as easy as I thought it would be. I think aMember should provide more visualized tutorial so people would know how to do everything... it would help the sales go up. I am thinking to open up an account with CCBill.com instead... it's prob. easier. advises please thank you guys!
sorry for any confusion, not suggesting that it is conflicting but that you should check your wordpress configuration for what you have set as the server name (it is using localhost or an actual server name). I'm mentioning this as the error message you are receiving is not an Amember issue so much as the ability for the script to communicate with the database as configured. It is actually a fairly easy script to install and configure once you have the right information.
Okay I figured out what went wrong... problem fixed. Now I have to figure out more about the templates... How would you compare aMember to CCBILL.com?
Great News! Just in case anyone else runs into the same problem, what was wrong with the database/config? How did you fix it? I have not used ccbill.com myself, but from what I can tell they are a hosted solution.. so some lack of control over the code base, having to redirect (?) to a different domain during transaction? (all guesses since I don't use it myself) Comes down to your needs. Do you need transaction support? How about folder protection? How about single signon across multiple scripts?
How to fix this issue Hey everyone, Just thought I'd follow up with the resolution on this since I had the same problem... The issue was with the host name. By default, aMember will insert "localhost" into this field during setup. You need to visit your control panel > MySQL Databases and double check what your host name is. More than likely it's NOT "localhost". Type in your correct host name and BINGO. You're good to go. Hope this helps. Regards, Levi
Thanks Levi Levi - you rock. I was having this same problem. I fell victim to the suggestion in the AMember set up that the host name is "often" localhost. They should change that wording and instead direct you to check the control panel for your web site. For those who have GoDaddy, the host name looks like this. Server: <dbname>.db.5929146.hostedresource.com (nnn.nnn.nn.nn via TCP/IP) In this case, if your database is testdb, your hostname is testdb.db.5929146.hostedresource.com
Hey guys maybe you could help me out, I am having the same sort of bullshit error when setting up, the difference is that I am getting this error message: # Cannot connect to mysql (Access denied for user 'amember'@'localhost' (using password: YES)) I setup my mysql database, aswell as a user "amember", who I gave all permissions for my db (also named "amember"). I am using the correct db name, username, and password, so WTF??? I am pretty sure my mysql host is indeed "localhost", so I dont believe that is the problem. I also made sure to change my folders permissions to 777 for the directories *amember/data/, * amember/data/new_rewrite/, and * amember/templates_c/ as per the step by step instructions I am amazed amember doesnt provide instructions on how to setup the mysql db, I was lucky that I have done a little bit of it before thanks Jesse
@Jesse: That error is nothing to do with file/folder permissions, strictly accessing the dB. Couple of things come to mind: 1) Double check you should be using localhost. Who is your host? 2) While you created the user name amember, sometimes your server configuration will append the account name before it (ex. account_amember) if this is the case, be sure you are using the right name (both username and dB name could have this issue)