how to trigger a script when an email is received to update my mySQL database. I do not want to physically send the message to the script, I just want the script to execute and to under execute under a specific mail account.
I thought of setting up a cron job at first, but decided going down that approach would be a huge waste of resources. What method would you recommend?
After installing postfix on my server , all emails sent by a PHP class that i built , are received to spam folder , no matter what i do .am not an expert , except in PHP , the class i built works fine everywhere else except on this server , so i think the problem might be from the server it self ?some told me wrong configuration/software on my server , others told me wrong DNS stuff . actually i don't understand the DNS stuff , and am not an expert in linux softwares and services but i cann install/configure them , so could anyone please check the DNS for problems ?
View 3 Replies View Relatedi need to update my mysql database from 5.0 for 5.1, i have several java application and php application running on that server, without disturbing the setup i need to upgrade the server can someone suggest a method of doing this
View 2 Replies View RelatedI'm having problems with my coding. Here is the problem: I have a database with a list of products. I can list all the products OK At the side of each product I have an EDIT and DELETE button. The delete button works fine and deletes the item. The EDIT button displays a form with all the details from the database. I can then edit this form and click on UPDATE. This is the code that I have to update the database:
$group = $_REQUEST['group'];
$description = $_REQUEST['description'];
$quantity = $_REQUEST['quantity'];
$price = $_REQUEST['price'];
$type = $_REQUEST['type'];
$type2 = $_REQUEST['type2'];
$order = $_REQUEST['order'];
$status = $_REQUEST['status'];
[Code]....
I cannot see anything wrong with this code. But when I click on UPDATE (in the form), I get Error in executing UPDATE exhausts SET group = 'Alloy Silencers', description = 'RS 125 Aprilia', quantity = '1', price = '57.00', type = 'alloy', type2 = 'all', order = '', status = '1' WHERE id = '3' query
error:1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group = 'Alloy Silencers', description = 'RS 125 Aprilia', quantity = '1', price' at line 1I have used this code many time before in other projects without problems.
I would like with bash to output the content of my very last email that has been received (I use gmail), especially using fetchmail or mutt.
View 1 Replies View RelatedI've setup a CentOS apache web server, and loaded a site onto it. The site previously was functioning under windows xp (before I "stepped in") and wamp. What I did was copy the site in /var/www, reconfigure the httpd.conf (DocumentRoot /var/www/site, etc). Although when I try to open the webpage I get this error: Database Error: Unable to connect to the database:The MySQL adapter "mysql" is not available.
[code]...
I have a MySQL database running on my local server, which I currently access via laptop, desktop using HTML/PHP.I want to re-write in HTML5, I have gone through a couple of HTML5 tutorials but cannot figure out the database interface. The best match I can find is Server-Sent Events, is this the best way forward? What about writing to the database? I have found several suggestions using Web SQL database but I don't think this is suitable as my database is also accessed from Python code on the server.
View 5 Replies View RelatedI can't get mysql to update from lenny (mysql-5.0) to squeeze (5.1). apt tries to start the server but comes up with some kind of configuration script error.
View 1 Replies View RelatedI have the problem where the email was sent but not received by users.. The message as below code...troubleshoot
View 2 Replies View RelatedI have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.
I'm having problems connecting to the mysql database on my system. I first noticed this when I was trying to set up the program anymeal. I subsequently tried using MySQL Administrator (mysql-admin), but had no luck. It gives my the following feedback:
Code:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Click the 'Ping' button to see if there is a networking problem. I press the ping button, and it seems to connect.
Code:
How do I create a new mysql user and a mysql database at the shell prompt?
View 1 Replies View RelatedPam-mysql can not connect to the database and below are my configurations.
saslfinger -s Output:
root@mailbackup:/# saslfinger -s
saslfinger - postfix Cyrus sasl configuration Tue May 10 10:12:10 EAT 2011
version: 1.0.2
mode: server-side SMTP AUTH
-- basics --
Postfix: 2.7.2
System: Slackware 13.1.0
-- smtpd is linked to --libsasl2.so.2 => /usr/local/lib/libsasl2.so.2 (0x00007f74ebfb7000)
-- active SMTP AUTH and TLS parameters for smtpd --
-- listing of /usr/lib64/sasl2 --
-- listing of /usr/local/lib/sasl2 --
-- content of /usr/lib64/sasl2/smtpd.conf --
-- content of /usr/local/lib/sasl2/smtpd.conf --
-- active services in /etc/postfix/master.cf --
-- mechanisms on localhost --
I have the latest LAMP running on F10 but need to do a database conversion from mysql 4.1.22 to mysql 5 for a client.
View 4 Replies View RelatedFor legal reasons, I may soon be required to have the ability to provide a user's emails to authorities as part of a discovery action.Not just a copy of backup.I'm running postfix with dovecot on rhel5.I'd need to be able to produce emails sent and received in a given time frame by a given user.
View 1 Replies View RelatedI was wondering if you could recommend a simple way to achieve functionality where received email messages are automatically processed and used in SQL commands (depending on certain criteria, of course). For example, say I have made a PHP-based blog application and it's located at example.com and I'd like to give members the option of posting to their blogs by sending email to a special @example.com address. The email messages received there will be inserted into a database depending on the sender's address, with the body becoming the post and the subject line becoming the post's title, etc.
Another example could be how those trouble ticket systems let customers submit tickets via email, while the support agents operate via a database-driven Web application. Is this the type of thing one must code from scratch, or is there an open source solution out there which only needs to be configured accordingly?
I am having no luck configuring ProFTPd on a Debian Lenny production server we use to host our MySQL databases and a few websites. I had originally set it up so I could login and manage our internal sites, but I have the need to allow a few clients in to access their sites that we host. I am trying to root the users in their site directory, which would be "/sites/www.whatever.com/".
It just hit me while typing this. Is it possible to create a user without a shell to prevent login via SSH and set the home folder to /sites/whatever instead of /home/username? That would allow me to continue operating with my current configuration and root them in their site while preventing SSH logins.
I am trying to connect to my mysql database using php but I am getting the error "Fatal error: Call to undefined function mysql_connect()".
I checked phpinfo() and there is no reference to MySQL. I believe this means that my install of PHP doesn't support MySQL. Do I need to uninstall and reinstall with a version of PHP with MySQL support? If so how should I do this and how do I get a version of PHP that supports MySQL?
So I have two servers in my environment, I have an app server that runs my Java App on it and then I have a utility server. Right now, I have that utility server acting as a simple mail gateway so when my app server needs to send an e-mail out, it forwards it to the utility server and the utility server sends it out to where-ever it's destined to. The Java server always sends as one specific user, let's call it bob@company.com.
This set-up is working just fine right now. Now, I also have my company.com e-mail hosted at an e-mail provider for all of my user's e-mail accounts and such. I also have a bob@company.com e-mail account so if e-mails ever bounce, they end up in this inbox. Again, this works fine.
My app is pretty email dumb so it can't authenticate itself or anything, that's why I am using sendmail on my utility server instead of my e-mail provider's SMTP server. What I would like to do is to configure sendmail to forward all outbound e-mails (and authenticate) to my e-mail provider's SMTP gateway using the bob@company.com account and credentials. Is it possible to configure sendmail to do this?
I'm getting some odd behavior from a new router (netgear wg614 i believe). It appears that it won't assign an IP address to any machine running linux, but it WILL assign an IP address just fine to windows machines. my laptop is running debian lenny, but it isn't just my laptop - other linux (or linux based) machines can't get an IP address from it, either (including my wii). yet my old windows desktop gets an IP address just fine, as do my friend's windows laptops. i did not have this problem with my old router. nor do i have this problem when i bring my laptop other places. i have this problem ONLY with this new router.
the workaround is to assign a static IP address to my laptop and my wii, which is fine, but... i still want to get to the bottom of it. my laptop is definitely associated with the router (iwconfig output confirms this), so it's not a problem with the card or the driver (right?). i can log into the router administration from my laptop. the router just won't give it an IP address. how can this be? considering:-the only thing that has changed is the router-the problem occurs with all non-windows machines-my laptop and wii both worked fine with my old router (and others), and the settings have not changed.so, is there something fundamentally different about how linux and windows request an IP address from a DHCP server? My knowledge of both linux and DHCP are "medium", and they don't overlap enough for me to figure this out, i guess.
upon boot I see Starting Clustered TB : ctdb failed! Starting system message bus: dbus Could not connect to database Starting MTA: exim4 startpar: service(s) returned failure: ctdb ... failed!
View 1 Replies View Relatedhow to do Mysql, PHP, Apache installation configuration, module/library update
View 2 Replies View RelatedI installed apache2 and mysql database on a Debian system. It is using reverse proxy on apache to redirect requests to apache2 running on any machine which is on Xen server as a Virtual host. I tried to install Drupal on it. Every thing went fine till I pointed my browser to:
http://IP[/url] of LAN where Drupal was installed/drupal
then I see an installation page of Drupal which welcomes me. I click install in English then it can not proceed to connect with database. Database configuration: Your web server does not appear to support any common database types. Check with your hosting provider to see if they offer any databases that Drupal supports.
I have created a database and username for Drupal separately. What should I check to. There is one more error
http://Public IP/some location/
Is showing me contents of Document Root but there is a folder named drupal on it. When I click on it I get error. Not Found. The requested URL /drupal/ was not found on this server. Apache/2.2.9 (Debian) PHP/5.2.6-1+lenny8 with Suhosin-Patch proxy_html/3.0.0 Server at
What things should I check in for? I am also getting errors like:
- Could not reliably determine the server's fully qualified domain name, using 127.0.0.1 for ServerName on individual DomU's what should I check in. and on Dom0 when restarting apache2 I get following error.
- Reloading web server config: apache2apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1 for ServerName
[Wed Apr 14 15:23:05 2010] [warn] NameVirtualHost *:80 has no VirtualHosts
I want to install a email server so my domain handles it's on email. I understand I need a dns server first. I down loaded dbndns but can not even figure out how to start it. does anyone know how to get this set up. Or where the setup files is for this.
View 2 Replies View RelatedI have installed debian on my laptop and included during the installation the webserver version. Now I want to develop a page locally to test it before I put it on the web. I first had an old reflex, jumping straight away and installing xampp. But then I thought that I already all that it takes as I installed the webserver feature of debian. I installed phpmyadmin ( with the command #apt-get install phpmyadmin) as to be able to create and attribute databases but when I try to log in I have the following message:
"Error
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)"
I googled but I cannot find the mysql.conf (I searched using "find") but with no result. It is all very blury what is going on with this webserver option running on my laptop...
Related to my last post in that it is another email issue, but something else I am having a problem with.
Debian Lenny on virtual KVM (32-bit, v5.0.7)
With Postfix it is necessary to have an alias for root, eg: root: someuser
In theory, and as far as I am aware, this can also be something like: root: someone@someaddress.tld
When I use the latter, though, the following happens whenever my system tries to redirect root email messages, but not when I use the root: someuser method in the aliases file (and, yes, I do know to use newaliases after amending the file).
The firewall is not an issue (tested with and without the firewall), nor are the resolvers, and the DNS for accounts on the box is all okay and fully propagated. Also, changing the email address to something like this.address@google.com does not work, either, - same error message.
The problem I have is so simple yet difficult for me to resolve. My Postfix MTA allow fake mails from me@example.com to me@example.com. How can I block them?
For example, if I do "telnet smtp.mail.yahoo.it 25", as I write the MAIL FROM command I get the alert "Authentication required". How can I achieve that?
Could anyone point me to some simple articles that explain what email encryption is and how to set up a mail server (e.g. Exim) that can send secure emails? I know nothing about networks, mail servers, encryption, etc., but I have to be an expert on it before I walk into work tomorrow morning.
View 14 Replies View RelatedI'm running a desktop-less version of Debian via Sun VirtualBox. The reason I'm doing this is because I don't have enough graphics or RAM power to have a desktop environment running on top of my current desktop; also, I want to learn Linux through the command prompt. I'm running the AMD64 version of Debian; I'm not sure if that's relevant.
My main goal is to be able to email useful files from the virtual Debian to my main computer, so that I can save them for later if I ever decide to do a "real" installation of Debian on this computer. I realize now that there's probably some "easy" way to do this by reading the virtual machine's hard drive, but at this point, my curiosity wants to see this issue resolved. I started off wanting to find a command-line program to send my email with, and one was built-in. The syntax ~$ sudo mail -s "Subject" email@yahoo.com "This is a test email."
C^D
Cc:C^D ~$
is what I found. I tried it, and (unsurprisingly), it failed. I then learned that the mail command calls exim4, or something along those lines, so I needed to configure exim4. Soon thereafter, I learned that Yahoo's SMTP wasn't public, but Google's was. So, I found this web page which described how to configure exim4 to allow for email to be sent to a Gmail account. I made one, and followed the page word-for-word.
I sudo-mailled a test email to my Gmail account, and nothing happened. I waited a bit longer, and still, nothing happened. Finally, I started looking around, and found out about the exim4 logs in /var/log/exim4. In my mainlog, I think that it's telling me that Google denied my connection: <date><time><random numbers and letters> == **********.gmail.com R=send_via_gmail t=gmail_smtp defer (111): Connection refused
So, now, I'm just stuck. I don't know what I did wrong, I checked my exim4.conf.template twice for spelling errors, but I don't think I made any. At this point, I can only hope that someone else has had a similar problem, or knows what I'm doing wrong (or haven't done yet).
Is there a way to import my contacts list into this (new for me) email program?
View 1 Replies View Related