Displaying 20 results from an estimated 33 matches for "information_schema".
2005 Aug 14
0
ActiveRecord and SQL92 INFORMATION_SCHEMA?
Hello,
I''m wondering if there is any plan to leverage SQL92 INFORMATION_SCHEMA
in ActiveRecord?
In a nutshell, INFORMATION_SCHEMA provides the meta information
necessary to automatically discover all the associations between
objects (primary and foreign keys, has_many, has_one and belongs_to,
etc).
Most relational databases do support this SQL92 standard one way or...
2006 Jan 05
8
Repost - Do dynamic finders work with legacy schemas?
Hello everyone,
I have another question related to a legacy schema I am working with.
Do dynamic finders work with legacy schemas in general? The schema I am
working with uses hungarian prefixes for column names. For example fOpen is
0 if a bug is closed and 1 if it is open (type smallint). When I try @bugs
= Bug.find_all_by_fOpen(1), I get the following exception:
undefined method
2006 Jan 19
3
problems with migrations in sql server
...SELECT COLUMN_NAME as ColName, COLUMN_DEFAULT as
DefaultValue, DATA_TYPE as ColType, COL_LENGTH(''schema_info'', COLUMN_NAME)
as Length, COLUMNPROPERTY(OBJECT_ID(''schema_info''), COLUMN_NAME,
''IsIdentity'') as IsIdentity, NUMERIC_SCALE as Scale FROM
INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ''schema_info'' 54
SQL:BatchCompleted SELECT TOP 1 version FROM schema_info 54
SQL:BatchCompleted SELECT TOP 1 version FROM schema_info 54
SQL:BatchCompleted CREATE TABLE Foo ([id] int NOT NULL IDENTITY(1, 1)
PRIMARY KEY, [Name] varchar(5...
2005 Nov 24
1
Log question
...) SELECT COLUMN_NAME as
ColName, COLUMN_DEFAULT as DefaultValue, DATA_TYPE as ColType,
COL_LENGTH(''reports'', COLUMN_NAME) as Length,
COLUMNPROPERTY(OBJECT_ID(''reports''), COLUMN_NAME, ''IsIdentity'') as
IsIdentity, NUMERIC_SCALE as Scale FROM INFORMATION_SCHEMA.COLUMNS WHERE
TABLE_NAME = ''reports''
[4;36;1mSQL (0.050000) [0;1mSELECT COLUMN_NAME as ColName,
COLUMN_DEFAULT as DefaultValue, DATA_TYPE as ColType, COL_LENGTH('''',
COLUMN_NAME) as Length, COLUMNPROPERTY(OBJECT_ID(''''), COLUMN_NAME,
'...
2016 Mar 24
10
C5 MySQL injection attack ("Union Select")
...ables block when the key used for database
access is excessively long.
My URL was something like this
...../...../.....php?key=123456
The injection was something like this
...../...../.....php?key=876711111111111111111111111111' UNION SELECT
13,CONCAT([X],count(*),[X],13,13,13,13,13,13 FROM
information_schema.TABLES WHERE `TABLE_NAME` LIKE "%wp_users%" -- /*
order by 'as
There are no user permission on information_schema.
There seems to be 2 versions of the coding floating around on Austrian
and Russian IPs. One is ineffective but the other works. It seems the
author is expert in the i...
2006 Mar 09
3
Building a model from a database view
Hi,
I''m trying to use rails to build a model from a database view.
I get this output
C:\dev\v6\project>ruby script/generate scaffold Assignment
...
error Before updating scaffolding from new DB schema, try creating a
tab
le for your model (Assignment)
Is this not possible in Rails? It would be *really* helpful for my
application.
-------------- next part --------------
An
2005 Dec 15
2
Checking the existance of a NOT NULL constraint from Active Record
Hi,
I'd like to check the existance of a NOT NULL constraint for a given
attribute using ActiveRecord. Is this possible or do I have to
painstakingly query the information_schema myself? I need this for
some reflection in a custom association.
Thanks,
- Rowan
--
Morality is usually taught by the immoral.
_______________________________________________
Rails mailing list
Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
http://lists.rubyonrails.org/mailman/listin...
2019 Oct 30
2
Dovecot and MySQL aborted connections.
We also spotted these sql connections getting aborted, upon upgrading
MySQL from 5.6 to 5.7. (Going back to 5.6 we don't see them!)
Turning on mysql general query logging we can see it is Dovecot's mysql
connections that inquire about or update quota usage in particular:
*** /logs//mysql.log ***
2019-10-30T10:52:22.624690-07:00 2 Connect dovecot at localhost on
npomail using
2005 Apr 23
2
[Tip] Introspection to determine if a column may be null
...Column
def required?
@required
end
end
class ActiveRecord::ConnectionAdapters::PostgreSQLAdapter
alias_method :_real_columns, :columns
def columns( table_name, name=nil )
cols = _real_columns( table_name, name )
cols.each{ |col|
sql = "select is_nullable from information_schema.columns where
table_name=''#{table_name}'' and column_name=''#{col.name}''"
col_is_required = nil
log(sql, nil, @connection) { |connection| col_is_required =
connection.query(sql)[0][0].downcase != ''yes'' }
col.instance_va...
2016 Mar 24
0
C5 MySQL injection attack ("Union Select")
...ess is excessively long.
>
> My URL was something like this
>
> ...../...../.....php?key=123456
>
> The injection was something like this
>
> ...../...../.....php?key=876711111111111111111111111111' UNION SELECT
> 13,CONCAT([X],count(*),[X],13,13,13,13,13,13 FROM
> information_schema.TABLES WHERE `TABLE_NAME` LIKE "%wp_users%" -- /*
> order by 'as
>
> There are no user permission on information_schema.
>
> There seems to be 2 versions of the coding floating around on Austrian
> and Russian IPs. One is ineffective but the other works. It seems t...
2016 Mar 24
0
C5 MySQL injection attack ("Union Select")
...Just my $0.02
Valeri
>
> My URL was something like this
>
> ...../...../.....php?key=123456
>
> The injection was something like this
>
> ...../...../.....php?key=876711111111111111111111111111' UNION SELECT
> 13,CONCAT([X],count(*),[X],13,13,13,13,13,13 FROM
> information_schema.TABLES WHERE `TABLE_NAME` LIKE "%wp_users%" -- /*
> order by 'as
>
> There are no user permission on information_schema.
>
> There seems to be 2 versions of the coding floating around on Austrian
> and Russian IPs. One is ineffective but the other works. It seems t...
2019 Oct 30
0
Dovecot and MySQL aborted connections.
...se the same database and mysql user, so I created a new user for dovecot.
syslog shows a few communication packet errors but these are all from postfix, none from dovecot so far.
It seems connections are closed after 60s of inactivity (vmail is postfix, vmail2 is dovecot):
mysql> select * from INFORMATION_SCHEMA.PROCESSLIST where USER like 'vmail%';
+-----+--------+-----------------+-------+---------+------+-------+------+---------+-----------+---------------+------+
| ID | USER | HOST | DB | COMMAND | TIME | STATE | INFO | TIME_MS | ROWS_SENT | ROWS_EXAMINED | TID |
+-----+------...
2015 Aug 15
2
wordpess can't connect to DB but mediawiki can
...Db like 'jfwiki' or Db like
'jokefire';
Empty set (0.00 sec)
Not sure why that would be the case. They're definitely there on this
database server:
MariaDB [mysql]> show databases;
+--------------------+
| Database |
+--------------------+
| bacula |
| information_schema |
| jfwiki |
| jokefire |
| mysql |
| performance_schema |
+--------------------+
6 rows in set (0.00 sec)
Any other ideas?
Thanks,
Tim
On Sat, Aug 15, 2015 at 3:07 PM, Richard <lists-centos at listmail.innovate.net
> wrote:
>
>
> > Date: Sat...
2011 Jul 17
1
ODBC MySql DB: sqlQuery empty
...|
+---------------------------------------+
SQL> show databases;
+-----------------------------------------------------------------+
| Database |
+-----------------------------------------------------------------+
| information_schema |
|
+-----------------------------------------------------------------+
SQLRowCount returns 2
2 rows fetched
---4: GNU R TEST
> library(RODBC)
> odbcDataSources()
MySQL-data
"/home/me/opt/mysql-conne...
2017 Aug 14
3
migrating 2.1 to 3.x, sql pass scheme, pass value?
...B MariaDB Server
Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| postfix |
| vmail |
+--------------------+
3 rows in set (0.00 sec)
MariaDB [(none)]>
I've used the password i've made, NOT the string I have in
/etc/dovecot/mysql file
> enter password <what I do is copy and paste the password from the file
> FIR...
2017 Aug 15
3
migrating 2.1 to 3.x, sql pass scheme, pass value?
...B MariaDB Server
Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| test |
+--------------------+
2 rows in set (0.00 sec)
MariaDB [(none)]>
NOW:
MariaDB [(none)]> SELECT PASSWORD('test1234');
+-------------------------------------------+
| PASSWORD('test1234') |
+--------------------------------------...
2019 Oct 31
2
Dovecot and MySQL aborted connections.
...d mysql user, so I created a new user for dovecot.
> syslog shows a few communication packet errors but these are all from postfix, none from dovecot so far.
>
> It seems connections are closed after 60s of inactivity (vmail is postfix, vmail2 is dovecot):
>
> mysql> select * from INFORMATION_SCHEMA.PROCESSLIST where USER like 'vmail%';
> +-----+--------+-----------------+-------+---------+------+-------+------+---------+-----------+---------------+------+
> | ID | USER | HOST | DB | COMMAND | TIME | STATE | INFO | TIME_MS | ROWS_SENT | ROWS_EXAMINED | TID |
>...
2015 Aug 15
2
wordpess can't connect to DB but mediawiki can
...; Not sure why that would be the case. They're definitely there on
> > this database server:
> >
> > MariaDB [mysql]> show databases;
> > +--------------------+
> >| Database |
> > +--------------------+
> >| bacula |
> >| information_schema |
> >| jfwiki |
> >| jokefire |
> >| mysql |
> >| performance_schema |
> > +--------------------+
> > 6 rows in set (0.00 sec)
> >
> > Any other ideas?
> >
> > Thanks,
> > Tim
> >
> > On...
2009 Sep 28
5
Multi-databases support
Hi,
While I was hacking ovirt-server, I have found that it's currently
restricted to Postgres DB. Even if I like postgres for serious work on a
server, I really prefer to hack/dev locally on a Sqlite or MySQL DB.
I have googled on rails in order to find a good answer for the "foreign
key problem" which forces OVirt to stay on pg. I have found a plugin on
this particular
2015 Aug 15
0
wordpess can't connect to DB but mediawiki can
...9;;
> Empty set (0.00 sec)
>
> Not sure why that would be the case. They're definitely there on
> this database server:
>
> MariaDB [mysql]> show databases;
> +--------------------+
>| Database |
> +--------------------+
>| bacula |
>| information_schema |
>| jfwiki |
>| jokefire |
>| mysql |
>| performance_schema |
> +--------------------+
> 6 rows in set (0.00 sec)
>
> Any other ideas?
>
> Thanks,
> Tim
>
> On Sat, Aug 15, 2015 at 3:07 PM, Richard wrote:
>
>>...