I'm probably going to sound like a complete idiot asking what I am going to, but I've been struggling with this for a while now and hope someone has been in the same boat as me.
I do not currently have a MySQL database set up for Coppermine, mainly because I have been looking for a free available one over the internet (I know free ones are less reliable and harder to come by, but I can't afford webspace at the minute) but have not had much success (I've signed up to a couple, but they will never connect to the FTP program). Does anyone use a free MySQL database that they found on the net? and if so could they point me in the right direction?
Also, with regards to uploading Coppermine, which program is best to use? (I've not had a lot of experience using FTP and all that, I'm currently trying out WS_FTP Home and CuteFTP that were recommended, but neither of these will connect, making me think it's a problem with the MySQL host).
I'm aware that I sound like a total retard, but I'm trying to get my head around this and if you can bear with me I would be very grateful. Has anyone else been in the same situation? if so, where did you find a reliable MySQL database to set up?
Thanks :-\\
Hysteria,
Hi.
Are you trying to set up a local server on your computer? You don't need MySql if you are going to set up on a remote server. The remote server would have that already installed.
If you are planning to install a local server on your own computer to work with coppermine before actually putting your site online, then the simplest approach for the unfamiliar would be to search for XAMMP. Download the self-installing version appropriate to your operating system. Run MyPHPadmin on it and create a database. Copy your coppermine folder into the htdocs directory in XAMMP. Then install CPGl i.e. "http://localhost/CoppermineFoldername/install.php"
(Note: Uploading your finished CPG to a remote server will ultimately involve creating your own update.sql file to export all the changes to your completed gallery. )
If you prefer to work on it on a remote server you may want to check these listings: http://forum.coppermine-gallery.net/index.php?topic=5721.0 Setup is the same. You will need to create a blank database, copy your CPG files into the appropriate folder as instructed by your webhost and run CPG's install.php. ie. Http://www.yournewurl.com/install.php
Hope this helped.
Dennis
(Oh yeah, insofar as FTP programs are concerned either one is good. I use Smart FTP on one machine, WS_FTP on another. It's really just an interface choice. Try several, then select the one that you are most comfortable using.)
Yeah I've been taking the remote server approach, that thread link has helped, just waiting to see if I can find an FTP program that will actually connect to the webhost now.
Quote from: Hysteria86 on September 09, 2005, 10:02:10 PM
, just waiting to see if I can find an FTP program that will actually connect to the webhost now.
Ah! Well that would help. ;) It's been a while since I set up my FTP's but I believe one of the common errors is to set the User ID and password to the coppermine User ID and Password. It should be the User ID and Password used with your Web server.
Good luck.
Dennis
Yeah I can't get WS_FTP to work whatsoever.
CuteFTP doesn't show an error message but it is continuously attempting to establish a connection but doesn't get anywhere (keeps retrying). I've tried this with two different hosts that I've signed up to and the same thing happens.
I'll get there soon. I hope. :-\\
Woah not good, huh?
Have you tried typing in ftp://yourwebsite.com in your browser, not using a 3rd part ftp engine, and entering your password and user id just to see if you can get in? Slower than a snail on an oiled leaf, but it should get you in to do some basic work.
Also, I believe Ws_ftp and cute use mulitple threads, sessions, or whatever they call it to make mulitiple connections to your site to speed up the upload/download process. Try limiting these to 1 or two.
Dennis
You don't use an FTP app to connect to a mysql server - it's a database, you know! You just enter the mysql data into coppermine's config file during install and that's about it.
Warning: it's not recommended at all that you try self-hosting with so little expertise!
Yeah I'm just trying to learn it.
Was hoping someone else has tried to set it up from my point of view.
All I've done so far is downloaded and unzipped the Coppermine file. What should I be doing next? (I've not had success creating or finding a MySQL database for free, that's what I'm having the main trouble with).
Quote from: Hysteria86 on September 11, 2005, 12:58:37 PM
What should I be doing next? (I've not had success creating or finding a MySQL database for free, that's what I'm having the main trouble with).
Did you sign up with webhost service?
If you did, you should be able to access the "phpMyAdmin" from the administrative page of your new site. Use "phpMyAdmin" to create a new database. Just give the database a name, don't add any tables. The database that is created is the beginnings of your MySQL database. When you run the install setup of coppermine, Coppermine will add the necessary tables and entries into this database where it will store the data it needs to operate your gallery.
Chances are you will not be able to see any database file you create as these are safely tucked away somewhere else in your hosting services system. You can, however, browse the data in the file using phpMyAdmin.
Upload your coppermine files to whatever folder your hosting service instructs you to use (usually http://yourwebsite.com/public_html/) and follow the installation instructions for coppermine.
Dennis
Quote from: madeinhawaii on September 11, 2005, 08:56:53 PM
Quote from: Hysteria86 on September 11, 2005, 12:58:37 PM
What should I be doing next? (I've not had success creating or finding a MySQL database for free, that's what I'm having the main trouble with).
Did you sign up with webhost service?
I've been looking but have not had much success so far. Does anyone know of any decent, reliable (free) ones?
Apologies, I'm really new to this but really intent on learning it. :-\\
Please search the board.
http://forum.coppermine-gallery.net/index.php?board=12.0
Ok, I've created the Database, hopefully with success this time, I have the following from my webhost:
The MySQL database has been successfully created for your account.
MySQL DataBase name: 1031
MySQL DataBase login username: 1031
MySQL DataBase login password: The same as for FTP and account manager
MySQL DataBase hostname: localhost
To admin your database please go to: phpMyAdmin using your MySQL username and password
Do I now go to the FTP program and upload it?
Upload all of the files with your FTP client and run the install.php file. Please read the documentation that comes with Coppermine before going any further.
Can anyone recommend a good FTP client to download?
I can't get WS_FTP to work at all.
I use TurboFTP - an excellent FTP client. 30 day fully functional trial.
You may want to try SmartFTP.
It's free.
http://www.smartftp.com/
Good luck! Don't be discouraged. I was where you are today, just 6 weeks ago.
Dennis
For some reason it's saying my password is incorrect, so it won't connect.
I've just enquired and received an e-mail of my account data from the host:
Your Personal MySQL Information
MySQL DataBase
1031
MySQL HostName
localhost
MySQL UserName
1031
The same as for FTP
SmartFTP message I got....
SmartFTP v1.5.990.2
Resolving host name "pinoybabes.com"
Connecting to 205.209.152.84 Port: 21
Connected to pinoybabes.com.
220---------- Welcome to Pure-FTPd ----------
220-You are user number 1 of 50 allowed.
220-Local time is now 04:30. Server port: 21.
220-This is a private system - No anonymous login
220-IPv6 connections are also welcome on this server.
220 You will be disconnected after 15 minutes of inactivity.
USER 1031
331 User 1031 OK. Password required
PASS (hidden)
530 Authentication failed, sorry
Active Help: http://www.smartftp.com/support/kb/index.php/51
QUIT
221-Goodbye. You uploaded 0 and downloaded 0 kbytes.
221 Logout.
Cannot login waiting to retry (30s)...
Server closed connection
Verify all of your names and passwords are correct. Read this post (http://forum.coppermine-gallery.net/index.php?topic=16217.msg75687;topicseen#msg75687) and do what it says. Report back with your results.
After I posted this, I see you edited your previous post. You don't put in your MySQL information in your FTP client - use your FTP connection information.
Ok it's connected and seems to be uploading. Is it normal for it to take quite a while?
If it looks like it's uploading... it should display somewhere on smartftp ... xx kbs / sec . The speed of the upload depends really on the speed of your hosting service. A really busy server may upload slower or faster depending on the time of day.
Dennis
Trying to run the Install script now, not working though >:(
http://pinoybabes.com/coppermine_dir/install.php is what I've entered. :-\\
Where am I meant to enter this?
Point your browser to wherever you uploaded your Coppermine files. We don't know where you put your files.
coppermine_dir is just an example. Your gallery is actually here (apparently installed already): http://www.pinoybabes.com/photogallery/
Quote from: Hysteria86 on September 11, 2005, 11:26:26 PM
Trying to run the Install script now, not working though >:(
http://pinoybabes.com/coppermine_dir/install.php is what I've entered. :-\\
Where am I meant to enter this?
When you signed up with pinoybabes.com didn't they give you a 'domain name'?
What you should be typing in is: Http://your_new_domain_name/name_of_coppermine_install_folder/install.php
where "your_new_domain_name" is replaced with the the url they gave you or the domain name you signed up with your webhost.
and "name_of_coppermine_install_folder" is replaced with the name of the folder in which your coppermine install.php is located.
Dennis
This is where it's stored:
stmarys.cagayanvalley.com/cpg133/install.php
I presume that's what I enter but it doesn't go anywhere when I try and enter it.
Quote from: Hysteria86 on September 12, 2005, 11:28:11 AM
This is where it's stored:
stmarys.cagayanvalley.com/cpg133/install.php
I presume that's what I enter but it doesn't go anywhere when I try and enter it.
Hysteria,
I can get to "Http://stmarys.cagayanvalley.com/" but not "http://stmarys.cagayanvalley.com/cpg133/" . This kind of indicates to me that the folder cpg133 doesn't exist in the right place. Usually your host server provides you with a couple of places to upload your folders and files. Most commonly, public_html for your website and public_ftp for uploads by others. Your coppermine folder should reside in the public_html folder. If you do not have a public_html folder, check your service provider's instructions as to where to install your website folder and files.
Dennis
In the member area there are 8 options:
'Account Data'
'Change Password'
'File Manager' (where the files currently are at the minute, it allows the creation of directories and files if this is any significance.)
'Install Forum'
'phpMyAdmin'
'Delete DB'
'Delete Account'
'Upgrade'
Should I create the said folders in there or would it not make any difference?
When you click on the FileManager doesn't it display a number of pre-existing folders and files?
Dennis
It shows the Coppermine files that I've uploaded, but nothing else.
Quote from: Hysteria86 on September 12, 2005, 12:24:41 PM
It shows the Coppermine files that I've uploaded, but nothing else.
Hmmm. Try contact your hosting service and ask them if there is a specific folder you need to create where you are supposed to upload your website files.
Other than that, you might look for an "index.html" (not the ones in the coppermine folders) but somewhere else in your site. Click on it and see if it is the default page one sees when they log onto " http://stmarys.cagayanvalley.com". If you can find it, that's where your folder should be.
Dennis
I don't understand why the http://stmarys.cagayanvalley.com comes up with cPanel.
There doesn't seem to be anywhere within the account that allows me to edit that page >:(
Quote from: Hysteria86 on September 12, 2005, 07:18:54 PM
When I look at what I've uploaded which Coppermine files should I be able to see? (without clicking on any of the files), as there's an index file there, but I'm not sure if it's part of Coppermine or not.
Chances are you will see your coppermine folder "cpg133" and an index.html file. We are looking for an index.htm or index.html file that is NOT in the cpg133 folder.
When you click on that index.htm or html file, you should see your default homepage. The one that everyone would see when they go to your URL.
http://cagayanvalley.com/cms/forum_viewtopic.php?48.746 Aysoos, my understanding of filipino dialects is but one or two words -- none of which I can say around women and children, :-) but you may want to look around this forum for installation instructions specific to your host.
Dennis
Dennis
Had a look but couldn't find anything I could understand.
Does anyone else use pinoybabes.com?
Quote from: Hysteria86 on September 12, 2005, 09:32:29 PM
Had a look but couldn't find anything I could understand.
Does anyone else use pinoybabes.com?
Hysteria,
Post your install question on the Pinoybabes.com forum or Cagayanvalley.com forum. Someone there can tell you exactly where your uploaded files should be. They use Coppermine as well.
Dennis
Hysteria,
I just got an email response from Andy, one of the Administrators for your webhost. He says the subdomains for cagayanvalley.com and loversinparis.com are still not operable. He didn't say when they would be either. I guess you'll just have to sit and wait. I'm somewhat curious as to how you found their service as they are relatively new with only 186 members and what looks like two administrators.
Dennis
Ah ok, thanks for finding that out anyway.
I may try and find another free host in the meantime, as ideally I'd like to get the gallery set up before this time next week.
Trouble is they're pretty hard to come by, that's the only one I've found so far where I've managed to actually create the database :-\\
I'd signed up here http://free-mysql.bizhostnet.com/, but I could never get it to connect, or actually see where you can log in to do anything.
What are you expecting to login to ? All they will give you is a username and password by which you can connect to your database.
Quote from: Nibbler on September 13, 2005, 03:58:03 PM
What are you expecting to login to ? All they will give you is a username and password by which you can connect to your database.
Oh right I see. I was thinking you had to configure your database somewhere within your hosted account.
I've just been given a username and password. What do I do with them in order to upload my Coppermine gallery?
You need to upload the coppermine files to some webspace and then enter the details given to you into the installer when prompted. Be aware that you need webspace to install coppermine aswell as a mysql database.
Right, I've signed up to 100webspace and have successfully created a database.
Where should I be uploading Coppermine to?
I've seen that a couple of people are using/have used 100webspace so hopefully they can point me in the right direction.
Hysteria,
I think you would get a lot better response regarding this step if you posted it on the forums at 100Webspace. Before running the coppermine install.php, do a search on 100Webspace forums for "imagick" or "GD". I believe that 100webspace uses imagick and you will need the path to imagick when your run coppemine's installation.
Dennis
"imagick" is not ImageMagick. That is a PHP extension of ImageMagick. Coppermine does not use imagick extensions, it uses standard command-line ImageMagick interface. You will still need the location of the ImageMagick convert binary. Most hosts provide GD2, which provides excellent image conversion utilities and they are built into PHP.
kegobeer,
I was browsing through the forum pages on 100Webspace and they mentioned that they do not support GD and that they support Image Magic (This was in reference to an attempted Coppermine install). I thought this a bit unusual, but felt it was worth mentioning. This is why I posted the previous message. I didn't post the path here because it might be more webhost specific and there was some confusion as to what the real path was for 100Webspace.
regards,
Dennis
I just wanted to clarify that imagick is not ImageMagick, to prevent any confusion.
upload speed depends on your internet connection as well. If you're on ADSL, your upstream (the speed to upload files) will be considerably slower than your downstream (the speed to download files from the web or browse the internet). Patience, grasshopper ;)
Joachim