I have question about embedding existing mysql data to FTP. Let me tell you how the system works. Apache gets the user name and passwords records to the MYSQL and creates a folder per user in server. However users can not access their created folder using FTP client software. So how am I gonna merge the existing user/password data in MYSQL ---> to the FTP user/password. Vsftpd and proftpd installed already, so in whichever you feel more knowledgeable, I can go with that.
i inherited 200 tables in a mysql db from each of the 200 table there are table created on php pages
the information is organized pretty much the same (fields) in each of them, so i dont see the point of having so many different tables
i wanna redesign the db, in 4 tables each of this 200 table have a few essential characteristics, like: table name is (version_country_type), ie: v8_de_pro, v8_de_std, v9_uk_pro the fields are: No, Document_file, Document_path, ISBN, Book_Name, Subtitle, Status, Year_issue, Author
i will need to break the table name, and put each part in the new redesigned 4 tables separate fields... ill have something like:
but i have no idea how to do it i know i cant do it in mysql... so ill need to build up a php script which will need to read every table, and drop it in the new format:
table1 called Main: ID, version table2 called Cat: ID, IDmain, Country table3 called Sub: ID, IDmain, IDcat, type table4 called files: ID, IDmain, IDcat, IDsub, Document_file, Document_path, ISBN, Book_Name, Subtitle, Status, Year_issue, Author
The Payment Card Institute (PCI) is requiring our site to upgrade to the latest versions of Apache, Mysql, OpenSSL, and PHP to fix known bugs that can compromise securityI can build all these from source, but when I do "make install" they don't mimic at all what is installed (directory format, files, etc) when I do apt-get install (of whatever old versions are in the dist).How can I find out how the packages are build via configure/make so that I can replicate the files, directory structure, etc, just with the current versions.
I lost my capability to boot into any OS for some reason. I am dual booting Windows 7 and Ubuntu 10.10 and I have managed to restore my Windows bootloader using a Windows repair disk.I have tried to reinstall Grub using these commands from a Ubuntu Live CD:
ubuntu@ubuntu:~$ sudo mount /dev/sda6 /mnt ubuntu@ubuntu:~$ sudo grub-install --root-directory=/mnt /dev/sda
The latter gives this output:
/usr/sbin/grub-setup: warn: Your embedding area is unusually small. core.img won't fit in it.. /usr/sbin/grub-setup: warn: Embedding is not possible. GRUB can only be installed in this setup by using blocklists. However, blocklists are UNRELIABLE and their use is discouraged.. /usr/sbin/grub-setup: error: if you really want blocklists, use --force.
Here are the results from the boot info script:
Boot Info Script 0.55 dated February 15th, 2010 ============================= Boot Info Summary: ============================= => Windows is installed in the MBR of /dev/sda sda1: _________________________________________________________________________ File system: ntfs
PS. I probably should mention that I edited the partitions prior to these problems, moving the extended sda3 to the left to give it some more space. The order of the partitions remained unchanged.
I am trying to embed a command in a Jython script. The version of jython does not support popen so I am using os.system("pmap -x %s | tail -n1 |cut -f2 -dB" % (pid)) to get the memory consumption of a pid and pass same into my Jython script. The problem is that my code which looks like this:
executes properly but does not assing the result into the variable "memusage". So when I used the variable elsewhere I get "0". How do I manage to get the variable to grab this value rather than it executing directly.
I would like to backup my entire Ubuntu installation (/boot, swap and /) at /dev/sda (4GB) to /dev/sdb (10GB).I recreated the exact partitions on /dev/sdb, formatted and cp -rp all the files over.For /boot, I used
dd if=/dev/sda1 of=/dev/sdb1
It didn't boot successfully as the system kept rebooting. I then tried to install grub onto the MBR and boot partition (mounted at /mnt/tempboot).
I have an existing unix user that some how didnt make it into the copy over to our LDAP server. How do I add an existing unix user to an existing LDAP directory? Will ldapadd work? I was under the impression ldapadd required an ldif file to work properly.
I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:
Code: the-matrix:~ # mysql start ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or Code: the-matrix:~ # rcmysql start Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory
How can I really, really remove everything related to mysql / mysql-server. I read and tried all kinds of things, but on every reinstall there is still old mysql stuff there, for example an existing password. Even resetting the password does not help.
Reason of removal: it looks like the mysql setup is really corrupt, so I want to remove, and then do a fresh install. Running Ubuntu 11.04 64-bit
sander@R540:~$ sudo apt-get purge mysql-server Reading package lists... Done Building dependency tree Reading state information... Done Package mysql-server is not installed,
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:
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.
I've downloaded and installed MySQL-client-5.1.53-1.glibc23.x86_64.rpm. I'm rather new to linux so it might be I haven't started the server. Unfortunately I have no idea which file is responsible for that. It is also possible that my head isn't functioning correctly ( if at all ).
Error I receive is:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Mysql starting problem after changing mysqladmin password.I tried all the solutions available on forums, but not solve the problem.At last I restored the mysql db backup, this make mysql service start, but till other databases not showing all tables.