Am a 'rank beginner' with no knowledge of PHP etc, and have tried to follow the steps to install SI. However, it just doesn't seem to work, and I need some advice on where I'm going wrong. I use a MacBook Pro, with Mac OS X 10.5.5
1.. I downloaded MAMP and installed it fine. It is working OK.
2.. I downloaded the simpleinvoices…zip file and extracted the simpleinvoices folder to my webservers document root.
I wasn't sure of this, but it seems to be /library/webserver/documents/… on a Mac. Is this right?
3.. I changed the Apache document root address for MAMP using the MAMP preferences dashboard, to the same directory (i.e. /library/webserver/documents).
4.. I used phpMyAdmin to create a new database titled simple_invoices, as instructed. I then used the “import” feature on phpMyAdmin to import the simpleinvoices.sql file that I'd downloaded (in the zip file). This went OK.
5.. I notice that phpMyAdmin creates this database in the following directory - /MAMP/db/mysql…
Is this right? Or should I move this also to the 'document root' ie /library/webserver/documents?
6.. I modified the config.php file in /simpleinvoices/config as instructed. I left the name of the database server as 'localhost'. Pls see (5) above…. does this mean I have to move the simple_invoices database to /library/webserver/documents???
7.. I don't know how to do the chown or chmod steps…. terminal? Anyway, I used Mac's Ctrl-I option to ensure that simpleinvoices directory is “read and write” by me (ie. admin user of computer).
8.. After this, I wanted to test the thing… so I typed “http://localhost/simpleinvoices” into my browser. I get a page with a list of all the files in the directory. Incidentally, next to all the ”.php” files there is a question mark.
9.. To test php GD status, I typed “http://localhost/simpleinvoices/phpinfo.php” into my browser window, and it displays the file as if in a text editor (i.e. starting with the line ”<?php” then /*
* Script: quick_view.tpl
* Show the servers PHP settings” and so on).
Please advise me on what I've done wrong?
I've seen the demo of SI, and it is really exciting with great features for an individual consultant like me to manage invoices … but need your help in setting it up!!!
Thanks in advance for the help.
Anand
justin, 2008/09/30 07:16
Thanks Anand,
I'll reply to this question via your post in the forum
in php.ini … 32M is not enough for all operations … i put 128M and it works like a charm :)
justin, 2008/11/24 06:47
thanks p1nkrubb3rd1ld0
if you don't have 128M available 64M should be OK
Cheers
Justin
emma, 2008/12/19 00:08
Quite a few mistakes in the instructions.
You may want to simplify the steps, and make the sentances shorter…
Try finding certain fields, or experted SQL database file names etc…
This needs to be updated freqently inline with each new release!
Also, could you offer a location to get a standard php.ini file?
I wasn't provided one since migrating from my old host, to the new one. The old host did not permit EXEC, however this server does seem too.
KEEP UP THE GOOD WORK BOYS!
(:
Merry Christmas!
emm
justin, 2008/12/19 05:59
thanks for the comments emma
re mistakes
this site is a wiki, just create an account - i'll give you the right access - just send me an email - an you can update the documentation as you want
also you can just go into our wiki page - which requires no login and create a better documentation page if you wish
re try finding certain fields
i'm not 100% sure exactly what you mean - if you detail this further i'll look into it
re php.ini
good idea - i'll create a wiki page and detail the php.ini stuff that needs to be set
it wont be a full php.ini as its custom for each server
I followed instructions as listed in the README. I have managed to get the apache server up and all the correct modules using MAMP, I have moved tthe simpleinvoices directory to /Applications/MAMP/htdocs/simpleinvoices, changed the config.ini file, however as stated in the README I could not find any values labeled with the $db etccc, instead mine looks like this
I also added the user mike & password hello to phpMySQL priviliges.
Checked php info: PHP Version 5.2.6
What else do I need to do or what am I missing???
Any help will be much appreciated.
justin, 2009/01/22 02:29
hey mike
your setup all looks fine - im not sure why your getting a blank screen?
best bet is to try on the forum - someone else may have had this issue previously
cheers
justin
Mike, 2009/01/23 14:19
Installation Updates for Version 20080926 (For MAC users using MAMP & MySQL 5)
Create a simple_invoices database on your database server. I recommend you use phpMyAdmin to create/manage your new database.
- In order to do this open up MAMP or WAMP home page and click on the link “phpMyAdmin”
- In the main window you will see a heading localhost and about 7 lines down you will see a heading Create New Database. In this box enter your database name “simple_invoices” and click “Create” [you can leave the default as “Collation”]
- Once this is done you will see your new database on your left side of the screen under where it says “phpMyAdmin”.
- Click on the link of your database “simple_invoices”. You will see on the main window a new screen with many different tabs.
- Click the tab labeled “Import”.
- Your new main screen will then have a heading “File to Import”, click the “Browse” button and go to the directory simpleinvoices/databases/MySQL/ and choose the file “SimpleInvoices-MySQL5_0.sql” [Note this is for users using MySQL 5]
- At the bottom right side of the main screen click the button that says “Go”
–Your database should now be populated with the demo data supplied from the file SimpleInvoices-MySQL5_0.sql
—- I have experience certain issues with connecting to the database and a good way around it was that I created a user “test” with the password “test” in order to get simpleinvoices working originally, later you can change this for security reasons.
- In order to create a new user go back to the home screen of phpMyAdim and on the main screen click on the link “Privileges”. In the main screen about half way down click on the link that says “Add a new user”.
- In Username put “test”; Host “localhost” ; Password “test”. Then next to the heading that says Global Priviliges, click “Check All”and click “Go”
- Now the database has data and files have been 'installed' in the webservers document root, SimpleInvoice just need to have its configuration file edited and then its fine to use
In version 20080926 there is a change and the file you now need to edit is called “config.php”. This file is located in the directory /simpleinvoices/config/
Open this file with your favorite editor and edit the following fields:
database.params.host = localhost
database.params.username = test
database.params.password = test
database.params.dbname = simple_invoices
Basically things should be set up and working for the new version
Mike, 2009/01/23 20:08
Updates to Enabling the login/authentication system for SI-20080926
- The file you need to change is config.ini and is located at /simpleinvoices/config/ directory
Open the config/config.ini file and change the line $authenticationOn = “false” to $authenticationOn = “true”
*
Done :), now just open up Simple Invoices and it should redirect you to a login page
*
Note: the default username = demo@simpleinvoices.org and password = demo
If you would like to change the username and password you will need to do this via phpMyAdmin.
On the right side of phpMyAdmin click on your database (usually: simple_invoices)
Now on the right side click on the table si_users.
You can now either change the current user to what you want, or delete the current user and add your own details, or those of others:
In order to change the current user, in the main window you will see a line with the user demo@simpleinvoices.org, next to the checkbox you will see a pencil type icon (if you put your mouse over this it will say Edit), click this button and change the details to your own. Make sure that when you change your password, on the right of the box you will have a drop-down menu and you must choose MD5.
In order to delete the current user and add your own, next to the line that that says demo@simpleinvoices.org, on the right next to the edit button is a red X push this button to delete the user.
To add a new user (in mySQL 5) you will see on the top of the main window a bunch of tabs, click on the “INSERT” tab and fill out the details of the users you would like to add, remember to use the MD5 for your passwords and click GO.
You should now be able to login with your own details.
justin, 2009/01/30 13:40
awesome info mike!!
the more info you can post the better
cheers
justin
Richard Brooks, 2009/02/14 10:50
I had an existing debian lenny server with AMP (apache2,mysql,php5) already loaded.
The first problem I found was that in the zip file I downloaded, utf-8.map was missing. I logged in via ssh to my server, went into the makefont directory and typed :-
The last issue was Report generation - my phpinfo.php didn't have any relevant sections, so after a little probing of packages.debian.org I figured out the command I needed was :-
NOTE : my installation of Apache2 would not obey the restart command - a reboot fixed it, who cares about uptime anyway,on a non production server.
As for the existing data, I just used phpmyadmin to delete the rows in the relevant tables.
Overall - ABSOLUTELY love the simplicity of SI - well done
Lars Skau, 2009/12/09 20:47
Hi - I had a lot of problems with PDF export features - I kept getting error 500 on them, but after following the above description by Richard and removing .htaccess from library/pdf it worked like a charm
justin, 2009/02/15 03:19
thanks for the updates Richard - all this info helps new uses get started with Simple Invoices
Cheers
Justin
Cheryl Campbell, 2009/04/09 22:41
Excellent guide - I am a novice MySQL user, and had no problem installing and setting up a user on my GoDaddy dedicated server. I am looking forward to getting this all set up, now that I am into the application!
justin, 2009/04/14 06:22
Great to hear Cheryl that the install went well
I'm always concerned that the setup is to much work and to hard for most people - hopefully we'll get a simple installer made for Simple Invoices
Cheers
Justin
Joanie, 2009/06/24 12:35
Hello,
I am installing SimpleInvoices on my website and I am stuck in the middle of the Export to PDF part.
Sorry I don't know wiki sytax to make this look nice so please bear with me.
*
500 Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, webmaster@FFFFFF.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.7a mod_bwlimited/1.4 FrontPage/5.0.2.2635 mod_auth_passthrough/2.1 Server at www.FFFFFF.com Port 80
I have replace my website address with FFFFFF.com, thanks for your understanding.
Have I done something wrong in the previous steps? I have followed the instructions line by line and I think I managed everything well up to this part.
Also I have tried downloading the utf-8.map file that is missing in my zip file with “Save Target As” but it downloads a htm file. Where can I find/download the missing utf-8.map please?
Thank you very much for your help, sincerely,
Joanie
Export to PDF - error 404 (IIS 7), 2009/06/25 09:28
i downloaded your system and i am using globat.com for hosting. After all the installation at gloabat server, when I go to log on page and trying to log on it doesnt go anywhere or doesnt do anything. it definitely is authenticating against the database cause if I use the wrong password it warns me but whne i am using the right password it doesnt do anything.
What i am doing wrong?
Thanks
Jay
Col.Panic, 2009/10/08 07:09
same here:
authentication.enabled = true and i get the same login problem as Jay dash
htaccess and authentication.http = true and I get logo pdf problems and no print preview in firefox
documentation.txt · Last modified: 2009/09/21 09:03 by justin
Discussion
Hi
Am a 'rank beginner' with no knowledge of PHP etc, and have tried to follow the steps to install SI. However, it just doesn't seem to work, and I need some advice on where I'm going wrong. I use a MacBook Pro, with Mac OS X 10.5.5
1.. I downloaded MAMP and installed it fine. It is working OK.
2.. I downloaded the simpleinvoices…zip file and extracted the simpleinvoices folder to my webservers document root.
3.. I changed the Apache document root address for MAMP using the MAMP preferences dashboard, to the same directory (i.e. /library/webserver/documents).
4.. I used phpMyAdmin to create a new database titled simple_invoices, as instructed. I then used the “import” feature on phpMyAdmin to import the simpleinvoices.sql file that I'd downloaded (in the zip file). This went OK.
5.. I notice that phpMyAdmin creates this database in the following directory - /MAMP/db/mysql…
6.. I modified the config.php file in /simpleinvoices/config as instructed. I left the name of the database server as 'localhost'. Pls see (5) above…. does this mean I have to move the simple_invoices database to /library/webserver/documents???
7.. I don't know how to do the chown or chmod steps…. terminal? Anyway, I used Mac's Ctrl-I option to ensure that simpleinvoices directory is “read and write” by me (ie. admin user of computer).
8.. After this, I wanted to test the thing… so I typed “http://localhost/simpleinvoices” into my browser. I get a page with a list of all the files in the directory. Incidentally, next to all the ”.php” files there is a question mark.
9.. To test php GD status, I typed “http://localhost/simpleinvoices/phpinfo.php” into my browser window, and it displays the file as if in a text editor (i.e. starting with the line ”<?php” then /* * Script: quick_view.tpl * Show the servers PHP settings” and so on).
Please advise me on what I've done wrong?
I've seen the demo of SI, and it is really exciting with great features for an individual consultant like me to manage invoices … but need your help in setting it up!!!
Thanks in advance for the help.
Anand
Thanks Anand,
I'll reply to this question via your post in the forum
http://simpleinvoices.org/forum/discussion/623/installation-woes/
Cheers
Justin
i would like to note one thing …
in php.ini … 32M is not enough for all operations … i put 128M and it works like a charm :)
thanks p1nkrubb3rd1ld0
if you don't have 128M available 64M should be OK
Cheers
Justin
Quite a few mistakes in the instructions. You may want to simplify the steps, and make the sentances shorter… Try finding certain fields, or experted SQL database file names etc…
This needs to be updated freqently inline with each new release!
Also, could you offer a location to get a standard php.ini file? I wasn't provided one since migrating from my old host, to the new one. The old host did not permit EXEC, however this server does seem too.
KEEP UP THE GOOD WORK BOYS! (: Merry Christmas! emm
thanks for the comments emma
re mistakes
re try finding certain fields
re php.ini
cheers
justin
Hi,
I followed instructions as listed in the README. I have managed to get the apache server up and all the correct modules using MAMP, I have moved tthe simpleinvoices directory to /Applications/MAMP/htdocs/simpleinvoices, changed the config.ini file, however as stated in the README I could not find any values labeled with the $db etccc, instead mine looks like this
roduction]
database.adapter = pdo_mysql
database.params.host = localhost
database.params.username = mike
database.params.password = hello
database.params.dbname = simple_invoices
I created the DB and imported the mysql file.
My problem is when I go to http://localhost:8888/simpleinvoices/index.php all i get is a blank page.
[BTW, I am running everything on MAC OS 10.5.6]
I also added the user mike & password hello to phpMySQL priviliges.
Checked php info: PHP Version 5.2.6
What else do I need to do or what am I missing???
Any help will be much appreciated.
hey mike
your setup all looks fine - im not sure why your getting a blank screen?
best bet is to try on the forum - someone else may have had this issue previously
cheers
justin
Installation Updates for Version 20080926 (For MAC users using MAMP & MySQL 5)
Create a simple_invoices database on your database server. I recommend you use phpMyAdmin to create/manage your new database. - In order to do this open up MAMP or WAMP home page and click on the link “phpMyAdmin” - In the main window you will see a heading localhost and about 7 lines down you will see a heading Create New Database. In this box enter your database name “simple_invoices” and click “Create” [you can leave the default as “Collation”] - Once this is done you will see your new database on your left side of the screen under where it says “phpMyAdmin”. - Click on the link of your database “simple_invoices”. You will see on the main window a new screen with many different tabs. - Click the tab labeled “Import”. - Your new main screen will then have a heading “File to Import”, click the “Browse” button and go to the directory simpleinvoices/databases/MySQL/ and choose the file “SimpleInvoices-MySQL5_0.sql” [Note this is for users using MySQL 5] - At the bottom right side of the main screen click the button that says “Go” –Your database should now be populated with the demo data supplied from the file SimpleInvoices-MySQL5_0.sql
—- I have experience certain issues with connecting to the database and a good way around it was that I created a user “test” with the password “test” in order to get simpleinvoices working originally, later you can change this for security reasons. - In order to create a new user go back to the home screen of phpMyAdim and on the main screen click on the link “Privileges”. In the main screen about half way down click on the link that says “Add a new user”. - In Username put “test”; Host “localhost” ; Password “test”. Then next to the heading that says Global Priviliges, click “Check All”and click “Go”
- Now the database has data and files have been 'installed' in the webservers document root, SimpleInvoice just need to have its configuration file edited and then its fine to use
In version 20080926 there is a change and the file you now need to edit is called “config.php”. This file is located in the directory /simpleinvoices/config/
Open this file with your favorite editor and edit the following fields:
database.params.host = localhost database.params.username = test database.params.password = test database.params.dbname = simple_invoices
Basically things should be set up and working for the new version
Updates to Enabling the login/authentication system for SI-20080926
- The file you need to change is config.ini and is located at /simpleinvoices/config/ directory
Open the config/config.ini file and change the line $authenticationOn = “false” to $authenticationOn = “true” * Done :), now just open up Simple Invoices and it should redirect you to a login page * Note: the default username = demo@simpleinvoices.org and password = demoIf you would like to change the username and password you will need to do this via phpMyAdmin.
You should now be able to login with your own details.
awesome info mike!!
the more info you can post the better
cheers
justin
I had an existing debian lenny server with AMP (apache2,mysql,php5) already loaded.
The first problem I found was that in the zip file I downloaded, utf-8.map was missing. I logged in via ssh to my server, went into the makefont directory and typed :-
wget http://www.simpleinvoices.org/demo/library/pdf/fpdf/font/makefont/utf-8.map
That fixed the PDF generation issues.
For Apache2 under debian lenny, the permissions needed are www-data.www-data Hence - the commands I typed for permissions were :-
chown www-data.www-data cache chown www-data.www-data library/pdf/fpdf/ -R chown www-data.www-data database_backups
The last issue was Report generation - my phpinfo.php didn't have any relevant sections, so after a little probing of packages.debian.org I figured out the command I needed was :-
apt-get install php5-xsl /etc/init.d/apache2 restart
NOTE : my installation of Apache2 would not obey the restart command - a reboot fixed it, who cares about uptime anyway,on a non production server.
As for the existing data, I just used phpmyadmin to delete the rows in the relevant tables.
Overall - ABSOLUTELY love the simplicity of SI - well done
Hi - I had a lot of problems with PDF export features - I kept getting error 500 on them, but after following the above description by Richard and removing .htaccess from library/pdf it worked like a charm
thanks for the updates Richard - all this info helps new uses get started with Simple Invoices
Cheers
Justin
Excellent guide - I am a novice MySQL user, and had no problem installing and setting up a user on my GoDaddy dedicated server. I am looking forward to getting this all set up, now that I am into the application!
Great to hear Cheryl that the install went well
I'm always concerned that the setup is to much work and to hard for most people - hopefully we'll get a simple installer made for Simple Invoices
Cheers
Justin
Hello,
I am installing SimpleInvoices on my website and I am stuck in the middle of the Export to PDF part. Sorry I don't know wiki sytax to make this look nice so please bear with me.
I can't find this page 'html2ps/pdf demo' to test. I tried opening the following files: http://localhost/simpleinvoices/library/pdf/demo/html2ps.php http://localhost/simpleinvoices/library/pdf/html2ps.php but both pages will give me the following Error, it happens in both IE and FireFox.
* 500 Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, webmaster@FFFFFF.com and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request. Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.7a mod_bwlimited/1.4 FrontPage/5.0.2.2635 mod_auth_passthrough/2.1 Server at www.FFFFFF.com Port 80
I have replace my website address with FFFFFF.com, thanks for your understanding.
Have I done something wrong in the previous steps? I have followed the instructions line by line and I think I managed everything well up to this part.
Also I have tried downloading the utf-8.map file that is missing in my zip file with “Save Target As” but it downloads a htm file. Where can I find/download the missing utf-8.map please?
Thank you very much for your help, sincerely, Joanie
hi,
I am getting this error when try to export pdf :
HTTP error 404
Could not open URL http://localhost/simpleinvoices/index.php?module=invoices&view=templates/template&invoice=5&action=view&location=pdf you've specified.
Server responded with:
HTTP/1.1 404 Not Found
Cache-Control: private
Content-Length: 7359
Content-Type: text/html; charset=utf-8
Server: Microsoft-IIS/7.0
X-Powered-By: ASP.NET
Date: Thu, 25 Jun 2009 05:20:05 GMT
html2pdf test is working fine.
thanks.
hi
i downloaded your system and i am using globat.com for hosting. After all the installation at gloabat server, when I go to log on page and trying to log on it doesnt go anywhere or doesnt do anything. it definitely is authenticating against the database cause if I use the wrong password it warns me but whne i am using the right password it doesnt do anything.
What i am doing wrong?
Thanks
Jay
same here: authentication.enabled = true and i get the same login problem as Jay dash htaccess and authentication.http = true and I get logo pdf problems and no print preview in firefox