Jump to content


  • Posts

  • Joined

  • Last visited

Profile Information

  • Gender
  • Location
    Calgary, Alberta
  • Age

DeX's Achievements

Advanced Member

Advanced Member (4/5)




Community Answers

  1. Sorry, I should have included that. We will be running reports based on which quotes have certain criteria: - how many are over a certain length - how many have item X selected - how many of item X we sold These are all based on user entered inputs and wrapped up in the JSON. The reports are generated whenever anyone loads the reports page to view them, they're not done on a schedule like nightly.
  2. The inputs are related to quotes being sent to customers so often times a customer will want to modify their quote, in which case the user will open an old one, load all of the input values from the database and change some, only to re-save it with the new inputs. The re-save does not modify the old table row, it simply creates a new row under the same account.
  3. I have a system where users enter about 100 inputs, not all are required. We capture every input when the user clicks save and they have the ability to look back at any save they have and edit the inputs to re-save. Currently we serialize the inputs, wrap it up in a JSON string and save it into a column in the MySQL table. I'm wondering if there would be a speed / storage advantage to specifying a column for each input and storing each value in its own column. If you're wondering how often the inputs change, it's infrequent. We might add / remove / modify about 20 inputs a year, probably fewer. If you're wondering how often saves are done, it's about 8 users doing 40 saves each, per day.
  4. Every item has a corresponding quantity calculation that's input manually by the developer, this calculation never changes. Then when a final price for the building is needed, it does the following: - get all product ID from the database - loop through all product ID quantity calculations and multiply this quantity by the price in the database (price updated once a month) - adding all these totals together and multiplying by a markup percentage gives us our final price Is that all you needed?
  5. There are only 400 items total in the products table, plus however many of these items there are.
  6. I have a Bill Of Materials (BOM) and we buy a building product from a third party supplier that custom makes them for us. They charge us a certain price based on these factors of the product: - width of building (in static increments: 24, 30, 36, 42, 44, 50...) - building type it's being used in (each type requires certain design specifications to meet code requirements) - snow load (depending on where in the country the building will be, we need to make it more durable if there will be a higher snow load on the building) Based on all of these, they build the product for us and charge us accordingly. I'm wondering if I need to have 400 items in my BOM to account for each combination of length, building type and snow load for this one product. Is this normal practice? The price differences don't have a pattern and don't overlap in any way, it's random pricing set for each combination. It's not like the price goes up $30 for each length, the pricing gaps are all different for each setting.
  7. Never mind. I was trying to run the script on the wrong server, it appears it was working the whole time on the proper server.
  8. bitnami@ip-172-26-***.***:~$ echo "subjectt" | sudo -u daemon mail -s "bodyy" d*****@******.com /home/bitnami/Maildir/sent: Permission denied Failed to save message in "/home/bitnami/Maildir/sent" - message not sent
  9. Is this correct? Daemon is the web user for Bitnami Apache. bitnami@ip-172-26-***-***:~$ sudo -u daemon echo "subjectt" | mail -s "bodyy" d*****@*****.com
  10. How can I do that if the command is being run through PHP and Apache?
  11. I just set up my first mail server ever using Postfix and when I run echo testing | mail -s subjecttttt da***@*********.com it sends fine and I receive the email at that address. The problem is when I create a php page on the server and write mail("da***@*****.com", "test", "test"); then run the page in my browser, it doesn't send the email. From what I read online, it's because the root user on the command line has permissions to send mail while the www-data user in the browser does not. Is there a way I can specify which user Postfix uses? Any other suggestions? Thanks a lot.
  12. I actually figured it out after 3 weeks of frustration. I disabled a NAT policy on my firewall for outbound requests and it solved everything. The script works great now and I can ping without issue.
  13. More discoveries. I remembered I still have the old virtual machine we were previously using as our web server, I have since replaced that with a new virtual machine on the same VMWare server. Both virtual servers are almost identical, the only difference is the new one has more disk space. I spooled up the old server, copied the test script to it and it runs flawlessly every time. I'm also able to ping out of that server no problem so it's some setting in the new server which is preventing me from making outbound requests. I'm going to continue my search there and not mess with any firewall settings.
  14. I get it, so I need to forward ports 80 and 443 from the ISP 2 static IP as well. Is that what you're saying? I thought a ping would always come through but I guess that makes sense. Something else I'm exploring is the fact that I can't really ping anything from this server which leads me to think it's something with the DNS or gateway not being set properly. That way inbound traffic works fine but outbound not so much. I'm just trying to figure out what I would set the gateway, DNS and subnet mask to right now to see if that's the issue. I'm not sure if it's the settings I got from my ISP or if it's an internal default for the firewall.
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.