Security For Shared Server.xml Passwords
I have an ISP that has the server.xml in a shared environment. The server.xml file is where my password is available for database access under connection pooling. I really would like to use connection pooling.
Does anyone know how I can protect my password from being viewed by others using the same server.xml file? I cannot get the administrator to change the protection of the file because others in the shared environment need to be able to view it.
View Complete Forum Thread with Replies
Related Forum Messages:
Connections On Shared Server
I frequently get the error message: Warning: mysql_connect(): User user1 has already more than 'max_user_connections' active connections in /home/.sites/60/site23/web/Connections/mysite.php on line 9 It's commercial web hosting on a shared server so I have no control over the server side of things. The php scripting has been written using the GUI in Dreamweaver. Is there anything I can do to resolve this? Should I be using mysql_connect or mysql_pconnect, or is this not the problem? Do I need to include somewhere in my scripts a snippet which disconnects from the server? If so where would I put this? I am not all that familiar with php and mySQL, though I understand parts of it when looking at the code. The database connection is made via a connection.php file produced by Dreamweaver which includes the database details etc. My max connections are only 10. Is this the issue? It only seems to appear when I use php to edit or add to the mySQL database.
View Replies !
Getting Error On Applying Security Error Nr. 2003 Can't Connect To MySQL Server On 'localhost' 1006 1
i have tried over and over and over and over and i even add a port on firewall, but i keep getting this error at the end part of the configuration of MySQL: The security settings could not be applied to the database because the connection has failed with the following error. Error Nr. 2003. Can't connect to MySQL server 'localhost' [10061] if a personal firewall is running on your machine, pleas make sure you have opened the TCP port 3306 for connections. otherwise no client application can connect to the server. after you have opened the port please press [retry] to apply the security settings.
View Replies !
UDF Shared Library
I am trying to create a User Defined Function (UDF) using mySql 4.1.11 (mysql-max-4.1.11 for Solaris 8). I am trying to get the examples to work (udf_example.so) I have successfully compiled it and copied the resulting .so file to /usr/lib. The command 'crle' (like ldconfig on Linux) shows that /usr/lib is in the library path, but when I type in mysql: CREATE FUNCTION metaphon RETURNS STRING SONAME "udf_example.so" I get the error 1126, Can't open shared library 'udfexample.so' I've tries renaming the library 'libudf_example.so', but that didn't work either. I don't know how to check what libraries mysql is looking through. I am just guessing that it uses the library path from 'crle'. Any ideas?
View Replies !
Shared Password
I've installed mySQL out of the box and set a new password for the root account, which works in the MySQL monitor but not with the mysqladmin tool. Please can anyone advise whats going on or if I have to do anything else to get access to the admin tool?
View Replies !
MySQL And Shared Storage
--=_D38DA341.B3D2A80A Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable I would like to set up a round robin cluster with mysql. The round robin = would be done through the DNS to two different servers. Each of those = servers would have mysql installed and each would reference the same data = directory on our SAN. Are there any problems with doing this? =20
View Replies !
MySQL-shared RPM Install
I'm having problems installing the shaired libraries. This RPM came from the MySQL.com download site. [root@localhost src]# rpm -i MySQL-shared-4.0.17-0.i386.rpm warning: MySQL-shared-4.0.17-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
View Replies !
Replication Using A Shared Fileserver
I thought of a radical way to do replication of MySQL servers. Let's assume two MySQl servers access a shared mapped storage (/mnt/db) which is a local mount to a fileserver on the network. This fileserver is shared between the MySQL servers; which means any writes to /mnt/db appears immediately on /mnt/db on the other MySQL machine. Two MySQL servers may attempt to modify to the same file if we don't use synchronization. My question is, first, can we do this without making patches to MySQL code, and somehow using some synchronization mechanism accross the two machines running MySQL server each. Or we need to patch MySQL code to support such architecture. Second, is it trivial or impossible to do, how much man-time it requires roughly.
View Replies !
Find Shared Values
Say I have a one long Table of people and the foods they like. How do I find all the foods that are like by both of two particular people? ie David peas Kate sausages Kate eggs Bill eggs Kate peas Fred sausages Fred peas and i want to find out what both Fred and Fate like:
View Replies !
How To Find Out Values Shared By Some Members
I have a table contains words extracted from documents which are belonging to a number of categories. Each category contains a number of documents. For each category, I want to find out those words which occur at least in N documents belonging to this category. Code:....
View Replies !
Shared Column Data Transfer
I have two tables with one shared column. One other column in table 2 is empty but has to get filled with a value from one column in table 1. select * from tbl1, tbl2 where tbl1.column = tbl2.column; Above query gives me the results that need to be updated. What will the update statement look like?
View Replies !
Multiple Database, 1 Shared Table, Is It Possible?
I Used MySQL for a long time dev under PHP 3, 4 and now 5 now i'm facing a problems that i solved in the past with php, but i wonder if MySQL could do it on it's own, that'll help me a lot. Multiple database, 1 shared table, is it possible? i mean, i already done with 5 install of Xoops CMS and modified it that every install is on the same database, with deifferents prefixes (like db1_ db2_ ...) then i mod Xoops for each time it called for it's users or saved open sessions id in the DB it use the same table on all install... so the users seamlessly wonder about in 5 differents xoops install without disconnect and change username. now i face the same problem, i need a multi-install or a single install of a core system that will act as a multi-install sofware, but with the same set of users, sessions and some other things.
View Replies !
Cannot Open Shared Object File!
i just upgraded from MySQL 4.1 to MySQL 5.1. But when i try to run a program, i'm getting this error: error while loading shared libraries: libmysqlclient.so.14: cannot open shared object file: No such file or directory
View Replies !
Can A MySQL Database Be Shared Between Windows And Linux?
I've got Windows and Linux running on my computer, on seperate partitions. I also have a shared partition for stroing files, and can be read and written by either system. I also have MySQL installed on both systems. When I make changes to the database in Windows, I have to do a dump of the database (or single tables) to a text file on my shared partition. I then have to switch into Linux and load that file into MySQL there. This is a bit of a hassle. Is it possible to somehow store the database file on the shared partition, and use the same database from both OSes? This would be very convenient, since I wouldn't have to maintain two copies of the same database!
View Replies !
ODBC Connection To MySQL On Shared Hosted Website
I'm trying to connect to a mySQL database that exists in connection w/ my website. I created the database using c-panel. Everything that I use to access the website from my site uses "localhost" as the host name. I installed the ODBC drivers for Windows on my XP machine and am trying to connect from my local machine. I am not sure what I should use for the hostname in that case -- I tried www.mysitename.com as the host but that didn't work. I also tried the IP address, but that didn't work either. I asked my host's support team, but haven't heard back from them yet. It's a shared hosting service. Any ideas on what the hostname should be?
View Replies !
How Often Is Best To Create New Database, Migrate Data With Shared Hosting?
I have got a web site that I have ben working on since March, 2007. It is a news reporting web site. It is replacing an older web site. I created a new database (it uses the MySQL database) last March when I started working on the new web site. I have migrated all of the news content from the old web site database to the new web site database. I have a shared web hosting. It's my understanding that the hosting service provider fills up one server with databases then starts a new server with databases. For example, the IP for the server that is hosting the current database for the new web site is 10.6.166.5 I just created a new database (the hosting allows you to have ten databases per shared hosting). The IP for the server for the recently created database for the new web site hosting is 10.6.166.92 If the servers are ordered sequentially there have been 87 new servers filled up with databases since last March (i.e. 10.6.166.92 recently created IP minus 10.6.166.5 March, 2007 IP equals 87 servers). The problem with migrating the nine-month old database to the new database is that I have got over a thousand news stories and two thousand pictures stored in the database with the 10.6.166.5 IP address. I would have to copy and paste all of the data into the phpMyAdmin program or write a PHP script that would automate the process. Is there any benefit to migrating the 10.6.166.5 March, 2007 IP database over to the more recently created 10.6.166.92 IP database? Would it be reasonable to expect the more recently created database to perform better over the next 12 to 18 months than the one created nine months ago?
View Replies !
Why Dont Shared Hosting Accounts Provide Stored Procedures And Triggers?
i am searching for 3 days now for a reliable, fast hosting company, which supports stored procedures and triggers on mysql5. most of them dont support this, because mysql5 has a design-flaw in which it stores procedures and triggers on a root level-area (tables mysql information_schema). due this logic, most of the hosting companies wont allow you to create/run procedures and triggers. funny, that hosting companies forbid you to use new technologies and methods to build faster.
View Replies !
Passwords & DBI/DBD
I installed the current stable release of MySQL from RPMs. I used the client and server packages. After installing the server package, the RPM printed a note saying I should run two commands. I only got the first one, which was # ./mysqladmin -u root --password I assume this gave the root user a password. I then downloaded and proceeded to compile the Perl DBI and DBD:mysql packages. The DBI package installed fine after I also installed the "MySQL-devel" RPM. Code:
View Replies !
Where Passwords Are Kept
I am just starting out using mySQL. I created some databases and tables and installed mySQLcc to ease my usage. After about 4 months, I've needed to make some changes that needed root access. I appearantly wrote down the wrong password so I couldn't make any changes. In the process of trying to change the password I think I changed it again and unsynced mySQL and mySQLcc because now I can't access any of the databases with any user. Although I can still open mySQLcc, it can't connect to the database. I get access denied no matter what I do. Is there a way to clear the passwords and start over? Where are the passwords kept? Or do I have to remove mySQL and reinstall it and start over?
View Replies !
Inserting Passwords Into DB
I have a couple of questions concerning the insertion of encrypted passwords into a mysql database (4.0) first, some admins seem to think it's a good idea to feed the password in plaintxt to the db and have the db encrypt and store it. I tend to think this is less secure seeing as there is no seperation between the data and the encrypt/decrypt so therefore encrypt the password beforehand and I want to insert nand retreive it that way. What type should I be using with the store, and what's the best way to store and retrieve it with that type?
View Replies !
My.ini :: Add A Line To Old Passwords?
I read about the problems related to the usage of phpMyAdmin und mySQL > 4 because of the password. It was written everywhere to add a line 'old_passwords' into the my.ini configuration file. I have no clue what file (and where it is) I have to change on a os X installation. Who could give me a hint?
View Replies !
Users Passwords
I use the windows mysql connector 3.51 to connect to a mysql database on a linux server. I also have local library on the windows station that supports sha type encryption. What I'd like to do is encrypt the userid and passwords entrys locally with this library and still connect to linux server but have not been able to. What is the default encryption that mysql uses for passwords ? I did read about the password function and it did mention a bit about sha but I'm still unable to match the encryption locally.
View Replies !
Passwords For Myadmin
I am looking for a way to setup a username/password to myadmin. I made the mistake of showing other the website for admin work and now they are messing it all up.
View Replies !
Best Way To Store Passwords
I've written a windows based from end for a mysql database that will work across a local intranet, it stores usernames and passwords for a reporting system, what is the best way to store the passwords int he db? i.e encrypted or?
View Replies !
Passwords / Authentication
I have just started messing around with MySQL and something I find weird is that we connecting using localhost, if I supply the password, it will not authenticate...if I leave the password off, it's fine.If I connect from another machine, it requires the password or it will not authenticate.Is that normal?
View Replies !
Understanding Passwords
1. I know in mySql you need a username and a password to access a database. However, can you set a username and password (or even just a password) to access a table or a row? 2. Is there a way you can set a database so you can only add data? 3. is there a way I can have people access values to a database (php) without using a password? 4. is there a way to set up diffrent users (with diffrent permissions) for accessing mySQL data? 5. Any comments about how I can get alot of people accessing a database, from diffrent websites, with keeping i as secure as possible?
View Replies !
Transferring Passwords
I tried doing a search but did not find the answer I was looking for. I just redesigned the database that I had created a few months ago. I broke my one single table up into multiple tables. My problem is that in my old large table I had a password column that is populated by using Password(). Is there a way for me to transfer the info from that column to my new broken down table set? I did not create a new database when I broke up the large table, I just built my new tables around it so they are all stored in the same database. I'm not sure if that makes a difference or not. Is it possible for me to just copy and paste the info from one of the fields into the new table? Or will that break the encryption?
View Replies !
Encoding Passwords In MySQL
I am developing a database application in which I store usernames and passwords. Naturally I want to store the passwords in an encrypted form. However, just like you see in many web applications, I want to be able to email the users password back to them should they forget their old password. I looked at how to store the password data in MySQL and they recommend using MD5 or SHA. Both of these appear to be one way encryption routines. IOW once I encrypt and store the users password there is no way to unencrypt it. How can I store passwords in my SQL database such that I can convert them back to plain text when the user requests them?
View Replies !
User Accounts With Passwords
I am able to connect to the database using users that are not password protected. After updating privileges to use passwords and changing login info(in a php document) I recieve the following error from the php document: Warning: mysql_query(): Access denied for user 'ODBC'@'localhost' (using password: NO) in c:inetpubwwwrootgindex.php on line 9 Warning: mysql_query(): A link to the server could not be established in c:inetpubwwwrootgindex.php on line 9 I am attempting to connect as 'test'@'localhost' with the password 'test'. If I remove the password, I can connect no problem.
View Replies !
Transferred DB, Now Passwords Not Working..
We just switched hosting companies and transferred 3 of our DB's from the old server to the new. Everything seemed to go alright. Our sites are reading from the DB's however none of the users from our DB can log into the website. When a user signs up to the site we use the MYSQL PASSWORD() function to enter the users passwords into the DB.
View Replies !
Passwords Getting Corrupted On Import
i have a large dump of user table which has a password field containing hashed password (used mcrypt for encryption) when i import the dump using command line only the passwords get corrupted. I dont know how ?
View Replies !
Mod_auth_mysql Or Mysql Usernames And Passwords
I'm writing a web app that needs a login page. I'm doing the dev on a windows box although the final version will go on a Linux box. I can't find any versions of mod_auth_Mysql precompiled for windows and have no idea about compiling c.source on windows (or anything to do it with). Is there a good reason I shouldn't store hashed password in MySQL and call them from Python scripts instead of using the apache auth module directly?
View Replies !
Hide Mysql Usernames And Passwords
I'm trying to have people access a secure mysql database. If they get to a certain webpage, they have clearance to access the database, and we have one password and one username (that the users do not know). Does anyone know how to have it so the people cannot see the cgi script to access the database?
View Replies !
Passwords, Permissions, And Blank Users
I have Apache 2 server, PHP5, and the latest MySQL installed on my system. I'm currently reading PHP and MySQL for Dummies (I told you I was a newbie) and trying to work through a few of the examples.One thing I noticed when I looked at the "users" table in the "mysql" database is a blank user with all privileges on localhost. I deleted that entry, set a password for my "root" account, and created another account with a non-blank password. The problem I am having is that I am trying to connect to the database as "root" with a blank password, and it's still working. I then tried a blank user, and it worked. I tried a random assortment of letters and numbers, and it worked.
View Replies !
Can't Add New Users & Passwords To Grant Table
I am running MySQL 4.1.7 on my Windows XP system. I can create databases, ect. on the command line, but when I try to run a PHP script I receive the 'Access denied' error message. I have tried using the Grant command to add a new user but nothing comes up when I show SHOW GRANT except the root user. How do I add the new users for running the PHP script?
View Replies !
PASSWORD() Function :: Not Matching Passwords
I'm writing a login.php script for my web site and am encountering some problems matching the password of the user logging in. Here's some of my code where I believe the problem to be: $query = "SELECT user_id, first_name FROM users WHERE username='$u' AND password=PASSWORD('$p')"; echo($query); $result = mysql_query ($query); $row = mysql_fetch_array ($result, MYSQL_NUM); if ($row) { // Start the session, register the values & redirect. session_start(); $_SESSION['first_name'] = $row[1]; $_SESSION['user_id'] = $row[0]; header ("Location: [url]http://"[/url]; . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . "/loggedin.php"); exit(); } else { $message = '<p>The username and password entered do not match those on file.</p>'; } mysql_close(); } else { $message .= '<p>Please try again.</p>'; } } I keep getting my error message "The username and password entered do not match those on file" listed above in the conditional. The server doing my hosting is running MySQL 4.1.14 - standard. The test login script that is getting passed prints out as follows: SELECT user_id, first_name FROM users WHERE username='test' AND password=PASSWORD('test1') Am I doing something wrong with the PASSWORD() function?
View Replies !
User Passwords Lost On Reboot
Server 2003 | IIS6 | MySQL 4.1.14-nt-max | phpMyAdmin 2.6.4-pl3 Apart from root, I have only 6 databases and whenever I reboot the server, I have to reset the passwords on 4 db's (using phpMyAdmin). Checking the mysql db, user table I note that the 4 that are causing problems have an asterix *preceding the encrypted password. The passwords that do not change were set with the help of a friend using SQL statements.
View Replies !
Password Encryption To Store Passwords
What I'd like to do is have an html login page using php to process the request, and then compare the input strings to a username & password stored in a SQL table. My question is though, what is the best way to store the password in the mySQL table. Is it better to store it as an encrypted value, and can I do this?
View Replies !
People Store Passwords In Database
i used to store the password in database using md5() function but there is no way to retrieve the password back. Now i want to know that - is it standard and secure way to store password? is there any other technique to store password so i can retrive it back?
View Replies !
Packed Passwords In Command Line Programs
I think this is a trivial newbie question but can only be answered by a guru. In command line programs, why should passwords be packed with the parameter name? For example for mysqlimport one would write the command like that: mysqlimport -u user -ppass Why not just mysqlimport -u user -p pass ?
View Replies !
Back Up And Restore Field Containing Encrypted Passwords
I am using a web application that stores information about users in a table (username, password, address etc.). The password is encrypted (MD5). I backed up this database using mysqldump -u -p database >db.sql and restored the table on some other machine. My first machine is RHEL4 running Mysql 4.1 and new machine is RHEL5 running Mysql5. After restoration, I am unable to login to the users through web application. Is there an option to backup and restore tables containing fields with encrypted password information.
View Replies !
How To Maintain Schemas With Different Passwords In Mysql As Oracle
I am new to mysql,i know oracle, recently we are migrated database from oracle to mysql,we are have one database with different schema s in oracle and different passwords.Is there any chance to maintain different schema s with different passwords in mysql (In mysql we are getting only one user contain all schema s) With Single port number....
View Replies !
MySQLAdmin :: Store Passwords Option Enabled
I've created a scheduled backup job with MySQL Administrator (1.0.20, MySQL 4.1.11, Windows Server 2003) and it fails with: Cannot connect to MySQL Server. Access denied for user 'root'@'localhost' (using password: NO) (Error Number 1045) The 'Store Passwords' option is enabled. Why isn't it using the password?
View Replies !
Binary Column Types / Hashed Passwords
I'm building an asp.net application using MySQL as the database. I've created a table to store usernames and passwords. During user creation and authentication - i'm presenting the db with a hashed password value. When a hashed password is stored in a db - how should it appear in the table? In the MySQL table I'm using to store username and passwords, it appears as system.byte[]. The data type is defined as varchar(16), binary. The field is not behaving as it should during authentication - as long at I enter a valid username, the system authenticates me despite a correct or incorrect password value. Can anyone help me to define the appropriate column type? My application works fine w/ MS SQL but fails w/ MySql. In MS SQL the field is described as:[PWD] [binary] (16) NULL
View Replies !
Switched To 4.1, Now Passwords Work Differently - How To Adjust?
I switched from MySQL 3.23 to 4.1. I used Pear DB but now, it doesn't seem to work so I switched to Pear MDB2. I used MySQL Control Center to add a new system user to the MySQL user table but the password was like an nd5 hash instead of the old 16 character password in version 3.23. When I try to connect it indicates it can not connect.
View Replies !
|
TRACKER
